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.

What Will I Learn?


Database fundamentals, database design, normalization. SQL statements like SELECT, INSERT, DELETE , UPDATE, WHERE clause, GROUP BY, Wildcards, Functions, Null keyword,sub-query, joins, unions, views, index.

Syllabus


Database Fundamentals

  1. What is a database? What is SQL?
  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 SQL
  3. How to query data using Where clause in SQ
  4. How to use Insert Into in SQL
  5. How to Delete & Update data in SQL

Data Sorting

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

Functions

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

Must Know Stuff!

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

Most Dreaded Topics!

  1. Using Sub-Queries in MySQL
  2. How to use Joins in SQL
  3. How to use Unions in SQL
  4. How to use Views in SQL
  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 is very important to us. Please tell us what you think of these tutorials - http://goo.gl/aPc4K