4.7/5 
4.5/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 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
-
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
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
Dot net Tricks Training is career turning training where I have learnt ASP.NET MVC with Anugular JS and enhanced my concepts & Development skills. Best thing is that they always introduce the latest technology during Training and update skills with latest industry trends available in IT industries also upcoming ones. I am especially impressed with teaching techniques of Mr. Shailendra Chauhan. I would like to suggest you as well if you are looking for something different.
Shubham Agarwal
(Software Developer)
Mr. Shailendra is very experienced and highly competent. I attended MEAN course under his guidance. His presentation is confident and extremely perceptive of the various existing skills and he knows well about the latest technology trends in the market and needs of his audience. I would like to thanks him and congrats for his initiative. Personally, I want to suggest if you need best in your career go with Dot Net Tricks
Rajneesh Joshi
(UI Developer)
It was very good experience getting NodeJS Development Training with Dot Net Tricks. Top quality of training by Mr. Shailendra Chauhan Project Implementation was superb!. Join this place for quality training.
Mayank Agarwal
(Sr. Software Engineer )
My experience with the Dot Net Tricks has been phenomenal. The center has set a bar of expectation that I am not sure other centers would ever be able to meet! I learned so much, had fun, made friends and truly enjoyed time at the Dot Net Tricks. I suggest you to update your project implementation skills.
Mahesh Verma
(Software Engineer)
There is no doubt about quality of Dot Net Tricks real time project base training. There project implementation is impressive that help me lot to develop my company project easily by this training, I have got confidence about where to implement what. If you have been facing problem in development you should try Dot Net Tricks.
Pankaj Tiwari
(Software Engineer)
Frequently Asked Questions
Q1. Do you offer certificates of completion?
We do. Once you've finished a course, reach out to us.
Q2. 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
Q3. 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.
Q4. Do you provide technology version upgrade session free?
Yes, we do. As the technology upgrades your content gets updated at no cost.
Q5. 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.
Q6. 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.
Q7. 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
Q8. 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.
Q9. 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.
Q10. 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.
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
