The advantage of SQL are:
1, high performance design, can make full use of the advantage of WindowsNT;
2, supports Windows graphical management tools, and support of local and remote system management and configuration;
3, symmetric multiprocessor structure, stored procedure, ODBC, and with independent of SQL language;
4, powerful transaction, adopt various methods to ensure the integrity of the data;
5, the built-in data replication, powerful management tools, and tightly integrated and open system structure of the Internet for the majority of users, developers and system integrators to provide a superior database platform,
Learn SQL database, we can do what?
When we learn database, can find a job is usually system administrator, the main work includes:
(1) the backup system data
(2) the transaction log backup
(3) the system fails to restore the database system for
(4) copies of the interaction between the database and its log
(5) monitoring system operation condition, timely processing system error
6. Create user information table, and empower the information table
All landowners to ensure the safety of system data, periodic change user password
To understand the type of data in the database, what
Create the database, delete statements, database table statements, delete table statements, view the database statement
The primary key, automatic growth
In the table to add, delete, change, check, one by one slowly to
Some statistical statements about table fields, some related functions, then followed by the index, the foreign key constraints, statements, etc.
The above is the small make up roughly introduction, hope for your help!
CodePudding user response:
Thanks for sharing, it is recommended that the blogCodePudding user response:
Thanks for sharing, it is recommended that the blog