Database Programming with SQL
Database Design and Programming with SQL – Course Description Overview This course engages participants helping them implement their database design by creating a physical database using SQL. Basic SQL syntax and the rules for constructing valid SQL statements are reviewed. This course culminates with a project that challenges students to implement and demonstrate a database solution for a business or organization.
|Study Type:||Part Time|
|Academic Level:||Not Applicable|
12 weeks (2.5 hours per week).
Start Date: October 2020 - Tuesdays at 6.00pm
• 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
• 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
• Oracle Nonequijoins and Outer Joins
• Using Group By and Having Clauses
• Using Rollup and Cube Operations, and Grouping Sets
• Using Set Operators
• Fundamentals of Subqueries
• Single-Row Subqueries
• Multiple-Row Subqueries
• Correlated Subqueries
• INSERT Statements
• Updating Column Values and Deleting Rows
• DEFAULT Values, MERGE, and Multi-Table Inserts
• Creating Tables
• Using Data Types
• Modifying a Table
• Intro to Constraints; NOT NULL and UNIQUE Constraints
• PRIMARY KEY, FOREIGN KEY, and CHECK Constraints
• Managing Constraints
• Creating Views
• DML Operations and Views
• Managing Views
Sequences and Synonyms
• Working with Sequences
• Indexes and Synonyms
Duration: 12 weeks
Tuition fees: £450
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.
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