Master SQL and Databases in 30 Days A Complete Guide

Started by AD-TEAM, Dec 21, 2024, 05:34 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

AD-TEAM


2.64 GB | 00:14:11 | mp4 | 1280X720  | 16:9
Genre:eLearning |Language:English

Files Included :
1 -Understanding SQL and its Importance  (44.95 MB)
2 -Setting Up Your Local SQL Environment and Running Your First Database  (85.19 MB)
1 -Hands-on Project Joining Multiple Tables  (70.21 MB)
1 -Understanding Subqueries  (52.53 MB)
2 -Hands-on Project Writing Subqueries in SQL  (98.54 MB)
1 -Understanding CASE Statements  (53.44 MB)
2 -Hands-on Project Writing Conditional SQL Queries  (98.69 MB)
1 -Understanding Self-Joins  (49.94 MB)
2 -Hands-on Project Writing Queries with Self-Joins  (66.75 MB)
1 -Combining Result Sets with UNION  (45.41 MB)
2 -Hands-on Project Merging Results from Multiple Queries  (66.34 MB)
1 -Introduction to Indexing in Databases  (37.22 MB)
2 -Hands-on Project Creating and Managing Indexes  (70.38 MB)
1 -Overview of SQL Views  (60.86 MB)
2 -Hands-on Project Creating and Using Views in SQL  (85 MB)
1 -Understanding Transactions in SQL  (53.74 MB)
2 -Hands-on Project Implementing Transactions in SQL  (80.59 MB)
1 -Introduction to Stored Procedures  (54.4 MB)
1 -Understanding SQL Triggers  (28.58 MB)
1 -Database Structure and Table Relationships  (69.63 MB)
2 -Hands-on Project Creating Databases and Tables in SQL  (84.31 MB)
3 -Hands-on Project  Verifying Structure and Relationships  (58.8 MB)
1 -Importance of Database Normalization  (37.78 MB)
2 -Hands-on Project Applying Normalization Techniques  (74.52 MB)
1 -Understanding ACID Transactions  (43.44 MB)
1 -Overview of SQL Date Functions  (30.77 MB)
2 -Hands-on Project Manipulating Dates in SQL Queries  (48.32 MB)
1 -Purpose and Syntax of SELECT  (42.99 MB)
2 -Hands-on Project Querying Data from Tables in SQL  (83.71 MB)
3 -Hands-on Project Use SELECT with Aggregate Functions  (52.38 MB)
1 -Filtering Data with WHERE Clause  (56.65 MB)
2 -Hands-on Project Applying Logical Operators in SQL Queries  (97.47 MB)
1 -Sorting Data Using ORDER BY  (54.37 MB)
2 -Hands-on Project Writing Queries with ORDER BY  (79.98 MB)
1 -Understanding LIMIT & OFFSET  (47.68 MB)
2 -Hands-on Project Limiting Query Results  (93.68 MB)
1 -Overview of Aggregate Functions  (67.66 MB)
2 -Hands-on Project Applying Aggregate Functions to Data  (89.28 MB)
1 -Grouping Data with GROUP BY  (58.23 MB)
2 -Hands-on Project Applying Aggregate Functions to Groups  (94.02 MB)
1 -Filtering Groups with HAVING  (47.57 MB)
2 -Hands-on Project Applying Filters to Grouped Data  (85.09 MB)]
Screenshot