44 VideosSelf-paced Course
Welcome to the free SQL Server certification course! This course will help you understand database management with Microsoft SQL Server. Starting with the basics, we'll guide you through SQL Server's role in data management along with important database concepts such as design, relationships, or normalization—all of which are necessary for developing efficient, reliable databases.
You'll study SQL commands such as SELECT, INSERT, UPDATE, and DELETE, as well as more complex features like stored procedures, functions, views, and transactions. We'll show you how to use constraints and triggers to keep your data consistent and how to increase database performance through optimization.
By the end of the course, you'll understand how to back up and restore data to keep it safe and operational. With your certification, you'll be ready to use your skills as a database administrator, data analyst, or SQL developer.
Course Features: Free SQL Server Certification Course
Video Course 44 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 This is nice learning developer site. It helped me to become more prepared and more confident in my interviews. I purchased C# interview questions and answers book is really helpful to learn a new feature. I found it online after my first interview so it has been very beneficial in preparing for the second interview. Thanks, ScholarHat!!
One of the best e-learning and training platforms I have known ever in our country. The best part is, that it always starts with basics so anyone can easily learn, understand or update their knowledge. I highly recommend ScholarHat for Software professionals who want to learn or keep themselves updated.
I am really happy that I chose ScholarHat for the Mastering Asp.Net Core with Microservices. and the quality of teaching is very good as in a few weeks I see lots of changes in myself to accept challenges which come in my project-related technologies
ScholarHat by DotNetTricks is one of the best e-learning platforms with live training. Each course gives us knowledge from basic to expertise. I highly recommend ScholarHat training to grab good technical knowledge.
ScholarHat is one of the best training platforms to learn .NET Stack technical knowledge and carrier guidance. Shailendra Sir explains the concept in the simplest way. And Especially I like the career guidance program, it will help me to clear the goals and doubts about my career.
Yes, you can Attend a Demo Session before Enrolment in angular certification course. It gives you the opportunity to assess whether the training program aligns with your learning objectives. So, don't hesitate! Take advantage of this opportunity and attend a demo session before making your decision.
Yes, of course you can request for a support session if you need to better understand the topics. For that, you need to be in touch with the counsellor. Contact on +91- 999 9123 502 or you can mail us at hello@scholarhat.com
Yes. The certificate is valid and can be used for interviews. Additionally, the student can register for the .Net Certification exam after completion of this course.
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.
All online training classes are recorded. You will get the recorded sessions so that you can watch the online classes when you want. Also, you can join other class to do your missing classes.
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.
Yes we do. You will get access to the entire content including class videos, mockups, and assignments through LMS.
Yes we do. As the technology upgrades we do update our content and provide your training on latest version of that technology.
Yes, we do. We will discuss all possible technical interview questions and answers during the training program so that you can prepare yourself for interview.
Yes, you’ll get placement assistance after receiving your course completion certificate. The placement assistance provided by the US will guide you through the job search process, help you polish your resume, and connect you with potential employers. For that, you need to be in touch with the counsellor. Contact on +91- 999 9123 502 or you can mail us at hello@scholarhat.com
A world-class learning platform
Unlimited live sessions
Quick Notes
Hands-on labs
Real-world projects
Interview Q&A
4.7/5 