I have been working with MySQL for several years and decided to share my knowledge with any developer who is interested in database management systems. This is a beginners course for developers or potential developers to learn how to utilise the MYSQL database, all the way from installation, navigation, manipulation, and display of data. If you are curious about MYSQL this is the course for you!
In this course you will learn;
Learn how to install MySQL and configure admin rights.
Syntax of the MySQL commands with simple descriptions
Learn how to create tables, insert data and read/display data
I hope this helps you upskill your MYSQL game!
section 1: Introduction
- 1. Installation of MYSQL
section 2: Creating the database
- 1. Creating the MYSQL database
section 3: Creating Tables and Inserting Data
- 1. Creating tables
- 2. Drop Tables
- 3. Insert Data & Show Data
section 4: Manipulating Data
- 1. Manipulate Data
section 5: Displaying Data
- 1. Where Clauses
- 2. Like Clauses
- 3. Sorting & Order Clauses
System developer- Java, PHP, C#, Python