10 Day MySQL Bootcamp | My SQL Database Design for Beginners

سرفصل های دوره

Learn SQL Using MySQL with Over 150+ Examples, Hands-On Lectures, and Challenges. Beginner to Advanced My SQL in 10 Days

1. Introduction to Our SQL with MySQL Course

1. Welcome to the SQL Database Design with MySQL Course

2. How to Download the Lecture Resources

2. Day 1 Getting Started With SQL Using MySQL

1. Introduction to DAY 1

2. Basics Understanding Data and Databases

3. What is DBMS (Database Management System)

4. Introduction to Relational Databases Concepts

5. Overview of SQL

6. Installing MySQL on Windows

7. Installing MySQL on Mac

8.1 sql-mysql-0220-mysql-on-linux.zip

8. Installing MySQL on Linux

9. MySQL Interface

10.1 sql-mysql-0260-creating-database.zip

10. Creating Database to work on this Course

11.1 sql-mysql-0280-use-database.zip

11. USE Database in SQL

12.1 sql-mysql-0300-basic-sql-query.zip

12. Basic SQL Query with MySQL

13.1 sql-mysql-0320-doing-more-with-select.zip

13. Doing More with SELECT

14.1 sql-mysql-0340-challenge-getting-overview.zip

14. Challenge Getting Overview Of Products

15.1 sql-mysql-0360-challenge-specific-product.zip

15. Challenge Specific Product Information

16.1 sql-mysql-0380-comments.zip

16. Comments in SQL

17.1 sql-mysql-0400-day-1-review.zip

17. DAY 1 Review

3. Day 2 SELECT - A Closer Look

1. Introduction to DAY 2

2.1 sql-mysql-0440-introduction-to-select.zip

2. Introduction to SELECT Statement

3. Data Types in SQL

4.1 sql-mysql-0480-eliminating-duplicate.zip

4. Eliminating Duplicate Rows using SQL

5.1 sql-mysql-0500-challenge-product-diversity.zip

5. Challenge Product Diversity

6.1 sql-mysql-0520-column-aliases.zip

6. Column Aliases in SQL

7.1 sql-mysql-0540-challenge-report.zip

7. Challenge Customer Report

8.1 sql-mysql-0560-using-expressions.zip

8. Using Expressions with SELECT

9. What are NULL Values in SQL

10.1 sql-mysql-0600-handling-null-values.zip

10. Handling NULL Values in SQL

11.1 sql-mysql-0620-sorting-results-order.zip

11. Sorting Results with ORDER BY

12.1 sql-mysql-0640-challenge-pricing-review.zip

12. Challenge Pricing Review

13.1 sql-mysql-0660-limiting-results.zip

13. Limiting Results with LIMIT

14.1 sql-mysql-0680-challenge-premium-products.zip

14. Challenge Premium Products

15.1 sql-mysql-0700-day-2-review.zip

15. DAY 2 Review

4. Day 3 WHERE - A Closer Look

1. Introduction to DAY 3

2.1 sql-mysql-0740-introduction-where.zip

2. Introduction to WHERE Clause

3.1 sql-mysql-0760-operators-sql.zip

3. Operators in SQL

4.1 sql-mysql-0780-arithmetic-operators.zip

4. Arithmetic Operators in SQL

5.1 sql-mysql-0800-challenge-tax-calc.zip

5. Challenge Tax Calculations

6.1 sql-mysql-0820-comparison-operators.zip

6. Comparison Operators in SQL

7.1 sql-mysql-0840-and-operator.zip

7. AND Operator Working with Multiple Conditions

8.1 sql-mysql-0860-challenge-accessories.zip

8. Challenge Accessories under $30

9.1 sql-mysql-0880-or-operator.zip

9. OR Operator Working with Multiple Conditions in SQL

10.1 sql-mysql-0900-challenge-inventory.zip

10. Challenge Inventory Check

11.1 sql-mysql-0920-not-operator.zip

11. NOT Operator in SQL

12.1 sql-mysql-0940-alternative-multiple-ors.zip

12. Alternative to Multiple ORs

13.1 sql-mysql-0960-challenge-location.zip

