SQL Server Part1 - Basics of SQL

SQL Server Database - Part1 is for beginners

What you'll learn
- Write SELECT Queries – Learn how to retrieve data from one or more tables using SELECT.
- Filter Data Using WHERE Clause – Understand how to apply conditions with WHERE, IN, NOT IN, BETWEEN, and LIKE.
- Use SQL Functions – Explore basic built-in functions like COUNT, SUM, AVG, MIN, and MAX.
- Combine Conditions – Use AND, OR, and NOT operators to form complex filters.

Requirements
- Basic Excel functions is fine to take up this course. No coding required.

Description
1. SQL Server Installation

Steps to install SQL Server:

Download and installSQL Server Developer EditionorExpress Editionfrom Microsoft.

Configure SQL Server setup (choose authentication mode).

InstallSQL Server Management Studio (SSMS)to interact with the database.

Connect to the SQL Server instance using SSMS.

SSMS Installation (SQL Server Management Studio)

SSMS is used to manage SQL Server databases visually.

Download from Microsoft’s website and install it.

Use it to create, modify, and execute SQL queries easily.

2. SELECT Query

Used to retrieve data from one or more tables.

Syntax: SELECT column1, column2 FROM table_name;

Can retrieve all columns using SELECT * FROM table_name;

Can use aliases with AS for better readability: SELECT column1 AS NewName FROM table_name;

3. ORDER BY Clause

Used to sort query results in ascending (ASC, default) or descending (DESC) order.

Example: SELECT * FROM Employees ORDER BY Salary DESC;

Can sort by multiple columns: ORDER BY Department ASC, Salary DESC;

NULL values usually appear first in ascending order, last in descending.

4. WHERE Clause

Filters records based on conditions.

Operators: =, !=, <, >, <=, >=, BETWEEN, LIKE, IN, NOT IN

Example: SELECT * FROM Employees WHERE Salary > 50000;

Used with AND, OR, and NOT for multiple conditions.

5. HAVING Clause

Used to filter aggregated results from GROUP BY.

Difference from WHERE: WHERE filters individual rows, HAVING filters grouped results.

6. GROUP BY Clause

Groups rows sharing the same values into summary rows.

Must be used with aggregate functions like COUNT(), SUM(), AVG().

Example: SELECT Department, AVG(Salary) FROM Employees GROUP BY Department;

7. Aggregation Calculations

Functions used to summarize data:

SUM(), AVG(), COUNT(), MIN(), MAX()

8. OVER Clause with Partition

Used for window functions to calculate rankings, running totals, etc.,without collapsing rows.

Who this course is for:
- Data Analysts and those who work with medium or especially large datasets.
More Info