Microsoft SQL Server Online Course
Microsoft SQL Server Development for Everyone
Do you want to gain knowledge of Microsoft SQL Server to understand how it stores and retrieves huge amounts of data? This video will help you learn about Microsoft SQL Server, including the features and functionalities that are needed to design and develop reliable database systems.
The course begins with an introduction to SQL Server and databases, followed by a guided installation of SQL Server Express. After setting up, you'll learn to connect to a database instance, create a new database, and build tables within it. As you progress, you'll run queries to manipulate tables and data, as well as establish relationships in SQL Server through foreign keys and normalization. You'll also learn to perform mathematical operations using aggregate functions like AVG, COUNT, MAX, and SUM.
By the end of this course, you will be well-versed with SQL Server 2017 and have developed the skills to write SQL queries for manipulating 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
