About This Course

MySQL is the world’s most popular open source database. 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. 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.

What you’ll learn:

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

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

Our Promise to You

By the end of this course, you will have learned database development techniques.

30 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
Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel