Understanding SQL Scripting iEnabler Singapore
Price: AED 1,521

    Course details

    • 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

    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

    Updated on 08 November, 2015

    Database Management Related Questions

    Are you from iEnabler Singapore ? Claim your course!
    Courses you can instantly connect with... Do an online course on Database Management starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?

    or