Course Overview:
SQL Fundamentals
This course introduces the fundamentals of SQL (Structured Query Language) for managing and querying relational databases in a data analytics context. Participants will learn to interact with databases through hands-on exercises and real-world examples, focusing on data extraction, transformation, and business insights
SQL Fundamentals
Course Objectives
By the end of this course, participants will be able to:
- Understand the Fundamentals of SQL & Database Management.
- Retrieve & Analyze Data Using SQL Queries.
- Modify & Manage Database Structures.
SQL Fundamentals Modules
MODULE 1- SQL & Relational Databases Basics
MODULE 1- SQL & Relational Databases Basics
MODULE 1- SQL & Relational Databases Basics
- Understand what SQL is and why it is essential for databases.
- Learn about Relational Database Management Systems (RDBMS).
- Explore primary keys, foreign keys, and database relationships.
- Set up a SQL environment and run basic queries.
MODULE 2- ER Modeling basics
MODULE 1- SQL & Relational Databases Basics
MODULE 1- SQL & Relational Databases Basics
- Learn Entity-Relationship (ER) modeling for database design.
- Understand entities, attributes, relationships, and cardinality.
- Convert ER diagrams into normalized relational schemas.
- Design real-world databases using ER modeling principles.
MODULE 3: normalization & Denormalization
MODULE 1- SQL & Relational Databases Basics
MODULE 3: normalization & Denormalization
- Understand data redundancy and anomalies.
- Learn normalization (1NF, 2NF, 3NF) to improve efficiency.
- Explore denormalization and when to use it for performance optimization.
- Apply normalization principles in real-world database designs.
MODULE 4: Querying & Modifying Data
MODULE 6: Advanced Data Integrity & Constraints
MODULE 3: normalization & Denormalization
- Write SELECT, INSERT, UPDATE, and DELETE statements.
- Filter data using WHERE, LIKE, BETWEEN, and IN operators.
- Use ORDER BY and LIMIT for sorting and paginating data.
MODULE 5: Aggregate Functions & Grouping Data
MODULE 6: Advanced Data Integrity & Constraints
MODULE 6: Advanced Data Integrity & Constraints
- Use SUM, AVG, COUNT, MIN, and MAX for data analysis.
- Group data using GROUP BY and filter grouped data with HAVING.
- Apply ROLLUP & CUBE for hierarchical data aggregation.
- Perform advanced calculations in SQL queries.
MODULE 6: Advanced Data Integrity & Constraints
MODULE 6: Advanced Data Integrity & Constraints
MODULE 6: Advanced Data Integrity & Constraints
- Enforce data integrity using PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, CHECK, and DEFAULT constraints.
- Implement ON DELETE CASCADE and ON UPDATE CASCADE to maintain referential integrity.
- Use composite primary keys for multi-column uniqueness.
- Prevent incorrect data entry using constraint handling techniques.
MODULE 7: Combining Data from Multiple Tables (JOINS & Subqueries)
MODULE 7: Combining Data from Multiple Tables (JOINS & Subqueries)
MODULE 7: Combining Data from Multiple Tables (JOINS & Subqueries)
- Master INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN.
- Use subqueries in SELECT, FROM, and WHERE clauses.
- Retrieve insights from multiple tables efficiently.
- Apply JOINS in real-world business scenarios.
MODULE 8: SQL Functions & Data Manipulation
MODULE 7: Combining Data from Multiple Tables (JOINS & Subqueries)
MODULE 7: Combining Data from Multiple Tables (JOINS & Subqueries)
- Work with String Functions (LENGTH, CONCAT, SUBSTRING, REPLACE, UPPER, LOWER).
- Use Date Functions (NOW, CURDATE, DATEDIFF, EXTRACT, TIMESTAMPDIFF).
- Perform calculations with Numeric Functions (ROUND, CEIL, FLOOR, ABS, MOD).
- Format and manipulate data efficiently using SQL functions.
Capstone Project – Sales & Inventory Analysis
MODULE 7: Combining Data from Multiple Tables (JOINS & Subqueries)
Capstone Project – Sales & Inventory Analysis
- Apply everything learned in a real-world business scenario.
- Design and query a multi-table database for sales and inventory management.
- Optimize queries for performance and scalability.
- Present insights and recommendations using SQL reports.
Course Expectations
Course Duration
12 hours (Flexible delivery: Spread over 2 weeks )
Expected Outcome
Students will develop strong querying and data manipulation skills, allowing them to extract meaningful insights from databases.
assessment
- Hands-On Practice: Structured exercises after each module.
- Final Project: Write and execute SQL queries for a sample database.
Prerequisites
No prior database knowledge is required. Basic computer skills are recommended.
Materials provided
- Access to a sample database.
- Course slides and reference materials.
SQL Friends
Copyright © 2025 SQL Friends - All Rights Reserved.
Powered by BookWorm IT
This website uses cookies.
We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.