Oracle Database SQL Workshop
This course is a combination of Oracle Database: SQL Workshop I and Oracle Database: SQL Workshop II courses. The Oracle Database SQL Workshop course provides step-by-step instructions on how to use a combination of database modelling and development techniques to address your business challenges.
On successful Completion of the Fundamentals of Modelling course you will be able to:
- Identify the major structural components of the Oracle Database
- Create reports of aggregated data
- Write SELECT statements that include queries
- Retrieve row and column data from tables
- Run data manipulation statements (DML) in Oracle Database 12c
- Create tables to store data
- Utilize views to display data
- Control database access to specific objects
- Manage schema objects
- Display data from multiple tables using the ANSI SQL 99 JOIN syntax
- Manage objects with data dictionary views
- Write multiple-column sub-queries
- Employ SQL functions to retrieve customized data
- Use scalar and correlated sub-queries
- Create reports of sorted and restricted data
Oracle Database SQL Workshop Training Guide
- Brand: Weblearning Publishing
- Product Code: Oracle Database SQL Workshop Training Guide
- Reward Points: 600
- Availability: In Stock
- £29.99
-
£19.99
Related Products
Tags: Database Management, Oracle Database, SQL