Course Overview
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.
FAQ
FAQ area empty
Course curriculum
-
Introduction to DAY 1
200 Xem trước -
Basics: Understanding Data and Databases
321 Xem trước -
What is DBMS (Database Management System)?
268 Xem trước -
Introduction to Relational Databases Concepts
360 -
Overview of SQL
218 Xem trước -
Installing MySQL on Windows
892 Xem trước -
Installing MySQL on Mac
732 -
Installing MySQL on Linux
956 -
MySQL Interface
488 -
Creating Database to work on this Course
244 -
USE Database in SQL
195 -
Basic SQL Query with MySQL
303 -
Mastering Data Selection
0 -
Doing More with SELECT
401 -
Refining Data Retrieval
0 -
Challenge: Getting Overview Of Products
177 -
Challenge: Specific Product Information
156 -
Comments in SQL
515 -
DAY 1: Review
283 -
Section 2 Recap Quiz
-
Introduction to DAY 2
210 -
Introduction to SELECT Statement
185 -
Data Types in SQL
655 -
Eliminating Duplicate Rows using SQL
293 -
Challenge: Product Diversity
172 -
Exploring Data Uniqueness
0 -
Column Aliases in SQL
394 -
Enhancing Data Clarity
0 -
Challenge: Customer Report
214 -
Using Expressions with SELECT
461 -
Product Revenue Calculation
0 -
What are NULL Values in SQL
352 -
Handling NULL Values in SQL
503 -
Null Value Handling
0 -
Sorting Results with ORDER BY
606 -
Effective Data Sorting
0 -
Challenge: Pricing Review
116 -
Limiting Results with LIMIT
476 -
Top Scoring Players
0 -
Challenge: Premium Products
134 -
DAY 2: Review
312 -
Section 3 Recap Quiz
-
Introduction to DAY 3
197 -
Introduction to WHERE Clause
139 -
Filtering the results
0 -
Operators in SQL
183 -
Arithmetic Operators in SQL
673 -
Profit Analysis
0 -
Challenge: Tax Calculations
162 -
Comparison Operators in SQL
633 -
Hire Date Filter
0 -
AND Operator: Working with Multiple Conditions
573 -
Student Performance Evaluation
0 -
Challenge: Accessories under $30
171 -
OR Operator: Working with Multiple Conditions in SQL
541 -
Course Enrollment
0 -
Challenge: Inventory Check
417 -
NOT Operator in SQL
120 -
Voter Eligibility Check
0 -
Alternative to Multiple OR’s
338 -
Color Preference Survey
0 -
Challenge: Customer Location
269 -
Challenge: Product Popularity
214 -
Between in SQL
521 -
Sports Events Age Group
0 -
Challenge: Price Adjustment
222 -
Searching for a Pattern in Data with LIKE Operator
961 -
Find University Names
0 -
Challenge: Searching for Stars
128 -
Using WHERE with NULL Values
501 -
Bank Account Status
0 -
Nested WHERE Clauses using MySQL
371
-
DAY 3: Review
337 -
Introduction to Day 4
182 -
Introduction to Grouping and Aggregation in SQL
279 -
Understanding Aggregate Functions in SQL
667 -
Total Grocery Inventory
0 -
The GROUP BY Clause in SQL
493 -
Art Sales Summary
0 -
Challenge: Sales Volume
216 -
Combining Aggregate Functions and GROUP BY
349 -
Challenge: Customer Demographic
185 -
Challenge: Retrieving Best Sellers
284 -
Grouping By Multiple Columns
303 -
Enrollment Summary
0 -
The HAVING Clause in SQL
433 -
Top-Performing Bands
0 -
Challenge: Premium Customers
213 -
Challenge: Frequent Shoppers
187 -
Challenge: Customer Spending Habits
123 -
Nested Aggregation and Grouping
337 -
High-Scoring Courses
0 -
Common Pitfalls and How to Avoid Them
464 -
Practical Applications of Grouping and Aggregation
338 -
DAY 4 Review
307 -
Section 5 Recap Quiz
-
Introduction to Day 5
274 -
Introduction to Joins in SQL
176 -
INNER JOIN in SQL
762 -
Region Climate Data
0 -
Inner Joins with Multiple Tables
615 -
Student Enrollment
0 -
Challenge: Product Names in Sales Volume
287 -
LEFT JOIN in SQL
349 -
Product Reviews
0 -
Challenge: Product Sales Analysis
465 -
RIGHT JOIN in SQL
250 -
Department Employees
0 -
Understanding ON vs USING in Joins
270 -
Self Join in SQL
409 -
Employee Supervisors
0 -
Challenge: City-Wise Customer Analysis
251 -
CROSS JOIN in SQL
151 -
Team Combinations
0 -
NATURAL JOIN in SQL
252 -
University Departments
0 -
Challenge: Customer Analysis
314 -
Challenge: Customer Purchase Analysis
377 -
Common Pitfalls and Best Practices
674 -
DAY 5 Review
454 -
Section 6 Recap Quiz
-
Introduction to Day 6
158 -
Introduction to Database Design
329 -
QuantumTutors - Our New Startup
304 -
Introduction to Entity-Relationship Model
146 -
ER Diagrams in Database Design
535 -
One to One Relationship
395 -
One to Many Relationship
398 -
Many to Many Relationship
415 -
Normalization Techniques
197 -
First Normal Form (1NF)
130 -
Second Normal Form (2NF)
112 -
Third Normal Form (3NF)
127 -
Identifying Relationships for Database Design
336 -
DAY 6 Review
72 -
Section 7 Recap Quiz
-
Introduction to DAY 7
352 -
Introduction to DDL in SQL
179 -
Creating and using Database
582 -
Challenge: Database for QuantumTutors
160 -
CREATE Statement in SQL
909 -
Describing Tables in SQL
236 -
Primary Keys in Database
450 -
Foreign Keys in Database
701 -
Challenge: Defining REST Of the Tables
384 -
Sample Data For MySQL
143 -
Copy Tables in SQL
512 -
ALTER Statement in SQL
97 -
ALTER to add column
480 -
Challenge: Course Duration
166 -
ALTER to Drop column
271 -
Challenge: Changes in Business Model
131 -
ALTER to modify column
559 -
Challenge: Managing Integrity
192 -
Challenge: Course Categorization
211 -
DROP Statement in SQL
538 -
DROP and Foreign Keys in Database
190 -
TRUNCATE Statement in SQL
305 -
Challenge: Data Pruning
113 -
DROP with references
703 -
RENAME Statement in SQL
246 -
Day 7 Review
327 -
Section 8 Recap Quiz
-
Introduction to DAY 8
220 -
Introduction to DML Statements in SQL
37 -
Working with Insert Statements
454 -
Challenge: New Admin Onboarding
125 -
Inserting multiple records at once
175 -
Database Insert Statements Challenge
0 -
Challenge: New Instructors Onboarding
162 -
Inserting data from another table
359 -
Copying Data Between Tables
0 -
Update statement in SQL
214 -
Modifying Employee Information
0 -
Challenge: Course Title Improvements
324 -
Updating multiple columns
269 -
Updating Multiple Employees Information
0 -
Challenge: Profile Update
133 -
Updating multiple rows in SQL
218 -
Advanced Employee Performance Update
0 -
Challenge: Discounted Courses
97 -
Deleting specific records from the table
286 -
Employee Records Deletion
0 -
Challenge: Course Retirement
422 -
Deleting all records from the table
89 -
Challenge: Complete Reset
153 -
Difference between DROP, DELETE, and TRUNCATE
149 -
DAY 8 Review
335 -
Section 9 Recap Quiz
-
Introduction to DAY 9
154 -
Subqueries Introduction
437 -
Subquery Utilization with WHERE and IN
0 -
Challenge: Course Popularity
485 -
Correlated and Non-Correlated Subqueries using SQL
536 -
Challenge: Course with Highest Price
238 -
Exists and Not Exists with Subqueries
237 -
Challenge: Instructors Not Teaching
203 -
Using ANY and ALL with Subqueries in SQL
208 -
Challenge: Top Performing Instructors
210 -
Single Row Subqueries in SQL
80 -
Single-Row Subquery Challenge
0 -
Multi Row Subqueries in SQL
91 -
Multi-Row Subquery with IN Operator Challenge
0 -
Inserting and Deleting using Subquery
156 -
Challenge: Remove Reviews for Courses Not Offered
128 -
DAY 9 Review
327 -
Section 10 Recap Quiz
Requirment
-
No prior experience in SQL or database necessary, everything will be taught in the course
Outcomes
-
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.
0 Student
1 Course
0 review