[ WebToolTip.com ] Udemy - SQL for Beginners - Build Real Query Skills (MySQL)

File Name

Size

Get Bonus Downloads Here.url

180 B

~Get Your Files Here !/1 - Introduction & Course Setup/1. 00_README_SETUP.txt

1.6 kB

~Get Your Files Here !/1 - Introduction & Course Setup/1. Introduction & Getting Started.html

22 kB

~Get Your Files Here !/1 - Introduction & Course Setup/1. Introduction & Why Learn SQL.mp4

92 MB

~Get Your Files Here !/1 - Introduction & Course Setup/1. Introduction & Why Learn SQL_en-US.srt

6.8 kB

~Get Your Files Here !/1 - Introduction & Course Setup/1. Stack Overflow Developer Survey — Most Popular Technologies.url

60 B

~Get Your Files Here !/1 - Introduction & Course Setup/2. Installing MySQL Server & DBeaver Community Client.mp4

69 MB

~Get Your Files Here !/1 - Introduction & Course Setup/2. Installing MySQL Server & DBeaver Community Client_en-US.srt

13 kB

~Get Your Files Here !/1 - Introduction & Course Setup/2. Lecture_02_MySQL_and_DBeaver_Setup_Guide.txt

464 B

~Get Your Files Here !/2 - Database Foundations & Architecture/10. Column Constraints NOT NULL, UNIQUE, CHECK & DEFAULT.mp4

161 MB

~Get Your Files Here !/2 - Database Foundations & Architecture/10. Column Constraints NOT NULL, UNIQUE, CHECK & DEFAULT_en-US.srt

19 kB

~Get Your Files Here !/2 - Database Foundations & Architecture/10. Lecture_10_Column_Constraints_Practice.sql

627 B

~Get Your Files Here !/2 - Database Foundations & Architecture/2. Database Foundations.html

25 kB

~Get Your Files Here !/2 - Database Foundations & Architecture/3. What is a Relational Database & Why Does It Matter.mp4

100 MB

~Get Your Files Here !/2 - Database Foundations & Architecture/3. What is a Relational Database & Why Does It Matter_en-US.srt

10 kB

~Get Your Files Here !/2 - Database Foundations & Architecture/4. Tables, Rows, and Columns Explained.mp4

76 MB

~Get Your Files Here !/2 - Database Foundations & Architecture/4. Tables, Rows, and Columns Explained_en-US.srt

8.6 kB

~Get Your Files Here !/2 - Database Foundations & Architecture/5. Data Types Part 1 Text Types (CHAR, VARCHAR, TEXT).mp4

64 MB

~Get Your Files Here !/2 - Database Foundations & Architecture/5. Data Types Part 1 Text Types (CHAR, VARCHAR, TEXT)_en-US.srt

10 kB

~Get Your Files Here !/2 - Database Foundations & Architecture/6. Data Types Part 2 Numbers & Dates (INT, DECIMAL, FLOAT, DATE, DATETIME).mp4

106 MB

~Get Your Files Here !/2 - Database Foundations & Architecture/6. Data Types Part 2 Numbers & Dates (INT, DECIMAL, FLOAT, DATE, DATETIME)_en-US.srt

19 kB

~Get Your Files Here !/2 - Database Foundations & Architecture/7. Data Types Part 3 Boolean, NULL & Designing Your Schema.mp4

68 MB

~Get Your Files Here !/2 - Database Foundations & Architecture/7. Data Types Part 3 Boolean, NULL & Designing Your Schema_en-US.srt

7.0 kB

~Get Your Files Here !/2 - Database Foundations & Architecture/8. DBeaver Workspace Creating Your First Database.mp4

145 MB

~Get Your Files Here !/2 - Database Foundations & Architecture/8. DBeaver Workspace Creating Your First Database_en-US.srt

12 kB

~Get Your Files Here !/2 - Database Foundations & Architecture/8. Lecture_08_Create_First_Database.sql

283 B

~Get Your Files Here !/2 - Database Foundations & Architecture/9. Primary Keys Your Data's Unique Identity.mp4

143 MB

~Get Your Files Here !/2 - Database Foundations & Architecture/9. Primary Keys Your Data's Unique Identity_en-US.srt

14 kB

~Get Your Files Here !/3 - Reading & Filtering Data Mastery/11. 00_Setup_MyFirstDB.sql

36 kB

~Get Your Files Here !/3 - Reading & Filtering Data Mastery/11. Lecture_11_SELECT_Basic_Queries.sql

433 B

~Get Your Files Here !/3 - Reading & Filtering Data Mastery/11. SELECT Your Data Retrieval Power Tool.mp4

137 MB

~Get Your Files Here !/3 - Reading & Filtering Data Mastery/11. SELECT Your Data Retrieval Power Tool_en-US.srt