13. Challenge Customer Location

14.1 sql-mysql-0980-challenge-product-popularity.zip

14. Challenge Product Popularity

15.1 sql-mysql-1000-between-in-sql.zip

15. Between in SQL

16.1 sql-mysql-1020-challenge-price-adjustment.zip

16. Challenge Price Adjustment

17.1 sql-mysql-1040-searching-for-a-pattern-like.zip

17. Searching for a Pattern in Data with LIKE Operator

18.1 sql-mysql-1060-challenge-searching-stars.zip

18. Challenge Searching for Stars

19.1 sql-mysql-1080-using-where-null.zip

19. Using WHERE with NULL Values

20.1 sql-mysql-1100-nested-where.zip

20. Nested WHERE Clauses using MySQL

21.1 sql-mysql-1120-3-review.zip

21. DAY 3 Review

5. Day 4 Grouping and Aggregation

1. Introduction to Day 4

2. Introduction to Grouping and Aggregation in SQL

3.1 sql-mysql-1180-understanding-aggregate.zip

3. Understanding Aggregate Functions in SQL

4.1 sql-mysql-1200-group-by.zip

4. The GROUP BY Clause in SQL

5.1 sql-mysql-1220-challenge-sales-vol.zip

5. Challenge Sales Volume

6.1 sql-mysql-1240-combining-aggregate.zip

6. Combining Aggregate Functions and GROUP BY

7.1 sql-mysql-1260-challenge-demographic.zip

7. Challenge Customer Demographic

8.1 sql-mysql-1280-challenge-retrieving.zip

8. Challenge Retrieving Best Sellers

9.1 sql-mysql-1300-grouping-multiple.zip

9. Grouping By Multiple Columns

10.1 sql-mysql-1320-having-clause.zip

10. The HAVING Clause in SQL

11.1 sql-mysql-1340-challenge-premium.zip

11. Challenge Premium Customers

12.1 sql-mysql-1360-challenge-frequent.zip

12. Challenge Frequent Shoppers

13.1 sql-mysql-1380-challenge-customer-habits.zip

13. Challenge Customer Spending Habits

14.1 sql-mysql-1400-nested-aggregation.zip

14. Nested Aggregation and Grouping

15.1 sql-mysql-1420-common-pitfalls.zip

15. Common Pitfalls and How to Avoid Them

16.1 sql-mysql-1440-practical-applications.zip

16. Practical Applications of Grouping and Aggregation

17.1 sql-mysql-1460-day-4-review.zip

17. DAY 4 Review

6. Day 5 JOINS in SQL

1. Introduction to Day 5

2. Introduction to Joins in SQL

3.1 sql-mysql-1520-inner-join.zip

3. INNER JOIN in SQL

4.1 sql-mysql-1530-inner-joins-multiple.zip

4. Inner Joins with Multiple Tables

5.1 sql-mysql-1540-challenge-product.zip

5. Challenge Product Names in Sales Volume

6.1 sql-mysql-1560-left-join.zip

6. LEFT JOIN in SQL

7.1 sql-mysql-1580-challenge-product.zip

7. Challenge Product Sales Analysis

8.1 sql-mysql-1600-right-join.zip

8. RIGHT JOIN in SQL

9.1 sql-mysql-1620-on-using.zip

9. Understanding ON vs USING in Joins

10.1 sql-mysql-1640-self-join.zip

10. Self Join in SQL

11.1 sql-mysql-1660-challenge-city-wise.zip

11. Challenge City-Wise Customer Analysis

12.1 sql-mysql-1680-cross-join.zip

12. CROSS JOIN in SQL

13.1 sql-mysql-1700-natural-join.zip

13. NATURAL JOIN in SQL

14.1 sql-mysql-1740-challenge-customer.zip

14. Challenge Customer Analysis

15.1 sql-mysql-1760-challenge-customer-purchase.zip

15. Challenge Customer Purchase Analysis

16.1 sql-mysql-1780-pitfalls-and-practices.zip

16. Common Pitfalls and Best Practices

17.1 sql-mysql-1800-day-5-review.zip

17. DAY 5 Review

