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
I joined in Scholarhat Mastering Mastering Angular 2 to 6. I got to know a lot of the thing from the course. It was a nice experience for me that this course evidence enhances my profile to grab new opportunities. I am really happy to share trainer knowledge. They have IDS logic real time Industry expert and have been very impressed with their speed of implemention and professional approach to their learning. I am very happy that I choose Scholarhat.
Chirag Saxena
(Software Engineer)
I have imaging experience with ScholarHat. I joined ScholarHat to upgrade my latest skills for new demanding upcoming technologies. Good Experience in Mastering Asp.Net MVC with Angular. The course contents are real-time base and the trainer way of teaching are imaging. The LMS interfaces are very good and easy to understand Thanks, ScholarHat.
Achal Prajapati
(Senior Software Engineer )
I have taken the ScholarHat Mastering Asp.Net MVC with Angular development course. I recommended ScholarHat is the best online training platform to learn & develop coding skills. Course content covers each & prospect of web development, interview questions & answer explanation helps me lot to gain confidence to crack the interview. Their cloud base LMS panel is very convenient for learning after live session what else I can expect from a Training my experience was pleasant.
Chetan Sharma
(Senior Software Developer)
I am currently working in North California I took instructor-led online Training on Mastering Azure Development Solutions. It was a nice experience for me that honestly speaking help me grow in my career with 90% growth. After completion of my training, I cracked 3 interviews in the USA at the same time. Almost all questions of interview were discussed and how to answer was discussed in the Live session. I learnt real-time exposure as project development part was based upon how we work on clients projects. I would surely recommend Scholarhat for everyone interested in upgrading their knowledge. In this competitive world.
Amod Nikam
(Tech lead Morrisville, North Carolina)
It was a great experience with the ScholarHat.The Course content was well defined and easy to understand. The most important part of the session Step by step project development help to get the things quick understandable. The certification has helped to boost my career goal. Thanks, ScholarHat!
Ankit Gupta
(Technical Lead )
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
57.17 % OFF₹1,179 ₹499
12 months unlimited access to the course.
