Learning Outcomes:
You will also learn to use single row functions to customize output, use conversion functions and conditional expressions. Usage of group functions to report aggregated data is also covered in detail. Practical, hands-on exercises reinforce the fundamental concepts.
- Introduction to Oracle Database
- Retrieve Data using the SELECT statement, from a single table.
- Learn to Restrict and Sort Data in different ways
- Usage of Single-Row Functions to Customize Output
- Invoke Conversion Functions and Conditional Expressions
- Aggregate Data Using the the Group Functions
- Display Data from Multiple Tables Using Join Statement.
- Use Sub-queries to create simpler Queries
- The SET Operators to restrict different sets of data
- Data Manipulation Statements to modify data in the Oracle database
- Use of Data Definition Language (DDL Statements) to Create and Manage Tables
- Other Schema Objects
- Control User Access
- Management of Schema Objects
- Manage Objects with Data Dictionary Views
- Manipulate Large Data Sets within Oracle database
- Data Management in different Time Zones
- Retrieve Data Using Sub-queries in different ways
- Regular Expression Usage in Oracle
|
|
Course Objectives
You will also learn to use single row functions to customize output, use conversion functions and conditional expressions. Usage of group functions to report aggregated data is also covered in detail. Practical, hands-on exercises reinforce the fundamental concepts.
- Display data from Single Tables
- Display data from multiple tables using JOIN syntax.
- USe SQL functions to generate customized data.
- Create reports of aggregated data easily
- Use the SET operators to create subsets of data.
- Run data manipulation statements (DML) in Oracle Database 11g.
- Run data definition language (DDL) statements to create schema objects.
- Identify the major structural components of Oracle Database 11g.
- Retrieve data from tables, views
- Create reports of sorted and restricted data using specific SQL Syntax.
|
| You can call Vinai at (65) 6296 2995 or email to training@intellisoft.com.sg for any questions, or to register for the upcoming class of Oracle SQL Expert Certification Training. |
Click here to REGISTER ONLINE |
|
Please like us on Facebook