Topics

Introduction

• Oracle Application Express

• Relational Database Technology

• Anatomy of an SQL Statement

SELECT and WHERE

• Columns, Characters, and Rows

• Limit Rows Selected

• Comparison Operators

WHERE, ORDER BY, and Intro to Functions

• Logical Comparisons and Precedence Rules

• Sorting Rows

• Introduction to Functions

Single Row Functions Part I

• Case and Character Manipulation

• Number Functions

• Date Functions

Single Row Functions Part II

• Conversion Functions

• NULL Functions

• Conditional Expressions

JOINs

• Cross Joins and Natural Joins

• Join Clauses

• Inner versus Outer Joins

• Self-Joins and Hierarchical Queries

• Oracle Equijoin and Cartesian Product

• Oracle Nonequijoins and Outer Joins

Group Functions

• Group Functions

• Oracle Nonequijoins and Outer Joins

• Using Group By and Having Clauses

• Using Rollup and Cube Operations, and Grouping Sets

• Using Set Operators

Subqueries

• Fundamentals of Subqueries

• Single-Row Subqueries

• Multiple-Row Subqueries

• Correlated Subqueries

DML

• INSERT Statements

• Updating Column Values and Deleting Rows

• DEFAULT Values, MERGE, and Multi-Table Inserts

DDL

• Creating Tables

• Using Data Types

• Modifying a Table

Constraints

• Intro to Constraints; NOT NULL and UNIQUE Constraints

• PRIMARY KEY, FOREIGN KEY, and CHECK Constraints

• Managing Constraints

Views

• Creating Views

• DML Operations and Views

• Managing Views

Sequences and Synonyms

• Working with Sequences

• Indexes and Synonyms

Duration: 12 weeks

Fees for Academic Year 2020/21 Entry

Tuition fees: £450

Concession: NO
Government Subsidised: NO
Student Loan Available: NO

Please note: Fees are for 2020/21 entry and are for home and EU students of all ages. For more information about financial support for students, please click here.

You will need to have at least a basic knowledge of databases.

Disclaimer:

This Nescot College website describes the facilities and courses which the College intends to offer during the academic year commencing Autumn 2020. The web pages are prepared in advance of the academic year to which they relate and every effort has been made to ensure that the information contained in these pages is helpful, fair and accurate at the time of printing. However, this information is subject to change over time.

Nescot will take reasonable steps to provide the courses and services as described, however, the College cannot guarantee the provision of any course or facility. Some circumstances, such as staff changes, resource limitations and other factors over which the College has no control, such as industrial action or a change in the law or the level of demand for a particular programme or module (please note that this list is non-exhaustive), may result in the College having to withdraw or change aspects of the programmes, modules and/or student services detailed on the website. This could include, but not necessarily be limited to, programme/module content, staffing, the location where the programme/module is taught or the manner of teaching delivery, and the facilities provided to deliver or support the programme. Where circumstances demand an unavoidable change or where it is necessary for the College to discontinue a programme of study, Nescot will take all reasonable steps to minimise the effect and all proposed changes will be notified to potential applicants who have registered an interest in the relevant programme at the earliest possible opportunity as well as being reflected on the College’s website. In addition, any changes between the website and the proposed course and services will be notified to applicants at the time of making an offer.

All prices quoted may be subject to change and you will be notified of any such change when any offer of a place is made to you by Nescot.

Should you become a student of the College, this notice shall be a term of any contract between you and Nescot. Any offer of a place at the College shall be subject to the student enrolment conditions and the College’s rules and regulations as amended from time to time. A copy of the Nescot’s current terms and conditions can be obtained in writing from Nescot, Quality Office, Reigate Road, Ewell, Epsom, Surrey, KT17 3DS.

Last updated – 27/05/20