This course is designed for those interested to learn the basics of MySQL, as well as database development techniques with MySQL Server and MySQL Workbench.
Read more.Instructor
I am CEO of Sonar Systems which is the world leader in educational material.
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
Who this course is for:
- Beginners with absolutely no experience in database
- If you are already comfortable with basic database operations
- If you feel a bit ‘rusty’ and need to refresh your knowledge
- If you want to understand design principles in database development
- If you are looking to learn a new Database Management System
What you’ll learn:Â
- Basic database design (Tables, Columns, Data Types, Primary Keys, Foreign Keys, Normalization)
- How to use and install and MySQL Workbench
- Queries against single tables (Filtering, Ordering, Grouping)
- How to remove data from a database
- How to insert data into a table
- How to update existing data
- Overall Database Development best practices
MySQL is the world’s most popular open source database. With its proven performance, reliability, and ease-of-use. It has become the leading database choice for web-based applications, used by high profile web properties including Facebook, Twitter and YouTube.Â
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. We will also explore best practices in database development using MySQL Database Server and will be building a small school management system database.
This is a complete course with over 5 hours of premium content, all put together to ensure that you get up and running with becoming a Database Developer. I will take you through various scenarios and techniques to write queries, build a database and further administrate.Â
By the time you have finished the course, you will have moved around in MySQL Workbench so much that it will become second nature for you when building a MySQL Database. This will put your new learned skills into practical use and impress your boss and coworkers.
Our Promise to You
By the end of this course, you will have learned database development techniques.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about the fundamentals of MySQL.
Course Curriculum
| Section 1 - Introduction | |||
| Introduction to MySQL Server and Databases | 00:00:00 | ||
| Resources For MySQL Database Development | 00:00:00 | ||
| Download and Install MySQL Server and MySQL Workbench | 00:00:00 | ||
| Section 2 - Manipulating Tables and Data - CRUD Operations | |||
| Connect And Create A Database | 00:00:00 | ||
| Drop Or Remove Database | 00:00:00 | ||
| Insert Data Into The Table With SQL Script | 00:00:00 | ||
| Insert Data Into the Table With Workbench | 00:00:00 | ||
| Select Data From The Table With SQL Script | 00:00:00 | ||
| Select Data With Filters | 00:00:00 | ||
| Update Data In The Table | 00:00:00 | ||
| Delete Data From The Table | 00:00:00 | ||
| Reverse Engineer Database Into Model | 00:00:00 | ||
| Forward Engineer Data Model Into Database | 00:00:00 | ||
| Section 3 - Relationships And Foreign Keys | |||
| What Are Relationships, Foreign Keys And Normalization | 00:00:00 | ||
| Create Relationships With Data Modelling | 00:00:00 | ||
| Create Relationships With Workbench Table Design Tool | 00:00:00 | ||
| Insert Records In Related Tables | 00:00:00 | ||
| Run Queries on Related Tables (Inner Joins) | 00:00:00 | ||
| Left, Right And Cross Joins | 00:00:00 | ||
| Section 4 - Aggregate Functions | |||
| Grouping Data using SQL GROUP BY Clause | 00:00:00 | ||
| SQL AVG Aggregate Function | 00:00:00 | ||
| SQL COUNT Aggregate Function | 00:00:00 | ||
| SQL MIN And MAX Aggregate Functions | 00:00:00 | ||
| SQL SUM Aggregate Function | 00:00:00 | ||
| Splitting Groups Using HAVING Clause | 00:00:00 | ||
Related Courses
Are you interested in higher education?