• Home
  • Testing
  • SAP
  • Web
  • Must Learn!
  • Big Data
  • Live Projects
  • Blog

Training Summary


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.


Training Syllabus


Database Fundamentals
Tutorial What is a database? What is MySQL?
Tutorial Introduction to MySQL & MySQL workbench
Database Design
Tutorial Introduction To Database Design
Tutorial Learn Database Normalization with the help of a case study
Tutorial Learn ER Modeling with a Case Study
SQL Basics
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
Data Sorting
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

Functions

Tutorial Ultimate guide to Functions used in PHP
Tutorial How to use Aggregate Function in MySQL
Must Know Stuff!
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
Most Dreaded Topics!
Tutorial Using Sub-Queries in MySQL
Tutorial How to use Joins in MySQL
Tutorial How to use Unions in MySQL
Tutorial How to use Views in MySQL
Tutorial How to use Index in MySQL
What Next!
Tutorial Creating an Application using MySQL