Model Online / On-Site
Duration
Modules 8 modules

About the Course

SQL Server Database Querying Fundamentals teaches the core structure of the SQL language and relational database querying. The training covers database modeling concepts, normalization, fundamental SQL commands, and retrieving data across tables.

Target Audience

  • Beginners to SQL and relational databases

  • Professionals who work with data but have no prior SQL experience

  • Analysts looking to extract data directly from databases for reporting

  • Individuals entering software development, business intelligence, or data analytics

Learning Outcomes

  • Understand relational database design and SQL querying logic

  • Use core SQL statements (SELECT, WHERE, ORDER BY, etc.)

  • Write accurate queries across tables and columns

  • Filter, sort, and perform calculations on database records

  • Retrieve required datasets reliably from relational databases

Curriculum

Module 1 – Introduction to Databases and SQL

  • Introduction to relational databases

  • Other database types

  • Data analysis fundamentals

  • Database languages (DDL, DML, DCL)
Module 2 – Data Modeling

  • Data modeling concepts

  • ANSI/SPARC database architecture

  • Entity-Relationship (ER) modeling
Module 3 – Normalization

  • Why normalize data?

  • Normalization terminology

  • Normal forms (1NF, 2NF, 3NF)

  • Denormalization
Module 4 – Relationships

  • Schema mapping

  • Referential integrity
Module 5 – Performance

  • Indexing

  • Query performance

  • Concurrency
Module 6 – Database Objects

  • Tables

  • Views

  • Stored Procedures

  • Other database objects
Module 7 – Working with Multiple Tables

  • JOIN Logic

  • INNER JOIN

  • Relational Data

  • Core table relationships
Module 8 – Hands-On SQL Practice

  • End-to-End Scenario

  • Queries on a real-world dataset

  • Review and evaluation

  • Common mistakes

  • Best practices

Other Courses in This Category

  • SQL Server Database Querying Training SQL Server Querying

    Comprehensive SQL Server and T-SQL querying course covering SSMS, SELECT workflows, multi-table JOINs (INNER, OUTER, CROSS, SELF), filtering and pagination, data types, and built-in Scalar, Aggregate, and Window functions.

    Databases Corporate
    Live Course
    7 modules
    View
  • Big Data Querying and Analytics with Apache Spark SQL

    Apache Spark SQL and the DataFrame API, Catalyst Optimizer and Adaptive Query Execution (AQE), Parquet/Delta Lake/Iceberg table formats, join strategies and fixing data skew — for teams building big-data analytics.

    Databases Corporate
    Live Course
    5 modules
    View
  • PostgreSQL for Developers: From Fundamentals to Advanced SQL

    PostgreSQL data types, advanced SQL (CTEs, window functions, LATERAL), JSONB document modelling, full-text search, B-Tree/GIN/GiST/BRIN indexes, PL/pgSQL, MVCC/locking and partitioning — for application developers.

    Databases Corporate
    Live Course
    5 modules
    View
  • PostgreSQL Database Administration, High Availability and Operations

    PostgreSQL architecture, memory and WAL tuning, MVCC/Autovacuum and bloat control, PgBouncer connection pooling, PITR backups with pgBackRest, Streaming/Logical Replication and Patroni high availability.

    Databases Corporate
    Live Course
    5 modules
    View
  • MySQL and MariaDB Development, Tuning and Administration

    InnoDB storage engine and clustered index architecture, query and index optimisation, transaction and lock analysis, backups, GTID replication and high availability — for developer and DBA teams running MySQL and MariaDB.

    Databases Corporate
    Live Course
    5 modules
    View
  • Oracle Database Architecture, SQL Tuning and Administration

    Oracle Multitenant (CDB/PDB) architecture, SGA/PGA memory and background processes, tablespace/segment management, B-Tree/Bitmap indexes, partitioning, AWR/ASH tuning, RMAN backups and Data Guard essentials.

    Databases Corporate
    Live Course
    5 modules
    View

Get in touch