SQL 101: SQL Programming for Beginners

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.
20 hours
(4 days)
Fees (US$)
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.
- 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
- Create, Alter and Drop View
- Use View as Virtual Tables for Data Queries
- Create and Use Stored Functions