MS SQL Server Full Course
About Course
This course with database expert Instructor introduces you to creating relational databases with SQL Server and the graphical interface, SQL Server Management Studio. Instructor walks you through your first steps in the newest edition of Microsoft’s database management system. He takes a detailed look at creating efficient tables and adding rows of data, importing existing tabular data from spreadsheets, and writing queries to view and process that data. Instructor also covers important database management tasks such as creating backups, securing access to sensitive information, and leveraging the capabilities of Microsoft’s Azure cloud infrastructure.
Course Content
Course content
-
Exercise File
-
Getting Started
33:28 -
Logging in to the Server
20:59 -
Creating Databases
53:12 -
Table Design for Healthy Databases
50:51 -
Structure Query Language
47:26 -
Writing Efficient Queries
49:12 -
Backup and Restore
20:19 -
Security
29:32 -
Monitoring and Management
15:55