7. Day 6 Database Design

1. Introduction to Day 6

2. Introduction to Database Design

3. QuantumTutors - Our New Startup

4. Introduction to Entity-Relationship Model

5. ER Diagrams in Database Design

6. One to One Relationship

7. One to Many Relationship

8. Many to Many Relationship

9. Normalization Techniques

10. First Normal Form (1NF)

11. Second Normal Form (2NF)

12. Third Normal Form (3NF)

13. Identifying Relationships for Database Design

14. DAY 6 Review

8. Day 7 DDL in SQL

1. Introduction to DAY 7

2. Introduction to DDL in SQL

3.1 sql-mysql-2140-creating-database.zip

3. Creating and using Database

4.1 sql-mysql-2160-challenge-database.zip

4. Challenge Database for QuantumTutors

5.1 sql-mysql-2180-create.zip

5. CREATE Statement in SQL

6.1 sql-mysql-2200-describing.zip

6. Describing Tables in SQL

7.1 sql-mysql-2220-primary.zip

7. Primary Keys in Database

8.1 sql-mysql-2240-foreign.zip

8. Foreign Keys in Database

9.1 sql-mysql-2260-challenge-tables.zip

9. Challenge Defining REST Of the Tables

10.1 sql-mysql-2280-sample-data.zip

10. Sample Data For MySQL

11.1 sql-mysql-2300-copy-tables.zip

11. Copy Tables in SQL

12.1 sql-mysql-2340-alter-statement.zip

12. ALTER Statement in SQL

13.1 sql-mysql-2360-alter-to-add-column.zip

13. ALTER to add column

14.1 sql-mysql-2380-challenge-duration.zip

14. Challenge Course Duration

15.1 sql-mysql-2400-alter-to-drop-column.zip

15. ALTER to Drop column

16.1 sql-mysql-2420-challenge-business-model.zip

16. Challenge Changes in Business Model

17.1 sql-mysql-2440-alter-modify-column.zip

17. ALTER to modify column

18.1 sql-mysql-2460-challenge-managing-integrity.zip

18. Challenge Managing Integrity

19.1 sql-mysql-2480-challenge-course-categorization.zip

19. Challenge Course Categorization

20.1 sql-mysql-2500-drop-statement.zip

20. DROP Statement in SQL

21.1 sql-mysql-2510-drop-foreign.zip

21. DROP and Foreign Keys in Database

22.1 sql-mysql-2540-truncate-statement.zip

22. TRUNCATE Statement in SQL

23.1 sql-mysql-2560-challenge-data-pruning.zip

23. Challenge Data Pruning

24.1 sql-mysql-2580-drop-with-references.zip

24. DROP with references

25.1 sql-mysql-2600-rename-statement.zip

25. RENAME Statement in SQL

26.1 sql-mysql-2640-day-7-review.zip

26. Day 7 Review

9. Day 8 DML in SQL

1. Introduction to DAY 8

2. Introduction to DML Statements in SQL

3.1 sql-mysql-2700-working-insert.zip

3. Working with Insert Statements

4.1 sql-mysql-2720-challenge-new-admin.zip

4. Challenge New Admin Onboarding

5.1 sql-mysql-2740-inserting-multiple-records.zip

5. Inserting multiple records at once

6.1 sql-mysql-2760-challenge-new-instructors-1.zip

6.2 sql-mysql-2760-challenge-new-instructors-2.zip

6. Challenge New Instructors Onboarding

7.1 sql-mysql-2780-inserting-data.zip

7. Inserting data from another table

8.1 sql-mysql-2820-update-statement.zip

8. Update statement in SQL

9.1 sql-mysql-2840-challenge-course-title.zip

9. Challenge Course Title Improvements

10.1 sql-mysql-2860-updating-multiple-columns.zip

10. Updating multiple columns

11.1 sql-mysql-2880-challenge-profile-update.zip

11. Challenge Profile Update

12.1 sql-mysql-2900-updating-multiple-rows.zip

12. Updating multiple rows in SQL

13.1 sql-mysql-2920-challenge-discounted.zip

13. Challenge Discounted Courses

