July 2022
4h 20m
English
Overview
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.
About the Technology
About the Video
What's Inside
- 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 Reader
No pre-requisites for this course. Anyone who wants to learn Database development from the basics can take this course.
About the Author
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.
Quotes
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Watch now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.