Learn MySQL from scratch for Data Science and Analytics
in MySQL
4.0
(122 Ratings)
11,212 Students
Created by
Metla Sudha Sekhar
About this course
Learn MySQL for Data Science & Analytics: From Basics to Advanced Queries
What You'll Learn
- Master SQL queries to extract valuable insights for business reporting.
- Land a job as a junior Data Analyst or SQL Developer with real-world skills.
- Write advanced SQL queries for complex data operations.
- Use MySQL Workbench to design and manage database schemas.
- Boost your resume by confidently listing SQL and MySQL expertise.
- Apply GROUP BY statements to generate Business Intelligence reports.
- Solve real-world data problems with hands-on query exercises.
- Perform essential SQL operations like SELECT, INSERT, UPDATE, and DELETE.
- Filter and sort data using WHERE clauses to refine queries.
- Apply SQL for Data Science and Data Engineering workflows.
- Use JOINs to merge data from multiple tables for insightful reports.
- Analyze datasets with aggregate functions for deep data insights.
- Import and export data from CSV and Excel into MySQL databases.
- Secure your data by learning Backup & Restore techniques.
- Explore Generative AI and its future applications in Data Science.
- Test your skills with coding exercises for hands-on learning.
Requirements
- No prior SQL or technical experience needed—just a computer!
- No software required in advance—all tools used in the course are free.
Description
Unlock the power of MySQL for Data Science and Analytics with this beginner-friendly course! Whether you're new to databases or looking to enhance your data analysis skills, this course is designed to help you master MySQL and apply it to real-world data challenges.
You'll start with the basics of MySQL, including setting up databases, designing schemas, and writing queries. As you advance, you'll learn JOINs, subqueries, window functions, and performance optimization techniques. You'll also discover how to handle large datasets, generate reports, and integrate MySQL with Data Science workflows.
By the end of this course, you’ll be job-ready and confident in using MySQL for business intelligence, analytics, and data-driven decision-making.
🔥 Don't miss out! Enroll now to master MySQL and boost your career! 🔥
Who This Course Is For
- Beginners looking to start a career in SQL, Data Science, or Business Analytics.
- Anyone working with data—including marketing, finance, operations, and sales professionals.
- Aspiring Business Intelligence Developers who want to extract actionable insights.
- Freelancers & entrepreneurs looking to integrate SQL skills into their business.
- Those aiming for high-paying tech jobs—SQL developers earn near six figures!
Comments (0)
1. Introduction
7 Parts
1. Introduction.mp4
17.89 MB
2. How to get course requirements.mp4
4.14 MB
3. Getting started on Windows Linux or Mac.mp4
3.30 MB
4. How To Ask Great Questions.mp4
4.37 MB
5. FAQs.mp4
3.27 MB
6. What is Source code.mp4
24.07 MB
7. Learn What is Generative AI Gen AI.mp4
27.41 MB
2. SQL Server Setting Up
5 Parts
1. Section Introduction.mp4
3.82 MB
2. MySQL Server Installation.mp4
28.79 MB
3. Connect MySQL Server Instance.mp4
13.60 MB
4. MySQL Workbench overview.mp4
23.68 MB
5. Download and Restore Sample Database.mp4
23.88 MB
3. SQL Database basics
11 Parts
1. Section Introduction.mp4
3.81 MB
2. Overview of Databases.mp4
18.39 MB
3. Creating Database.mp4
13.40 MB
4. SQL Data Types.mp4
7.55 MB
5. Column Data Types on Workbench.mp4
15.84 MB
6. Creating Table.mp4
9.23 MB
7. Overview of Primary and Foreign Key.mp4
7.79 MB
8. Primary Key.mp4
14.10 MB
9. Foreign Key.mp4
24.15 MB
10. Creating Temporary tables.mp4
26.57 MB
11. EER – Enhanced Entity Relationship Diagrams.mp4
13.57 MB
4. SQL DML (Data Manipulation Language)
4 Parts
1. Section Introduction.mp4
4.20 MB
2. Insert statement.mp4
18.57 MB
3. Update statement.mp4
15.77 MB
4. Delete statement.mp4
10.42 MB
5. SQL DDL (Data Definition Language)
7 Parts
1. Section Introduction.mp4
3.99 MB
2. CREATE table statement.mp4
17.70 MB
3. DROP statement.mp4
8.88 MB
4. ALTER statement.mp4
13.60 MB
5. TRUNCATE statement.mp4
9.81 MB
6. COMMENT in query.mp4
7.41 MB
7. RENAME table.mp4
9.49 MB
6. SQL DCL (Data Control Language)
3 Parts
1. Create Database user.mp4
9.01 MB
2. GRANT permissions.mp4
13.46 MB
3. REVOKE permissions.mp4
11.05 MB
7. SQL Statement Basic
7 Parts
1. Section Introduction.mp4
3.43 MB
2. SQL Statement basic.mp4
7.96 MB
3. SELECT Statement.mp4
9.35 MB
4. SELECT DISTINCT.mp4
6.11 MB
5. SELECT with column headings.mp4
6.69 MB
6. Column AS statement.mp4
8.30 MB
7. DASHBOARD Analytics.mp4
17.14 MB
8. Filtering Data rows
2 Parts
1. SELECT WHERE Clause – theory.mp4
6.81 MB
2. SELECT WHERE Clause – practical.mp4
17.23 MB
9. Aggregate functions for Data Analysis
2 Parts
1. Sum().mp4
17.10 MB
2. Min()-Max().mp4
8.68 MB
10. SQL Data Analytic statements
5 Parts
1. Order By statement.mp4
16.10 MB
2. SELECT TOP 3 records.mp4
6.74 MB
3. BETWEEN command.mp4
16.98 MB
4. IN operator.mp4
10.27 MB
5. Search Data using LIKE cards.mp4
14.65 MB
11. SQL Group by statement
4 Parts
1. Section Introduction.mp4
3.07 MB
2. Group by – theory.mp4
7.65 MB
3. Data Analytics with Group By.mp4
11.49 MB
4. HAVING statement.mp4
9.09 MB
12. JOINS
9 Parts
1. Overview of Joins.mp4
4.76 MB
2. What are Joins.mp4
5.21 MB
3. Inner join.mp4
19.46 MB
4. Left outer join.mp4
8.66 MB
5. Right outer join.mp4
8.39 MB
6. Union.mp4
9.43 MB
7. CERTESIAN Product or Cross Join.mp4
9.99 MB
8. Query Exercise.mp4
5.44 MB
9. Solution for Query Exercise.mp4
4.64 MB
13. SQL Constraints
4 Parts
1. Section introduction.mp4
4.31 MB
2. Check constraint.mp4
20.37 MB
3. NOT NULL constraint.mp4
9.12 MB
4. UNIQUE constraint.mp4
16.89 MB
14. Views
2 Parts
1. Creating Views.mp4
11.10 MB
2. Data Analytic Views from multiple tables.mp4
12.08 MB
15. Advanced SQL Functions
8 Parts
1. Section Introduction.mp4
3.66 MB
2. Timestamp.mp4
9.86 MB
3. Extract from timestamp.mp4
9.64 MB
4. Mathematical scalar functions.mp4
7.88 MB
5. String functions.mp4
18.87 MB
6. Advanced functions.mp4
11.13 MB
7. Sub Queries.mp4
9.48 MB
8. SELECT with calculations.mp4
15.03 MB
16. SQL Stored procedures
3 Parts
1. Create stored procedure.mp4
16.40 MB
2. Stored procedure with parameter.mp4
11.76 MB
3. Drop Procedure.mp4
6.21 MB
17. Import & Export data
3 Parts
1. Section Introduction.mp4
3.87 MB
2. Import .csv file.mp4
13.34 MB
3. Export Data to .csv file.mp4
8.32 MB
18. Backup and Restore Database
3 Parts
1. Section Introduction.mp4
2.99 MB
2. Creating Database backup.mp4
8.85 MB
3. Restoring Database backup.mp4
8.70 MB
0
0 Reviews
