Reference SQL

SQL Tutorial for Beginners:

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

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
Tutorial	Oracle MySQL 5.6 Certification with Study Guide
Tutorial	SQL vs MySQL: What's the Difference?
Tutorial	20 Best SQL Management Tools
Tutorial	Top 50 SQL Interview Questions & Answers
Tutorial	SQL Tutorial for Beginners PDF

PostgreSQL Tutorial:

Course Syllabus

Tutorial	What is PostgreSQL? Introduction, History, Features, Advantages
Tutorial	How to Download and Install PostgreSQL on Windows
Tutorial	PostgreSQL Data Types
Tutorial	PostgreSQL CREATE DATABASE with Example
Tutorial	PostgreSQL DROP DATABASE with Example
Tutorial	How to Create & Drop Table in PostgreSQL [Example]
Tutorial	PostgreSQL Create, Alter, Add, Drop USER
Tutorial	PostgreSQL Select: Distinct, Order By, Limit
Tutorial	PostgreSQL Array: Functions, Type, Example
Tutorial	PostgreSQL BETWEEN with Example
Tutorial	PostgreSQL IN, Not IN with Examples
Tutorial	PostgreSQL LIKE, Not Like, Wildcards (%, _ ) Examples
Tutorial	PostgreSQL EXISTS with Examples
Tutorial	PostgreSQL DELETE Row matching 1/2 Condition, Exits Example
Tutorial	PostgreSQL ALTER Table: ADD Column, Rename Column/Table Examples
Tutorial	PostgreSQL SUBSTRING() with Example
Tutorial	PostgreSQL Union, Union ALL with Examples
Tutorial	PostgreSQL Joins: Inner, Outer, Left, Right, Natural with Examples
Tutorial	PostgreSQL Create View with Example
Tutorial	PostgreSQL Trigger: Create, Drop Example
Tutorial	PostgreSQL vs MySQL: What's the Difference?

Oracle PL/SQL Tutorial for Beginners:

Oracle PL/SQL is an extension of SQL language, designed for seamless processing of SQL statements enhancing the security, portability, and robustness of the database. This PL/SQL online programming course explains some important aspect of PL SQL language like block structure, data types, packages, triggers, exception handling, etc.

Here is what we cover in the Course

Tutorial	What Is PL/SQL? Introduction & Architecture
Tutorial	SQL Vs. PL/SQL Vs T-SQL: Key Differences
Tutorial	PL/ SQL Block: STRUCTURE, Syntax, ANONYMOUS Example
Tutorial	PL/SQL First Program: Hello World Example
Tutorial	Oracle PL/SQL Data Types: Character, Number, Boolean, Date, LOB
Tutorial	Oracle PL/SQL Variable Identifiers Tutorial with Examples
Tutorial	Oracle PL/SQL Collections: Varrays, Nested & Index by Tables
Tutorial	Oracle PL/SQL Records Type with Examples
Tutorial	Oracle PL/SQL IF THEN ELSE Statement: ELSIF, NESTED-IF
Tutorial	Oracle PL/SQL: CASE Statement with Examples
Tutorial	Oracle PL/SQL LOOP with Example
Tutorial	Oracle PL/SQL FOR LOOP with Example
Tutorial	Oracle PL/SQL WHILE LOOP with Example
Tutorial	Oracle PL/SQL Stored Procedure & Functions with Examples
Tutorial	Oracle PL/SQL Exception Handling: Examples to Raise User-defined Exception
Tutorial	Oracle PL/SQL Insert, Update, Delete & Select Into [Example]
Tutorial	Oracle PL/SQL Cursor: Implicit, Explicit, Cursor FOR Loop [Example]
Tutorial	Oracle PL/SQL BULK COLLECT: FORALL Example
Tutorial	Autonomous Transaction in Oracle PL/SQL: Commit, Rollback
Tutorial	Oracle PL/SQL Package: Type, Specification, Body [Example]
Tutorial	Oracle PL/SQL Trigger Tutorial: Instead of, Compound [Example]
Tutorial	Oracle PL/SQL Object Types Tutorial with EXAMPLES
Tutorial	Oracle PL/SQL Dynamic SQL Tutorial: Execute Immediate & DBMS_SQL
Tutorial	Nested Blocks & Variable Scope in Oracle PL/SQL Tutorial [Example]
Check	PL/SQL Interview Questions
Tutorial	PL/SQL Tutorial for Beginners PDF