Skip to content

README.md

Latest commit

 

History

History
61 lines (42 loc) · 1.06 KB

README.md

File metadata and controls

61 lines (42 loc) · 1.06 KB
Raw

SQL Fundamentals Practice

Overview

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).

Skills Demonstrated

  • SELECT
  • WHERE
  • ORDER BY
  • GROUP BY
  • Aggregate Functions
  • DISTINCT
  • TOP
  • HAVING
  • CREATE DATABASE
  • CREATE TABLE
  • ALTER TABLE
  • INSERT
  • UPDATE
  • DELETE
  • TRUNCATE
  • DROP TABLE

Project Structure

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.

Tools

  • SQL Server
  • SQL Server Management Studio (SSMS)

Learning Outcome

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