FPL-103: SQL Programming for Beginners

Description
You will learn Structured Query Language (SQL) to define relational databases and manipulate data records, write basic data queries, work with views, understand and use indexes, join multiple data tables or use sub-queries to retrieve desired information etc.
Duration
40 hours
(8 days)
Fees
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
- Write Basic Data Queries
- Import Data
Data Manipulation Language (DML)
- Write Data Queries, Apply Conditions, Sorts and Patterns
- Compare Data in Queries
- Join Data Sets
Data Definition Language (DDL)
- Apply Constraints, Indexes, Defaults, Auto-increment
- Establish Data Relationships
- Create, Alter and Drop Data Tables
- 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