home page > Special package > data base > SQL Server > Collection of SQL Server Database Practice Topics

Collection of SQL Server Database Practice Topics

This special package starts from the basics of SQL Server and has three stages. It starts from the basics of SQL (aggregation+nesting+multi table interconnection), transitions to the advanced SQL (view+stored procedure+trigger+cursor, etc.), and then to the maintenance and optimization of SQL Server database, as well as SQL sentence tracking. It is a one-stop case study, Gradually improve the comprehensive practical skills of SQL Server database!

four

Courses

nine thousand two hundred and sixty-seven

Human learning

Total course duration

Be modest and have Li

Lecturer rating: 5.0

Watch for a long time

Systematic learning

Course content Q&A

Phase I: SQL Basic Practical Course (SQLServer)

1 course twenty-five thousand seven hundred and forty

Master the practical knowledge of adding, deleting, modifying, and checking SQL, and lay the necessary foundation for subsequent advanced learning.

SQL Basic Practical Course (SQLServer)
32 sections 7 hours and 9 minutes
Course objectives:
This course passes the following: 1. General introduction to the course 2. Building a learning environment 3. Preliminary understanding of SQL 4. Practical skills for single table query 5. Practical skills for multi table query 6. Inserting, changing, and deleting data 7. Operation of data tables to simulate the actual operation of business data, and grasp the basic practical skills for adding, deleting, changing, and querying SQL. PS
Course outline
Free trial

Phase II: SQL Advanced Practical Course (SQLServer)

1 course twenty-nine thousand seven hundred and sixty

Master SQL data constraints, data integrity, indexes, views, process control, stored procedures, triggers, cursors, transactions and other practical skills.

SQL Advanced Practical Course (SQLServer)
Section 36 8 hours and 16 minutes
Course objectives:
This course has passed the following 11 chapters: 1. General introduction to the course 2. Building a learning environment 3. Data constraints 4. Data integrity 5. Index 6. View 7. Variable and process control 8. Stored procedure 9. Trigger 10. Cursor 11. Transaction. With the operation drill of commercial level simulated data+actual case, master the SQL number
Course outline
Free trial

Stage 3: SQL Server maintenance optimization and statement tracking

2 courses thirteen thousand and twenty

Master the practical skills of daily maintenance and optimization of SQL Server database, easily obtain the underlying SQL code of the database, master the practical skills of SQL statement tracking, and solve difficult problems in software development and application.

Practical Course of Daily Maintenance and Optimization of SQLServer
10 sections 2 hours and 2 minutes
Course objectives:
This course passes the following: 1. General introduction to the course 2. Building a learning environment 2.1. Installing SQLServer2.2. Starting and stopping MSSQLSERVER service 3. Database maintenance 3.1. Practical - offline and online databases 3.2. Practical - separating and attaching databases 3.3. Practical - backup and restore
Course outline
Free trial
Database SQL Statement Tracking Practical Course (SQLServer)
5 sections 1 hour 35 minutes
Course objectives:
This course has passed the following: 1. Course introduction 2. Configuring the database SQL tracking environment 3. Practice - Troubleshooting the ERP sales invoice detail window opening exception 4. Practice - Analyzing the forms involved in the ERP purchase order review 5. Practice - Obtaining the ERP custom report SQL code as a demonstration operation of an actual case to easily obtain the data
Course outline
Free trial