• LOGIN
  • No products in the cart.

Login

Course Curriculum

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

Mastering MySQL Database Development

4.7( 5 REVIEWS )
338 STUDENTS
$346.11
Mastering MySQL Database Development
  • 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. 

  • Learning outcome
  • Learn how to develop database from scratch
  • Be able able to forward Engineer Data Model into Database
  • Learn different types of aggregate functions e.g. MIN, MAX, SUM
  • Know how to split groups using HAVING function
  • Know how to select data with filters, delete or update it.
  • Learn how to create relationships with data modelling
  • Gain profound knowledge of how to work with databases
  • Requirements
  • No formal qualifications required, anyone from any academic background can take this course.
  • Access to any internet-enabled smart device.
  • Why should I take this course?
  • 4+ hours of on-demand video lectures and downloadable resources.
  • Affordable premium-quality E-learning content, you can learn at your own pace.
  • You will receive a completion certificate upon completing the course.
  • Internationally recognized Accredited Qualification will boost up your resume.
  • You will learn the researched and proven approach adopted by successful salespeople to transform their careers.
  • You will be able to incorporate various practical sales techniques successfully and understand your customers better.
  • 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.

Testimonial

Hear what our happy students want to say

Setup Menus in Admin Panel

Select your currency