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
6 Tests
Skill Tests
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
- Skill Tests 6 Tests
- 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 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: Joins
00:20:00
SQL Server: Primary Key
00:20:00
SQL Server: Distinct Clause
00:25:00
SQL Server: Stored Procedures
00:25:00
SQL Server: Triggers
00:40:00
SQL Server: Views
00:15:00
SQL Server: Indexes
00:30:00
SQL Server: Order By Clause
00:35:00
SQL Server: Foreign Key
00:25:00
SQL Server: Inner Join
00:25:00
SQL Server: Self Join
00:25:00
SQL Server: Not Null Constraint
00:15:00
SQL Server: Where Clause
00:35:00
SQL Server: Built-In Functions
00:40:00
SQL Server: Aggregate Functions
00:35:00
SQL Server: Check Constraint
00:25:00
SQL Server: Outer Join
00:30:00
SQL Server: Left Outer Join
00:15:00
SQL Server: Unique Constraint
00:15:00
SQL Server: Default Constraint
00:15:00
SQL Server: Right Outer Join
00:20:00
SQL Server: Full Outer Join
00:15:00
SQL Server: Insert Statement
00:20:00
SQL Server: Select Statement
00:15:00
SQL Server: Operations on Joins
00:35:00
SQL Server: Subqueries
00:20:00
Skill Tests Tests (6)
SQL Server Skill Challenge
15 Questions
Introduction to SQL Server
15 Questions
T-SQL Fundamentals with SQL Server
15 Questions
SQL Server Views & Indexes
15 Questions
SQL Server Stored Procedures & Functions
15 Questions
SQL Server Triggers & Cursors
15 Questions
Introduction to Database
Introduction to Database Preview 11m 32s Introduction to Sql Server
Introduction to SQL Server 22m 16s SQL Keys
SQL Keys 20m 24s SQL Commands and Constraints
SQL Commands 11m 44s SQL Constraints 12m 37s Course Overview
Course Overview Preview 02m 06s Data Types
Data Types 13m 31s Variables and Operators
Variable and Operators 07m 18s Conditional Statement
Conditional Statement 20m 58s SQL Query /Sub Query
SQLQuaries 12m 01s SQL Clauses and Predicates 15m 20s SQL Joins and Exception Handling
SQL Joins 15m 15s Exception Handling 08m 02s Corse Overview
Course Overview Preview 00m 52s SQL Server Triggers
SQL Server Triggers 28m 50s Logical tables and Temporary Tables
Logical Tables 12m 34s Temporary Tables 05m 33s Table Variable and SQL Server Cursors
Table Variable 05m 52s SQL Server Cursors 19m 34s Our Students Reviews
ScholarHat is a nice online institute. I have studied in Several institutes but this is the best among all. The best thing here is Shailendra Sir, the way he teaches is nice, and easy to understand. As per my experience, ScholarHat is the best place for the latest technology learning. I have completed the course ASP.NET Core with MVC and it helped me a lot to understand the concept properly.
Avinash Kumar
(software Engineer at Tech Mahindra)
It was an excellent experience to learn MERN Stack training from ScholarHat. The courses are top rate and the best part is live instruction, with playback. DNT is one of the modern platforms to learn and equip in the IT Market. I have learned a lot from this training. And really helped to understand all the concepts very well. Thanks again.
Gulam Simnani Qureshi
(UI developer at CRMnext)
This is the first time I have completed the online Training for MVC5 with the angular 2 & 4 development program, earlier I attended classroom training. But now considering the way ScholarHat provides training is awesome. Training Quality is a knowledgeable and well-managed session. The trainer has in-depth knowledge of technology and trying to give his best to share the same. ScholarHat staff are Cooperative and well-behaved.
Vilas mahale
(Cognizant Pune As SA)
I would like to thank ScholarHat for providing training on the latest technologies ASP. Net MVC5 with Angular 4 and I got what I was looking for, basically to learn Typescript and Angular 2 & 4. The ScholarHat Staff is very supportive and provides all the help that we used to be required. I appreciate the Trainer's way, of clearing the concept, and deliberating the knowledge to others is excellent. I appreciate the Scholarhat Team backup staff, really amazing. Regular Monitoring sessions via mock-up tests as well as assignments, which proved of great help at the time of project development, paying attention individually is Great. The study material is also easy to understand and the video can be downloaded after every session. I strongly recommend ScholarHat, even if they provide WhatsApp for the resolution of any technical query. Thanks for standing with me for all my concerns.
Gourav Tyagi
(Senior Project Manager at Larsen & Toubro Infotech)
Shailendra sir has in-depth and sound knowledge of .NET and related stack. His way of conducting sessions and handling doubts/queries is awesome. And the staff are awesome they are eager to help that’s sounds Great. All the assignments and videos are also very helpful to enhance .NET knowledge. I would like to thank ScholarHat for providing training on the Advanced Full Stack .NET and grooming my career for future perspective.
Sameer Vyas
(Technical Lead at Wipro)
Frequently Asked Questions
Q1. What is Self Paced course offered by ScholarHat?
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.
Still have some questions? Let's discuss.
CONTACT USThis course includes
71.06 % OFF₹3,065 ₹875
12 months unlimited access to the course.
Unlimited live sessions
Real-world projects