What Will You Learn?
- By the end of this course you will be a professional SQL database administrator and be able to apply for SQL jobs
- Administration of SQL database through Microsoft Windows
- You will learn 150+ SQL queries
- You will be able to troubleshoot everyday SQL related issues
- You will manage SQL servers in a corporate environment
- You will write basic to advance SQL queries
- Troubleshoot everyday SQL database related issues
- Know how to answer specific business questions by using SQL’s aggregate functions
Course Curriculum
MS SQL Course syllabus
-
Introduction to SQL
00:00 -
Introduction to Database and RDBMS
00:00 -
Basic SQL syntax
00:00 -
Data Definition Language (DDL)
00:00 -
Data Manipulation Language (DML)
00:00 -
Data Control Language (DCL)
00:00 -
Transaction Control Language (TCL)
00:00 -
Data Constraints
00:00 -
Joins
00:00 -
Subqueries
00:00 -
Advanced SQL Functions
00:00 -
Views
00:00 -
Indexes
00:00 -
Data Integrity and Security
00:00 -
Stored Procedures and Functions
00:00 -
Performance Optimization
00:00
Student Ratings & Reviews
4.0
Total 2 Ratings