What you'll learn:
- Understand the Basic Relational Database Management System Concepts
- Execute Basic to Advanced MySQL Queries
MySQL is a general purpose relational database management system (RDBMS) used mainly to provide a back-end database for web applications. In this course, we'll introduce the concepts of relational database management systems in general, and how they relate to MySQL in particular.
Unlike traditional courses that concentrate mainly on theory, we'll take a practical “how-to” approach to working with data. Here's what yyou'll learn:
Creating databases and tables
Adding data to a table with INSERT
Reading a table with SELECT
How to use WHERE to filter data
Using ORDER BY to sort data
JOINs and how to use them to read from multiple tables
Changing data in a table with UPDATE
The DELETE query: removing one or more rows of data from a table
Using a text file to load a database schema
These topics and many more will be covered. The concentration in this course is on MySQL itself… not on how to use it to for any particular purpose. But this course makes a great introduction to our upcoming course about web databases using php and MySQL. So why wait… sign up today!