SQL Programming Online for beginners by Intek Technologies

Relational Database Basics

» Brief History of SQL
» Relational Databases
» Tables
» Rows
» Columns
» Relationships
» Datatypes
» Primary Keys
» Foreign Keys
» Relational Database Management System
» Popular Databases
» Commercial Databases
» Popular Open Source Databases
» Valid Object References
» SQL Statements
» Database Manipulation Language (DML)
» Database Definition Language (DDL)
» Database Control Language (DCL)

Simple SELECTS

» Introduction to the Northwind Database
» Some Basics
» Comments
» Whitespace and Semi-colons
» Case Sensitivity
» SELECTing All Columns in All Rows
» Exploring the Tables
» SELECTing Specific Columns
» Sorting Records
» Sorting By a Single Column
» Sorting By Multiple Columns
» Sorting By Column Position
» Ascending and Descending Sorts
» Sorting Results
» The WHERE Clause and Operator Symbols
» Checking for Equality
» Checking for Inequality
» Checking for Greater or Less Than
» Checking for NULL
» WHERE and ORDER BY
» Using the WHERE clause to check for equality or inequality
» Using the WHERE clause to check for greater or less than
» Checking for NULL
» Using WHERE and ORDER BY Together
» The WHERE Clause and Operator Words
» The BETWEEN Operator
» The IN Operator
» The LIKE Operator
» The NOT Operator
» More SELECTs with WHERE
» Checking Multiple Conditions
» AND
» OR
» Order of Evaluation
» Writing SELECTs with Multiple Conditions

Advanced SELECTs

» Calculated Fields
» Concatenation
» Mathematical Calculations
» Aliases
» Calculating Fields
» Aggregate Functions and Grouping
» Aggregate Functions
» Grouping Data
» Selecting Distinct Records
» Working with Aggregate Functions
» Built-in Data Manipulation Functions
» Common Math Functions
» Common String Functions
» Common Date Functions
» Data Manipulation Functions

Subqueries, Joins and Unions

» Subqueries
» Joins
» Table Aliases
» Multi-table Joins
» Using Joins
» Outer Joins
» Unions
» UNION ALL
» UNION Rule
» Working with Unions

Conditional Processing with CASE

» Using CASE
» Working with CASE

Inserting, Updating and Deleting Records

» INSERT
» Inserting Records
» UPDATE
» DELETE
» Updating and Deleting Records

Creating and Modifying Tables

» Data Types
» Creating Tables
» NULL Values
» Primary Keys
» Foreign Keys
» Creating Tables
» Adding and Dropping Columns
» Renaming Tables
» SQL Server
» Oracle and MySQL
» Dropping Tables

Views

» Creating Views
» Dropping Views
» Benefits of Views
» Creating a View

Stored Procedures

» Creating Stored Procedures
» Dropping Stored Procedures
» Creating a Stored Procedure
» Benefits of Stored Procedures