Database Learning Experience Sharing

It is also supported! This is a database learning experience that I have summarized during my work and study. In fact, database learning is not as difficult as I imagined, it would be easier to become a DBA without involving the development of the database. Learning the database will help you navigate the network management path!

I. Learning direction: Management and Development

Ii. Management Method: Enterprise Manager and SQL statement

Iii. Learning Process:

1. Learn about the relevant RDBMS system and install MSSQLServer2000/2005

2. Create, modify (use sp_renamedb), and delete a database.

3. Manage tables (create tables, modify tables, Delete tables, use the Where condition group by and having statements in combination, and sort orader by statements). Try to learn as much as possible)

4. Next we will discuss Account creation, server and database security and image permission security, database backup and recovery, DTS, automation (operator alarms and jobs), database replication, view and index creation, etc.

Haha, there are still some shortcomings that need to be supplemented!