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|
If you are interested with this course, please register or call us as soon as possible.