In this fantastic course you will learn the SQL query language for the MySQL Engine. We will install MySQL with PhpMyAdmin to make learning as easy as possible. This course will teach you all about database relationships, creating tables, selecting data, inserting data, updating data, deleting data, subqueries and joining multiple tables together. Taught by a professional freelance software engineer with a 1st class bachelors degree in Computer Science and over 13 years experience you cannot go wrong with this course! By the end of this course you will understand SQL very well and should have no trouble passing your university level assignments

Free Lessons
In this lecture you will learn how to install MySQL engine and PhpMyAdmin web interface
In this lecture we will discuss database internals so you can grasp how databases work
Course Timeline:
In this lecture you will learn how to install MySQL engine and PhpMyAdmin web interface
In this lecture we will discuss database internals so you can grasp how databases work
In this lecture you will learn how to create database tables and we will then add data to the database using the SQL Query Language
In this lecture you learn how to select data from the database with the SQL Query language. This allows you to bring back data from your database and access it
In this lecture you learn how to update existing data in the database using the SQL Query Language
In this lecture we will start our very own medical database
Here we learn about database relationships and why they are important
This lecture covers using SQL to join data and tables
This lecture shows you how you can order your data in ascending or descending order when reading it
Sometimes you no longer need information anymore, well why not delete it in SQL using the DELETE keyword. This lecture shows you how to do that
Subqueries allow you to have a query within a query and can be incredibly useful when used properly

Course Reviews:

Average Rating 0
0 Ratings
Details
5 Stars 0
4 Stars 0
3 Stars 0
2 Stars 0
1 Stars 0

No reviews yet.