Mysql Database Development Mastery

  1. Home
  2. Database-administration
  3. Mysql Database Development Mastery

Tags: Database Administration

Learn fundamental Database Development techniques with MySQL Server and MySQL Workbench

Last updated 2022-01-10 | 4.4

- Basic Database Design (Tables
- Columns
- Data Types
- Primary Keys
- Foreign Keys
- Normalization)
- How to Use install and MySQL Workbench
- SELECT Statements: Queries against single tables (Filtering
- Ordering
- Grouping)

What you'll learn

Basic Database Design (Tables
Columns
Data Types
Primary Keys
Foreign Keys
Normalization)
How to Use install and MySQL Workbench
SELECT Statements: Queries against single tables (Filtering
Ordering
Grouping)
DELETE: How to remove data from a database
INSERT INTO: How to insert data into a table
UPDATE: How to update existing data
Overall Database Development Best Practices
Creating Relationships and Foreign Keys
How to craft SQL statements based on real scenarios
How to export Query Results to Excel
Using Aggregate Functions in SQL
How to query related data from multiple tables

* Requirements

* A Reliable Computer
* A desire to learn database development

Description

  • Basic Database Design (Tables, Columns, Data Types, Primary Keys, Foreign Keys, Normalization)
  • How to Use install and MySQL Workbench
  • SELECT Statements: Queries against single tables (Filtering, Ordering, Grouping)
  • DELETE: How to remove data from a database
  • INSERT INTO: How to insert data into a table
  • UPDATE: How to update existing data
  • Overall Database Development Best Practices
  • Creating Relationships and Foreign Keys
  • How to craft SQL statements based on real scenarios
  • How to export Query Results to Excel
  • Using Aggregate Functions in SQL
  • How to query related data from multiple tables

Course content

5 sections • 26 lectures

Introduction 2 lectures

Introduction to MySQL Server and Databases Preview 06:33

Download and Install MySQL Server and MySQL Workbench Preview 12:23

Manipulating Tables and Data - CRUD Operations 11 lectures

Connect and Create a Database Preview 12:50

Drop or Remove Database Preview 03:40

Create an SQL Database Table Preview 22:59

Insert Data into the Table with SQL Script Preview 08:49

Insert Data into the Table with Workbench Preview 09:02

Select Data from the Table with SQL Script Preview 08:09

Select Data with Filters Preview 19:53

Update Data in the Table Preview 08:33

Delete Data from the Table Preview 10:20

Reverse Engineer Database into Model Preview 06:54

Forward Engineer Data Model into Database Preview 11:44

Relationships and Foreign Keys 6 lectures

What are Relationships, Foreign Keys and Normalization Preview 10:49

Create Relationships with Data Modelling Preview 15:28

Create Relationships with Workbench Table Design Tool Preview 20:24

Insert Records in Related Tables Preview 08:55

Run Queries on Related Tables (Inner Joins) Preview 15:21

Left, Right and Cross Joins Preview 07:07

Aggregate Functions 6 lectures

Grouping Data using SQL GROUP BY Clause Preview 09:52

SQL AVG Aggregate Function Preview 09:00

SQL COUNT Aggregate Function Preview 07:44

SQL MIN & MAX Aggregate Functions Preview 02:53

SQL SUM Aggregate Function Preview 05:18

Splitting Groups using HAVING Clause Preview 04:33

BONUS Discounts 1 lectures

Bonus Discounts Preview 00:17