20 kB

~Get Your Files Here !/3 - Reading & Filtering Data Mastery/12. Lecture_12_WHERE_Filtering.sql

405 B

~Get Your Files Here !/3 - Reading & Filtering Data Mastery/12. WHERE Clause Filtering for Exact Data Subsets.mp4

143 MB

~Get Your Files Here !/3 - Reading & Filtering Data Mastery/12. WHERE Clause Filtering for Exact Data Subsets_en-US.srt

14 kB

~Get Your Files Here !/3 - Reading & Filtering Data Mastery/13. Comparison Operators (=, !=, , , =, =).mp4

80 MB

~Get Your Files Here !/3 - Reading & Filtering Data Mastery/13. Comparison Operators (=, !=, , , =, =)_en-US.srt

11 kB

~Get Your Files Here !/3 - Reading & Filtering Data Mastery/13. Lecture_13_Comparison_Operators.sql

384 B

~Get Your Files Here !/3 - Reading & Filtering Data Mastery/14. Lecture_14_Logical_Operators_AND_OR_NOT.sql

659 B

~Get Your Files Here !/3 - Reading & Filtering Data Mastery/14. Logical Operators Combining Conditions with AND, OR, NOT.mp4

92 MB

~Get Your Files Here !/3 - Reading & Filtering Data Mastery/14. Logical Operators Combining Conditions with AND, OR, NOT_en-US.srt

15 kB

~Get Your Files Here !/3 - Reading & Filtering Data Mastery/15. Lecture_15_ORDER_BY_LIMIT_DISTINCT.sql

526 B

~Get Your Files Here !/3 - Reading & Filtering Data Mastery/15. Refining Results ORDER BY, LIMIT, and DISTINCT.mp4

67 MB

~Get Your Files Here !/3 - Reading & Filtering Data Mastery/15. Refining Results ORDER BY, LIMIT, and DISTINCT_en-US.srt

15 kB

~Get Your Files Here !/3 - Reading & Filtering Data Mastery/16. Bonus Practice Hands-On SQL Challenges.mp4

66 MB

~Get Your Files Here !/3 - Reading & Filtering Data Mastery/16. Bonus Practice Hands-On SQL Challenges_en-US.srt

10 kB

~Get Your Files Here !/3 - Reading & Filtering Data Mastery/16. Lecture_16_Section_3_Bonus_Practice_Queries.sql

580 B

~Get Your Files Here !/3 - Reading & Filtering Data Mastery/3. Querying Data with SELECT.html

24 kB

~Get Your Files Here !/4 - Modifying & Managing Database Records/17. INSERT Adding New Records to Tables.mp4

101 MB

~Get Your Files Here !/4 - Modifying & Managing Database Records/17. INSERT Adding New Records to Tables_en-US.srt

21 kB

~Get Your Files Here !/4 - Modifying & Managing Database Records/17. Lecture_17_INSERT_Adding_Records.sql

828 B

~Get Your Files Here !/4 - Modifying & Managing Database Records/18. Lecture_18_UPDATE_Modifying_Records.sql

671 B

~Get Your Files Here !/4 - Modifying & Managing Database Records/18. UPDATE Modifying Existing Records Safely.mp4

97 MB

~Get Your Files Here !/4 - Modifying & Managing Database Records/18. UPDATE Modifying Existing Records Safely_en-US.srt

12 kB

~Get Your Files Here !/4 - Modifying & Managing Database Records/19. DELETE Removing Data Safely & Avoiding Pitfalls.mp4

60 MB

~Get Your Files Here !/4 - Modifying & Managing Database Records/19. DELETE Removing Data Safely & Avoiding Pitfalls_en-US.srt

14 kB

~Get Your Files Here !/4 - Modifying & Managing Database Records/19. Lecture_19_DELETE_Removing_Records_Safely.sql

653 B

~Get Your Files Here !/4 - Modifying & Managing Database Records/20. Best Practices & Common Mistakes Backups, Recovery & Practice Challenges.mp4

120 MB

~Get Your Files Here !/4 - Modifying & Managing Database Records/20. Best Practices & Common Mistakes Backups, Recovery & Practice Challenges_en-US.srt

17 kB

~Get Your Files Here !/4 - Modifying & Managing Database Records/20. Lecture_20_Backups_Recovery_and_Best_Practices.sql

580 B

~Get Your Files Here !/4 - Modifying & Managing Database Records/21. Lecture_21_Working_With_NULL_Values.sql

442 B

~Get Your Files Here !/4 - Modifying & Managing Database Records/21. Working with NULL Values & Unknowns.mp4

83 MB

~Get Your Files Here !/4 - Modifying & Managing Database Records/21. Working with NULL Values & Unknowns_en-US.srt

15 kB

