SQL 101: SQL Programming for Beginners

Description
Students will learn Structured Query Language (SQL) to define a relational database and store data records, write queries to manipulate the data records including retrieve, update, delete, insert, find etc., understand and use constraints to enforce data integrity and establish entity-relationship among the data records, understand and use indexes to expedite search performance, learn join technique to retrieve information from multiple data tables, use sub-queries to conduct sequential data mining etc. Note: the course duration include class time and practice/exercise time.
Duration
20 hours
(4 days)
Fees (US$)
Online:
$975.00
Classroom:
$975.00
Customized:
$1,575.00
Objectives
-
To learn basic data manipulations: query, insertion, update, delete
-
To learn basic data definitions: create, change and drop database objects like dataabse, table, views etc
-
To learn basic data security, access priviliges and roles
-
To understand and use indexes
-
To understand and use constraints
-
To learn, understand and use query joins
-
To learn, understand and use views as virtual tables
Prerequisites
-
Basic Windows OS knowldge such as file explorer, software installation, service start/stop/restart etc. Lunix/Unix knowledge or experience is a plus but not required.
Contents
Basic
- Installation, Setup and Configuration
- Create Database, Understand Schema, Character Set
- Create Database Tables
- Import Data
- Write Basic Data Queries
Data Manipulation Language (DML)
- Write Data Queries, Apply Conditions, Sorts and Patterns
- Compare Data in Queries
- Join Data Sets
Data Definition Language (DDL)
- Create, Alter and Drop Data Tables
- Apply Constraints, Indexes, Defaults, Auto-increment
- Establish Data Relationships
- Create and Use Functions
- Create and Use Views
View
- Create, Alter and Drop View
- Use View as Virtual Tables for Data Queries
Function
- Create and Use Stored Functions