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
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 )
I loved ScholarHat course! With my new upgrade technology Mastering Asp.Net Core with Angular skill-set, Learned practical knowledge of ASP.Net Core with Angular. The teaching method of Trainer is very easy to understand. This is definitely value addition to my career. Thanks, ScholarHat!
Ashish Nakil
(Software Engineer)
I have 5 years of experience working in dot net technology. I want to switch my job because there was not learning and salary growth with my previous employer. So, I started giving interview but after a couple of weeks, I realize that people looking for the candidate who knows MVC and Core with Angular. So my friends refer to ScholarHat. I have taken Mastering Asp.Net Core with Angular course from ScholarHat. The best part of the training was hands-on project. The trainer was excellent with crisp and quality real-time hands-on best training. Which helped me lot clear out doubts. After training enhance my confidence and knowledge. Have to say one of the best platforms to learn ScholarHat.
S.S.Vinodh Vinu
(Sr. Programmer Analyst )
I have taken two courses from ScholarHat self-paced training program. The complete Asp.Net MVC with Angular and The complete Xamarin forms. Both courses were amazing. The quality of the contents was very good. The trainer was excellent with crisp. I suggest everyone avail ScholarHat online self- paced course to meet future planning growth. Thanks, ScholarHat, and Happy Learning.
Yashobanta Bai
(Technology Lead at Icertis)
My name is Jaideep, I am a software developer consultant, I have been working on .NET, asp.net web forms, SQL Being honest I was able to develop applications my own, but I was not very confident about my coding, might be that was the reason, I was not getting salary increment nor able to crack interview. As we know to be an IT professional we need to update and keep enhancing our skills. After looking for many courses I decided to master Asp.Net Core with angular online Training from ScholaHat, this course not only helped me MVC and .Net CORE but also Angular, This real-time training program help gain confidence in Hands-on coding, learn to implement best practices and design patterns. I really thanks ScholarHat for this training.
Jaideep Bisht
(Software Development Consultant at NTT DATA)
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.
