4.7/5 
4.7/5
SQL Server Database and Tables
00:04:00
Course Preview
SQL Server Course
Self Paced Course
72 Videos
Video Course
19 Notes
Quick Notes
26 Labs
Hands-on Labs
26 Videos
Interview Q&A
SQL Server Course Overview
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.
Course objectives
Participants in the SQL training online course will have the following skills after completing this course:
- Understand the SQL Server architecture and its various components
- Understand how to install and configure SQL Server
- Understand the basics of SQL and T-SQL programming
- Understand how to design and create SQL Server databases
- Understand how to use data types, constraints, and keys
- Write SQL Query and Subqueries
- Understand how to use SQL Server Views and Indexes
- Understand how to use SQL Server Stored Procedures and Functions
- Understand how to use SQL Server Triggers and Cursors
SQL Server Course Eligibility
Who can Join the 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.
Pre-requisites
There are no prerequisites to learn SQL server course.
Tools/IDE
SQL Server, SQL Server Management Studio
Included in this SQL Server Course
-
Video Course 72 Videos
-
Quick Notes 19 Notes
-
Labs 26 labs
-
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
Quick Notes Notes (19)
SQL Keys
00:03:00
SQL Commands
00:02:00
SQL Constraints
00:02:00
SQL Server Data Types & Variables
00:02:00
SQL Server Operators
00:02:00
SQL Server Control Of Flow
00:02:00
SQL Query and Sub Query
00:02:00
SQL Clauses
00:03:00
SQL Predicates
00:01:00
SQL Joins
00:02:00
SQL Exceptions
00:01:00
Try..Catch in SQL Server
00:03:00
SQL Server Views
00:02:00
SQL Server Indexes
00:02:00
SQL Server Stored Procedure
00:02:00
SQL Functions
00:02:00
SQL Server Triggers
00:02:00
SQL Server Cursors
00:01:00
Hands-On Labs Labs(26)
SQL Server: Primary Key
00:20:00
SQL Server: Foreign Key
00:25:00
SQL Server: Not Null Constraint
00:15:00
SQL Server: Check Constraint
00:25:00
SQL Server: Unique Constraint
00:15:00
SQL Server: Default Constraint
00:15:00
SQL Server: Insert Statement
00:20:00
SQL Server: Select Statement
00:15:00
SQL Server: Joins
00:20:00
SQL Server: Distinct Clause
00:25:00
SQL Server: Order By Clause
00:35:00
SQL Server: Inner Join
00:25:00
SQL Server: Self Join
00:25:00
SQL Server: Where Clause
00:35:00
SQL Server: Outer Join
00:30:00
SQL Server: Left Outer Join
00:15:00
SQL Server: Right Outer Join
00:20:00
SQL Server: Full Outer Join
00:15:00
SQL Server: Operations on Joins
00:35:00
SQL Server: Subqueries
00:20:00
SQL Server: Views
00:15:00
SQL Server: Indexes
00:30:00
SQL Server: Stored Procedures
00:25:00
SQL Server: Built-In Functions
00:40:00
SQL Server: Aggregate Functions
00:35:00
SQL Server: Triggers
00:40:00
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
Our Students Reviews
First of all I would like to thank DNT for everything. Here is my experience in Dot Net Tricks - "When I came to know about DNT, honestly I didn't have much idea about Xamarin Forms and was looking for job. So I thought it would be a better option to join here and get some knowledge about real time project and few interviews, which would be a big thing for me. Then I was assured by the staff from the DNT and joined. From day one I felt a different energetic atmosphere in the class room. And about the staff all are well educated, trained and also very much friendly to everyone, as a student which helped me a lot, they never shown any irritation even though I was asking same things repeatedly. The main thing is that all the syllabus covered up in a proper manner, so that a student can understand each things about the training. And thanks for providing some important seminar which helped me a lot to crack a interview. Thank you DNT for making my career". I have ever taken so far in my life time, and day by day it’s getting better for me.I have got confidence facing Xamarin interviews and learned lot of new real time scenario. Shailendra Sir is a passionate trainer he give some really simple examples to explain the complicated scenarios. he always make us think and also answer our questions smartly. Keep rocking DotNetTricks, your team is doing great job.. Way to Go..
Rajkishore Yadav
(Sr. Software Developer)
It's a great experience to be part of dotnet tricks. this Training really helps me for improving my enhancements skills professionally also. If I talk about interview purpose it's really a great great opportunity because in training class this was my personal experience that Sir won't leave a single scenario that Interviewer going to ask you. He covers all the concepts theoretical as more focused on practical. If you really want to beat Interview and get good job and hike join dot net tricks.
Deepali Panwar
(Software Engineer )
First of all thank you Shailendra sir for your great knowledge, amazing energy, good style of teaching and hard effort you put into MVC class. This was the best class i joined, it helped me to enhance my skills. I think you are excellent at motivating people to enjoy the class and do their best. It's just incredible to see how different your approach is from others. It was great learning experience with you. You and this class will be remembered for long time. Thanks Dot Net Tricks...
Vipul Kaushik
(Associate Technical Lead )
Scholarhat training is really professional, and Services provided by them on installation & technical issues are mind blowing. This training was really helpful for me in understanding the asp.net core. In one word, I have received "Outstanding support" from Scholarhat and its staff. trainers is very supportive. Scholarhat is very well organized and structured organization. In Scholarhat, you will find each bit of information scratch to In-depth. Training materials, Interview blogs, Assignment, Quiz and etc. are organized in proper way. Finally, I will recommend Scholarhat to anybody, looking for instructor led live session to keep oneself up to date with the latest trends & technology.
Hardeep Singh
(Team Lead)
I am so glad after join to dot net trick, It was a really nice training. Helped me a lot to enhance my skills. Our professor is not only a good tutor but also a true guide for student bright future. dot net trick to gain true knowledge with great guidance and helped me so much specially in cracking interview.
Sulabh Kaushik
(Software Developer)
Frequently Asked Questions
Q1. What is Self Paced course offered by Dot Net Tricks?
Online Self Paced Courses are designed for self-directed training, allowing participants to begin at their convenience with structured training and review exercises to reinforce learning. You'll learn through videos, PPTs, and Assignments designed to enhance learning outcomes, all at times that are most convenient for you.
Q2. Who are your mentors?
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.
Q3. How would I get access to the Learning Content?
As soon as you enroll in the course, you will get access to the course content through LMS (The Learning Management System) in the form of a complete set of Videos, PPTs, PDFs, and Assignments. You can start learning right away.
Q4. How do I enroll for the course?
You can enroll in the course by doing payment. Payment can be made using any of the following options.
- Visa debit/credit card
- Net banking
- Through PayPal
Q5. Student discounts?
Yes, Dot Net Tricks provides student discount to learners who cannot afford the fee. Email us from your student account, or attach your student ID.
Q6. Can I share my course with someone else?
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.
Q7. How do I setup my team?
Please drop us an email with a list of user details like name, email you’d like to enroll and have access, we'll create your team accounts.
Q8. Do you provide technology version upgrade session free?
Yes, we do. As the technology upgrades your content gets updated at no cost.
Q9. Whom do I contact, if I have more queries?
You can give us a CALL at +91 113 303 4100 OR email us at enquiry@dotnettricks.com
Q10. Do you offer certificates of completion?
We do. Once you've finished a course, reach out to us.
This course includes
57.17 % OFF
₹ 1,179
₹ 499
12 months unlimited access to the course.
Still have some questions? Let's discuss.
CONTACT US
