SQL Server Transact SQL Querying assisted by GitHub CoPilot
Learn to prepare SQL Server data for analytics using GitHub Copilot. Master data shaping techniques for powerful insights.
Course Content
SQL Server Transact SQL Querying assisted by GitHub CoPilot is a beginner-level Udemy course taught by Mark Manore. It runs 9h 46m, is taught in English, and includes a certificate of completion. Learners rate it 5.0 out of 5 from 1 review, with 5 students enrolled. It is a paid course, first published July 2025.
Learn to master SQL Server querying with Transact SQL (T-SQL)! This comprehensive course guides you through the fundamentals of interacting with SQL Server databases, leveraging the power of GitHub Copilot to accelerate your learning.
The course is structured into key sections:
- Orientation and Setup: Get started with your development environment.
- SQL Foundations: Build a solid base in SQL syntax and concepts.
- Built-in Functions & Data Types: Explore a wide range of pre-built functions and data types for data manipulation.
- Filtering & Ordering: Learn to precisely filter and sort your data for targeted results.
- FROM Clause Basics & JOINS: Master querying data from multiple tables using
FROMand variousJOINtypes. - Subqueries: Utilize nested queries for complex data retrieval.
- Analytical Functions: Unlock powerful analytical capabilities with window functions and grouped aggregates.
- Set Operators: Employ set operators (UNION, INTERSECT, EXCEPT) to combine and manipulate result sets.
- Pivot & Window Functions: Gain expertise in pivoting data and using window functions for advanced data analysis.
- Extra Innings: Cornucopia Programming: Integrate various programming elements learned throughout the course.
- Data Warehousing: Explore coding against a dimensionally modeled data warehouse, using the popular Adventureworks database.
- Query Data Shaping: Discover intermediate programming techniques for shaping and transforming data.
- Data Shaping Exercise: Apply window functions to perform data wrangling tasks like deduplication, gap detection, generating new keys, and calculating trimmed means.
- Voice to Prompt: A brief overview of using voice-to-text for generating AI prompts to create code.
Throughout the course, you'll utilize Azure Data Studio, Jupyter Books, and Jupyter Notebooks for hands-on practice. GitHub Copilot assists in code generation via AI prompts, encouraging a process of review and validation to solidify your understanding of T-SQL syntax and functionality. This combination of prompt engineering and code review provides a powerful learning approach.
This course is ideal for anyone looking to improve their SQL skills, work with SQL Server, and leverage AI-assisted coding for efficient database querying and data manipulation.
Hire the developers behind TutorialSearch.io
We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.