- 1. Introduction 2m 23s
- 2. How to get course requirements 1m 23s
- 3. Getting started on Windows, Linux or Mac 48s
- 4. How to ask great questions 1m 27s
- 5. FAQ’s 1m 3s
- 6. source code file 8m 47s
Learn MySQL from scratch for Data Science and Analytics
About this course
Learn MySQL from scratch for Data Science and Analytics": ```html Unlock the power of data with our comprehensive course, Learn MySQL from scratch for Data Science and Analytics. This course is meticulously crafted for individuals eager to gain a robust understanding of MySQL and its applications in the realm of data science and analytics. Whether you are a complete beginner, a professional, or a student, this course will equip you with the essential skills to manage, analyze, and derive valuable insights from data. Throughout the course, you will delve into various critical topics including: - Installation and configuration of MySQL Server - Understanding database fundamentals and SQL syntax - Executing essential SQL commands for data manipulation - Employing advanced techniques such as joins, constraints, and views - Importing and exporting data efficiently - Backing up and restoring databases to safeguard your data By the end of this course, you'll be proficient in using MySQL, enabling you to tackle real-world data challenges in your projects and career.
What you'll learn
- Learn MySQL from scratch for Data Science and Analytics": ```html Unlock the power of data with our comprehensive course, Learn MySQL from scratch for Data Science and Analytics.
- This course is meticulously crafted for individuals eager to gain a robust understanding of MySQL and its applications in the realm of data science and analytics.
- Whether you are a complete beginner, a professional, or a student, this course will equip you with the essential skills to manage, analyze, and derive valuable insights from data.
- Throughout the course, you will delve into various critical topics including: - Installation and configuration of MySQL Server - Understanding database fundamentals and SQL syntax - Executing essential SQL commands for data manipulation - Employing advanced techniques such as joins, constraints, and views - Importing and exporting data efficiently - Backing up and restoring databases to safeguard your data By the end of this course, you'll be proficient in using MySQL, enabling you to tackle real-world data challenges in your projects and career.
Curriculum
88 Lessons • 5H 49M- 1. Section Introduction 1m 8s
- 2. MySQL Server Installation 13m 44s
- 3. Connect MySQL Server Instance 5m 50s
- 4. MySQL Workbench overview 10m 41s
- 5. Download and Restore Sample Database 7m 43s
- 1. Section Introduction 1m 10s
- 2. Overview of Databases 9m 16s
- 3. Creating Database 6m 34s
- 4. SQL Data Types 3m 47s
- 5. Column Data Types on Workbench 7m 23s
- 6. Creating Table 3m 45s
- 7. Overview of Primary and Foreign Key 3m 29s
- 8. Primary Key 6m 9s
- 9. Foreign Key 11m 34s
- 10. Creating Temporary tables 12m 23s
- 11. EER – Enhanced Entity Relationship Diagrams 4m 21s
- 1. Section Introduction 1m 17s
- 2. Insert statement 7m 12s
- 3. Update statement 6m 3s
- 4. Delete statement 3m 13s
- 1. Section Introduction 1m 11s
- 2. CREATE table statement 7m 51s
- 3. DROP statement 2m 59s
- 4. ALTER statement 4m 54s
- 5. TRUNCATE statement 3m 3s
- 6. COMMENT in query 2m 23s
- 7. RENAME table 3m 16s
- 1. Create Database user 3m 16s
- 2. GRANT permissions 5m 6s
- 3. REVOKE permissions 3m 47s
- 1. Section Introduction 56s
- 2. SQL Statement basic 3m 17s
- 3. SELECT Statement 3m 12s
- 4. SELECT DISTINCT 1m 31s
- 5. SELECT with column headings 1m 28s
- 6. Column AS statement 2m 21s
- 7. DASHBOARD Analytics 6m 4s
- 1. SELECT WHERE Clause – theory 3m 4s
- 2. SELECT WHERE Clause – practical 6m 16s
- 1. Sum() 6m 20s
- 2. Min()-Max() 2m 40s
- 1. Order By statement 4m 43s
- 2. SELECT TOP 3 records 1m 44s
- 3. BETWEEN command 5m 46s
- 4. Search Data using LIKE cards 4m 35s
- 5. IN operator 2m 57s
- 1. Section Introduction 43s
- 2. Group by – theory 3m 34s
- 3. Data Analytics with Group By 3m 59s
- 4. HAVING statement 3m 1s
- 1. Overview of Joins 2m 2s
- 2. What are Joins 2m 18s
- 3. Inner join 6m 43s
- 4. Left outer join 2m 5s
- 5. Right outer join 1m 53s
- 6. Union 2m 54s
- 7. CERTESIAN Product or Cross Join 3m 14s
- 8. Query Exercise 1m 16s
- 9. Solution for Query Exercise 1m 3s
- 1. Section introduction 1m 24s
- 2. Check constraint 8m 33s
- 3. NOT NULL constraint 2m 46s
- 4. UNIQUE constraint 5m 53s
- 1. Creating Views 3m 26s
- 2. Data Analytic Views from multiple tables 3m 15s
- 1. Section Introduction 1m 2s
- 2. Timestamp 3m 11s
- 3. Extract from timestamp 3m 1s
- 4. Mathematical scalar functions 2m 35s
- 5. String functions 7m 14s
- 6. Advanced functions 3m 59s
- 7. Sub Queries 3m 11s
- 8. SELECT with calculations 4m 45s
- 1. Create stored procedure 5m 39s
- 2. Stored procedure with parameter 3m 19s
- 3. Drop Procedure 1m 21s
- 1. Section Introduction 1m 9s
- 2. Import .csv file 4m 7s
- 3. Export Data to .csv file 2m 13s
- 1. Section Introduction 45s
- 2. Creating Database backup 2m 28s
- 3. Restoring Database backup 2m 10s
- 0.00 instructor rating
- 1 courses
- Systems students worldwide
Metla Sudha Sekhar
Learn from DragonZap instructors with practical, build-first lessons focused on systems, low-level programming, compilers, kernels, and real-world engineering fundamentals.
Student reviews
No student reviews have been posted yet.