About this Course

This course is a follow-up course on our highly popular Understanding SQL Scripting course.

In the Advanced SQL(Structured Query Language) course, you will create advanced SQL queries to manipulate and index tables. 

You will work with advanced queries to create and work with subqueries, creating and manipulating view and index tables. 

You will learn how to do Table Design, creating tables with Constraints and Backing Up Tables.

You will also create and committ transactions so that you can choose to save or cancel data entry process and learn rollback transactions.

You will also learn Database Security in creating & managing users, roles and privileges. 

Granting permissions to roles and modifying privileges.

Course Outline:

1. Advanced SQL Querying Using Subqueries

2. Advanced Data Manipulation Statement

3. Manipulating Table Structure

4. Working with Views

5. Indexing Data

6. Managing Transactions

7. Database Security - Roles & Privileges

Prerequisite:

Follow up course on Understanding Sql Scripting course.

Fundamental SQL and Relational Database knowledge required.

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 : 1 Day

Time : 9.30am - 5.30pm

Rate this course:

Log in to submit

Comments