Overview Prerequisites Skills You’ll Gain Self Study Materials Included Tools What You’ll Learn Course Modules FAQs

What’s Included?

icon High-Quality Video, E-book & Audiobook icon Module Quizzes icon AI Mentor icon Access for Tablet & Phone

Prerequisites

    • Basic understanding of data and databases
    • Familiarity with general IT or computing concepts
    • No prior SQL experience required
    • Interest in data analysis or database management

Skills You’ll Gain

  • SQL Query Writing
  • Data Modification Techniques
  • Table Join Operations
  • Data Filtering Logic
  • Azure SQL Usage
  • Synapse Environment Navigation
  • Relational Structure Understanding
  • Database Interaction Skills

Self Study Materials Included

Videos

Engaging visual content to enhance understanding and learning experience.

Podcasts

Insightful audio sessions featuring expert discussions and real-world cases.

Audiobooks

Listen and learn anytime with convenient audio-based knowledge sharing.

E-Books

Comprehensive digital guides offering in-depth knowledge and learning support.

Module Wise Quizzes

Interactive assessments to reinforce learning and test conceptual clarity.

Additional Resources

Supplementary references and list of tools to deepen knowledge and practical application.

Tools You’ll Master

SQL Server Management Studio (SSMS)

SQL Server Management Studio (SSMS)

Azure Data Studio

Azure Data Studio

Azure SQL Database

Azure SQL Database

Azure Synapse Analytics

Azure Synapse Analytics

What You’ll Learn

Query & Join Data

Use SELECT and JOIN to retrieve related data.

Modify SQL Records

Apply INSERT, UPDATE, DELETE to manage database entries.

Filter & Sort Results

Use WHERE and ORDER BY for refined queries.

Work with Azure SQL

Understand T-SQL and manage cloud-hosted environments.

Course Modules

Module 1: Introduction to Transact-SQL
  • 1.1 Introduction
  • 1.2 Work with schemas
  • 1.3 Explore the structure of SQL statements
  • 1.4 Examine the SELECT statement
  • 1.5 Work with data types
  • 1.6 Handle NULLs
  • 1.7 Summary
Module 2: Sort and Filter Results in T-SQL
  • 2.1 Introduction
  • 2.2 Sort your results
  • 2.3 Limit the sorted results
  • 2.4 Page results
  • 2.5 Remove duplicates
  • 2.6 Filter data with predicates
  • 2.7 Summary
Module 3: Combine Multiple Tables with JOINs in T-SQL
  • 3.1 Introduction
  • 3.2 Understand joins concepts and syntax
  • 3.3 Use inner joins
  • 3.4 Use outer joins
  • 3.5 Use cross joins
  • 3.6 Use self joins
  • 3.7 Summary
Module 4: Write Subqueries in T-SQL
  • 4.1 Introduction
  • 4.2 Understand subqueries
  • 4.3 Use scalar or multi-valued subqueries
  • 4.4 Use self-contained or correlated subqueries
  • 4.5 Summary
Module 5: Use Built-in Functions and GROUP BY in Transact-SQL
  • 5.1 Introduction
  • 5.2 Categorize built-in functions
  • 5.3 Use scalar functions
  • 5.4 Use ranking and rowset functions
  • 5.5 Use aggregate functions
  • 5.6 Summarize data with GROUP BY
  • 5.7 Filter groups with HAVING
  • 5.8 Summary
Module 6: Modify Data with T-SQL
  • 6.1 Introduction
  • 6.2 Insert data
  • 6.3 Generate automatic values
  • 6.4 Update data
  • 6.5 Delete data
  • 6.6 Merge data based on multiple tables
  • 6.7 Summary

Frequently Asked Questions

Yes, it’s designed for those new to SQL and databases.

SQL Server, Azure SQL Database, Synapse, and Microsoft Fabric.

Yes, data modification using T-SQL is a key focus.

Yes, practical exercises are part of the course.

Yes, both instructor-led and self-paced formats are available.