Understanding SQL Scripting

Course details

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

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.

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