This project contains my SQL Server practice exercises completed while learning SQL fundamentals.
The project covers querying data, modifying tables, creating databases, and performing data manipulation using Microsoft SQL Server Management Studio (SSMS).
- SELECT
- WHERE
- ORDER BY
- GROUP BY
- Aggregate Functions
- DISTINCT
- TOP
- HAVING
- CREATE DATABASE
- CREATE TABLE
- ALTER TABLE
- INSERT
- UPDATE
- DELETE
- TRUNCATE
- DROP TABLE
01_Create_Database.sql
Creates the database, table, and inserts sample employee data.
02_Practice_Questions.sql
Contains 70 SQL practice questions and my solutions.
- SQL Server
- SQL Server Management Studio (SSMS)
By completing this project I practiced:
- Writing SQL queries
- Data retrieval
- Data aggregation
- Database creation
- Table modification
- Data manipulation
- Query optimization through selecting only required columns