SQL Level 2: Advanced Data Querying and Management - Cloud Learning Academy

SQL Level 1: Introduction to SQL and Database Design

24 Hours

Beginner to advanced

7 Modules

LE 1,850.00
LE 1,850.00
10 customers are viewing this product
This beginner-level course is designed to equip students with the fundamental skills required to design and manage databases using SQL. Focusing on essential topics like Entity-Relationship Diagrams (ERD), database schema design, normalization techniques, and SQL syntax, this course provides a strong foundation in relational database concepts. Starting with an introduction to database types and SQL commands, students will learn how to design effective data models using ERDs, identify entities and relationships, and convert these designs into well-structured database schemas. Through data normalization, students will reduce redundancy and improve efficiency by organizing data into optimal structures. Practical exercises guide students in creating and managing databases, defining tables, and applying SQL commands to insert, update, and delete data. Additionally, students will master essential SQL querying techniques, including data filtering, sorting, joining tables, and aggregating data. By the end of the course, they will apply their knowledge in a real-world project, designing a database from scratch, implementing the schema in SQL, and performing practical data operations. This hands-on approach ensures that students build confidence in creating, managing, and querying databases, laying a solid foundation for more advanced SQL topics in the future.
    • Course Outline
    • What you will learn
    • Audience profile
    Lesson 1: Understanding Databases Definition of a Database Types of Databases Key Concepts: Tables, Rows, Columns, and Relationships Lesson 2: Introduction to SQL What is SQL? SQL Commands Overview (DDL, DML, DCL, TCL) Common SQL Use Cases
    Lesson 1: Fundamentals of ERD What is an ERD? Components of ERD: Entities, Attributes, and Relationships ERD Symbols and Notations Lesson 2: Identifying Entities and Attributes Identifying Key Entities in a System Determining Entity Attributes Activity: Creating a Simple ERD for a Small Database Lesson 3: Defining Relationships Types of Relationships: One-to-One, One-to-Many, Many-to-Many Mapping Relationships in ERD Activity: Building ERD with Multiple Relationships
    Lesson 1: What is a Schema? Defining a Database Schema Importance of Schema Design Primary and Foreign Keys Lesson 2: Converting ERD to Schema Mapping ERD to Database Tables Creating Primary and Foreign Keys Activity: Designing a Database Schema from an ERD Lesson 3: Building Tables with SQL Basic SQL Syntax for Table Creation Data Types and Constraints (e.g., NOT NULL, UNIQUE) Creating Simple Tables Activity: Writing SQL Commands for Table Creation
    Lesson 1: Introduction to Data Normalization Why Normalize Data? Concepts of Redundancy and Anomalies Benefits of Data Normalization Lesson 2: Normal Forms First Normal Form (1NF): Atomic Data Second Normal Form (2NF): Removing Partial Dependencies Third Normal Form (3NF): Eliminating Transitive Dependencies Examples and Exercises Lesson 3: Applying Normalization in Database Design Practical Steps to Normalize a Database Examples of Transforming Non-normalized Data Activity: Normalizing Tables and Writing Normalized SQL
    Lesson 1: Creating a Database in SQL SQL Syntax for Database Creation Database Naming Conventions Activity: Creating Your First Database Lesson 2: Defining and Managing Tables Altering and Deleting Tables Adding Constraints (Primary Key, Foreign Key) Activity: Creating and Managing Database Tables Lesson 3: Basic Data Operations (INSERT, UPDATE, DELETE) Adding Data with INSERT Updating Existing Data Deleting Data Activity: Practice Data Operations on Created Tables
    Lesson 1: Using SELECT to Query Data Basic SELECT Syntax Filtering with WHERE Clauses Sorting Data with ORDER BY Activity: Writing Basic Queries on Created Tables Lesson 2: Joining Tables for Data Analysis Understanding Joins (INNER, LEFT, RIGHT, FULL) Writing Joins in SQL Practical Use Cases for Joins Activity: Practice Querying with Joins on Tables Lesson 3: Aggregating Data with SQL Functions COUNT, SUM, AVG, MIN, MAX Functions GROUP BY and HAVING Clauses Activity: Aggregating Data from Multiple Tables
    Project Description Choose a Real-World Scenario (e.g., Library, Retail, or HR Database) Design ERD for the System Convert ERD to Database Schema Normalize Database Design (Achieve at least 3NF) Implement SQL to Create Database, Define Tables, and Perform Data Operations Project Presentation Explain the ERD, Schema, and Normalization Decisions Demonstrate Basic Queries on the Database
    All SQL funcations from basic to expert level
    Individuals looking to enter data analysis, data science, or database administration. They may have little to no experience with SQL but aim to gain foundational knowledge for building or querying databases.
    Analysts who want to enhance their data manipulation skills and optimize report generation. Understanding SQL allows them to work directly with databases and extract insights without always needing support from a database administrator. IT and Database Professionals: Those in IT roles who interact with data, work with backend systems, or manage databases and seek to deepen their technical skills. This course is ideal for database administrators, system engineers, or IT support professionals who need a solid foundation in SQL.

    Related Products

    CLA
    Example course title
    LE 1,850.00
    LE 1,850.00
    CLA
    Example course title
    LE 1,850.00
    LE 1,850.00
    CLA
    Example course title
    LE 1,850.00
    LE 1,850.00
    CLA
    Example course title
    LE 1,850.00
    LE 1,850.00