U3F1ZWV6ZTMzNzE0NzkxNV9BY3RpdmF0aW9uNDQzNjUxMw==

SQL|SQL database Structure Query Language


SQL|SQL database Structure Query Language 




Welcome to a new course on Structure Query Language
Databases using SQL
INTRODUCTION TO DATABASE USING
Where databases are considered the most widespread and most useful information sciences in In the field of engineering, information
Through this first article of this fun course, we will learn

What is the importance of the database→
And what are some generalities about the database→
What are the easiest ways to store data→
What is the concept and definition of the rules of the database→
What are the objectives of database→
What are the advantages of the database→
Types of database joining→
What is the difference between MYSQL and SERVER SQL→
What is the Concept of SQLSQL database sections→
What are sQL language sections→
What are sql cycle hubs→
The importance of the database→

Data collection, accuracy and handling of data are essential processes that depend on them in many areas
As a result of accurate data, they lead to accurate decisions after they are analyzed, using special systems to analyze those


Some outs about the database

Files File
Data storage
The easiest way to store data
Ways to store data files and so on
Direct storage
And that's by keeping the data in the form of successive lines
In files
Or serial storage
This process is stored sequentially with each line ending with a break
Or store the direct serial
This method is the same as before with the addition of indexing of stored data



The concept and definition of the  Databases

Databases are a collection of stored data in a structured manner
It is one of the most important pillars of information where through databases we can save, modify and delete information in smooth ways as well as allow us to extract data
Saved as we want
A target from the DATABASE
The purpose of databases is to organize data, to facilitate retrieval, search and extract information
From her
And reduce the time and effort while dealing with data
Features of the Bayat Base
Database label
Safety: Safety systems are very high
Size: Holds up to 1 TB
Number of users: No specific number
Flexibility and liquidity in dealing
The pre-defined functionality property supports Procedures Stored and Triggers

Types of database join

System Management Database Hierarchical⌦
System Management Database Network⌦
System Management Database Relational⌦


The difference between MYSQL and SERVER SQL


MySQL

Are Access-MS-like databases
But without a user interface, As it usually is
Remember PHP with Access-MS databases
Server SQL
Is a program for the work of databases from Microsoft and is very interactive with languages
Designed programming


SERVER SQL

SQL is an abbreviation for Language Query Structured
a non-procedural language that doesn't have Next for Loop, case select
If it is the language of the query in structured order, it is code used to handle data
SQL is an ansi standard language and ANSI is an abbreviation for e Standars Natioml American
 this language identifies the processes that we want to implement on the databases and dbms perform these processes and DBMS is an abbreviation
For System Management Database database management systems

SQL database sections

SQL databases are divided into two types

DR- Data Retrieval⇒
DML- Data Manipulating language⇒
TC- Transaction command⇒
DCL- Data Control language⇒
DDL- Data Definition language⇒



SQL role axes

The first axis: The basics of SQL language
The second axis: the basic SELECT instruction
The third axis: retrieving and arranging data on conditions
The fourth axis: Use one row dependents in the SELECT query
5th Axis: Assembly Minions
The sixth axis: View and browse data from multiple tables
Axis 7: Sub-queries
Axis 8: Multi-column sub-surveys
Axis 9: Data handling
Axis 10: Tables
11th axis: restrictions on tables
The 12th axis: the practical section


Notes on SQL

Sql language is insensitive to small or large letters
Sql language is not in white blank spaces
;Sql language ends with a semicolon
ليست هناك تعليقات
إرسال تعليق

إرسال تعليق