• LOGIN
  • No products in the basket.

Online Database Development Course

  • Learn how to install and use MySQL Server and MySQL Workbench to create Relational Database Management Systems (RDBMS) with this accredited video course.
  • Study how to write scripts in Structured Query Language.
  • Discover how to manipulate Tables and Data with CRUD (Create, Read, Update and Delete) Operations.
  • Learn about Relationships and Foreign Keys.
  • Study Aggregate Functions from Average to Sum, Count, Minimum & Maximum and Having clauses.
  • You will be graded on an assignment where you must answer questions based on the course and submit this at your leisure.

Course Content

  • Module 01:  Introduction to MySQL Server and Databases


My SQL Server is a relational database management system or RDBMS. A DBMS is a program that enables its users to access databases, manipulate data, reports, or representation of data. This module looks at what is data, a database, a table, relationships, and foreign keys.

  • Module 02: Download and Install MySQL Server and MySQL Workbench


A video walkthrough to download and install MySQL Server and Workbench.

  • Module 01: Connect and Create a Database

This video looks at connecting to a database using SQL commands for the MySQL Server and creating your first database.

  • Module 02: Drop or Remove Database

This video guides you with dropping or removing a database by using an SQL command script.

  • Module 03: Create an SQL Database Table

This video covers quite a few concepts, namely creating tables using SQL scripts, and the fact that we can have multiple commands in one file, and how we can execute them all vs executing them in parts.

  • Module 04: Insert Data into the Table with SQL Script

In this lesson, we will look at inserting records into our tables. To begin this exercise, we will use a script and we will look at the syntax to insert records into our student table.

  • Module 05: Insert Data into the Table with Workbench

In this video, we will look at using the MySQL Workbench interface to insert records into our data tables. The MySQL Workbench allows you to insert records directly without having to write any SQL code.

  • Module 06: Select Data from the Table with SQL Script

In this lesson, we will discuss how we go about selecting or viewing records (using SQL statements) in our database tables.

  • Module 07: Select Data with Filters

In this video, we will learn how the Workbench generates records and about more advanced queries in terms of custom columns and filters.

  • Module 08: Update Data in the Table

In this lesson, we will look at how we can go about updating data that is already in our database with SQL statements.

  • Module 09: Delete Data from the Table

In this tutorial, we will learn how to remove records from our database.

  • Module 10: Reverse Engineer Database into Model

This video covers how we can go about reverse engineering our newly created database into a database model. This is a graphical representation of our database.

  • Module 11: Forward Engineer Data Model into Database

Learn how to forward engineer a data model into a database. This time, instead of writing scripts or going into the user interface and creating the database upfront, we want to take it from the modelling perspective. This is for people who are visual first.

  • Module 01: What are Relationships, Foreign Keys and Normalization?

Study relational database design as it relates to relationships, foreign keys and normalization.

  • Module 02: Create Relationships with Data Modelling

In this video, we will learn how to start modifying our databases so we can prepare them to have relationships and foreign keys.

  • Module 03: Create Relationships with Workbench Table Design Tool

Working with our school database, we will modify the table to support foreign keys. We will be adding more tables to this database using Workbench.

  • Module 04: Insert Records in Related Tables

We will be adding data to the new class and enrolment tables. The challenge with the relational database is once we start introducing relationships to the table, as you will learn.

  • Module 05: Run Queries on Related Tables (Inner Joins)

This video covers running queries from multiple tables that are related or Inner Joins.

  • Module 06: Left, Right and Cross-Joins

Understand how Left, Right and Cross-Joins work with this video tutorial.

  • Module 01: Grouping Data using SQL GROUP BY Clause

Learn about the group-by statements available to us in MySQL. Group-bys allow us to eliminate repeating data and select distinct records from a table, as well as to conduct mathematical operations.

  • Module 02: SQL AVG Aggregate Function

In this video, we will look at aggregate functions starting with the average function.

  • Module 03: SQL COUNT Aggregate Function

We will look at two scenarios where the number of students per class or course will help us to accomplish the “count” function.

  • Module 04: SQL MIN & MAX Aggregate Functions

In this scenario, we want to see the highest and lowest grades by course using the “Min” & “Max” functions.

  • Module 05: SQL SUM Aggregate Function

For this scenario, we want to look at the total number of credits that each student is studying using the “Sum” function.

  • Module 06: Splitting Groups using HAVING Clause

You are faced with a scenario where you want to see only students with a certain number of credits. This tutorial shows you how to sum up conditionally with the “having” clause.

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

Course Reviews

Reviews

