Introduction
A database is a collection of organized data. If you want to be able to design a database, you have to learn database design. There are things you must know in a database design course. After learning how to design a database, you still have to learn how to implement the database in a computer. There is software called database server. This software is of different types. One of them is called, MySQL (pronounced Mee Sequel or My Sequel). MySQL is used to implement a database in a computer or in an Internet server (a main computer in the Internet). So, learning to implement a database in a computer means learning how to code (program) a database server such as MySQL. In any course there are things you must know. So, there are things you must know for a MySQL server course. In this post I introduce you to a database design and MySQL courses, all in one volume.
There are 3 series in the database design course as follows:
Database Essentials
In this short series, you will learn that a database consists of tables (tabulations). You will learn the possible relationships between tables and the special characteristics of the tables.
Designing Database Tables
The story of database design does not end with what you learn above. In this second series, you learn how to optimize the tables. Any table will not do for a database design. You have to learn how to design the tables in such a way that the data are not managed with errors and in a way that the tables will operate fast in the computer. All that is database optimization (or normalization).
Efficiency in Database Design
For what you must know in database design, the story ends in this very short series. The database has to occupy the smallest space in the computer hard disk. You have to mark certain table columns as index in order to increase speed of operation of the database. You also have to keep metadata, which is information about data; this will help you modify the database in future as the business changes.
After the above, you have to learn how to implement the database designed on paper, into a computer. For that I propose the MySQL server software. You will learn the following for the MySQL server:
Implementing Database in MySQL
This series teaches you how to code the tables into the MySQL server so that the tables and the whole database would be saved electronically (as electronic documents) in the computer hard disk.
Handling MySQL Events with Triggers and Procedures Using SQL
People will be using the database. Any action a user takes on the database in the computer, is an event. You learn how to handle that in this series.
MySQL Access Privileges
Is it anyone who has the right to use any table in a database? No. In this series, you learn how to give both the database programmers and ordinary users, rights to access certain tables and other issues of the database (MySQL implemented database).
MySQL Backup Basics
When the computer hosting your database gets bad, should you loose all your precious data? No. So, you need to learn how to backup the database in a device separated from the host computer. After repairing the computer, you re-load in the database from the backup copy; and life goes on.
MySQL Regular Expressions
There is a relatively new innovation in programming called, Regular Expressions. Regular expression techniques enable you to search and replace words in a string of text. In a set of strings, the techniques enable you to find which strings have a particular word, or phrase or text construct, automatically. There are other things the techniques enable you to do, with text. You learn the techniques for MySQL, in this series.
MySQL Dates
The date is not recorded into the MySQL server arbitrarily. You need to learn dating in MySQL server.
Event Scheduler
When will a piece of code execute at a certain time or regularly, without you causing (launching) the code to execute. This series takes care of that.
Syllabus
The above is the syllabus for what you must know in database design and MySQL server. It is enough for you to do wonderful things in the Internet and other networks, so far as database programming is concerned.