Databases can be found in almost all software applications. SQL is the standard language to query a database. This course will teach you database design. Also, it teaches you basic to advanced SQL.
What should I know?
The course is designed for SQL beginners. No prior DB experience is required.
| Tutorial ||What is a database? What is MySQL? |
| Tutorial ||Introduction to MySQL & MySQL workbench |
| Tutorial ||Introduction To Database Design |
| Tutorial ||Learn Database Normalization with the help of a case study |
| Tutorial ||Learn ER Modeling with a Case Study |
| Tutorial ||How To Create A Database & MySQL DataTypes |
| Tutorial ||How to use SELECT in MySQL |
| Tutorial ||How to query data using Where clause in MySQL |
| Tutorial ||How to use Insert Into in MySQL |
| Tutorial ||How to Delete & Update data in MySQL |
| Tutorial ||How sorting is done in MySQL using ORDER BY, DESC and ASC |
| Tutorial ||How to use Group By in MySQL |
| Tutorial ||How to use Wildcards in MySQL |
| Tutorial ||Using Regular Expressions & Wild Cards in MySQL |
Must Know Stuff!
| Tutorial ||Ultimate guide to Functions used in PHP |
| Tutorial ||How to use Aggregate Function in MySQL |
Most Dreaded Topics! What Next!
| Tutorial ||All about Null value & Keyword in MySQL |
| Tutorial ||How to use Auto Increment in MySQL |
| Tutorial ||How to use Alter, Drop & Rename function in MySQL |
| Tutorial ||How to use Limit keyword in MySQL |
| Tutorial ||Creating an Application using MySQL |