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
• Familiarity with Excel operations
• Knowledge of data types and variables
• Ability to work on diverse software platforms
• Strong problem-solving skills
• No prior experience with SQL is required but is beneficial.
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
Sorry! It looks like we haven’t updated our dates for the class you selected yet. There’s a quick way to find out. Contact us at 502.265.3057 or email info@training4it.com
Request a Date