btfox

Udemy - Master SQL and Databases in 30 Days A Practical Guide (10.2024)

File list

  • 12 - DAY 12 Working with CASE Statements/2 -Hands-on Project Writing Conditional SQL Queries.mp4-98.69 MB
  • 11 - DAY 11 Subqueries/2 -Hands-on Project Writing Subqueries in SQL.mp4-98.54 MB
  • 4 - DAY 04 WHERE Clause and Logical Operators/2 -Hands-on Project Applying Logical Operators in SQL Queries.mp4-97.47 MB
  • 8 - DAY 8 GROUP BY Clause/2 -Hands-on Project Applying Aggregate Functions to Groups.mp4-94.02 MB
  • 6 - DAY 06 Using LIMIT & OFFSET/2 -Hands-on Project Limiting Query Results.mp4-93.68 MB
  • 7 - DAY 07 Using Aggregate Functions/2 -Hands-on Project Applying Aggregate Functions to Data.mp4-89.28 MB
  • 1 - DAY 01 Introduction to SQL/2 -Setting Up Your Local SQL Environment and Running Your First Database.mp4-85.19 MB
  • 9 - DAY 9 HAVING Clause/2 -Hands-on Project Applying Filters to Grouped Data.mp4-85.09 MB
  • 16 - DAY 16 Working with Views/2 -Hands-on Project Creating and Using Views in SQL.mp4-85 MB
  • 2 - DAY 02 Understanding Databases and Tables/2 -Hands-on Project Creating Databases and Tables in SQL.mp4-84.31 MB
  • 3 - DAY 03 Using the SELECT Statement/2 -Hands-on Project Querying Data from Tables in SQL.mp4-83.71 MB
  • 17 - DAY 17 Transaction Management/2 -Hands-on Project Implementing Transactions in SQL.mp4-80.59 MB
  • 5 - DAY 05 Sorting Data with ORDER BY/2 -Hands-on Project Writing Queries with ORDER BY.mp4-79.98 MB
  • 23 - DAY 23 String Functions/2 -Hands-on Project Manipulating Strings in SQL Queries.mp4-77.93 MB
  • 25 - DAY 25 Window Functions/2 -Hands-on Project Writing Queries Using Window Functions.mp4-74.77 MB
  • 20 - DAY 20 Database Normalization/2 -Hands-on Project Applying Normalization Techniques.mp4-74.52 MB
  • 15 - DAY 15 Understanding Indexes/2 -Hands-on Project Creating and Managing Indexes.mp4-70.38 MB
  • 10 - DAY 10 JOINs/2 -Hands-on Project Joining Multiple Tables.mp4-70.21 MB
  • 2 - DAY 02 Understanding Databases and Tables/1 -Database Structure and Table Relationships.mp4-69.63 MB
  • 7 - DAY 07 Using Aggregate Functions/1 -Overview of Aggregate Functions.mp4-67.66 MB
  • 13 - DAY 13 Self-Joins/2 -Hands-on Project Writing Queries with Self-Joins.mp4-66.75 MB
  • 14 - DAY 14 UNION & UNION ALL/2 -Hands-on Project Merging Results from Multiple Queries.mp4-66.34 MB
  • 16 - DAY 16 Working with Views/1 -Overview of SQL Views.mp4-60.86 MB
  • 2 - DAY 02 Understanding Databases and Tables/3 -Hands-on Project Verifying Structure and Relationships.mp4-58.8 MB
  • 26 - DAY 26 Common Table Expressions (CTE)/1 -Introduction to CTE in SQL.mp4-58.77 MB
  • 8 - DAY 8 GROUP BY Clause/1 -Grouping Data with GROUP BY.mp4-58.23 MB
  • 4 - DAY 04 WHERE Clause and Logical Operators/1 -Filtering Data with WHERE Clause.mp4-56.65 MB
  • 23 - DAY 23 String Functions/1 -Overview of SQL String Functions.mp4-55.48 MB
  • 18 - DAY 18 Creating Stored Procedures/1 -Introduction to Stored Procedures.mp4-54.4 MB
  • 5 - DAY 05 Sorting Data with ORDER BY/1 -Sorting Data Using ORDER BY.mp4-54.37 MB
  • 17 - DAY 17 Transaction Management/1 -Understanding Transactions in SQL.mp4-53.74 MB
  • 12 - DAY 12 Working with CASE Statements/1 -Understanding CASE Statements.mp4-53.44 MB
  • 11 - DAY 11 Subqueries/1 -Understanding Subqueries.mp4-52.53 MB
  • 3 - DAY 03 Using the SELECT Statement/3 -Hands-on Project Use SELECT with Aggregate Functions.mp4-52.38 MB
  • 30 - DAY 30 Query Performance Tuning/1 -Understanding Query Performance Tuning.mp4-50.83 MB
  • 26 - DAY 26 Common Table Expressions (CTE)/2 -Hands-on Project Writing Queries with CTEs.mp4-50.43 MB
  • 10 - DAY 10 JOINs/1 -Introduction to SQL JOINs.mp4-50.26 MB
  • 13 - DAY 13 Self-Joins/1 -Understanding Self-Joins.mp4-49.94 MB
  • 22 - DAY 22 Date Functions/2 -Hands-on Project Manipulating Dates in SQL Queries.mp4-48.32 MB
  • 27 - DAY 27 Analytic Functions/1 -Overview of Analytic Functions.mp4-47.98 MB
  • 6 - DAY 06 Using LIMIT & OFFSET/1 -Understanding LIMIT & OFFSET.mp4-47.68 MB
  • 9 - DAY 9 HAVING Clause/1 -Filtering Groups with HAVING.mp4-47.57 MB
  • 25 - DAY 25 Window Functions/1 -Overview of Window Functions.mp4-45.56 MB
  • 14 - DAY 14 UNION & UNION ALL/1 -Combining Result Sets with UNION.mp4-45.41 MB
  • 1 - DAY 01 Introduction to SQL/1 -Understanding SQL and its Importance.mp4-44.95 MB
  • 24 - DAY 24 Math Functions/1 -Introduction to SQL Math Functions.mp4-44.15 MB
  • 28 - DAY 28 Pivot & Unpivot/1 -Understanding Pivot & Unpivot in SQL.mp4-44.01 MB
  • 21 - DAY 21 Exploring ACID Properties/1 -Understanding ACID Transactions.mp4-43.44 MB
  • 29 - DAY 29 Index Optimization/1 -Index Optimization Techniques.mp4-43.24 MB
  • 3 - DAY 03 Using the SELECT Statement/1 -Purpose and Syntax of SELECT.mp4-42.99 MB