7 Reviews Available
Lola Bond
Lola Bond
Student
Read More
The course costs £7.99 each month; however, the first four weeks are free. Try it out with the free sessions, and I'm sure you'll end up subscribing as I did!
Poppy Whitehouse
Poppy Whitehouse
Student
Read More
Keep up the incredible work, Visio Learning. Your classes have blown me away, and I will definitely be taking more.
Shannon Kent
Shannon Kent
Student
Read More
Thank you very much, Visio Learning, for providing students with such excellent opportunities. I've picked up several new talents that have proven to be helpful in my professional life.
Anthony Fisher
Anthony Fisher
Student
Read More
I can't tell you how much this course taught me! There are over 500 courses available on Visio Learning, and I'm going to subscribe for more.
Tyler Mitchell
Tyler Mitchell
Student
Read More
I highly encourage everyone not to squander time and take advantage of Visio Learning's fantastic learning opportunities.
Amy Dean
Amy Dean
Student
Read More
I had no idea that an online course could teach me so much! I'm glad I subscribed for this course.
Jennifer Winter
Jennifer Winter
Student
Read More
I'm glad for the chance to study under world-class educators. Thank you so much, Visio Learning!
Kate Dobson
Kate Dobson
Student
Read More
"I paid £7.99 for a monthly subscription to this course, and trust me, and it's well worth it! This course has taught me so much. "
David Law
David Law
Student
Read More
I'm thrilled to have the chance to learn from world-class professors! It went above and beyond my expectations. I strongly advise everyone to give it a shot.
Leon Davey
Leon Davey
Student
Read More
The course is a wealth of information! I thoroughly enjoyed every moment of it. Strongly recommend!
Sienna Simpson
Sienna Simpson
Student
Read More
Visio Learning offers student help 24/7 students support, and that's amazing! I could contact them with any questions or concerns I have, and they were always willing to help.
Lucas Coleman
Lucas Coleman
Student
Read More
What a fantastic course! I started for free for the first month and couldn't stop myself from subscribing! Highly recommend.
Sienna Leonard
Sienna Leonard
Student
Read More
The top educators are unquestionably found at Visio Learning. I can't express how thorough the instructor was in each lesson, and I could pick up a lot of information.
Abbie Hayward
Abbie Hayward
Student
Read More
"I discovered this website through a friend and joined in the free trial course for the first month. I couldn't resist subscribing for £7.99 each month. It's my third month with them, and I'm having a great time! "
Kyle Pearson
Kyle Pearson
Student
Read More
I had no idea that an online course could provide me with so much information! I appreciate it.
Matthew Thomson
Matthew Thomson
Student
Read More
The instructor was great! I was blown away by how expertly he explained the complex topics.
Olivia Lee
Olivia Lee
Student
Read More
I can't express how fantastic the courses Visio Learning provides. The £7.99/month subscription charge is insignificant when compared to the training quality. I've taken a lot of courses from them, and they've all been great!
Liam Whittaker
Liam Whittaker
Student
Read More
I had previously taken a few online courses that did not match my expectations. I'm delighted I discovered Visio training. It provided me with the most beneficial learning experience. The 24/7 student support helped me immensely with my inquiries.
Faith Sharpe
Faith Sharpe
Student
Read More
"This course was quite beneficial to me. Everyone should give it a try, in my opinion. You may cancel your subscription at any time, but I bet you won't since you'll be delighted by the great classes. "
Jayden Carr
Jayden Carr
Student
Read More
I am a person who is always willing to learn new skills. I took a bunch of online courses, but none of them lived up to my expectations. Thank you for your excellent classes, Visio Learning. They've been quite helpful in expanding my skill set.
Muhammad Field
Muhammad Field
Student
Read More
Excellent classes at a fair price for a subscription. Truly recommend!
Ryan Barry
Ryan Barry
Student
Read More
The instructor was upfront and knowledgeable. His instructions revealed his intelligence. I gained a lot of knowledge and am grateful for the fantastic learning experience.
Brandon Vincent
Brandon Vincent
Student
Read More
In my perspective, they deliver knowledge with care. They were incredibly accommodating anytime I needed help with the courses or anything else. All of my doubts were dispelled. Thank you very much!
Hannah Bates
Hannah Bates
Student
Read More
"The training I took from them was beneficial in terms of bolstering my CV with new skills. Keep up the great work, Visio Learning! "
Ellis Swift
Ellis Swift
Student
Read More
Thank you so much for the fantastic lessons and welcoming environment, Visio Learning. Access to your classes at any time helped me immensely in learning at my own pace.
Previous
Next

Certifications

Get accredited certificates

New skills

Add skills to your CV

Exams

Test your skills

Dedicated Support

for any questions

Set your own speed

Self-paced learning

Enjoy first month free

Start for free