Skip to content
/ SQL-Code-Samples Public

The SQL codes in this repository contains codes that are used to extract data from Azure Data Studio during Business Intelligence and Data Analytics Trainining by CFI

1 star 0 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

Ainaganiu/SQL-Code-Samples

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
An Example SQL Statement.sql
An Example SQL Statement.sql
 
 
Basic SQL Queries - 1 Basic SQL Query with TOP.sql
Basic SQL Queries - 1 Basic SQL Query with TOP.sql
 
 
Basic SQL Queries - 2 Basic SQL Query including OFFSET FETCH.sql
Basic SQL Queries - 2 Basic SQL Query including OFFSET FETCH.sql
 
 
Basic SQL Queries - 3 Basic SQL Query including DISTINCT.sql
Basic SQL Queries - 3 Basic SQL Query including DISTINCT.sql
 
 
Basic SQL Queries - Student Exercise 1a.sql
Basic SQL Queries - Student Exercise 1a.sql
 
 
Basic SQL Queries - Student Exercise 1b.sql
Basic SQL Queries - Student Exercise 1b.sql
 
 
Basic SQL Queries - Student Exercise 1c.sql
Basic SQL Queries - Student Exercise 1c.sql
 
 
Manipulating Values - 1b Aggregate Functions.sql
Manipulating Values - 1b Aggregate Functions.sql
 
 
Manipulating Values - 1c Aggregate functions with NULL values.sql
Manipulating Values - 1c Aggregate functions with NULL values.sql
 
 
Manipulating Values - 2 Numeric Functions.sql
Manipulating Values - 2 Numeric Functions.sql
 
 
Manipulating Values - 3 Date Functions.sql
Manipulating Values - 3 Date Functions.sql
 
 
Manipulating Values - 4 Server Properties.sql
Manipulating Values - 4 Server Properties.sql
 
 
Manipulating Values - 5 String Functions.sql
Manipulating Values - 5 String Functions.sql
 
 
Manipulating Values - 6 Comparison Operators and Testing NULL.sql
Manipulating Values - 6 Comparison Operators and Testing NULL.sql
 
 
Manipulating Values - 6b Logical Operators.sql
Manipulating Values - 6b Logical Operators.sql
 
 
Manipulating Values - 7 Conditional Columns IF CASE and replacing NULLS.sql
Manipulating Values - 7 Conditional Columns IF CASE and replacing NULLS.sql
 
 
Manipulating Values - 9 National.sql
Manipulating Values - 9 National.sql
 
 
Manipulating Values - Student exericse 2a.sql
Manipulating Values - Student exericse 2a.sql
 
 
Manipulating Values - Student exericse 2b.sql
Manipulating Values - Student exericse 2b.sql
 
 
Multiple Tables - 1 Inner Joins.sql
Multiple Tables - 1 Inner Joins.sql
 
 
Multiple Tables - 2 Right Join.sql
Multiple Tables - 2 Right Join.sql
 
 
Multiple Tables - 3 Left Join.sql
Multiple Tables - 3 Left Join.sql
 
 
Multiple Tables - 5 UNIONS.sql
Multiple Tables - 5 UNIONS.sql
 
 
Multiple Tables - 6 Creating a view.sql
Multiple Tables - 6 Creating a view.sql
 
 
Multiple Tables - 7 Quering a view.sql
Multiple Tables - 7 Quering a view.sql
 
 
Multiple Tables - 8 Subqueries.sql
Multiple Tables - 8 Subqueries.sql
 
 
Multiple Tables - Student exercise 4a.sql
Multiple Tables - Student exercise 4a.sql
 
 
Multiple Tables - Student exercise 4b.sql
Multiple Tables - Student exercise 4b.sql
 
 
Multiple tables - 4 Bridge table.sql
Multiple tables - 4 Bridge table.sql
 
 

About

The SQL codes in this repository contains codes that are used to extract data from Azure Data Studio during Business Intelligence and Data Analytics Trainining by CFI

Topics

data-science data sql dataextraction datawrangl
Activity

Stars

1 star

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages