Data Analysis with MySQL | Online Evening | M0100438
FREE
/CourseBundles(58768)/4102917-Data_analysis_with_Mysql.jpg)
Course Overview
Schedule of Classes
Start Date & End Date
Jun 05 2025 - Jun 06 2025
Total Classes
14 Classes
Course Curriculum
1 Subject
Data Analysis with MySQL | Online Evening | M0100438
9 Exercises • 43 Learning Materials
SQL Installation
MySQL Workbench Installation Processor
Data Analysis With MySQL
20th May - DAY 1 - Introduction To SQL
21st May - Day 2 - SOL COMMANDS
22nd May - Day 3 - Implementing SQL Commands on Work Bench
23rd May - Day 4 - Operators , Constraints - 1
26th May SQL_CONSTRAINTS
27th May SQL Clauses, Case statements
28th May Case statements , aggregation function
29th May String Functions, Date Functions
30th May Order Of Excecution , ER Diagram , SubQueries
2nd June RELATIONSHIPS IN DBMS, JOINS
3rd June SET OPERATIONS , DERIVED TABLE , VIEWS , CTE
4th June STORED PROCEDURE , WINDOW FUNCTIONS
5th June loading csv file into MySql Workbench
6th June Triggers , Jupyter and MySQL Connection , Instragram Clone Project
MYSQL - Material
DAY1 - Introduction to SQL - Class Notes
Day 2 - SQL Commands
Day 3 - SQL Commands In WorkBench
Day 4 - SQL Operators
Day 4 - Notes ( operators and constraints )
DAY 5 - SQL_CONSTRAINTS
DAY 6 - CLAUSES,CASE STATEMENT_NOTES
DAY 6 -CONSTRAINTS
DAY6 - CLAUSES
day 7 - aggregation func
day 7
day 7
Day 8 - Notes
Day 8 - String_functions
Day 8 - Date Functions
DAY 9 - Notes ( Order of Excecution, ER Diagram , SubQuery)
Day - 9 Order of excecution
Day 9 - SubQuery
DAY 10 NOTES(RELATIONSHIP IN DBMS, JOINS)
DAY 10(RELATIONSHIP IN DBMS, JOINS)
Day 11 ( notes)
DAY11-SETOPERATIONS
DAY 11 ( DERIVED TABLE)
DAY11 - VIEWS
DAY 11 - CTE
Day 13 - Triggers
Day 13 - Python - MySQL Connection
Day 13 - Instragram Clone DB project
Assignments / Project
SQL DDL Comands Task
SQL ASSIGNMENT 1
SQL Assignment - 2
Assignment - 3
SQL - Final Project
Quizzes
Introduction to SQL
SQL_QUIZ_1
SQL_QUIZ_2
SQL_QUIZ_3
Course Instructor
/1192415-dark_logo.jpg){kind=logo}
Innomatics Research Labs
508 Courses • 23323 Students
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy