|Unit 01: Introduction|
|Module 01: Introduction to MySQL Server and Databases||00:07:00|
|Module 02: Download and Install MySQL Server and MySQL Workbench||00:12:00|
|Unit 02: Manipulating Tables and Data - CRUD Operations|
|Module 01: Connect and Create a Database||00:13:00|
|Module 02: Drop or Remove Database||00:04:00|
|Module 03: Create an SQL Database Table||00:23:00|
|Module 04: Insert Data into the Table with SQL Script||00:09:00|
|Module 05: Insert Data into the Table with Workbench||00:09:00|
|Module 06: Select Data from the Table with SQL Script||00:08:00|
|Module 07: Select Data with Filters||00:20:00|
|Module 08: Update Data in the Table||00:09:00|
|Module 09: Delete Data from the Table||00:10:00|
|Module 10: Reverse Engineer Database into Model||00:07:00|
|Module 11: Forward Engineer Data Model into Database||00:12:00|
|Unit 03: Relationships and Foreign Keys|
|Module 01: What are Relationships, Foreign Keys and Normalization?||00:11:00|
|Module 02: Create Relationships with Data Modeling||00:15:00|
|Module 03: Create Relationships with Workbench Table Design Tool||00:20:00|
|Module 04: Insert Records in Related Tables||00:09:00|
|Module 05: Run Queries on Related Tables (Inner Joins)||00:15:00|
|Module 06: Left, Right and Cross-Joins||00:07:00|
|Unit 04: Aggregate Functions|
|Module 01: Grouping Data using SQL GROUP BY Clause||00:10:00|
|Module 02: SQL AVG Aggregate Function||00:09:00|
|Module 03: SQL COUNT Aggregate Function||00:08:00|
|Module 04: SQL MIN & MAX Aggregate Functions||00:03:00|
|Module 05: SQL SUM Aggregate Function||00:05:00|
|Module 06: Splitting Groups using HAVING Clause||00:05:00|
Build your confidence in your database skills and use them to enhance your online and offline profile. Our exclusive MySQL Database Development Masterclass course will pop up your efficiency and make a smooth career path for you.
The MySQL Database Development Masterclass course has been designed by industry experts suitable for anyone who wants to build their professional skill set and improve their expert knowledge. It will allow you to learn the basic and advanced concepts of MySQL as well as the formulas that are used in MySQL in general and many more essential tactics that you must have known to use SQL.
The MySQL Database Development Masterclass course curriculum breaks down the topics for easy understanding. It is a pathway for learners to continue building their own skills and knowledge to consistently keep growing their expert status and credibility in the data analysis sector.
Enrol now and make your dream come true!!!
The MySQL Database Development Masterclass course will help you build your career in the field of:
Successful candidates will be awarded a professional certification that will help them to enhance their proficiency and be able to spike up their career ladder!
No Reviews found for this course.