14.1 sql-mysql-2960-deleting-specific-records.zip

14. Deleting specific records from the table

15.1 sql-mysql-2980-challenge-course.zip

15. Challenge Course Retirement

16.1 sql-mysql-3000-deleting-all-records.zip

16. Deleting all records from the table

17.1 sql-mysql-3020-challenge-complete-reset.zip

17. Challenge Complete Reset

18.1 sql-mysql-3040-difference.zip

18. Difference between DROP, DELETE, and TRUNCATE

19.1 sql-mysql-3060-day-8-review.zip

19. DAY 8 Review

10. Day 9 SubQueries and Functions

1. Introduction to DAY 9

2.1 sql-mysql-3100-subqueries-introduction.zip

2. Subqueries Introduction

3.1 sql-mysql-3120-challenge-popularity.zip

3. Challenge Course Popularity

4.1 sql-mysql-3140-correlated-non.zip

4. Correlated and Non-Correlated Subqueries using SQL

5.1 sql-mysql-3160-challenge-course-highest.zip

5. Challenge Course with Highest Price

6.1 sql-mysql-3180-exists-not-exists.zip

6. Exists and Not Exists with Subqueries

7.1 sql-mysql-3200-challenge-not-teaching.zip

7. Challenge Instructors Not Teaching

8.1 sql-mysql-3220-any-all.zip

8. Using ANY and ALL with Subqueries in SQL

9.1 sql-mysql-3240-challenge-top-instructors.zip

9. Challenge Top Performing Instructors

10.1 sql-mysql-3260-single-row.zip

10. Single Row Subqueries in SQL

11.1 sql-mysql-3280-multi-row.zip

11. Multi Row Subqueries in SQL

12.1 sql-mysql-3300-inserting-deleting-subquery.zip

12. Inserting and Deleting using Subquery

13.1 sql-mysql-3320-challenge-remove-reviews.zip

13. Challenge Remove Reviews for Courses Not Offered

14.1 sql-mysql-3340-day-9-review.zip

14. DAY 9 Review

11. Day 10 MySQL with Python

1.1 sql-mysql-3360-setting-python-mysql-1.zip

1.2 sql-mysql-3360-setting-python-mysql-2.zip

1. Setting Up Python MySQL Environment

2.1 sql-mysql-3380-querying-data.zip

2. Querying Data

3.1 sql-mysql-3400-grouping-data.zip

3. Grouping Data

4.1 sql-mysql-3420-inserting-data-into-tables-1.zip

4.2 sql-mysql-3420-inserting-data-into-tables-2.zip

4.3 sql-mysql-3420-inserting-data-into-tables-3.zip

4.4 sql-mysql-3420-inserting-data-into-tables-4.zip

4. Inserting Data into Tables

5.1 sql-mysql-3440-creating-a-database.zip

5. Creating a Database

6.1 sql-mysql-3460-creating-tables-1.zip

6.2 sql-mysql-3460-creating-tables-2.zip

6. Creating Tables

7.1 sql-mysql-3480-updating-data-1.zip

7.2 sql-mysql-3480-updating-data-2.zip

7. Updating Data

8.1 sql-mysql-3500-deleting-data-1.zip

8.2 sql-mysql-3500-deleting-data-2.zip

8. Deleting Data

12. Day 10 MySQL with Java

1.1 sql-mysql-3520-setting-up-java.zip

1. Setting Up Java MySQL Environment

2.1 sql-mysql-3540-querying-data.zip

2. Querying Data

3.1 sql-mysql-3560-grouping-and-joining.zip

3. Grouping and Joining

4.1 sql-mysql-3580-java-mysql-prepared-statements.zip

4. Java MySQL Prepared Statements

5.1 sql-mysql-3600-inserting-data-into-tables.zip

5. Inserting Data into Tables

6.1 sql-mysql-3620-creating-a-database.zip

6. Creating a Database

7.1 sql-mysql-3640-creating-tables.zip

7. Creating Tables

8.1 sql-mysql-3660-updating-data.zip

8. Updating Data

9.1 sql-mysql-3680-deleting-data.zip

9. Deleting Data

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy