pro $24.99 per month
- access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
- choose one free eBook per month to keep
- exclusive 50% discount on all purchases
lite $19.99 per month
- access to all Manning books, including MEAPs!
team
5, 10 or 20 seats+ for your team - learn more
Look inside
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.
prerequisites
No pre-requisites for this course. Anyone who wants to learn Database development from the basics can take this course.what you will learn
- 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
about the instructor
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.
what's a liveVideo?
- Quality lessons from expert programmers.
- Rich, interactive transcripts for navigation.
- Exercise driven learning.
what's a liveVideo?
choose your plan
pro
monthly
annual
$24.99
$249.99
only $20.83 per month
- access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
- choose another free product every time you renew
- choose twelve free products per year
- exclusive 50% discount on all purchases
-
![]()
MySQL Database Development Mastery liveVideo for free
MySQL Database Development Mastery liveVideo for free
team
monthly
annual
$49.99
$499.99
only $41.67 per month
- five seats for your team
- access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
- choose another free product every time you renew
- choose twelve free products per year
- exclusive 50% discount on all purchases
-
![]()
MySQL Database Development Mastery liveVideo for free
