Bootcamp with SQL

The Bootcamp with SQL Certification is a dedicated program that validates an individual's proficiency in SQL, a standard language for managing relational databases. This certification emphasizes understanding and utilizing SQL for data mining, database modifications, and complex queries, among other things. Industries utilize certified SQL professionals extensively for data analysis, database management, and decision-making tasks. Its core concepts include SQL syntax, subqueries, database testing methods, and SQL functions, which are crucial in handling large amounts of data and analysing it effectively. Hence, the Bootcamp with SQL certification plays a key role in fuelling data-driven business strategies.

Retail Price: $2,500.00

Next Date: 11/04/2024

Course Days: 5


Enroll in Next Date

Request Custom Course


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

• Basic understanding of Database concepts
• 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

Course Dates Course Times (EST) Delivery Mode GTR
11/4/2024 - 11/8/2024 9:00 AM - 5:00 PM Virtual Enroll
12/9/2024 - 12/13/2024 9:00 AM - 5:00 PM Virtual Enroll