SGD 799.00
Details
This 3-day course covers :
1. Understanding SQL Scripting / 2 Days
2. Advanced SQL Scritping / 1 Day
1. Understanding SQL Scripting / 2 Days
2. Advanced SQL Scritping / 1 Day
This course teaches 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.
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.
For more details,
http://www.ienabler.com.sg/Sql_scripting_course_singapore/sqlscript.asp
Online Registration,
http://www.ienabler.com.sg/register.asp
For more details,
http://www.ienabler.com.sg/Sql_scripting_course_singapore/sqlscript.asp
Online Registration,
http://www.ienabler.com.sg/register.asp
Outline
Understanding SQL Scripting / 2 Days
1. Introduction to SQL
2. SQL - SELECT Statement
3. SQL - WHERE Clause
4. SQL – INSERT, UPDATE, DELETE Statement
5. SQL – ORDER BY
6. SQL – AND & OR Conditions
7. SQL – IN & BETWEEN Operators
8. SQL – Alias & Sub Queries
9. SQL – JOIN & UNION Command
10. SQL – CREATE
11. SQL – DROP & ALTER Statement
12. SQL – Syntax Function
13. SQL – GROUP BY & HAVING Function
14. SQL – SELECT INTO Statement
15. SQL – CREATE VIEW Statement
16. SQL – Syntax Summary
Advanced SQL Scripting / 1 Day
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
For more details,
http://www.ienabler.com.sg/Sql_scripting_course_singapore/sqlscript.asp
Online Registration,
http://www.ienabler.com.sg/register.asp
1. Introduction to SQL
2. SQL - SELECT Statement
3. SQL - WHERE Clause
4. SQL – INSERT, UPDATE, DELETE Statement
5. SQL – ORDER BY
6. SQL – AND & OR Conditions
7. SQL – IN & BETWEEN Operators
8. SQL – Alias & Sub Queries
9. SQL – JOIN & UNION Command
10. SQL – CREATE
11. SQL – DROP & ALTER Statement
12. SQL – Syntax Function
13. SQL – GROUP BY & HAVING Function
14. SQL – SELECT INTO Statement
15. SQL – CREATE VIEW Statement
16. SQL – Syntax Summary
Advanced SQL Scripting / 1 Day
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
For more details,
http://www.ienabler.com.sg/Sql_scripting_course_singapore/sqlscript.asp
Online Registration,
http://www.ienabler.com.sg/register.asp
Reviews
Be the first to write a review about this course.
Write a Review
IT Enabler is incorporated in Singapore in year 2002. We aim to be a One-Stop IT Training Centre for aspired IT Professionals and IT Technopreneurs. We aim to bring the level of IT expertise from ground zero to the intermediate and advanced levels. We are offering our most successful flagship course Cisco Certified Network Associate CCNA with an impressive passing mark of over 90%. Some classes even achieved 100% passes.
We conduct courses like CCNA-R&S, CCNA Security, CCNP-R&S, CCNP Security, CCDA, CCDP, MCSA, MCSE, ITIL Foundation, VBA Excel, VBA Access, SQL Scripting, SQL Server Database Administration, SQL Server Database Query, Website Design, E-Commerce and Setting up Shopping Cart, Wordpress, HTML5 with Javascript and CSS3, Mobile Appns Development - Android, IOS, Windows, etc.
At iEnabler, we place the trainees/participants' interest at the highest priority.
We conduct courses like CCNA-R&S, CCNA Security, CCNP-R&S, CCNP Security, CCDA, CCDP, MCSA, MCSE, ITIL Foundation, VBA Excel, VBA Access, SQL Scripting, SQL Server Database Administration, SQL Server Database Query, Website Design, E-Commerce and Setting up Shopping Cart, Wordpress, HTML5 with Javascript and CSS3, Mobile Appns Development - Android, IOS, Windows, etc.
At iEnabler, we place the trainees/participants' interest at the highest priority.