SQL Fundamentals Training 24th – 28th June 2024(Weekdays)
- Description
- Reviews
Introduction:
Welcome to the SQL Fundamentals Training Guide! Structured Query Language (SQL) is a powerful and essential tool for managing relational databases. Whether you are a beginner or looking to refresh your SQL skills, this training program will provide you with a comprehensive understanding of SQL concepts, database querying, and data manipulation. By the end of this guide, you will be equipped with the skills needed to write efficient SQL queries and work confidently with databases. Let’s dive in!
Â
Module 1: Introduction to Databases and SQL 1.1 Understanding Databases:
What is a Database?
Types of Databases (Relational, NoSQL, etc.)
The Importance of Data Integrity and Security
1.2 Introducing SQL:
What is SQL?
SQL Standards and Variants (MySQL, PostgreSQL, SQL Server, etc.)
Common SQL Commands
1.3Â Setting up the Environment:
Installing SQL Management Tools
Connecting to Databases
Module 2: Basic SQL Queries 2.1 SELECT Statement:
Retrieving Data from a Single Table
Column Aliases
Filtering Data with WHERE Clause
2.2Â Sorting Data:
ORDER BY Clause
Sorting in Ascending and Descending Order
Sorting by Multiple Columns
2.3Â Filtering Data:
Logical Operators (AND, OR, NOT)
Comparison Operators (=, <>, >, <, etc.)
Using Wildcards (LIKE)
Module 3: Joins and Subqueries 3.1 Inner Joins:
Understanding Join Operations
INNER JOIN Syntax
Handling NULL Values
3.2Â Outer Joins:
LEFT JOIN, RIGHT JOIN, and FULL JOIN
Combining Multiple Tables
3.3Â Subqueries:
Using Subqueries in SELECT, WHERE, and FROM Clauses
Correlated Subqueries
Common Table Expressions (CTEs)
Module 4: Aggregating Data 4.1 Aggregate Functions:
SUM, AVG, COUNT, MIN, MAX
GROUP BY Clause
HAVING Clause
4.2Â Working with Date and Time:
Date Functions (DATE, MONTH, YEAR, etc.)
Date Arithmetic
Formatting Dates
Module 5: Modifying Data 5.1 Inserting Data:
INSERT INTO Statement
Adding Multiple Rows at Once
Handling Auto-Increment Columns
5.2Â Updating Data:
UPDATE Statement
Modifying Single or Multiple Rows
5.3Â Deleting Data:
 DELETE FROM Statement
Deleting with Conditions
Happy querying!
