Free SQL Tutorials

Class 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 advance SQL.

What should i know?


The course is designed for SQL beginners. No prior DB experience is required.


Syllabus


Database Fundamentals

  1. What is a database? What is MySQL?
  2. Introduction to MySQL & MySQL workbench

Database Design

  1. Introduction To Database Design
  2. Learn Database Normalization with the help of a case study
  3. Learn ER Modeling with a Case Study

SQL Basics

  1. How To Create A Database & MySQL DataTypes
  2. How to use SELECT in MySQL
  3. How to query data using Where clause in MySQL
  4. How to use Insert Into in MySQL
  5. How to Delete & Update data in MySQL

Data Sorting

  1. How sorting is done in MySQL using ORDER BY, DESC and ASC
  2. How to use Group By in MySQL
  3. How to use Wildcards in MySQL
  4. Using Regular Expressions & Wild Cards in MySQL

Functions

  1. Ultimate guide to Functions used in PHP
  2. How to use Aggregate Function in MySQL

Must Know Stuff!

  1. All about Null value & Keyword in MySQL
  2. How to use Auto Increment in MySQL
  3. How to use Alter, Drop & Rename function in MySQL
  4. How to use Limit keyword in MySQL

Most Dreaded Topics!

  1. Using Sub-Queries in MySQL
  2. How to use Joins in MySQL
  3. How to use Unions in MySQL
  4. How to use Views in MySQL
  5. How to use Index in MySQL

What Next!

  1. Creating an Application using MySQL

comments powered by Disqus
Search

Follow Us!

Feedback

Your Feedback & Ideas are very important to us. Please share your suggestions here