Description
In this course, you will :
- By the end of this course, you will be a proficient SQL database administrator who can apply for SQL jobs.
- SQL database administration using Microsoft Windows.
- Learn over 150 SQL queries.
- Be able to troubleshoot common SQL difficulties.
- In a business setting, you will be responsible for managing SQL servers.
- You will write SQL queries that range from simple to advanced.
- Troubleshoot everyday SQL database issues.
- Learn how to answer particular business queries with SQL's aggregate functions.
- Be able to provide reports for management to help them make financial decisions.
Syllabus:
- Download, Install and Configure Windows
- Download, Install and Configure MS SQL Server
- Database Fundamentals and Design
- Introduction to SQL Commands
- Query and Manipulation of Data using SQL
- Microsoft SQL Database Administration and System databases
- Deep Dive into MSSQL Working
- MSSQL Backup and Restore
- MSSQL User Management
- MSSQL Server Agent Management
- Advanced SQL Server Administration Topics