MySQL Database Development Mastery

With its proven performance, reliability, and ease-of-use, MySQL has become the leading database choice for web-based applications, used by high profile web properties including Facebook, Twitter and YouTube. MySQL is the world’s most popular open source database.

We will explore best practices in database development using MySQL Database Server and will be building a small school management system database.

All you need is a windows machine and we will walk through setting up an environment, to creating a database, creating your first table and writing queries.

At the end of this course, you should be comfortable writing queries for multiple situations and reports. This is a zero to hero course on MySQL Database Server and MySQL Workbench. If you are looking to get acquainted with the concept of Databases and Queries then this is the right course for you.

Distributed by Manning Publications

This course was created independently by Trevoir Williams and is distributed by Manning through our exclusive liveVideo platform.

• Basic Database Design (Tables, Columns, Data Types, Primary Keys, Foreign Keys, Normalization)
• How to install and use 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
• Create 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

Trevoir Williams is a passionate software and system engineer with a strong drive to share the best of his knowledge with students around the globe. His educational achievements include a Master’s degree in Computer Science (major in Software Development) and several Microsoft Azure Certifications.

His impressive work experience includes software consulting, software engineering, database development, cloud system, server administration, lecturing, and he’s also a musician!

Trevoir enjoys teaching IT and development skills and guides students in gaining the latest knowledge with practical application in the modern industry.