In a world where business units are becoming more self sufficient and knowledgeable about managing their overall processes through the use of technology, it becomes extremely important to identify the value of data and its interaction. Raw data needs to be manipulated into information that can be used for checking performance, setting strategies and for decision making. SQL is a data definition and data manipulation language for relational databases. By using SQL it is possible to create a database, load it with data and read ft update both data and data definitions.
Expected Accomplishments
- Create and maintain Oracle tables
- Insert, update, delete data from Oracle tables
- Produce complex queries
- Format queries in to Reports
Course Outline
- Introduction to SQL
- Data Dictionary
- The SELECT statement
- Substitution variables
- Functions
- Sub-queries
- Joining tables
- Report formatting
- Views
- Users, privileges and synonyms, security
- Data manipulation
- Table bcking
- Nested functions
- Advanced SQL *Plus techniques
- SQL *P!us performance tuning, using Explain Plan
Who Can Benefit
- Anyone who handles large volumes of data.
Related Training
- Oracle DBA: Administration Workshop I
- Oracle DBA: Program with PL/SQL
Mode
- Consultant led classes including theory and lab practicals.
Prerequisites
- Knowledge of the basic concepts and terminology of relational database management system and operating system
Twitter
Studied or Worked here? Share Your Review
Please do not post:
Thank you once again for doing your part to keep Edarabia the most trusted education source.