Microsoft SQL for Beginners

Introduction to SQL and SQL Server

⏳ 45 minutes

• Overview of SQL Server, its role in database management, and installation guide.

• Introduction to the SQL Server Management Studio (SSMS) interface.

Basic SQL Syntax and Data Types

⏳ 1 hour

• Understanding SQL data types: INT, VARCHAR, DATE, etc.

• Writing your first SQL queries.

Creating and Managing Databases

⏳ 1 hour

• How to create a new database and set up tables.

• Understanding primary keys, foreign keys, and relationships.

Working with Tables

⏳ 1 hour

• Creating tables with various data types.

• Altering table structures and dropping tables.

Inserting, Updating, and Deleting Data

⏳ 1.5 hours

• Inserting new rows into tables.

• Updating and deleting existing data.

• The differences between DELETE, TRUNCATE, and DROP.

Retrieving Data with SELECT

⏳ 1 hour

• Writing SELECT queries to retrieve data from one or more tables.

• Using DISTINCT to eliminate duplicate results.

Filtering and Sorting Data

⏳ 1 hour

• Using WHERE clauses to filter data.

• Sorting results with ORDER BY and using multiple sort criteria.

Working with Aggregate Functions

⏳ 1 hour

• Applying aggregate functions like COUNT(), AVG(), SUM(), MIN(), and MAX().

• Using GROUP BY to group records and HAVING to filter grouped results.

Combining Results with JOINs and Set Operations

⏳ 1.5 hours

• Understanding and using INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Combining result sets using UNION and UNION ALL.

Advanced Queries and Subqueries

⏳ 1 hour

• Writing subqueries and using them in SELECT, INSERT, UPDATE, and DELETE.

• Working with nested queries and their use cases.

SQL Functions and Stored Procedures

⏳ 1 hour

• Introduction to built-in SQL functions.

• Creating and using stored procedures to automate tasks.

Course Review and Final Project

⏳ 1 hour

• Review of key concepts covered in the course.

• Final project to demonstrate your skills in SQL.

Get certificate