Oracle: Database Design and SQL Induction to the Online Environment Beginners
This course is an induction to the Oracle online environment for the Oracle: Database Design and SQL (Online) course. It provides a session of familiarisation for those who are new to this environment.
If you wish to attend this induction session please make a booking as well as booking onto the Oracle: Database Design and SQL (Online) course so that you will have access to the online environment during and after the induction session.
This induction session is free, there is a compulsory charge for access to the Oracle: Database Design and SQL (Online) course which will be requested at the time of booking on that course as follows:
- £50 for University departments
- £50 + VAT = £60 for colleges and private payments from University members
If you are already familiar with the online environment and would just like access to the online course please directly book onto the Oracle: Database Design and SQL (Online) course. Should you need to discuss this with us first, please contact training services.
If you have database design and SQL experience the most relevant course to enrol on would be the follow on course Oracle: Database Programming with PL/SQL (Online).
- All University members (departments and colleges)
- Further details regarding eligibility criteria are available
- Before booking on this induction session, please book on the Oracle: Database Design and SQL (Online) course
Number of sessions: 1
| # | Date | Time | Venue | Trainers | |
|---|---|---|---|---|---|
| 1 | Thu 14 Nov 2013 09:30 - 11:00 * | 09:30 - 11:00 * | University Information Services, Roger Needham Building, Ely Training Room 1 | map | Lynn Foot, Chris Quy |
Section 1
- Introduction to the Oracle Academy
- Conceptual & Physical Models
- Entity Relationship Diagramming
- Supertypes, Subtypes, and Business Rules Working With Entity Relationships
- Unique Identifiers and Normalization
- Arcs, Hierarchies, and Historical Data
- Project Presentation
- Modelling Change
- Drawing Conventions and Generic Modelling
- Transforming From Conceptual Model to Physical Model
- Introduction to SQL
- System Development Lifecycle
- SELECT Statements and Relational Database Technology
- Using the WHERE Clause
- Restricting Rows and Introduction to Functions
Section 2
- Using Character, Number, and Date Functions
- Using Single Row Functions
- Executing Database Joins
- Working With Group Functions
- Using Complex SQL with Aggregated Data
- Creating Subqueries
- Constructing DML Statements
- Working With DDL Statements
- Ensuring Quality Query Results
- Creating and Managing Constraints
- Creating and Managing Views
- Working With Sequences
- Fundamentals of Database Security
- Understanding Database Transactions
- Oracle Proprietary Join Syntax
- Final Project
- Ensuring Quality Query Results – Advanced Techniques
Presentations, demonstrations and practicals
- This induction session is free, there is a compulsory charge for access to the Oracle: Database Design and SQL (Online) course during and after the induction session. This which will be requested at the time of booking on that course as follows:
- £50 for University departments
- £50 + VAT = £60 for colleges and private payments from University members
- There is an eternal exam fee for those who wish to take it
One session of half a day
Booking / availability