- Course Highlights
It is hard to be productive at the office when there are piles of information to work on. The Mastering MySQL Database Development course can be your saviour to save you from trouble immediately!
From running an e-commerce site to organizing a corporation, you need a database to organize your pieces of information so that you can find them when needed. You can store all the necessary records very easily with mySQL database. With this course, you will learn how to organize a table with proper columns and data types in mySQL. You will understand where to use primary keys and foreign keys. This course will also provide you with applicable knowledge by teaching you how to craft SQL statements when there is a real problem to resolve.
To make the course easy and fruitful there is an opportunity to access the course whenever you are comfortable with it. There are tutors whom you can ask anything regarding the lessons via e-mail. This is not the end, you will get a certificate after finishing the course successfully.
To keep pace with the market, you need to walk faster and systematically. Learning how to develop databases will take you long in your career. Enroll now and get smarter in handling all your business work.
- Who is this course for
- People who run e-business
- People who are on the hold of company information
- People who are looking for a job opportunity relevant to this sector.
Course Curriculum
| 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 | ||
Don't just take our word for it
