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.
- 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.
|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|