WebToolTip com Udemy Ultimate SQL Beginner to Intermediate Guide using SQL Server

WebToolTip com Udemy Ultimate SQL Beginner to Intermediate Guide using SQL Server

Name	[ WebToolTip.com ] Udemy - Ultimate SQL Beginner to Intermediate Guide using SQL Server	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	3.3 GB
Total Files	71
Last Seen
Hash	FDC159DA1CD6FED372CF878F23FADA2F4FFFA37D

/
Get Bonus Downloads Here.url	0.2 KB
/1 - Introduction/
1 - Introduction to the Course.mp4	31.5 MB
2 - Intro to our Tech Stack (SQL Server and SSMS).mp4	41.7 MB
/.../2 - Databases & SQL Fundamentals & Environment Setup/
1 - What is a Database & Relational vs Non-Relational Databases.mp4	96.4 MB
2 - Introduction to SQL.mp4	11.3 MB
3 - Introduction to SQL Queries & Query Structure.mp4	38.5 MB
4 - Environment Setup Links.html	1.9 KB
5 - Setting up SQL Server, SSMS and Importing AdventureWorks2022 Database.mp4	124.5 MB
/.../3 - Writing SQL Queries Beginner to Intermediate/
1 - Navigating SSMS - Watch if new to SSMS.mp4	69.6 MB
10 - Sorting Data with ORDER BY (and using the Format function).mp4	110.2 MB
11 - Count and Sum Aggregate SQL File.sql.sql	1.8 KB
11 - Grouping Data with GROUP BY and Aggregate Functions (SUM and COUNT).mp4	374.7 MB
12 - Grouping Data with GROUP BY and Aggregate Functions (AVG, MIN, and MAX).mp4	149.4 MB
12 - Min, Max, Avg SQL File.sql.sql	1.6 KB
13 - HAVING SQL File.sql.sql	1.3 KB
13 - Using the HAVING keyword with Aggregate Functions.mp4	211.5 MB
14 - Let's Explore what Joins are (Inner, LeftRight, Outer, etc.).mp4	153.2 MB
15 - Joining Tables with INNER JOIN.mp4	285.3 MB
15 - inner join.sql.sql	1.0 KB
16 - LEFT AND RIGHT JOIN.sql.sql	2.3 KB
16 - Left and Right Joins.mp4	101.7 MB
17 - FULL OUTER JOIN.sql.sql	1.7 KB
17 - Full Outer Joins.mp4	54.0 MB
18 - Combining Results with UNION.mp4	82.6 MB
18 - UNION and UNION ALL.sql.sql	3.7 KB
2 - Heads up on Case Sensitivity in SSMS.html	0.8 KB
3 - Learning SELECT with Alias's and FROM statements.mp4	80.1 MB
3 - SelectAndFrom_Lecture.sql.sql	0.3 KB
4 - Practice SELECT & FROM Statements.html	0.2 KB
4 - SelectAndFrom_Assignment.sql.sql	0.7 KB
5 - SELECT & FROM Statements Solution.mp4	26.1 MB
5 - SelectAndFrom_Solution.sql.sql	1.1 KB
6 - WHERE Statement Part 1 (Operators =, , , , =, =, NOT IN).mp4	147.0 MB
6 - WHERE+Part+1.sql.sql	0.6 KB
7 - WHERE Statement Part 2 (Continued AND, OR, LIKE).mp4	147.0 MB
7 - WHERE+Part+2.sql.sql	0.6 KB
8 - WHERE Statement Part 3 (IS NULL Handling NULL's).mp4	43.9 MB
8 - WHERE+Statement+Assignment.sql.sql	1.2 KB
9 - DISTINCT SELECT and FROM with WHERE.mp4	22.4 MB
/.../4 - Writing SQL Queries Advanced SQL/
1 - CTE.sql.sql	2.8 KB
1 - Common Table Expressions (CTEs).mp4	63.3 MB
2 - Using Views for Simplifying Complex Queries.mp4	102.5 MB
2 - VIEWS.sql.sql	2.9 KB
/.../5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/
1 - Introduction to Database Design (Theory Essentials).mp4	63.6 MB
10 - Creating All Final Project Database and Tables (Step-by-Step).mp4	46.4 MB
10 - Creating our Final Projects Tables SQL Query.sql.sql	3.4 KB
10 - Final Project Create our Database SQL.sql.sql	0.5 KB
10 - Final Project Schema Creation SQL.sql.sql	0.1 KB
11 - If you mess up your Data Insertion, follow this guide.html	1.5 KB
12 - Entering Data & Querying our Tables.mp4	164.3 MB
12 - Final Project Customers SQL Insert Dump.sql.sql	2.2 KB
12 - Final Project EmployeePayInfo SQL Insert Dump.sql.sql	1.2 KB
12 - Final Project Order Items SQL Insert Dump.sql.sql	1.1 KB
12 - Final Project Orders SQL Insert Dump.sql.sql	2.2 KB
12 - Final Project Products SQL Insert Dump.sql.sql	1.9 KB
12 - Final Projects - Employees Insert SQL Dump.sql.sql	2.3 KB
12 - Guide if you accidentally mess up your data inserts.sql.sql	1.2 KB
2 - Link to dbdiagram.html	0.1 KB
3 - Building an ERD (Entity Relationship Diagram).mp4	75.5 MB
3 - dbdiagram.io SQL.txt.txt	1.9 KB
4 - Microsoft Documentation on Creating Tables and Databases.html	0.6 KB
5 - Create a database (code).txt.txt	0.8 KB
5 - Creating Your First Database (SSMS GUI and T-SQL).mp4	47.8 MB
6 - Creating Tables (SSMS GUI and T-SQL).mp4	69.1 MB
6 - create our tables sql.txt.txt	0.8 KB
7 - Adding Constraints to our Tables and AlteringDropping our Tables.mp4	52.2 MB
7 - Foreign Key Constraints SQL.txt.txt	0.3 KB
8 - Inserting, Updating, and Deleting Data in our Tables.mp4	98.3 MB
9 - Final Project ERD SQL.txt.txt	1.3 KB
9 - Planning the Ski & Snowboard Shop Database (Creating our ERD).mp4	72.9 MB
/~Get Your Files Here !/
Bonus Resources.txt	0.1 KB
Total files 71