Kickstart your data career with our Microsoft SQL Server course—hands-on training, zero experience needed. Enroll now and get SQL-savvy fast! Read more.
I am a Post Graduate Masters Degree holder in Computer Science and Engineering with experience in Android/iOS Mobile and PHP/Python Web Developer Apps
Buy this course for $199 $10
and keep lifetime access.
Access all courses in our library for only $9/month with All Access Pass
About This Course
Who this course is for:
- Aspiring IT professionals
- Beginners seeking foundational skills in database management
- Anyone interested in learning how to manage, query, and secure data using Microsoft SQL Server
What you’ll learn:
- How SQL databases operate
- Common SQL commands for data retrieval and manipulation
- Basic SQL clauses and syntax
- SQL Server data types and their applications
- Working with SQL Joins to combine data from multiple tables
- Writing sub-queries in SQL Server
- Best practices for securing a database
Requirements:
- No prior experience or technical knowledge required—this course is beginner-friendly
Welcome to The Complete Dummies Guide To Microsoft SQL Server—a beginner-friendly Microsoft SQL Server course designed to help you understand the essentials of working with structured databases.
In today’s data-driven world, the ability to manage and query data is a highly valuable skill. This course introduces you to SQL (Structured Query Language), the standard language used for managing relational databases. You’ll focus specifically on Microsoft SQL Server, one of the most widely used SQL-based systems in the industry.
Throughout the course, you’ll gain hands-on experience with:
- Setting up and operating a SQL Server database
- Using real-world SQL commands to retrieve and manipulate data
- Understanding key concepts like joins, sub-queries, and data types
- Securing your database and applying best practices in data management
Whether you’re pursuing a career in IT or simply want to enhance your data skills, this Microsoft SQL Server training will give you practical knowledge that you can apply immediately.
Become the best version of yourself. Explore my courses and unlock your potential.
Our Promise to You
By the end of this Microsoft SQL Server course, you’ll be confident in your ability to use SQL Server to manage and query databases effectively.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Start your learning journey today and build your data skills with confidence!
Not into videos? Maybe a blog would do you better? Here’s a blog selection for you.
Course Curriculum
Section 1 - Course Introduction And Table Of Contents | |||
Course Introduction And Table Of Contents | 00:00:00 | ||
Section 2 - Introduction To Database And Database Management Systems | |||
Introduction To Database And Database Management Systems | 00:00:00 | ||
Section 3 - Introduction To RDBMS And NonRDBMS | |||
Introduction To RDBMS And NonRDBMS | 00:00:00 | ||
Section 4 - Types Of SQL Commands | |||
Types Of SQL Commands | 00:00:00 | ||
Section 5 - Installing MSSQL | |||
Installing MSSQL | 00:00:00 | ||
Section 6 - Basic DB Operations | |||
Basic DB Operations - Part 1 | 00:00:00 | ||
Basic DB Operations - Part 2 | 00:00:00 | ||
Section 7 - Basic Table Operations | |||
Basic Table Operations - Part 1 | 00:00:00 | ||
Basic Table Operations - Part 2 | 00:00:00 | ||
Basic Table Operations - Part 3 | 00:00:00 | ||
Basic Table Operations - Part 4 | 00:00:00 | ||
Section 8 - Sample Databases Import | |||
Sample Databases Import | 00:00:00 | ||
Section 9 - Aggregate Functions In MSSQL | |||
Aggregate Functions In MSSQL - Part 1 | 00:00:00 | ||
Aggregate Functions In MSSQL - Part 2 | 00:00:00 | ||
Section 10 - Clauses In MSSQL | |||
Clauses In MSSQL - Part 1 | 00:00:00 | ||
Clauses In MSSQL - Part 2 | 00:00:00 | ||
Clauses In MSSQL - Part 3 | 00:00:00 | ||
Section 11 - Grouping Sets Clause | |||
Grouping Sets Clause - Part 1 | 00:00:00 | ||
Grouping Sets Clause - Part 2 | 00:00:00 | ||
Section 12 - SQL Basic Operators | |||
SQL Basic Operators - Part 1 | 00:00:00 | ||
SQL Basic Operators - Part 2 | 00:00:00 | ||
Section 13 - Union And Intersect Operators | |||
Union And Intersect operators | 00:00:00 | ||
Section 14 - Popular Datatypes Introduction | |||
Popular Datatypes Introduction - Part 1 | 00:00:00 | ||
Popular Datatypes Introduction - Part 2 | 00:00:00 | ||
Section 15 - Popular Datatypes Example | |||
Popular Datatypes Example | 00:00:00 | ||
Section 16 - Constraints - Primary Key | |||
Constraints - Primary Key - Part 1 | 00:00:00 | ||
Constraints - Primary Key - Part 2 | 00:00:00 | ||
Section 17 - Constraints - Foreign Key | |||
Constraints - Foreign Key - Part 1 | 00:00:00 | ||
Constraints - Foreign Key - Part 2 | 00:00:00 | ||
Section 18 - NOT NULL And UNIQUE Constraints | |||
NOT NULL And UNIQUE Constraints - Part 1 | 00:00:00 | ||
NOT NULL And UNIQUE Constraints - Part 2 | 00:00:00 | ||
Section 19 - CHECK And DEFAULT Constraints | |||
CHECK And DEFAULT Constraints - Part 1 | 00:00:00 | ||
CHECK And DEFAULT Constraints - Part 2 | 00:00:00 | ||
Section 20 - ER Diagram Overview | |||
ER Diagram Overview | 00:00:00 | ||
Section 21 - SQL Popular String Functions | |||
SQL Popular String Functions - Part 1 | 00:00:00 | ||
SQL Popular String Functions - Part 2 | 00:00:00 | ||
Section 22 - SQL Popular Date Functions | |||
SQL Popular Date Functions - Part 1 | 00:00:00 | ||
SQL Popular Date Functions - Part 2 | 00:00:00 | ||
Section 23 - SQL Popular Mathematical Functions | |||
SQL Popular Mathematical Functions | 00:00:00 | ||
Section 24 - SQL Popular Convert Functions | |||
SQL Popular Convert Functions | 00:00:00 | ||
Section 25 - Joins - Introduction And Table Preparation | |||
Joins - Introduction And Table Preparation - Part 1 | 00:00:00 | ||
Joins - Introduction And Table Preparation - Part 2 | 00:00:00 | ||
Joins - Introduction And Table Preparation - Part 3 | 00:00:00 | ||
Section 26 - Inner Join | |||
Inner Join | 00:00:00 | ||
Section 27 - Outer Join | |||
Outer Join | 00:00:00 | ||
Section 28 - Self Join | |||
Self Join | 00:00:00 | ||
Section 29 - Cross Join | |||
Cross Join | 00:00:00 | ||
Section 30 - Stored Procedure Basics | |||
Stored Procedure Basics - Part 1 | 00:00:00 | ||
Stored Procedure Basics - Part 2 | 00:00:00 | ||
Section 31 - Stored Procedure Passing Parameters And Return | |||
Stored Procedure Passing Params And Return | 00:00:00 | ||
Section 32 - SQL SubQueries | |||
SQL SubQueries | 00:00:00 | ||
Section 33 - SQL Views | |||
SQL Views | 00:00:00 | ||
Section 34 - SQL Triggers - DDL Triggers | |||
SQL Triggers - DDL Triggers | 00:00:00 | ||
Section 35 - SQL Triggers - DML Trigger | |||
SQL Triggers DML Trigger - Part 1 | 00:00:00 | ||
SQL Triggers DML Trigger - Part 2 | 00:00:00 | ||
Section 36 - SQL Transactions | |||
SQL Transactions - Part 1 | 00:00:00 | ||
SQL Transactions - Part 2 | 00:00:00 | ||
Section 37 - Normalization | |||
Normalization | 00:00:00 | ||
Section 38 - DB Backup And Restore | |||
DB Backup And Restore | 00:00:00 | ||
Section 39 - Securing The Database | |||
Securing The Database | 00:00:00 | ||
Query Source | 00:00:00 |
About This Course
Who this course is for:
- Aspiring IT professionals
- Beginners seeking foundational skills in database management
- Anyone interested in learning how to manage, query, and secure data using Microsoft SQL Server
What you’ll learn:
- How SQL databases operate
- Common SQL commands for data retrieval and manipulation
- Basic SQL clauses and syntax
- SQL Server data types and their applications
- Working with SQL Joins to combine data from multiple tables
- Writing sub-queries in SQL Server
- Best practices for securing a database
Requirements:
- No prior experience or technical knowledge required—this course is beginner-friendly
Welcome to The Complete Dummies Guide To Microsoft SQL Server—a beginner-friendly Microsoft SQL Server course designed to help you understand the essentials of working with structured databases.
In today’s data-driven world, the ability to manage and query data is a highly valuable skill. This course introduces you to SQL (Structured Query Language), the standard language used for managing relational databases. You’ll focus specifically on Microsoft SQL Server, one of the most widely used SQL-based systems in the industry.
Throughout the course, you’ll gain hands-on experience with:
- Setting up and operating a SQL Server database
- Using real-world SQL commands to retrieve and manipulate data
- Understanding key concepts like joins, sub-queries, and data types
- Securing your database and applying best practices in data management
Whether you’re pursuing a career in IT or simply want to enhance your data skills, this Microsoft SQL Server training will give you practical knowledge that you can apply immediately.
Become the best version of yourself. Explore my courses and unlock your potential.
Our Promise to You
By the end of this Microsoft SQL Server course, you’ll be confident in your ability to use SQL Server to manage and query databases effectively.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Start your learning journey today and build your data skills with confidence!
Not into videos? Maybe a blog would do you better? Here’s a blog selection for you.
Course Curriculum
Section 1 - Course Introduction And Table Of Contents | |||
Course Introduction And Table Of Contents | 00:00:00 | ||
Section 2 - Introduction To Database And Database Management Systems | |||
Introduction To Database And Database Management Systems | 00:00:00 | ||
Section 3 - Introduction To RDBMS And NonRDBMS | |||
Introduction To RDBMS And NonRDBMS | 00:00:00 | ||
Section 4 - Types Of SQL Commands | |||
Types Of SQL Commands | 00:00:00 | ||
Section 5 - Installing MSSQL | |||
Installing MSSQL | 00:00:00 | ||
Section 6 - Basic DB Operations | |||
Basic DB Operations - Part 1 | 00:00:00 | ||
Basic DB Operations - Part 2 | 00:00:00 | ||
Section 7 - Basic Table Operations | |||
Basic Table Operations - Part 1 | 00:00:00 | ||
Basic Table Operations - Part 2 | 00:00:00 | ||
Basic Table Operations - Part 3 | 00:00:00 | ||
Basic Table Operations - Part 4 | 00:00:00 | ||
Section 8 - Sample Databases Import | |||
Sample Databases Import | 00:00:00 | ||
Section 9 - Aggregate Functions In MSSQL | |||
Aggregate Functions In MSSQL - Part 1 | 00:00:00 | ||
Aggregate Functions In MSSQL - Part 2 | 00:00:00 | ||
Section 10 - Clauses In MSSQL | |||
Clauses In MSSQL - Part 1 | 00:00:00 | ||
Clauses In MSSQL - Part 2 | 00:00:00 | ||
Clauses In MSSQL - Part 3 | 00:00:00 | ||
Section 11 - Grouping Sets Clause | |||
Grouping Sets Clause - Part 1 | 00:00:00 | ||
Grouping Sets Clause - Part 2 | 00:00:00 | ||
Section 12 - SQL Basic Operators | |||
SQL Basic Operators - Part 1 | 00:00:00 | ||
SQL Basic Operators - Part 2 | 00:00:00 | ||
Section 13 - Union And Intersect Operators | |||
Union And Intersect operators | 00:00:00 | ||
Section 14 - Popular Datatypes Introduction | |||
Popular Datatypes Introduction - Part 1 | 00:00:00 | ||
Popular Datatypes Introduction - Part 2 | 00:00:00 | ||
Section 15 - Popular Datatypes Example | |||
Popular Datatypes Example | 00:00:00 | ||
Section 16 - Constraints - Primary Key | |||
Constraints - Primary Key - Part 1 | 00:00:00 | ||
Constraints - Primary Key - Part 2 | 00:00:00 | ||
Section 17 - Constraints - Foreign Key | |||
Constraints - Foreign Key - Part 1 | 00:00:00 | ||
Constraints - Foreign Key - Part 2 | 00:00:00 | ||
Section 18 - NOT NULL And UNIQUE Constraints | |||
NOT NULL And UNIQUE Constraints - Part 1 | 00:00:00 | ||
NOT NULL And UNIQUE Constraints - Part 2 | 00:00:00 | ||
Section 19 - CHECK And DEFAULT Constraints | |||
CHECK And DEFAULT Constraints - Part 1 | 00:00:00 | ||
CHECK And DEFAULT Constraints - Part 2 | 00:00:00 | ||
Section 20 - ER Diagram Overview | |||
ER Diagram Overview | 00:00:00 | ||
Section 21 - SQL Popular String Functions | |||
SQL Popular String Functions - Part 1 | 00:00:00 | ||
SQL Popular String Functions - Part 2 | 00:00:00 | ||
Section 22 - SQL Popular Date Functions | |||
SQL Popular Date Functions - Part 1 | 00:00:00 | ||
SQL Popular Date Functions - Part 2 | 00:00:00 | ||
Section 23 - SQL Popular Mathematical Functions | |||
SQL Popular Mathematical Functions | 00:00:00 | ||
Section 24 - SQL Popular Convert Functions | |||
SQL Popular Convert Functions | 00:00:00 | ||
Section 25 - Joins - Introduction And Table Preparation | |||
Joins - Introduction And Table Preparation - Part 1 | 00:00:00 | ||
Joins - Introduction And Table Preparation - Part 2 | 00:00:00 | ||
Joins - Introduction And Table Preparation - Part 3 | 00:00:00 | ||
Section 26 - Inner Join | |||
Inner Join | 00:00:00 | ||
Section 27 - Outer Join | |||
Outer Join | 00:00:00 | ||
Section 28 - Self Join | |||
Self Join | 00:00:00 | ||
Section 29 - Cross Join | |||
Cross Join | 00:00:00 | ||
Section 30 - Stored Procedure Basics | |||
Stored Procedure Basics - Part 1 | 00:00:00 | ||
Stored Procedure Basics - Part 2 | 00:00:00 | ||
Section 31 - Stored Procedure Passing Parameters And Return | |||
Stored Procedure Passing Params And Return | 00:00:00 | ||
Section 32 - SQL SubQueries | |||
SQL SubQueries | 00:00:00 | ||
Section 33 - SQL Views | |||
SQL Views | 00:00:00 | ||
Section 34 - SQL Triggers - DDL Triggers | |||
SQL Triggers - DDL Triggers | 00:00:00 | ||
Section 35 - SQL Triggers - DML Trigger | |||
SQL Triggers DML Trigger - Part 1 | 00:00:00 | ||
SQL Triggers DML Trigger - Part 2 | 00:00:00 | ||
Section 36 - SQL Transactions | |||
SQL Transactions - Part 1 | 00:00:00 | ||
SQL Transactions - Part 2 | 00:00:00 | ||
Section 37 - Normalization | |||
Normalization | 00:00:00 | ||
Section 38 - DB Backup And Restore | |||
DB Backup And Restore | 00:00:00 | ||
Section 39 - Securing The Database | |||
Securing The Database | 00:00:00 | ||
Query Source | 00:00:00 |