72 VideosSelf-paced Course
26 VideosInterview Q&A
The SQL server certification course covers a variety of subjects, ranging from fundamental database concepts to more complex ones, to help you work with SQL Server efficiently and make use of its features to design and create reliable, scalable, and secure database solutions. In this SQL Server course, you will learn to work with SQL Server, database design, querying, administration, and more.
Participants in the SQL training online course will have the following skills after completing this course:
This certification is intended for IT professionals. Those who want to prove their proficiency with SQL and advance their understanding of SQL Server databases can learn SQL server to advance their career.
There are no prerequisites to learn SQL server course.
SQL Server, SQL Server Management Studio
Video Course 72 Videos
Q&A 26 Videos
Course overview
Course Overview
02m 15s
Introduction to Database
Introduction to Database
Preview
00m 44s
Types of Database
Preview
01m 41s
Introduction to SQL Server
Introduction to SQL Server
01m 42s
Version History of SQL Server
01m 28s
SQL Server Editions
01m 39s
Installing SQL Server and Components
Setting Up SQL Server 2017/2019
04m 27s
Verifying SQL Server Environment
07m 16s
SQL Server Components and Services
04m 11s
SQL Server Database and Tables
System Defined Databases
03m 00s
Creating A Database
04m 04s
Creating A Table
04m 14s
SQL Keys
SQL Keys
07m 38s
Demo : SQL Keys
09m 06s
SQL Commands
SQL Commands
01m 38s
Demo : DDL Commands
08m 39s
Demo : DML Commands
07m 16s
Demo : DQL Commands
02m 02s
Demo : DCL Commands
02m 53s
SQL Constraints
SQL Constraints
02m 05s
Demo : SQL Constraints
03m 47s
Course Overview
Course Overview
01m 32s
Data Types, Variables and Operators
Data Types
Preview
01m 15s
SQL Server Data Types
Preview
02m 48s
SQL Server Variables
03m 59s
SQL Server Operators
05m 39s
SQL Server Control Of Flow
SQL Server Control Of Flow
01m 58s
Demo : SQL Server Control Of Flow
07m 42s
SQL Query and Sub Query
SQL Query
04m 28s
SQL Sub Query
01m 58s
SQL Clauses
SQL Clauses
02m 42s
Demo : SQL Clauses
06m 12s
SQL Clauses Order Of Execution
01m 45s
SQL Predicates
SQL Predicates
01m 22s
Demo : SQL Predicates
06m 01s
SQL Joins
SQL Joins
04m 07s
Demo : Inner Join
08m 20s
Demo : Outer Join
06m 56s
Demo : Cross Join
01m 48s
Demo : Self Join
04m 31s
SQL Exceptions
SQL Exceptions
01m 56s
Demo : SQL Exceptions
07m 32s
Try..Catch
Try..Catch in SQL Server
03m 22s
Demo : Try..Catch
02m 40s
SQL Server Views
Introduction to Views
0h 04m 49s
System Defined Views
07m 21s
Simple Views
16m 20s
Complex Views
13m 27s
SQL Server Indexes
Clustered Index
17m 10s
Non-Clustered Index
09m 08s
Stored Procedure
Introduction to Stored Procedure
Preview
06m 42s
Creating Stored Procedure
06m 50s
Stored Procedure Parameters
09m 17s
Stored Procedure Inserting Data
11m 46s
Stored Procedure Deleting Data
07m 58s
Stored Procedure Updating Data
10m 25s
Stored Procedure Encrypt Alter Rename Drop
08m 21s
SQL Functions
Introduction to SQL Function
07m 21s
Scalar Functions
17m 42s
Table Valued Functions
09m 10s
SQL Server Triggers
Trigger Introduction Insert
17m 37s
Update Trigger
06m 45s
Delete Trigger
03m 32s
Instead Of Trigger
06m 36s
logon trigger
08m 08s
SQL Server Cursors
Introduction to Cursors
06m 18s
Static Cursor Example
08m 39s
Dynamic Cursor
09m 02s
Forward Only Cursor
07m 40s
Keyset Driver Cursor
06m 53s
Cursor Alternatives
Cursor Alternatives (Part-1)
02m 16s
Cursor Alternatives (Part-2)
07m 28s
Introduction to Database
Introduction to Database
Preview
0h 11m 32s
Introduction to Sql Server
Introduction to SQL Server
0h 22m 16s
SQL Keys
SQL Keys
0h 20m 24s
SQL Commands and Constraints
SQL Commands
0h 11m 44s
SQL Constraints
0h 12m 37s
Course Overview
Course Overview
Preview
0h 02m 06s
Data Types
Data Types
0h 13m 31s
Variables and Operators
Variable and Operators
0h 07m 18s
Conditional Statement
Conditional Statement
0h 20m 58s
SQL Query /Sub Query
SQLQuaries
0h 12m 01s
SQL Clauses and Predicates
0h 15m 20s
SQL Joins and Exception Handling
SQL Joins
0h 15m 15s
Exception Handling
0h 08m 02s
Course Overview
Course Overview
Preview
0h 00m 50s
Stored Procedures
Stored Procedure
0h 28m 11s
SQL Server Transaction
0h 12m 03s
SQL Function
SQL Server Functions
0h 24m 27s
Course Overview
Course Overview
Preview
0h 00m 36s
SQL Server Views
SQL server Views
0h 11m 25s
SQL Server Index
SQL Server Indexes
0h 09m 53s
Corse Overview
Course Overview
Preview
0h 00m 52s
SQL Server Triggers
SQL Server Triggers
0h 28m 50s
Logical tables and Temporary Tables
Logical Tables
0h 12m 34s
Temporary Tables
0h 05m 33s
Table Variable and SQL Server Cursors
Table Variable
0h 05m 52s
SQL Server Cursors
0h 19m 34s
It was a great learning experience at dot net tricks. I am totally satisfy with their teaching practices. The trainer's was well informative and tried his level best to trained us. The support staff was also very quick, whenever we need any assistance. All the best Dot net Tricks
I really have an amazing experience with DotNet Tricks. It helps me to explore MVC and other different technologies like Angular 2 & 4, Web API, LINQ and Bootstrap Etc. It's an honor to practice these technologies under the guidelines of Mr. Shailendra Chauhan, who has encouraged our work and motivated us to learn APS.NET MVC. I gained much knowledge from DotNet Tricks and now I'm flexible enough to work for this technology.
I have attended the ASP.NET MVC Development Training program from Dot Net Tricks. I have improved my skills and knowledge. He gives some really simple examples to explain the complicated scenarios. I am satisfied with course and its content. again i want to say thank you very much Dot Net Tricks , thanks DNT staff for your cooperation.
I have attended Shailendra Sir class for Asp.Net MVC with Angular2 & 4 He cleared many concepts of MVC and Angular and also tells us about the real life scenario where you can use these concepts. He answers whatever questions are raised during training course by students. He never gets irritated. I have cleared many basic concepts of web application development also.. which are very necessary to know when you are gradually moving to bigger companies. I have attended many training session but this training is different than others and i think more beneficial than others. I recommend professionals to join this training session.
I just completed my Xamarin Training in Dot Net Tricks with Great experience, I learned much more than expected. The course was good and very helpful. After this course I gained the my confidence and technical knowledge. if you want to learned training of Xamarin, I would definitely recommend you the DOT NET TRICKS is one of the best company. Thank you for DNT team and specially Shailendra Sir to enhance my technical knowledge in Mobiles apps background.
Yes, we do. We will discuss all possible technical interview questions and answers during the training program so that you can prepare yourself for interview.
Yes we do. As the technology upgrades we do update our content and provide your training on latest version of that technology.
Yes we do. You will get access to the entire content including class videos, mockups, and assignments through LMS.
In short, no. Check our licensing that you agree to by using Dot Net Tricks LMS. We track this stuff, any abuse of copyright is taken seriously. Thanks for your understanding on this one.
All online training classes are recorded. You will get the recorded sessions so that you can watch the online classes when you want. Also, you can join other class to do your missing classes.
All our mentors are highly qualified and experience professionals. All have at least 8-10 yrs of development experience in various technologies and are trained by Dot Net Tricks to deliver interactive training to the participants.
Enterprise-level databases supported by numerous large corporations are planned, run, and improved by SQL developers. The development of databases for businesses, organizations, etc., as well as their administration, is the developer's most crucial responsibility. For database documentation, many developers also write or gather user requirements. More work opportunities and new jobs may result from SQL certification.
The following career roles will benefit from this SQL server certification:
4.7/5 
4.5/5