Database Fundamentals Using Microsoft SQL Server
This course will provide you all the necessary skills you need to be a successful database developer, administrator or data analyst. It includes beginner and advanced level projects.
What is SQL Server?
Install SQL Server
Connect to the SQL Server
SQL Server Sample Database
Load Sample Database
Install SQL Server 2017
SQL Server Basics
SQL Server SELECT
Assignment 1 - Create Customers table
SQL Server ORDER BY
SQL Server OFFSET FETCH
SQL Server SELECT TOP
SQL Server WHERE
Assignment - Retrieve data from tables
1.1 Understand how data is stored in tables
1.2 Understand relational database concepts
1.3 Understand data manipulation language (DML)
1.4 Understand data definition language (DDL)
1.5 Constraints
Quiz - 1
Introduction to SQL
Final Exam Score