Oracle Database Design and Programming with SQL
This covers the Data Modelling and Database Development process and the models that are used at each phase of the lifecycle. Learn through interactive instruction and hands-on exercises.
On successful Completion of the Fundamentals of Modelling course you will be able to:
- Understand Relational Database Concepts
- Understand Types of Databases Models
- Understand Gathering Requirements for Database Design
- Understand the Stages of Database system Development
- Understand Oracle Database Development Tools
- Retrieve row and column data from tables with the SELECT statement
- Create reports of sorted and restricted data
- Employ SQL to generate and retrieve customised data
- Display data from multiple tables using the ANSI SQL 99 JOIN syntax
- Create reports of aggregated data
- Use the SET operators to create subsets of data
- Run data manipulation statements (DML) to update data in the Oracle Database
Oracle Database Design and Programming with SQL eLearning
- Brand: Weblearning Publishing
- Product Code: Oracle Database Design and Programming with SQL
- Reward Points: 600
- Availability: In Stock
- £79.99
-
£59.99