Microsoft SQL Server Online Course
Curious about how Microsoft SQL Server handles vast amounts of data with speed and efficiency? This course is your gateway to understanding and working with SQL Server to design and build robust database systems.
You’ll start with a clear introduction to SQL Server and the fundamentals of databases, followed by step-by-step guidance on installing SQL Server Express. From there, you’ll learn how to connect to a database instance, create new databases, and design tables.
As you advance, you'll write and execute queries to manipulate data, define relationships using foreign keys, and apply normalization techniques to optimize your database structure. You'll also use aggregate functions such as AVG, COUNT, MAX, and SUM to perform data analysis.
By the end of this course, you'll have a solid grasp of SQL Server 2017 and the confidence to write effective SQL queries for building and managing databases.
Course Curriculum
Introduction
- Introduction to SQL Server and Databases
- Understanding Types of Data and Storage
Environment Setup
- Download and Install SQL Server Express (Windows)
- Download and Install SQL Server Express on Mac and Linux
Understanding the Toolset
- Explore SQL Server Management Studio
- Explore Azure Data Studio
- Explore Draw.io
Creating and Manipulating Databases
- Section Overview
- Create a Database Using Management Studio
- Create a Database Using SQL Script
- How to Remove a Database
- How to Change Database Name
- Section Review
Managing Tables and Data
- What Is a Database Table?
- Create Entity Data Model
- Create a Database Table Using Management Studio
- What Is SQL?
- Create a Database Table Using SQL Script
- Review Table Creation
- Insert Data into the Table Using Management Studio
- Insert Data into the Table Using SQL Scripts
- Select Data from Tables - Simple Queries
- Select Data from Tables - Adding Filtering
- Select Data from Tables - Exporting Data
- Update Data in Tables
- Delete Data from the Tables
- SQL Transactions
- Review CRUD Operations
Normalization, Relationships, and Foreign Keys
- What Are Relationships, Foreign Keys, and Normalization?
- Normalizing Our Database
- Creating a Relationship in SQL Server
- Inserting Records in One-to-Many Related Tables
- Inserting Records in Many-to-Many Related Tables
- Using Inner Joins to Read Related Data
- Understanding Left, Right, and Full Joins
- Foreign Key Cascade Options
- Section Review
GROUP BY and Aggregate Functions
- Grouping Data Using the SQL GROUP BY Clause
- SQL COUNT Aggregate Function
- SQL AVG Aggregate Function
- SQL MAX and MIN Aggregate Functions
- SQL SUM Aggregate Function
- Filtering on Aggregate Values
Advanced SQL Server Objects and Concepts
- Section Overview
- Creating and Managing Views
- Scalar Valued Functions
- Inline Table-Valued Functions
- Multi-Statement Table-Valued Functions
- Stored Procedures
- Table Triggers
- Generating Database Scripts
- Database Backup and Restoring
SQL Server Security
- Section Overview
- Create a SQL User Login
- Add Windows Authenticated Login
- Add Server Logins with Script