[ WebToolTip.com ] Udemy - Ultimate SQL Beginner to Intermediate Guide using SQL Server

File Name

Size

Get Bonus Downloads Here.url

180 B

~Get Your Files Here !/1 - Introduction/1 - Introduction to the Course.mp4

30 MB

~Get Your Files Here !/1 - Introduction/2 - Intro to our Tech Stack (SQL Server and SSMS).mp4

40 MB

~Get Your Files Here !/2 - Databases & SQL Fundamentals & Environment Setup/1 - What is a Database & Relational vs Non-Relational Databases.mp4

92 MB

~Get Your Files Here !/2 - Databases & SQL Fundamentals & Environment Setup/2 - Introduction to SQL.mp4

11 MB

~Get Your Files Here !/2 - Databases & SQL Fundamentals & Environment Setup/3 - Introduction to SQL Queries & Query Structure.mp4

37 MB

~Get Your Files Here !/2 - Databases & SQL Fundamentals & Environment Setup/4 - Environment Setup Links.html

1.9 kB

~Get Your Files Here !/2 - Databases & SQL Fundamentals & Environment Setup/5 - Setting up SQL Server, SSMS and Importing AdventureWorks2022 Database.mp4

119 MB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/1 - Navigating SSMS - Watch if new to SSMS.mp4

66 MB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/10 - Sorting Data with ORDER BY (and using the Format function).mp4

105 MB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/11 - Count and Sum Aggregate SQL File.sql.sql

1.7 kB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/11 - Grouping Data with GROUP BY and Aggregate Functions (SUM and COUNT).mp4

357 MB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/12 - Grouping Data with GROUP BY and Aggregate Functions (AVG, MIN, and MAX).mp4

142 MB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/12 - Min, Max, Avg SQL File.sql.sql

1.6 kB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/13 - HAVING SQL File.sql.sql

1.3 kB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/13 - Using the HAVING keyword with Aggregate Functions.mp4

202 MB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/14 - Let's Explore what Joins are (Inner, LeftRight, Outer, etc.).mp4

146 MB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/15 - Joining Tables with INNER JOIN.mp4

272 MB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/15 - inner join.sql.sql

964 B

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/16 - LEFT AND RIGHT JOIN.sql.sql

2.3 kB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/16 - Left and Right Joins.mp4

97 MB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/17 - FULL OUTER JOIN.sql.sql

1.6 kB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/17 - Full Outer Joins.mp4

52 MB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/18 - Combining Results with UNION.mp4

79 MB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/18 - UNION and UNION ALL.sql.sql

3.6 kB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/2 - Heads up on Case Sensitivity in SSMS.html

781 B

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/3 - Learning SELECT with Alias's and FROM statements.mp4

76 MB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/3 - SelectAndFrom_Lecture.sql.sql

267 B

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/4 - Practice SELECT & FROM Statements.html

176 B

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/4 - SelectAndFrom_Assignment.sql.sql

742 B

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/5 - SELECT & FROM Statements Solution.mp4

25 MB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/5 - SelectAndFrom_Solution.sql.sql

1.1 kB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/6 - WHERE Statement Part 1 (Operators =, , , , =, =, NOT IN).mp4

140 MB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/6 - WHERE+Part+1.sql.sql

551 B

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/7 - WHERE Statement Part 2 (Continued AND, OR, LIKE).mp4

140 MB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/7 - WHERE+Part+2.sql.sql

609 B

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/8 - WHERE Statement Part 3 (IS NULL Handling NULL's).mp4

42 MB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/8 - WHERE+Statement+Assignment.sql.sql

1.1 kB

~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/9 - DISTINCT SELECT and FROM with WHERE.mp4

21 MB

~Get Your Files Here !/4 - Writing SQL Queries Advanced SQL/1 - CTE.sql.sql

2.7 kB

~Get Your Files Here !/4 - Writing SQL Queries Advanced SQL/1 - Common Table Expressions (CTEs).mp4

60 MB

~Get Your Files Here !/4 - Writing SQL Queries Advanced SQL/2 - Using Views for Simplifying Complex Queries.mp4

98 MB

~Get Your Files Here !/4 - Writing SQL Queries Advanced SQL/2 - VIEWS.sql.sql

2.8 kB

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/1 - Introduction to Database Design (Theory Essentials).mp4

61 MB

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/10 - Creating All Final Project Database and Tables (Step-by-Step).mp4

44 MB

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/10 - Creating our Final Projects Tables SQL Query.sql.sql

3.3 kB

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/10 - Final Project Create our Database SQL.sql.sql

502 B

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/10 - Final Project Schema Creation SQL.sql.sql

106 B

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/11 - If you mess up your Data Insertion, follow this guide.html

1.5 kB

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/12 - Entering Data & Querying our Tables.mp4

157 MB

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/12 - Final Project Customers SQL Insert Dump.sql.sql

2.2 kB

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/12 - Final Project EmployeePayInfo SQL Insert Dump.sql.sql

1.2 kB

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/12 - Final Project Order Items SQL Insert Dump.sql.sql

1.1 kB

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/12 - Final Project Orders SQL Insert Dump.sql.sql

2.2 kB

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/12 - Final Project Products SQL Insert Dump.sql.sql

1.8 kB

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/12 - Final Projects - Employees Insert SQL Dump.sql.sql

2.3 kB

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/12 - Guide if you accidentally mess up your data inserts.sql.sql

1.2 kB

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/2 - Link to dbdiagram.html

114 B

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/3 - Building an ERD (Entity Relationship Diagram).mp4

72 MB

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/3 - dbdiagram.io SQL.txt.txt

1.8 kB

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/4 - Microsoft Documentation on Creating Tables and Databases.html

648 B

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/5 - Create a database (code).txt.txt

754 B

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/5 - Creating Your First Database (SSMS GUI and T-SQL).mp4

46 MB

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/6 - Creating Tables (SSMS GUI and T-SQL).mp4

66 MB

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/6 - create our tables sql.txt.txt

805 B

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/7 - Adding Constraints to our Tables and AlteringDropping our Tables.mp4

50 MB

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/7 - Foreign Key Constraints SQL.txt.txt

266 B

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/8 - Inserting, Updating, and Deleting Data in our Tables.mp4

94 MB

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/9 - Final Project ERD SQL.txt.txt

1.3 kB

~Get Your Files Here !/5 - Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)/9 - Planning the Ski & Snowboard Shop Database (Creating our ERD).mp4

70 MB

~Get Your Files Here !/Bonus Resources.txt

70 B