~Get Your Files Here !/4 - Modifying & Managing Database Records/4. Modifying & Managing Data.html

23 kB

~Get Your Files Here !/5 - Aggregation & Summary Analytics/22. Essential Aggregate Functions COUNT, SUM, AVG, MIN & MAX.mp4

96 MB

~Get Your Files Here !/5 - Aggregation & Summary Analytics/22. Essential Aggregate Functions COUNT, SUM, AVG, MIN & MAX_en-US.srt

16 kB

~Get Your Files Here !/5 - Aggregation & Summary Analytics/22. Lecture_22_Aggregate_Functions_COUNT_SUM_AVG_MIN_MAX.sql

682 B

~Get Your Files Here !/5 - Aggregation & Summary Analytics/23. GROUP BY Calculating Business KPIs & Filtering Groups with HAVING.mp4

73 MB

~Get Your Files Here !/5 - Aggregation & Summary Analytics/23. GROUP BY Calculating Business KPIs & Filtering Groups with HAVING_en-US.srt

12 kB

~Get Your Files Here !/5 - Aggregation & Summary Analytics/23. Lecture_23_GROUP_BY_and_HAVING_Analytics.sql

804 B

~Get Your Files Here !/5 - Aggregation & Summary Analytics/5. Aggregation & Grouping.html

23 kB

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/24. Foreign Keys & Relational Table Architecture.mp4

74 MB

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/24. Foreign Keys & Relational Table Architecture_en-US.srt

11 kB

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/24. Lecture_24_Foreign_Keys_and_Relationships.sql

394 B

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/25. INNER JOIN Connecting Related Data Across Tables.mp4

94 MB

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/25. INNER JOIN Connecting Related Data Across Tables_en-US.srt

8.0 kB

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/25. Lecture_25_INNER_JOIN_Matching_Records.sql

633 B

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/26. LEFT JOIN Keeping Unmatched Records & Finding Missing Data.mp4

62 MB

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/26. LEFT JOIN Keeping Unmatched Records & Finding Missing Data_en-US.srt

10 kB

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/26. Lecture_26_LEFT_JOIN_Finding_Missing_Data.sql

566 B

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/27. INNER vs LEFT JOIN How to Choose in Business Scenarios.mp4

60 MB

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/27. INNER vs LEFT JOIN How to Choose in Business Scenarios_en-US.srt

13 kB

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/27. Lecture_27_When_To_Use_Which_JOIN.sql

709 B

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/28. Chaining Multi-Table Queries & Using Table Aliases.mp4

51 MB

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/28. Chaining Multi-Table Queries & Using Table Aliases_en-US.srt

8.9 kB

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/28. Lecture_28_Multi_Table_Chained_JOINs.sql

706 B

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/29. Lecture_29_Subqueries_Nested_Queries.sql

562 B

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/29. Subqueries Writing Nested Queries with Confidence.mp4

80 MB

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/29. Subqueries Writing Nested Queries with Confidence_en-US.srt

12 kB

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/30. Lecture_30_Ecommerce_Store_Analytics_Workflow.sql

600 B

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/30. Practice E-Commerce Store Analytics Workflow.mp4

105 MB

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/30. Practice E-Commerce Store Analytics Workflow_en-US.srt

13 kB

~Get Your Files Here !/6 - Table Relationships, Multi-Table JOINs & Subqueries/6. Table Relationships, JOINs & Subqueries.html

25 kB

~Get Your Files Here !/7 - End-to-End Capstone Project & Wrap-Up/31. 07-01_practice_exercises.sql

19 kB

~Get Your Files Here !/7 - End-to-End Capstone Project & Wrap-Up/31. 07-01_reporting_queries.sql

2.3 kB

~Get Your Files Here !/7 - End-to-End Capstone Project & Wrap-Up/31. Capstone Project Building a Full Music Shop Reporting Workflow.mp4

82 MB

~Get Your Files Here !/7 - End-to-End Capstone Project & Wrap-Up/31. Capstone Project Building a Full Music Shop Reporting Workflow_en-US.srt

10 kB

~Get Your Files Here !/7 - End-to-End Capstone Project & Wrap-Up/31. Lecture_31_Music_Shop_Capstone_Reporting_Workflow.sql

846 B

~Get Your Files Here !/7 - End-to-End Capstone Project & Wrap-Up/31. music_shop.sql

1.8 MB

~Get Your Files Here !/7 - End-to-End Capstone Project & Wrap-Up/32. Course Wrap-Up, The SQL Mindset & Next Career Steps.mp4

51 MB

~Get Your Files Here !/7 - End-to-End Capstone Project & Wrap-Up/32. Course Wrap-Up, The SQL Mindset & Next Career Steps_en-US.srt

6.1 kB

~Get Your Files Here !/Bonus Resources.txt

70 B