MySQL Database Development Mastery you own this product

Fundamental database development with MySQL Server and MySQL Workbench
Trevoir Williams
  • Course duration: 4h 19m

placing your order...

Don't refresh or navigate away from the page.
liveVideo liveVideo courses make it simple to learn complex concepts and technologies. Through quality lessons and short videos from expert programmers, you'll gain the skills you need to progress your career. $20.99 $29.99 you save $9 (30%)
MySQL Database Development Mastery (liveVideo) added to cart
continue shopping
adding to cart

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?
Find out more
RECENTLY VIEWED