Don't like banners? Log in and we will make sure you see no banners. For free.
No cover art

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

Size
3 GB
Seeders
3
Leechers
1
Files
70
Category
Added
at 3:06am GMT+1
Status
Not verified
Infohash
fdc159da1cd6fed372cf878f23fada2f4fffa37d
Don't like banners? Log in and we will make sure you see no banners. For free.

Description

Ultimate SQL Beginner to Intermediate Guide using SQL Server


https://WebToolTip.com


Published 12/2025

Created by Cloud Trader Academy

MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch

Level: Beginner | Genre: eLearning | Language: English | Duration: 39 Lectures ( 8h 55m ) | Size: 3.1 GB


Learn SQL by designing databases, creating ERDs, writing queries, and completing hands-on SQL Server projects.


What you'll learn

Install, set up, and configure SQL Server and SQL Server Management Studio

Create your own databases, tables, schemas, and relationships

Insert, update, and delete data to manage database content

Import sample databases into SQL Server for hands on practice

Query data using SELECT, FROM, WHERE, ORDER BY, GROUP BY, and HAVING

Join multiple tables using INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, and UNION

Use aggregate functions such as COUNT, SUM, AVG, MIN, and MAX to analyze data

Write advanced queries using Common Table Expressions and Views

Build and filter reports with GROUP BY and HAVING conditions

Modify database structures using ALTER TABLE and other DDL commands

Delete tables, rows, and entire databases safely and correctly

Understand database concepts that support data analysis, BI, and software development


Requirements

This is for complete beginners, basic knowledge on Databases is helpful but not necessary.

File list
  • [ WebToolTip.com ] Udemy - Ultimate SQL Beginner to Intermediate Guide using SQL Server
  • ~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 39.8 MB
  • ~Get Your Files Here !/2 - Databases & SQL Fundamentals & Environment Setup/1 - What is a Database & Relational vs Non-Relational Databases.mp4 91.9 MB
  • ~Get Your Files Here !/2 - Databases & SQL Fundamentals & Environment Setup/2 - Introduction to SQL.mp4 10.8 MB
  • ~Get Your Files Here !/2 - Databases & SQL Fundamentals & Environment Setup/3 - Introduction to SQL Queries & Query Structure.mp4 36.7 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 118.7 MB
  • ~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/1 - Navigating SSMS - Watch if new to SSMS.mp4 66.3 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.1 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.4 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.5 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 201.7 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.1 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/15 - Joining Tables with INNER JOIN.mp4 272.1 MB
  • ~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 51.5 MB
  • ~Get Your Files Here !/3 - Writing SQL Queries Beginner to Intermediate/18 - Combining Results with UNION.mp4 78.8 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.4 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 24.9 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.2 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.2 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 41.9 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.3 MB
  • ~Get Your Files Here !/4 - Writing SQL Queries Advanced SQL/1 - Common Table Expressions (CTEs).mp4 60.4 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/2 - Using Views for Simplifying Complex Queries.mp4 97.7 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 60.6 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.3 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 156.6 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 45.6 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)/6 - Creating Tables (SSMS GUI and T-SQL).mp4 65.9 MB
  • ~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 49.8 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 93.7 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 69.6 MB
  • ~Get Your Files Here !/Bonus Resources.txt 70 B

Rating
Not rated yet
Log in to rate

Comments

No comments yet.