What’s Included?
High-Quality Video, E-book & Audiobook
Module Quizzes
AI Mentor
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
Azure SQL Database
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
Lesson 1: Query and Modify Data with Transact-SQL
Module 1: Introduction to Transact-SQL
Module 2: Sort and Filter Results in T-SQL
Module 3: Combine Multiple Tables with JOINs in T-SQL
Module 4: Write Subqueries in T-SQL
Module 5: Use Built-in Functions and GROUP BY in Transact-SQL
Module 6: Modify Data with T-SQL
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.