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.
Who should take this Course?
The Microsoft SQL Server Online Course is ideal for database administrators, data analysts, developers, and IT professionals who want to learn how to install, manage, and query databases using Microsoft SQL Server. It’s also suitable for students and professionals preparing for roles in data management, business intelligence, or preparing for Microsoft certification exams. Basic knowledge of databases and SQL is helpful but not required, making it accessible to both beginners and intermediate learners.
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?
