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 have joined the Full Stack .NET Development Training to upgrade web technologies skills and It was a great experience getting training with ScholarHat. Thanks to Trainer for his simple and effective technique of teaching. He is a very experienced and knowledgeable professional. ScholarHat provides the best course material and content. Video recordings are helpful for the revision of sessions, and videos are more understandable for clearing the concepts for doing practice thoroughly. ScholarHat Faculty is very cooperative and always ready to help us. I strongly recommend ScholarHat !!
Priyanka Kulkarni
(Technical Lead at Lumedx)
The training was absolutely superb and I genuinely enjoyed each and every moment of it. The content of Mastering MERN Stack was extremely informative and incredibly useful. I have attended several trainings before but I can't recall any of them having such a strong impact. You have done a wonderful job and I appreciate your efforts. ScholarHat staff is well-mannered and cooperative, they humbly pay attention to each professional and sort out everyone’s issues. I will surely recommend this training to all my colleagues and friends. I, myself, would love to attend future training organized or featured by you.
Tanuj Khurana
(Software Engineer at Prometric)
After joining the Full Stack .NET Developer Training, I enhanced my professional skills with the current technology in the market. The trainer has very rich technical knowledge and is very professional. He answered all the queries raised during the training. ScholarHat Faculty organized the online course very well. The online This was the best online course I have ever attended. After completion of each course, they are updating the online recorded videos & PPT materials available to us on the same day. I recommend this course to anyone who wants to become a master in .NET in a short span of time.
Rajesh Ramachandran
(Sr .NET Consultant)
I have learnt more new things from this training that enhanced my coding skills. Apart from my training, I have got knowledge for new technology that frequently changes in the IT industry. The Trainer Provides Training Very well. I am learning a lot of new things from him. And all staff of DNT are good. They are very helpful. With the help of real-time project theory concept has been clearer. The way of teaching is excellent. Definitely, I received all the information that was helpful for me.
Sandeep kumar
(Software Developer at Chipsoft India)
This training helped me to learn ASP.Net MVC and Angular Development Program to develop web applications in more efficient way. I got what I was looking for, basically to learn Typescript. Training quality is excellent and the trainer also has good Teaching skills to teach each and every topic, well explained. Real-Time project Development helped me for basically the payment gateway process and AngularJS integration with MVC. The ScholarHat Staff is very supportive and provides all the help that we used to be required.
Ashutosh Trivedi
(Sr. Software Developer.)
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
100.00 % OFF₹1,180 ₹0
12 months unlimited access to the course.
