• views: 86
• date: 25 July 2025
• posted by: 0nelove

What you'll learn
Become familiar with the basics of querying SQL Server Databases using Transact-SQL
Become familiar with the use of GitHub CoPilot to generate faster Transact-SQL code
Experience the value of using Jupyter Books and Notebooks
Become familiar with the use of Azure Data Studio
Requirements
Some familiarity with relational databases would be useful
Some experience with programming
Some awareness of AI capabilities
Description
Fundamentally, this course will take you through the basics of querying SQL Server databases using Transact SQL (TSQL) with the assistance of GitHub CoPilot.
The course is divided into the following sections.
A) Orientation and Setup
B) Foundations
C) Builtin Functions and Datatypes
D) Filtering and Ordering
E) FROM Clause
Basics
with JOINS
F) SubQueries
G) Analytical Functions
Grouped Aggregates
Set Operators
Pivot
Window Functions
H) Extra Innings
Cornucopia Programming - bringing together various programming elements form the course at large.
Data Warehousing - most of the course is conducted using the transactional Adventureworks database. Here we look briefly at coding against a dimensionally modelled data warehouse - AdventureworksDW
Query Data Shaping - takes a look at intermediate programming techniques we may employ to output a final result set.
Data Shaping Exercise - explores the use of Window functions to facilitate data wrangling like 'deduplication', 'gap detection', 'generate new keys' for a data set, 'trimmed mean'.
Voice to Prompt - very brief survey of the possible use of voice to text capabilities in generating AI prompts to generate code.
The programming in all of these sections is facilitated through the use of Azure Data Studio and the use of Jupyter Books and Notebooks.
Through the use of AI prompts, GitHub Copilot generates code that is to be reviewed by the programmer as to its accuracy and functionality.
The combination of learning the 'prompting' and code reviews aids the student in learning the syntax and functionality of TSQL
Who this course is for
Report Writers (like Crystal, SSRS, Power BI, Tableau...)
Database Developers
ETL Programmers
Data Engineers
Data Scientists
Code Reviewers



   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.