SQL (Structured Query Language)
SQL is the most popular database management system used for web projects as well as for accessing and manipulating data in relational databases. It is recognized by most desktop and enterprise database systems. This course will teach the participant all of the features of SQL as it relates to developers of web/mobile applications and websites.
3 days - $1,895.00
Course taught by an expert Computer Coding Instructor.
Prerequisites:
Basic computer literacy and previous experience with command-line programs are required. Some knowledge of database concepts, data retrieval and reporting would also be beneficial.
Course Outline
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)
SELECTs
Comments
Whitespace and Semi-colons
Case Sensitivity
Selecting All Columns in All Rows
Exploring the Tables
Selectinging Specific Columns
Selectinging 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
Aggregate Functions and Grouping
Aggregate Functions
Grouping Data
Selecting Distinct Records
Built-in Data Manipulation Functions
Common Math Functions
Common String Functions
Common Date Functions
Data Manipulation Functions
Subqueries, Joins and Unions
Joins
Joins
Table Aliases
Multi-table Joins
Using Joins
Outer Joins
Unions
Union ALL
Union Rules
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
Dropping Tables
Views
Creating Views InnoDB
Dropping Views
Benefits of Views
Stored Procedures
Creating Stored Procedures
Dropping Stored Procedures
Creating a Stored Procedure
Benefits of Stored Procedures
