Understanding Relationships, Foreign Keys and Normalization | MySQL Database Development Mastery

Database normalization is the process of structuring a relational database in accordance with a series of so-called normal forms in order to reduce data redundancy and improve data integrity.

Full Udemy Course: http://bit.ly/2Gb0E9N (with coupon code discount)


This is a zero to hero course on MySQL Database Server and MySQL Workbench. There are no pre-requisites for this course. If you are looking to get acquainted with the concept of Databases and Queries then this is the right course for you.

What you’ll learn

Install MySQL Server
Install MySQL Workbench
Connect to an Instance
Create a database
Reverse Engineer Database into Data Models
Forward Engineer Data Models into Databases
Create Tables
Run Queries against Tables
General use of the MySQL Workbench
Create Relationships
Use Aggregate functions to do quick mathematical operations
Export data to Excel using MySQL Workbench
Practical use of SQL

___________________________________________________________________

I am a Software Engineer and Instructor. I can provide professional development services or private code coaching sessions to help you to accomplish your profesisonal or personal IT goals.

Check out my content on Social Media

Website: https://www.trevoirwilliams.com/
Instagram:   / trevthetrevwill  
Facebook:   / trevoirwilliams  
LinkedIn:   / trevoirwilliams  

Check out some free courses below:
Microsoft SQL Server 2017 for Everyone! - Database Development Course
   • Microsoft SQL Server 2017 for Everyon...  

PHP Bootstrap 4, Heroku and MySQL Course
   • PHP Bootstrap 4, Heroku and MySQL Course  

PHP Development with Bootstrap, GitHub and Heroku
   • PHP Development with Bootstrap, GitHu...  

Modern PHP Web Development with MySQL, GitHub and Bootstrap 4
   • Modern PHP Web Development with MySQL...  

C# - Basics Uncovered
   • C# - Basics Uncovered  

Enterprise C# Winforms Application Development
   • Enterprise C# Winforms Application De...  

Introduction To Website Technologies
   • Introduction To Website Technologies  

Check out my premium courses on Udemy
End to End ASP.NET Core 3.1 API and Blazor Development
https://www.udemy.com/course/end-to-e...

C# Console and Windows Forms Development with LINQ & ADO.NET
https://www.udemy.com/course/c-consol...

Complete ASP.Net Core 3.1 and Entity Framework Development
https://www.udemy.com/course/complete...

Modern PHP Web Development w/ MySQL, GitHub & Heroku
https://www.udemy.com/course/advanced...

Microsoft SQL Server Development for Everyone!
https://www.udemy.com/course/microsof...