Bootcamp with SQL

Learning Objectives

The main learning objectives of a Bootcamp with SQL course are to equip participants with the knowledge and skills to effectively use SQL for database management. Students will learn to create, edit, and manage databases and understand the principles of relational database design. They will also be taught to write SQL queries to retrieve, manipulate, and analyze data, how to establish relationships between multiple tables, and work with large datasets. Another objective is to develop expertise in using data handling functions and view data visualization using SQL. Ultimately, the course aims to build strong foundations to kick-start a career in data analysis.

Course Prerequisites

Target Audience

• IT professionals looking to enhance their data management skills
• Business analysts requiring advanced data manipulation techniques
• Aspiring data scientists needing a foundation in SQL
• Graduates seeking a career in data analytics
• Professionals aiming for roles requiring database management
• Tech-savvy individuals pursuing a better understanding of database frameworks.

Module 1: SQL Server setting up
Introduction
Microsoft SQL Server Installation
SQL Server Management Studio (SSMS) Installation
How to connect MS SQL (Windows Authentication)
How to connect MS SQL (SQL Server Authentication)
Download and Restore Sample Database

Module 2: Understanding the basics of SQL Server
Introduction
Overview of Databases
Creating Database
SQL Data Types
Column Data Types on SSMS
Creating Table
Overview of Primary Key and Foreign Key
Primary Key
Foreign Key
Creating Temporary tables

Module 3: SQL DML (Data Manipulation Language)
Introduction
Insert statement
Update statement
Delete statement

Module 4: SQL DDL (Data Definition Language)
Introduction
CREATE table statement
DROP statement
ALTER statement
TRUNCATE statement
COMMENT in query
RENAME

Module 5: SQL DCL (Data Control Language)
Introduction
Create Database user
GRANT permissions
REVOKE permissions

Module 6: SQL Statement Basic
Introduction
SQL Statement basic
SELECT Statement
SELECT DISTINCT
SELECT with column heading
Column AS statement

Module 7: Filtering Data rows
SELECT WHERE Clause – theory
SELECT WHERE Clause – practical

Module 8: Aggregate functions
Introduction
Count()
Sum()
Min()
Max()
AVG()

Module 9: SQL Query statements
Order By statement
SELECT TOP clause in SQL
BETWEEN command
IN operator
Wildcard Characters and LIKE

Module 10: SQL Group by statement
Introduction
Group by – theory
Group by – practical
HAVING statement

Module 11: JOINS
Introduction
Inner join
Left outer join
Right outer join
Full outer join
Union
Cross join
Query Exercise
Solution for Query Exercise

Module 12: SQL Constraints
Introduction
Check constraint
NOT NULL constraint
UNIQUE constraint

Module 13: Views
Introduction
Creating Views
Reporting with multiple tables

Module 14: Advanced SQL commands
Introduction
Timestamp
Extract from timestamp
Mathematical scalar functions
String functions
Subquery
SELECT with calculations

Module 15: SQL Stored procedures
Introduction
Create stored procedure
Stored procedure with parameter

Module 16: Import & Export data
Introduction
Import Flat File
Import .csv or excel file
Export Data to Excel or any format

Module 17: Backup and Restore Database
Introduction
Creating Database backup
Restoring Database backup