Udemy - The Ultimate MySQL Bootcamp - SQL from Beginner to Expert

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction to Databases & SQL
• 1. What is Database Why SQL.mp4 (75.0 MB)
• 2. Types of Databases (Relational vs NoSQL).mp4 (57.3 MB)
• 3. Installation on Windows.mp4 (28.2 MB)
• 4. Installation on Mac.mp4 (62.5 MB)
• 5. Understanding Database Objects.mp4 (167.6 MB)
• 6. 1.6-Creating-Your-First-database.sql (0.2 KB)
• 6. Creating Your First Database.mp4 (25.2 MB)
• 7. Restoring Employees Database.mp4 (39.5 MB)
10 - MySQL Administration & Security
• 52. 10.1-Intro-to-Users-Privilege.sql (0.4 KB)
• 52. Users & Privileges Part 1.mp4 (31.5 MB)
• 53. 10.2-Users-Priviledges-Part-2.sql (0.5 KB)
• 53. Users & Priviledges Part 2.mp4 (110.5 MB)
• 54. Backup_and_Restore.mp4 (75.3 MB)
• 55. 10.4-Acid-Properties-part-1.sql (0.6 KB)
• 55. Transactions & ACID Properties Part 1.mp4 (43.9 MB)
• 56. ACID Properties Part 2.mp4 (102.8 MB)
• 57. 10.6.Locking-Concurrency-Control.sql (0.3 KB)
• 57. Locking & Concurrency Control.mp4 (26.3 MB)
• 58. 10.5-Auto-commit-COMMIT-ROLLBACK.sql (0.1 KB)
• 58. COMMIT, ROLLBACK.mp4 (44.1 MB)
11 - MySQL with Applications
• 59. Python + MySQL (CRUD Operations using MySQL Connector).mp4 (67.8 MB)
• 59. python.py (1.5 KB)
• 60. MySQL with PHP Web Technologies.mp4 (105.4 MB)
• 60. employees.php (1.9 KB)
• 61. Introduction to ORMs.mp4 (93.9 MB)
• 61. mysql-alchemy-demo.py (1.8 KB)
2 - SQL Basics Retrieving Data
• 10. 2.3-Logical-Operators.sql (0.4 KB)
• 10. Logical operators AND, OR, NOT.mp4 (38.8 MB)
• 11. 2.4-Sorting-ORDER-BY.sql (0.3 KB)
• 11. Sorting ORDER BY.mp4 (32.2 MB)
• 12. 2.5-Aliasing-Columns.sql (0.3 KB)
• 12. Aliasing Columns.mp4 (24.0 MB)
• 13. 2.6-Basic-Exploration.sql (0.4 KB)
• 13. Basic Data Exploration Tasks.mp4 (33.0 MB)
• 8. 2.1-Select-Queries.sql (0.2 KB)
• 8. SELECT queries.mp4 (32.2 MB)
• 9. 2.2-Filtering-with-WHERE.sql (0.3 KB)
• 9. Filtering with WHERE clause.mp4 (35.9 MB)
3 - Working with MySQL Constraints & Data Types
• 14. 3.1-Numeric-Date-Time-String-Data.sql (0.2 KB)
• 14. Numeric, Date-Time, String Data Types.mp4 (31.1 MB)
• 15. Primary Key, Foreign Key, Unique, Check, Default.mp4 (68.4 MB)
• 16. 3.3-NULL-vs-NOT-NULL.sql (0.2 KB)
• 16. NULL vs NOT NULL.mp4 (41.0 MB)
• 17. 3.4-Auto-increment-and-identifiers-final-Video.mp4.sql (0.1 KB)
• 17. Auto Increment and Identifiers.mp4 (39.8 MB)
4 - DML (Insert, Update & Delete)
• 18. 4.1-INSERT-DATA.sql (0.5 KB)
• 18. INSERT single multiple rows.mp4 (35.6 MB)
• 19. 4.2-Update-records-with-condition.sql (0.3 KB)
• 19. UPDATE records with conditions.mp4 (31.2 MB)
• 20. 4.3-Delete-with-safe-rules.sql (0.1 KB)
• 20. DELETE with safe rules.mp4 (25.8 MB)
• 21. 4.4-Best-Practices-ROLLBack.sql (0.2 KB)
• 21. Best Practices & Rollbacks.mp4 (26.4 MB)
5 - SQL Functions & Operators
• 22. 5.1-Aggregate-Functions.mp4.sql (0.5 KB)
• 22. Aggregate Functions COUNT, SUM, AVG, MIN, MAX.mp4 (46.7 MB)
• 23. 5.2-String-Functions-CONCAT-UPPER-SUBSTR.sql (0.4 KB)
• 23. String Functions CONCAT, UPPER, SUBSTR, TRIM.mp4 (33.5 MB)
• 24. 5.3-Date-Time-Functions.sql (0.5 KB)
• 24. Date & Time Functions.mp4 (42.6 MB)
• 25. 5.4-Math-Conditional-Expression.sql (0.8 KB)
• 25. Math & Conditional Expressions.mp4 (67.4 MB)
• 26. 5.5-GROUP-BY-HAVING.sql (0.7 KB)
• 26. GROUP BY & HAVING.mp4 (51.2 MB)
6 - Advanced Data Retrieval
• 27. 6.1-JOINs.INNER-LEFT-RIGHT-FULL.sql (0.8 KB)
• 27. JOINs INNER, LEFT, RIGHT, FULL (with examples).mp4 (64.4 MB)
• 28. 6.2-UNION-UNION-ALL.sql (0.5 KB)
• 28. UNION vs UNION ALL.mp4 (44.7 MB)
• 29. 6.3-Subqueries.sql (0.7 KB)
• 29. Subqueries (Single-Row & Multi-Row).mp4 (59.6 MB)
• 30. 6.4-EXISTS-IN-operators.sql (0.6 KB)
• 30. EXISTS & IN operators.mp4 (59.2 MB)
• 31. 6.5-Correlated-Subqueries.sql (0.5 KB)
• 31. Correlated Subqueries.mp4 (58.0 MB)
7 - Database Design & Normalization
• 32. Normalization Part 1.mp4 (228.7 MB)
• 33. Normalization Part 2.mp4 (211.4 MB)
• 34. Normalization Part 3.mp4 (181.2 MB)
• 35. 7.4-KEY-IN-RELATIONAL-DB.sql (0.7 KB)
• 35. Keys in Relational DB.mp4 (40.0 MB)
• 36. What are ER Diagrams.mp4 (55.9 MB)
• 37. Create ER Diagram.mp4 (129.3 MB)
8 - Views, Indexes & Performance
• 38. 8.1-Creating-and-managing-Views.sql (0.5 KB)
• 38. Creating and managing Views.mp4 (36.5 MB)
• 39. 8.2.Types-Of-Indexes.sql (0.5 KB)
• 39. Types of Indexes.mp4 (67.5 MB)
• 40. 8.3-Index-use-cases.sql (0.6 KB)
• 40. Index Use-Cases & Performance Gains.mp4 (47.1 MB)
• 41. 8.4-How-to-Make-application-faster.sql (0.4 KB)
• 41. How to Make application faster.mp4 (92.8 MB)
• 42. 8.5-How-indexes-work.sql (0.2 KB)
• 42. How Indexes Work.mp4 (59.8 MB)
• 43. 8.6-Query-Execution-Plan1.sql (0.3 KB)
• 43. Query Execution Plan Part1.mp4 (56.6 MB)
• 44. Query Execution Plan Part 2.mp4 (155.1 MB)
• 45. Database Optimization Tips.mp4 (79.1 MB)
9 - Stored Programs & Triggers
• 46. 9.1-Stored-Procedure.sql (0.8 KB)
• 46. Stored Procedures.mp4 (91.8 MB)
• 47. 9.2-Functions.sql (0.7 KB)
• 47. Functions.mp4 (43.0 MB)
• 48. 9.3-Variables-Parameters.sql (0.9 KB)
• 48. Variables & Parameters.mp4 (43.2 MB)
• 49. 9.4-Cursors.sql (0.7 KB)
• 49. Cursors.mp4 (40.4 MB)
• 50. 9.5-Handling-Errors-using-Exception-Handlers.sql (0.4 KB)
• 50. Handling Errors using Exception Handlers.mp4 (77.2 MB)
• 51. 9.6-Triggers.sql (2.1 KB)
• 51. Triggers.mp4 (185.1 MB)
• Bonus Resources.txt (0.1 KB)