Torrent Downloads » Other » [ WebToolTip com ] Udemy - Ultimate SQL Beginner to Intermediate Guide using SQL Server
Other
[ WebToolTip com ] Udemy - Ultimate SQL Beginner to Intermediate Guide using SQL Server
Torrent info
Torrent Files List
Get Bonus Downloads Here.url (Size: 3.03 GB) (Files: 71)
Get Bonus Downloads Here.url
~Get Your Files Here !
1 - Introduction
1 - Introduction to the Course.mp4
2 - Intro to our Tech Stack (SQL Server and SSMS).mp4
2 - Databases & SQL Fundamentals & Environment Setup
1 - What is a Database & Relational vs Non-Relational Databases.mp4
2 - Introduction to SQL.mp4
3 - Introduction to SQL Queries & Query Structure.mp4
4 - Environment Setup Links.html
5 - Setting up SQL Server, SSMS and Importing AdventureWorks2022 Database.mp4
3 - Writing SQL Queries Beginner to Intermediate
1 - Navigating SSMS - Watch if new to SSMS.mp4
10 - Sorting Data with ORDER BY (and using the Format function).mp4
11 - Count and Sum Aggregate SQL File.sql.sql
11 - Grouping Data with GROUP BY and Aggregate Functions (SUM and COUNT).mp4
12 - Grouping Data with GROUP BY and Aggregate Functions (AVG, MIN, and MAX).mp4
12 - Min, Max, Avg SQL File.sql.sql
13 - HAVING SQL File.sql.sql
13 - Using the HAVING keyword with Aggregate Functions.mp4
14 - Let's Explore what Joins are (Inner, LeftRight, Outer, etc.).mp4
15 - Joining Tables with INNER JOIN.mp4
15 - inner join.sql.sql
16 - LEFT AND RIGHT JOIN.sql.sql
16 - Left and Right Joins.mp4
17 - FULL OUTER JOIN.sql.sql
17 - Full Outer Joins.mp4
18 - Combining Results with UNION.mp4
18 - UNION and UNION ALL.sql.sql
2 - Heads up on Case Sensitivity in SSMS.html
3 - Learning SELECT with Alias's and FROM statements.mp4
3 - SelectAndFrom_Lecture.sql.sql
4 - Practice SELECT & FROM Statements.html
4 - SelectAndFrom_Assignment.sql.sql
5 - SELECT & FROM Statements Solution.mp4
5 - SelectAndFrom_Solution.sql.sql
6 - WHERE Statement Part 1 (Operators =, , , , =, =, NOT IN).mp4
6 - WHERE+Part+1.sql.sql
7 - WHERE Statement Part 2 (Continued AND, OR, LIKE).mp4
7 - WHERE+Part+2.sql.sql
8 - WHERE Statement Part 3 (IS NULL Handling NULL's).mp4
8 - WHERE+Statement+Assignment.sql.sql
9 - DISTINCT SELECT and FROM with WHERE.mp4
4 - Writing SQL Queries Advanced SQL
1 - CTE.sql.sql
1 - Common Table Expressions (CTEs).mp4
2 - Using Views for Simplifying Complex Queries.mp4
2 - VIEWS.sql.sql
5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)
1 - Introduction to Database Design (Theory Essentials).mp4
10 - Creating All Final Project Database and Tables (Step-by-Step).mp4
10 - Creating our Final Projects Tables SQL Query.sql.sql
10 - Final Project Create our Database SQL.sql.sql
10 - Final Project Schema Creation SQL.sql.sql
11 - If you mess up your Data Insertion, follow this guide.html
12 - Entering Data & Querying our Tables.mp4
12 - Final Project Customers SQL Insert Dump.sql.sql
12 - Final Project EmployeePayInfo SQL Insert Dump.sql.sql
12 - Final Project Order Items SQL Insert Dump.sql.sql
12 - Final Project Orders SQL Insert Dump.sql.sql
12 - Final Project Products SQL Insert Dump.sql.sql
12 - Final Projects - Employees Insert SQL Dump.sql.sql
12 - Guide if you accidentally mess up your data inserts.sql.sql
2 - Link to dbdiagram.html
3 - Building an ERD (Entity Relationship Diagram).mp4
3 - dbdiagram.io SQL.txt.txt
4 - Microsoft Documentation on Creating Tables and Databases.html
5 - Create a database (code).txt.txt
5 - Creating Your First Database (SSMS GUI and T-SQL).mp4
6 - Creating Tables (SSMS GUI and T-SQL).mp4
6 - create our tables sql.txt.txt
7 - Adding Constraints to our Tables and AlteringDropping our Tables.mp4
7 - Foreign Key Constraints SQL.txt.txt
8 - Inserting, Updating, and Deleting Data in our Tables.mp4
9 - Final Project ERD SQL.txt.txt
9 - Planning the Ski & Snowboard Shop Database (Creating our ERD).mp4
Bonus Resources.txt
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch [ WebToolTip com ] Udemy - Ultimate SQL Beginner to Intermediate Guide using SQL Server Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
