About this Course

This 2-day course will teach database professionals about using SQL (Structured Query Language) to access and manipulate database. Usage of SQL statements to add, delete, insert, retrieve and update data in a SQL database will be covered. 

*Upgrade Path / Next Recommended Course:

SQL Scripting (Advanced) - Checkout our promotional bundle

Course Outline:

Chapter 1: Introduction to SQL 

Chapter 2: SQL - SELECT Statement 

Chapter 3: SQL - WHERE Clause

Chapter 4: SQL – INSERT, UPDATE, DELETE Statement

Chapter 5: SQL – ORDER BY

Chapter 6: SQL – AND & OR Conditions

Chapter 7: SQL – IN & BETWEEN Operators

Chapter 8: SQL – Alias & Sub Queries

Chapter 9: SQL – JOIN & UNION Command 

Chapter 10: SQL – CREATE

Chapter 11: SQL – DROP & ALTER Statement 

Chapter 12: SQL – Syntax Function

Chapter 13: SQL – GROUP BY & HAVING Function

Chapter 14: SQL – SELECT INTO Statement

Chapter 15: SQL – CREATE VIEW Statement

Chapter 16: SQL – Syntax Summary

Prerequisite:

No prerequisite required. Some database concepts and basic programming knowledge an added advantage.

Certificate Of Attendance:

Certificate Of Attendance will be awarded to students completing the course.

Training Methodology & Materials:

Practical case study sessions to enhance concept.

Well-designed lab sessions to further enhance the understanding of the courseware given.

Training Duration:

Full-Time : 2 days         

Time : 9.30am - 5.30pm

Rate this course:

Log in to submit

Comments