Udemy - Ultimate SQL Beginner to Intermediate Guide using SQL Ser...

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction
• 1 - Introduction to the Course.mp4 (30.0 MB)
• 2 - Intro to our Tech Stack (SQL Server and SSMS).mp4 (39.8 MB)
2 - Databases & SQL Fundamentals & Environment Setup
• 1 - What is a Database & Relational vs Non-Relational Databases.mp4 (91.9 MB)
• 2 - Introduction to SQL.mp4 (10.8 MB)
• 3 - Introduction to SQL Queries & Query Structure.mp4 (36.7 MB)
• 4 - Environment Setup Links.html (1.9 KB)
• 5 - Setting up SQL Server, SSMS and Importing AdventureWorks2022 Database.mp4 (118.7 MB)
3 - Writing SQL Queries Beginner to Intermediate
• 1 - Navigating SSMS - Watch if new to SSMS.mp4 (66.3 MB)
• 10 - Sorting Data with ORDER BY (and using the Format function).mp4 (105.1 MB)
• 11 - Count and Sum Aggregate SQL File.sql.sql (1.7 KB)
• 11 - Grouping Data with GROUP BY and Aggregate Functions (SUM and COUNT).mp4 (357.4 MB)
• 12 - Grouping Data with GROUP BY and Aggregate Functions (AVG, MIN, and MAX).mp4 (142.5 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 (201.7 MB)
• 14 - Let's Explore what Joins are (Inner, LeftRight, Outer, etc.).mp4 (146.1 MB)
• 15 - Joining Tables with INNER JOIN.mp4 (272.1 MB)
• 15 - inner join.sql.sql (0.9 KB)
• 16 - LEFT AND RIGHT JOIN.sql.sql (2.3 KB)
• 16 - Left and Right Joins.mp4 (97.0 MB)
• 17 - FULL OUTER JOIN.sql.sql (1.6 KB)
• 17 - Full Outer Joins.mp4 (51.5 MB)
• 18 - Combining Results with UNION.mp4 (78.8 MB)
• 18 - UNION and UNION ALL.sql.sql (3.6 KB)
• 2 - Heads up on Case Sensitivity in SSMS.html (0.8 KB)
• 3 - Learning SELECT with Alias's and FROM statements.mp4 (76.4 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 (24.9 MB)
• 5 - SelectAndFrom_Solution.sql.sql (1.1 KB)
• 6 - WHERE Statement Part 1 (Operators =, , , , =, =, NOT IN).mp4 (140.2 MB)
• 6 - WHERE+Part+1.sql.sql (0.5 KB)
• 7 - WHERE Statement Part 2 (Continued AND, OR, LIKE).mp4 (140.2 MB)
• 7 - WHERE+Part+2.sql.sql (0.6 KB)
• 8 - WHERE Statement Part 3 (IS NULL Handling NULL's).mp4 (41.9 MB)
• 8 - WHERE+Statement+Assignment.sql.sql (1.1 KB)
• 9 - DISTINCT SELECT and FROM with WHERE.mp4 (21.3 MB)
4 - Writing SQL Queries Advanced SQL
• 1 - CTE.sql.sql (2.7 KB)
• 1 - Common Table Expressions (CTEs).mp4 (60.4 MB)
• 2 - Using Views for Simplifying Complex Queries.mp4 (97.7 MB)
• 2 - VIEWS.sql.sql (2.8 KB)
5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)
• 1 - Introduction to Database Design (Theory Essentials).mp4 (60.6 MB)
• 10 - Creating All Final Project Database and Tables (Step-by-Step).mp4 (44.3 MB)
• 10 - Creating our Final Projects Tables SQL Query.sql.sql (3.3 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 (156.6 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.8 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 (72.0 MB)
• 3 - dbdiagram.io SQL.txt.txt (1.8 KB)
• 4 - Microsoft Documentation on Creating Tables and Databases.html (0.6 KB)
• 5 - Create a database (code).txt.txt (0.7 KB)
• 5 - Creating Your First Database (SSMS GUI and T-SQL).mp4 (45.6 MB)
• 6 - Creating Tables (SSMS GUI and T-SQL).mp4 (65.9 MB)
• 6 - create our tables sql.txt.txt (0.8 KB)
• 7 - Adding Constraints to our Tables and AlteringDropping our Tables.mp4 (49.8 MB)
• 7 - Foreign Key Constraints SQL.txt.txt (0.3 KB)
• 8 - Inserting, Updating, and Deleting Data in our Tables.mp4 (93.7 MB)
• 9 - Final Project ERD SQL.txt.txt (1.3 KB)
• 9 - Planning the Ski & Snowboard Shop Database (Creating our ERD).mp4 (69.6 MB)
• Bonus Resources.txt (0.1 KB)