Oracle SQL And PL / SQL

Course for you to have a handshake with the most popular RDBMS, Oracle and the most famous Programming techniques in SQL.

Course Outline:

• Introduction To Oracle Database 
• Retrieve Data Using The SQL Select Statement 
• Learn To Restrict And Sort Data 
• Usage Of Single-row Functions To Customize Output 
• Invoke Conversion Functions And Conditional Expressions 
• Aggregate Data Using The Group Functions 
• Display Data From Multiple Tables Using Joins 
• Use Sub-queries To Solve Queries 
• The Set Operators 
• Data Manipulation Statements 
• Use Of Ddl Statements To Create And Manage Tables 
• Other Schema Objects 
• Control User Access 
• Management Of Schema Object 
• Manage Objects With Data Dictionary Views 
• Manipulate Large Data Sets 
• Data Management In Different Time Zones 
• Retrieve Data Using Sub-queries 
• Regular Expression Support 
• Introduction To Pl/SQL 
• Pl/SQL Identifiers 
• Write Executable Statements 
• Interaction With The Oracle Server 
• Control Structures 
• Composite Data Types 
• Explicit Cursors 
• Exception Handling 
• Stored Procedures And Functions 
• Create Stored Procedures 
• Create Stored Functions 
• Create Packages 
• Packages 
• Implement Oracle-supplied Packages In Application Development 
• Dynamic SQL 
• Design Considerations For Pl/sql Code 
• Triggers 
• Create Compound, Ddl, And Event Database Triggers 
• Pl/SQL Collections