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

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
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 23779
    حجم: 6502 مگابایت
    مدت زمان: 934 دقیقه
    تاریخ انتشار: ۱۲ آذر ۱۴۰۲
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید