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
-
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
-
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.
Basic
- Installation, Setup and Configuration
- Create Database, Understand Schema, Character Set
- Write Basic Data Queries
Data Manipulation Language (DML)
- Write Data Queries, Apply Conditions, Sorts and Patterns
- Compare Data in Queries
Data Definition Language (DDL)
- Create, Alter and Drop Data Tables
- Apply Constraints, Indexes, Defaults, Auto-increment
- Establish Data Relationships
- Create and Use Functions
View
- Create, Alter and Drop View
- Use View as Virtual Tables for Data Queries
Function
- Create and Use Stored Functions