SQL Server 2017 Basics Training Course

If you want to master SQL Server 2017 quickly, this 2.5-hour training course is perfect for beginners. In this tutorial, you'll learn all the essential skills to create, manage, and manipulate databases like a pro.

Introduction to Microsoft SQL Server 📚​

Microsoft SQL Server is one of the most popular relational database management systems (RDBMS).
In this section, you'll understand:

• What SQL Server is
• How it stores and manages data
• Its main components (Databases, Tables, Queries)

---

​

Installing SQL Server 2017 🛠️​

Learn how to install SQL Server 2017 on your system, including:

• SQL Server setup wizard
• Selecting features
• Configuring services and authentication

---

​

Working with Databases 🗄️​

Databases are the backbone of any application. In this section, you'll learn how to:

• Create a database:

CREATE DATABASE MyDatabase;

• Alter a database:

ALTER DATABASE MyDatabase MODIFY NAME = NewDatabaseName;

• Drop a database:

DROP DATABASE MyDatabase;

---

​

Creating and Managing Tables 📝​

Tables store the actual data. You'll learn how to:

• Create a table:

CREATE TABLE Employees (
    ID INT PRIMARY KEY,
    Name NVARCHAR(50),
    Salary DECIMAL(10,2)
);

• Alter a table:

ALTER TABLE Employees ADD Email NVARCHAR(50);

• Drop a table:

DROP TABLE Employees;

---

​

Data Manipulation Language (DML) Basics ✨​

DML lets you insert, update, delete, and query data.

Insert Data ➕​

INSERT INTO Employees (ID, Name, Salary)
VALUES (1, 'John Doe', 50000);

Select Data 🔍​

Learn how to fetch data using SELECT statements:

• Basic SELECT:

SELECT * FROM Employees;

• Filter with WHERE:

SELECT * FROM Employees WHERE Salary > 40000;

• Using Operators (=, <>, >, <, >=, <=):

SELECT * FROM Employees WHERE Name LIKE 'J%';

• UNION & UNION ALL:

SELECT Name FROM Employees
UNION
SELECT Name FROM Contractors;

• EXISTS:

SELECT * FROM Employees WHERE EXISTS
(SELECT * FROM Departments WHERE Departments.ID = Employees.ID);

• Sorting with ORDER BY:

SELECT * FROM Employees ORDER BY Salary DESC;

• TOP Clause:

SELECT TOP 5 * FROM Employees;

• DISTINCT Statement:

SELECT DISTINCT Department FROM Employees;

• GROUP BY & HAVING:

SELECT Department, COUNT(*)
FROM Employees
GROUP BY Department
HAVING COUNT(*) > 5;

• Handling NULL values:

SELECT * FROM Employees WHERE Email IS NULL;

Update Records 🔄​

UPDATE Employees
SET Salary = 55000
WHERE Name = 'John Doe';

Delete Records ❌​

DELETE FROM Employees
WHERE ID = 1;

---

​

Watch the Full SQL Server 2017 Tutorial on YouTube ▶️​

You can follow along with examples and practice step by step:

👆 Click The Image To Watch The Video 👆