The Complete Dummies Guide To Microsoft SQL Server

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.

No ratings yet
Course Skill Level
Beginner
Time Estimate
7h 48m

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

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

Are you interested in higher education?