IIRF Online > Office Productivity > Oracle > Database Administration > MySQL Database Development Mastery
MySQL Database Development Mastery by Udemy
Learn fundamental Database Development techniques with MySQL Server and MySQL Workbench
Course Highlights
- 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
Skills you will learn!
Curriculum
2 Topics
Introduction to MySQL Server and Database
Understanding Types of Data and Storage
1 Topic
Download and Install MySQL Server and MySQL Workbench
11 Topics
Connect and Create a Database
Drop or Remove Database
Create an SQL Database Table
Insert Data into the Table with SQL Script
Insert Data into the Table with Workbench
Select Data from the Table with SQL Script
Select Data with Filters
Update Data in the Table
Delete Data from the Table
Reverse Engineer Database into Model
Forward Engineer Data Model into Database
6 Topics
What are Relationships Foreign Keys and Normalization
Create Relationships with Data Modelling
Create Relationships with Workbench Table Design Tool
Insert Records in Related Tables
Run Queries on Related Tables (Inner Joins)
Left Right and Cross Joins
6 Topics
Grouping Data using SQL GROUP BY Clause
SQL AVG Aggregate Function
SQL COUNT Aggregate Function
SQL MIN & MAX Aggregate Functions
SQL SUM Aggregate Function
Splitting Groups using HAVING Clause
1 Topic
Bonus Discounts
MySQL Database Development Mastery
Related Database Administration Courses
.webp)
Thank You!
Your review has been submitted successfully.