Companies Home Search Profile

10 Day MySQL Bootcamp | My SQL Database Design for Beginners

Focused View

Phil Ebiner,Video School,Faisal Memon,EmbarkX Official

15:33:53

20 View
  • 1. Welcome to the SQL Database Design with MySQL Course.mp4
    04:03
  • 2. How to Download the Lecture Resources.mp4
    03:22
  • 1. Introduction to DAY 1.mp4
    03:20
  • 2. Basics Understanding Data and Databases.mp4
    05:21
  • 3. What is DBMS (Database Management System).mp4
    04:28
  • 4. Introduction to Relational Databases Concepts.mp4
    06:00
  • 5. Overview of SQL.mp4
    03:38
  • 6. Installing MySQL on Windows.mp4
    14:52
  • 7. Installing MySQL on Mac.mp4
    12:12
  • 8.1 sql-mysql-0220-mysql-on-linux.zip
  • 8. Installing MySQL on Linux.mp4
    15:56
  • 9. MySQL Interface.mp4
    08:08
  • 10.1 sql-mysql-0260-creating-database.zip
  • 10. Creating Database to work on this Course.mp4
    04:04
  • 11.1 sql-mysql-0280-use-database.zip
  • 11. USE Database in SQL.mp4
    03:15
  • 12.1 sql-mysql-0300-basic-sql-query.zip
  • 12. Basic SQL Query with MySQL.mp4
    05:03
  • 13.1 sql-mysql-0320-doing-more-with-select.zip
  • 13. Doing More with SELECT.mp4
    06:41
  • 14.1 sql-mysql-0340-challenge-getting-overview.zip
  • 14. Challenge Getting Overview Of Products.mp4
    02:57
  • 15.1 sql-mysql-0360-challenge-specific-product.zip
  • 15. Challenge Specific Product Information.mp4
    02:36
  • 16.1 sql-mysql-0380-comments.zip
  • 16. Comments in SQL.mp4
    08:35
  • 17.1 sql-mysql-0400-day-1-review.zip
  • 17. DAY 1 Review.mp4
    04:43
  • 1. Introduction to DAY 2.mp4
    03:30
  • 2.1 sql-mysql-0440-introduction-to-select.zip
  • 2. Introduction to SELECT Statement.mp4
    03:05
  • 3. Data Types in SQL.mp4
    10:55
  • 4.1 sql-mysql-0480-eliminating-duplicate.zip
  • 4. Eliminating Duplicate Rows using SQL.mp4
    04:53
  • 5.1 sql-mysql-0500-challenge-product-diversity.zip
  • 5. Challenge Product Diversity.mp4
    02:52
  • 6.1 sql-mysql-0520-column-aliases.zip
  • 6. Column Aliases in SQL.mp4
    06:34
  • 7.1 sql-mysql-0540-challenge-report.zip
  • 7. Challenge Customer Report.mp4
    03:34
  • 8.1 sql-mysql-0560-using-expressions.zip
  • 8. Using Expressions with SELECT.mp4
    08:42
  • 9. What are NULL Values in SQL.mp4
    05:52
  • 10.1 sql-mysql-0600-handling-null-values.zip
  • 10. Handling NULL Values in SQL.mp4
    08:23
  • 11.1 sql-mysql-0620-sorting-results-order.zip
  • 11. Sorting Results with ORDER BY.mp4
    10:06
  • 12.1 sql-mysql-0640-challenge-pricing-review.zip
  • 12. Challenge Pricing Review.mp4
    01:56
  • 13.1 sql-mysql-0660-limiting-results.zip
  • 13. Limiting Results with LIMIT.mp4
    07:56
  • 14.1 sql-mysql-0680-challenge-premium-products.zip
  • 14. Challenge Premium Products.mp4
    02:14
  • 15.1 sql-mysql-0700-day-2-review.zip
  • 15. DAY 2 Review.mp4
    05:12
  • 1. Introduction to DAY 3.mp4
    03:17
  • 2.1 sql-mysql-0740-introduction-where.zip
  • 2. Introduction to WHERE Clause.mp4
    02:19
  • 3.1 sql-mysql-0760-operators-sql.zip
  • 3. Operators in SQL.mp4
    03:03
  • 4.1 sql-mysql-0780-arithmetic-operators.zip
  • 4. Arithmetic Operators in SQL.mp4
    11:13
  • 5.1 sql-mysql-0800-challenge-tax-calc.zip
  • 5. Challenge Tax Calculations.mp4
    02:42
  • 6.1 sql-mysql-0820-comparison-operators.zip
  • 6. Comparison Operators in SQL.mp4
    10:33
  • 7.1 sql-mysql-0840-and-operator.zip
  • 7. AND Operator Working with Multiple Conditions.mp4
    09:33
  • 8.1 sql-mysql-0860-challenge-accessories.zip
  • 8. Challenge Accessories under $30.mp4
    :
  • 9.1 sql-mysql-0880-or-operator.zip
  • 9. OR Operator Working with Multiple Conditions in SQL.mp4
    09:01
  • 10.1 sql-mysql-0900-challenge-inventory.zip
  • 10. Challenge Inventory Check.mp4
    06:57
  • 11.1 sql-mysql-0920-not-operator.zip
  • 11. NOT Operator in SQL.mp4
    02:00
  • 12.1 sql-mysql-0940-alternative-multiple-ors.zip
  • 12. Alternative to Multiple ORs.mp4
    05:38
  • 13.1 sql-mysql-0960-challenge-location.zip
  • 13. Challenge Customer Location.mp4
    04:29
  • 14.1 sql-mysql-0980-challenge-product-popularity.zip
  • 14. Challenge Product Popularity.mp4
    03:34
  • 15.1 sql-mysql-1000-between-in-sql.zip
  • 15. Between in SQL.mp4
    08:41
  • 16.1 sql-mysql-1020-challenge-price-adjustment.zip
  • 16. Challenge Price Adjustment.mp4
    03:42
  • 17.1 sql-mysql-1040-searching-for-a-pattern-like.zip
  • 17. Searching for a Pattern in Data with LIKE Operator.mp4
    16:01
  • 18.1 sql-mysql-1060-challenge-searching-stars.zip
  • 18. Challenge Searching for Stars.mp4
    02:08
  • 19.1 sql-mysql-1080-using-where-null.zip
  • 19. Using WHERE with NULL Values.mp4
    08:21
  • 20.1 sql-mysql-1100-nested-where.zip
  • 20. Nested WHERE Clauses using MySQL.mp4
    06:11
  • 21.1 sql-mysql-1120-3-review.zip
  • 21. DAY 3 Review.mp4
    05:37
  • 1. Introduction to Day 4.mp4
    03:02
  • 2. Introduction to Grouping and Aggregation in SQL.mp4
    04:39
  • 3.1 sql-mysql-1180-understanding-aggregate.zip
  • 3. Understanding Aggregate Functions in SQL.mp4
    11:07
  • 4.1 sql-mysql-1200-group-by.zip
  • 4. The GROUP BY Clause in SQL.mp4
    08:13
  • 5.1 sql-mysql-1220-challenge-sales-vol.zip
  • 5. Challenge Sales Volume.mp4
    03:36
  • 6.1 sql-mysql-1240-combining-aggregate.zip
  • 6. Combining Aggregate Functions and GROUP BY.mp4
    05:49
  • 7.1 sql-mysql-1260-challenge-demographic.zip
  • 7. Challenge Customer Demographic.mp4
    03:05
  • 8.1 sql-mysql-1280-challenge-retrieving.zip
  • 8. Challenge Retrieving Best Sellers.mp4
    04:44
  • 9.1 sql-mysql-1300-grouping-multiple.zip
  • 9. Grouping By Multiple Columns.mp4
    05:03
  • 10.1 sql-mysql-1320-having-clause.zip
  • 10. The HAVING Clause in SQL.mp4
    07:13
  • 11.1 sql-mysql-1340-challenge-premium.zip
  • 11. Challenge Premium Customers.mp4
    03:33
  • 12.1 sql-mysql-1360-challenge-frequent.zip
  • 12. Challenge Frequent Shoppers.mp4
    03:07
  • 13.1 sql-mysql-1380-challenge-customer-habits.zip
  • 13. Challenge Customer Spending Habits.mp4
    02:03
  • 14.1 sql-mysql-1400-nested-aggregation.zip
  • 14. Nested Aggregation and Grouping.mp4
    05:37
  • 15.1 sql-mysql-1420-common-pitfalls.zip
  • 15. Common Pitfalls and How to Avoid Them.mp4
    02:54
  • 16.1 sql-mysql-1440-practical-applications.zip
  • 16. Practical Applications of Grouping and Aggregation.mp4
    05:38
  • 17.1 sql-mysql-1460-day-4-review.zip
  • 17. DAY 4 Review.mp4
    05:07
  • 1. Introduction to Day 5.mp4
    04:34
  • 2. Introduction to Joins in SQL.mp4
    02:56
  • 3.1 sql-mysql-1520-inner-join.zip
  • 3. INNER JOIN in SQL.mp4
    12:42
  • 4.1 sql-mysql-1530-inner-joins-multiple.zip
  • 4. Inner Joins with Multiple Tables.mp4
    10:15
  • 5.1 sql-mysql-1540-challenge-product.zip
  • 5. Challenge Product Names in Sales Volume.mp4
    04:47
  • 6.1 sql-mysql-1560-left-join.zip
  • 6. LEFT JOIN in SQL.mp4
    05:49
  • 7.1 sql-mysql-1580-challenge-product.zip
  • 7. Challenge Product Sales Analysis.mp4
    07:45
  • 8.1 sql-mysql-1600-right-join.zip
  • 8. RIGHT JOIN in SQL.mp4
    04:10
  • 9.1 sql-mysql-1620-on-using.zip
  • 9. Understanding ON vs USING in Joins.mp4
    04:30
  • 10.1 sql-mysql-1640-self-join.zip
  • 10. Self Join in SQL.mp4
    06:49
  • 11.1 sql-mysql-1660-challenge-city-wise.zip
  • 11. Challenge City-Wise Customer Analysis.mp4
    04:11
  • 12.1 sql-mysql-1680-cross-join.zip
  • 12. CROSS JOIN in SQL.mp4
    02:31
  • 13.1 sql-mysql-1700-natural-join.zip
  • 13. NATURAL JOIN in SQL.mp4
    04:12
  • 14.1 sql-mysql-1740-challenge-customer.zip
  • 14. Challenge Customer Analysis.mp4
    05:14
  • 15.1 sql-mysql-1760-challenge-customer-purchase.zip
  • 15. Challenge Customer Purchase Analysis.mp4
    06:17
  • 16.1 sql-mysql-1780-pitfalls-and-practices.zip
  • 16. Common Pitfalls and Best Practices.mp4
    11:14
  • 17.1 sql-mysql-1800-day-5-review.zip
  • 17. DAY 5 Review.mp4
    07:34
  • 1. Introduction to Day 6.mp4
    02:38
  • 2. Introduction to Database Design.mp4
    05:29
  • 3. QuantumTutors - Our New Startup.mp4
    05:04
  • 4. Introduction to Entity-Relationship Model.mp4
    02:26
  • 5. ER Diagrams in Database Design.mp4
    08:55
  • 6. One to One Relationship.mp4
    06:35
  • 7. One to Many Relationship.mp4
    06:38
  • 8. Many to Many Relationship.mp4
    06:55
  • 9. Normalization Techniques.mp4
    03:17
  • 10. First Normal Form (1NF).mp4
    02:10
  • 11. Second Normal Form (2NF).mp4
    01:52
  • 12. Third Normal Form (3NF).mp4
    02:07
  • 13. Identifying Relationships for Database Design.mp4
    05:36
  • 14. DAY 6 Review.mp4
    01:12
  • 1. Introduction to DAY 7.mp4
    05:52
  • 2. Introduction to DDL in SQL.mp4
    02:59
  • 3.1 sql-mysql-2140-creating-database.zip
  • 3. Creating and using Database.mp4
    09:42
  • 4.1 sql-mysql-2160-challenge-database.zip
  • 4. Challenge Database for QuantumTutors.mp4
    02:40
  • 5.1 sql-mysql-2180-create.zip
  • 5. CREATE Statement in SQL.mp4
    15:09
  • 6.1 sql-mysql-2200-describing.zip
  • 6. Describing Tables in SQL.mp4
    03:56
  • 7.1 sql-mysql-2220-primary.zip
  • 7. Primary Keys in Database.mp4
    07:30
  • 8.1 sql-mysql-2240-foreign.zip
  • 8. Foreign Keys in Database.mp4
    11:41
  • 9.1 sql-mysql-2260-challenge-tables.zip
  • 9. Challenge Defining REST Of the Tables.mp4
    06:24
  • 10.1 sql-mysql-2280-sample-data.zip
  • 10. Sample Data For MySQL.mp4
    02:23
  • 11.1 sql-mysql-2300-copy-tables.zip
  • 11. Copy Tables in SQL.mp4
    08:32
  • 12.1 sql-mysql-2340-alter-statement.zip
  • 12. ALTER Statement in SQL.mp4
    01:37
  • 13.1 sql-mysql-2360-alter-to-add-column.zip
  • 13. ALTER to add column.mp4
    08:00
  • 14.1 sql-mysql-2380-challenge-duration.zip
  • 14. Challenge Course Duration.mp4
    02:46
  • 15.1 sql-mysql-2400-alter-to-drop-column.zip
  • 15. ALTER to Drop column.mp4
    04:31
  • 16.1 sql-mysql-2420-challenge-business-model.zip
  • 16. Challenge Changes in Business Model.mp4
    02:11
  • 17.1 sql-mysql-2440-alter-modify-column.zip
  • 17. ALTER to modify column.mp4
    09:19
  • 18.1 sql-mysql-2460-challenge-managing-integrity.zip
  • 18. Challenge Managing Integrity.mp4
    03:12
  • 19.1 sql-mysql-2480-challenge-course-categorization.zip
  • 19. Challenge Course Categorization.mp4
    03:31
  • 20.1 sql-mysql-2500-drop-statement.zip
  • 20. DROP Statement in SQL.mp4
    08:58
  • 21.1 sql-mysql-2510-drop-foreign.zip
  • 21. DROP and Foreign Keys in Database.mp4
    03:10
  • 22.1 sql-mysql-2540-truncate-statement.zip
  • 22. TRUNCATE Statement in SQL.mp4
    05:05
  • 23.1 sql-mysql-2560-challenge-data-pruning.zip
  • 23. Challenge Data Pruning.mp4
    01:53
  • 24.1 sql-mysql-2580-drop-with-references.zip
  • 24. DROP with references.mp4
    11:43
  • 25.1 sql-mysql-2600-rename-statement.zip
  • 25. RENAME Statement in SQL.mp4
    04:06
  • 26.1 sql-mysql-2640-day-7-review.zip
  • 26. Day 7 Review.mp4
    05:27
  • 1. Introduction to DAY 8.mp4
    03:40
  • 2. Introduction to DML Statements in SQL.mp4
    00:37
  • 3.1 sql-mysql-2700-working-insert.zip
  • 3. Working with Insert Statements.mp4
    07:34
  • 4.1 sql-mysql-2720-challenge-new-admin.zip
  • 4. Challenge New Admin Onboarding.mp4
    02:05
  • 5.1 sql-mysql-2740-inserting-multiple-records.zip
  • 5. Inserting multiple records at once.mp4
    02:55
  • 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.mp4
    02:42
  • 7.1 sql-mysql-2780-inserting-data.zip
  • 7. Inserting data from another table.mp4
    05:59
  • 8.1 sql-mysql-2820-update-statement.zip
  • 8. Update statement in SQL.mp4
    03:34
  • 9.1 sql-mysql-2840-challenge-course-title.zip
  • 9. Challenge Course Title Improvements.mp4
    05:24
  • 10.1 sql-mysql-2860-updating-multiple-columns.zip
  • 10. Updating multiple columns.mp4
    04:29
  • 11.1 sql-mysql-2880-challenge-profile-update.zip
  • 11. Challenge Profile Update.mp4
    02:13
  • 12.1 sql-mysql-2900-updating-multiple-rows.zip
  • 12. Updating multiple rows in SQL.mp4
    03:38
  • 13.1 sql-mysql-2920-challenge-discounted.zip
  • 13. Challenge Discounted Courses.mp4
    01:37
  • 14.1 sql-mysql-2960-deleting-specific-records.zip
  • 14. Deleting specific records from the table.mp4
    04:46
  • 15.1 sql-mysql-2980-challenge-course.zip
  • 15. Challenge Course Retirement.mp4
    07:02
  • 16.1 sql-mysql-3000-deleting-all-records.zip
  • 16. Deleting all records from the table.mp4
    01:29
  • 17.1 sql-mysql-3020-challenge-complete-reset.zip
  • 17. Challenge Complete Reset.mp4
    02:33
  • 18.1 sql-mysql-3040-difference.zip
  • 18. Difference between DROP, DELETE, and TRUNCATE.mp4
    02:29
  • 19.1 sql-mysql-3060-day-8-review.zip
  • 19. DAY 8 Review.mp4
    05:35
  • 1. Introduction to DAY 9.mp4
    02:34
  • 2.1 sql-mysql-3100-subqueries-introduction.zip
  • 2. Subqueries Introduction.mp4
    07:17
  • 3.1 sql-mysql-3120-challenge-popularity.zip
  • 3. Challenge Course Popularity.mp4
    08:05
  • 4.1 sql-mysql-3140-correlated-non.zip
  • 4. Correlated and Non-Correlated Subqueries using SQL.mp4
    08:56
  • 5.1 sql-mysql-3160-challenge-course-highest.zip
  • 5. Challenge Course with Highest Price.mp4
    03:58
  • 6.1 sql-mysql-3180-exists-not-exists.zip
  • 6. Exists and Not Exists with Subqueries.mp4
    03:57
  • 7.1 sql-mysql-3200-challenge-not-teaching.zip
  • 7. Challenge Instructors Not Teaching.mp4
    03:23
  • 8.1 sql-mysql-3220-any-all.zip
  • 8. Using ANY and ALL with Subqueries in SQL.mp4
    03:28
  • 9.1 sql-mysql-3240-challenge-top-instructors.zip
  • 9. Challenge Top Performing Instructors.mp4
    03:30
  • 10.1 sql-mysql-3260-single-row.zip
  • 10. Single Row Subqueries in SQL.mp4
    01:20
  • 11.1 sql-mysql-3280-multi-row.zip
  • 11. Multi Row Subqueries in SQL.mp4
    01:31
  • 12.1 sql-mysql-3300-inserting-deleting-subquery.zip
  • 12. Inserting and Deleting using Subquery.mp4
    02:36
  • 13.1 sql-mysql-3320-challenge-remove-reviews.zip
  • 13. Challenge Remove Reviews for Courses Not Offered.mp4
    02:08
  • 14.1 sql-mysql-3340-day-9-review.zip
  • 14. DAY 9 Review.mp4
    05:27
  • 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.mp4
    11:50
  • 2.1 sql-mysql-3380-querying-data.zip
  • 2. Querying Data.mp4
    05:55
  • 3.1 sql-mysql-3400-grouping-data.zip
  • 3. Grouping Data.mp4
    08:15
  • 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.mp4
    06:38
  • 5.1 sql-mysql-3440-creating-a-database.zip
  • 5. Creating a Database.mp4
    02:23
  • 6.1 sql-mysql-3460-creating-tables-1.zip
  • 6.2 sql-mysql-3460-creating-tables-2.zip
  • 6. Creating Tables.mp4
    02:03
  • 7.1 sql-mysql-3480-updating-data-1.zip
  • 7.2 sql-mysql-3480-updating-data-2.zip
  • 7. Updating Data.mp4
    03:21
  • 8.1 sql-mysql-3500-deleting-data-1.zip
  • 8.2 sql-mysql-3500-deleting-data-2.zip
  • 8. Deleting Data.mp4
    01:35
  • 1.1 sql-mysql-3520-setting-up-java.zip
  • 1. Setting Up Java MySQL Environment.mp4
    08:38
  • 2.1 sql-mysql-3540-querying-data.zip
  • 2. Querying Data.mp4
    04:03
  • 3.1 sql-mysql-3560-grouping-and-joining.zip
  • 3. Grouping and Joining.mp4
    02:09
  • 4.1 sql-mysql-3580-java-mysql-prepared-statements.zip
  • 4. Java MySQL Prepared Statements.mp4
    03:53
  • 5.1 sql-mysql-3600-inserting-data-into-tables.zip
  • 5. Inserting Data into Tables.mp4
    04:19
  • 6.1 sql-mysql-3620-creating-a-database.zip
  • 6. Creating a Database.mp4
    01:29
  • 7.1 sql-mysql-3640-creating-tables.zip
  • 7. Creating Tables.mp4
    01:20
  • 8.1 sql-mysql-3660-updating-data.zip
  • 8. Updating Data.mp4
    01:54
  • 9.1 sql-mysql-3680-deleting-data.zip
  • 9. Deleting Data.mp4
    02:28
  • Description


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

    What You'll Learn?


    • By the end of this course, you will be able to write SQL queries to perform data analysis and even manage the data on their own confidently.
    • Concepts applicable to Databases such as PostgreSQL, Oracle, and Microsoft SQL Server
    • Learn how you can design your own database and structure it by learning about different relationships and normalization techniques.
    • Gain comprehensive knowledge of SQL syntax to query, modify, and manage data in databases effectively, using MySQL. Concepts and SQL knowledge applicable to pla
    • Develop strong foundational skills in database creation, manipulation, and management using MySQL, a popular open-source relational database management system.
    • Learn to do data analytics to extract actionable insights from complex datasets using advanced SQL queries, these can help you make informed business decisions.
    • Develop a rounded understanding of database concepts, including database design, normalization, which are essential in maintaining data integrity and consistenc
    • Engage in 50+ hands-on challenges to apply your acquired knowledge in real-world scenarios using My SQL
    • Learn how you can use MySQL with popular development environments like Java and Python.

    Who is this for?


  • Programmers / Engineering Architects who are looking to learn SQL to build database-driven applications
  • Aspiring data analysts and business analysts
  • Professionals aiming to upscale their SQL skills
  • Students and enthusiasts who wish to learn SQL to excel in their career
  • What You Need to Know?


  • No prior experience in SQL or database necessary, everything will be taught in the course
  • More details


    Description

    You can learn MySQL Database Design and become a Data Analytics wizard in just 10 days!

    Step into the realm of database management and SQL proficiency with our immersive 10-day course using My SQL. This course is structured to facilitate learners with no prior experience, gradually leading up to advanced concepts, making you adept in handling and manipulating data using MySQL.

    Real World, Practical MySQL Course

    This is a completely hands on course where we work with real data and learn SQL using real world scenarios.


    10-Day My SQL Course Breakdown:


    Day 1: Getting Started with SQL & My SQL

    • Introduction to Databases

    • Setting up MySQL / My SQL

    • Understanding basic database terminology

    • Getting acquainted with MySQL interface

    • Writing basic SQL Statements and querying the database

    Day 2: Select - A Closer Look

    • Delving into SELECT statement

    • Selecting and extracting data from tables

    • Various options and settings associated with SELECT


    Day 3: Where - A Closer Look

    • Understanding WHERE clause

    • Filtering data based on various conditions

    • Complex WHERE clauses


    Day 4: Grouping and Aggregation

    • Introduction to data grouping

    • Using aggregate functions (SUM, AVG, MAX, MIN, COUNT)

    • Understanding GROUP BY and HAVING clauses


    Day 5: JOINS

    • Overview of JOINS

    • Types of JOINS (INNER, LEFT, RIGHT, SELF, CROSS, NATURAL)

    • Practical examples and use cases


    Day 6: Database Design

    • Principles of database design

    • Understanding relationships (One-to-One, One-to-Many, Many-to-Many)

    • Normalization and its types


    Day 7: DDL (Data Definition Language)

    • Understanding DDL commands (CREATE, ALTER, DROP)

    • Creating and managing tables and databases


    Day 8: DML (Data Manipulation Language)

    • Overview of DML commands (INSERT, UPDATE, DELETE)

    • Manipulating data in tables


    Day 9: SubQueries and Functions

    • Developing subqueries

    • Working with ANY, ALL, EXISTS, NOT EXISTS


    Day 10: MySQL with Python

    • Setting up Python MySQL environment

    • Executing MySQL commands from Python


    Day 10: MySQL with Java

    • Configuring MySQL with Java

    • Executing MySQL commands from Java


    What will You Learn in this SQL Database Design Course?

    • By the end of this course, you will be able to write SQL queries to perform data analysis and even manage the data on their own confidently.

    • Learn how you can design your own database and structure it by learning about different relationships and normalization techniques.

    • Gain comprehensive knowledge of SQL syntax to query, modify, and manage data in databases effectively, using MySQL. Concepts and SQL knowledge applicable to platforms like PostgreSQL, and SQL Server.

    • Develop strong foundational skills in database creation, manipulation, and management using MySQL, a popular open-source relational database management system.

    • Learn to do data analytics to extract actionable insights from complex datasets using advanced SQL queries, these can help you make informed business decisions.

    • Develop a rounded understanding of database concepts, including database design, normalization, which are essential in maintaining data integrity and consistency.

    • Engage in 50+ hands-on challenges to apply your acquired knowledge in real-world scenarios using My SQL

    • Learn how you can use MySQL with popular development environments like Java and Python.


    Database Design with MySQL Course Features:

    • Over 150+ examples/challenges

    • Hands-on exercises and real-world project examples

    • Taught by an experienced instructor

    • Comes with a Certificate of completion


    Prerequisites for this SQL with MySQL Course:

    • No prior experience in SQL or database is necessary


    Target Audience for this SQL with MySQL Course:

    • Programmers / Engineering Architects who are looking to learn SQL to build database-driven applications

    • Aspiring data analysts and business analysts

    • Professionals aiming to upscale their SQL skills

    • Students and enthusiasts who wish to learn SQL to excel in their career


    Let’s begin on this 10-day journey to transition from a novice to a proficient database master, capable of integrating MySQL functionalities with Python and Java. Let’s get data-driven.

    Are you ready?

    Enroll now, and we’ll see you in lesson 1.

    Who this course is for:

    • Programmers / Engineering Architects who are looking to learn SQL to build database-driven applications
    • Aspiring data analysts and business analysts
    • Professionals aiming to upscale their SQL skills
    • Students and enthusiasts who wish to learn SQL to excel in their career

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    great courses for beginnersI'll teach you the skills necessary to stand out from the crowd. Whether it’s a personal passion or a business pursuit, you can learn video, photography, art, design, marketing skills and more here.learn by doingStep-by-step tutorials and project-based learning.get supportOne-on-one support from experts that truly want to help you.don’t stress. have fun.more about philMy professional background is in video production and editing. I graduated from Loyola Marymount University's School of Film and Television in 2011. Since then, I've worked on thousands of projects that have appeared in movie theaters, film festivals, television and online.Today, I create all kinds of things from photographs that can be seen on my Instagram to homemade sourdough bread that feeds my family. Who knows where life will take me. But I know wherever I am, I'll be creating.Since 2012, I've been creating online courses that over two million students from around the world have taken. Course topics include everything from photography and video to design and business courses. If I can't teach it , I collaborate with other experts who share their skills with absolute beginners.I can't wait to see you in class!- Phil
    Video School
    Video School
    Instructor's Courses
    Learn creative skills, from absolute beginner to advanced mastery. Video School exists to help you succeed in life. Each course has been hand-tailored to teach a specific skill from photography and video to art, design and business.Whether you’re trying to learn a new skill from scratch, or want to refresh your memory on something you’ve learned in the past, you’ve come to the right place.Education makes the world a better place. Make your world better with new skills!Our courses can be watched 24/7 wherever you are. Most are fully downloadable so you can take them with you. You can also view them on mobile devices with the Udemy mobile app.All courses have a 30-day money-back guarantee so that you can check it out, make sure it’s the right course for you, and get a refund if it’s not!
    Faisal Memon
    Faisal Memon
    Instructor's Courses
    Hey - this is Faisal and thanks for checking out my course.I have over 12+ years of experience building global products being used by millions of users across the globe. I love technology and teaching it.Currently, I am heading Product at one of the fast-paced startups in India and enjoying every moment of it. Prior to his, I built out a couple of startups that had over half a million users across the globe, raised funding from Google + other investors, and was part of Google Launchpad Accelerator. I have experience in building products from scratch and scaling to global users.I am here on Udemy to share my knowledge with seekers and help them grow personally and professionally.Glad to meet you :)
    EmbarkX Official
    EmbarkX Official
    Instructor's Courses
    We don't teach, We educate.Over 40,000+ Students across the globe love our courses. Our courses have been also used by various corporates for upskilling their employees.We are experts in Java, Object oriented programming, Python, Spring Boot, Blockchain, Bitcoin, etc.We are on a mission to educate 1 Million people across the globe in an affordable way.
    Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
    • language english
    • Training sessions 179
    • duration 15:33:53
    • Release Date 2023/11/13

    Courses related to MySQL

    Courses related to Database Programming