Structured Query Language (SQL)

Structured Query Language (SQL) course is offered by CtrlIAI Soft Tech and Consulting for all skill level. We strongly believe that your success lies in choosing right learning paths, add value to your CV with needed certifications and getting prepared for tricky circumstances. Our goal is to improve one’s Capability, Productivity and Performance.

Structured Query Language:

• Introduction-Explaining the brief history of SQL
• The SELECT Statement
• The SELECT Statement
• Functions
• SQL Clauses
• SQL Joins
• SQL Joins in detail with Examples
• Sub Queries
• Data manipulation
• Creating and Managing Tables)
• Creating Views and Indexes
• Transactions Controlling
• DB Security
• Advanced topics in SQL
• SQL and its Dynamic Uses
• Improving Performance-Streamlining SQL Statements
• Use Views and Retrieve information from the Data Dictionary
• Generate SQL Statements
• PL/SQL:An Introduction
• Transact-SQL:An Introduction
• SQL*Plus
• Common SQL Mistakes/Errors and Resolutions

PLSQL

• Introduction
• Conventions
• PLSQL fundamentals
• Variables/Program Data
• SConditional control and Sequential Control
• Loops
• DB Interaction
• Cursors in PL/SQL
• Named Program Units
• Triggers
• Packages
• Calling PL/SQL Functions in SQL
• Oracle’s Object Oriented Features
• Collections
• External Procedures
• Java Language Integration