Oracle and SQL Short Courses
The Oracle and SQL short course teaches the basics of constructing and manipulating the gold-standard relational database - Oracle. You will learn how to create and populate database components such as tables and views, and enforce business rules with the use of appropriate constraints.
Software version: Oracle 11g
|Start Date||Start Time||Duration||Cost||Course Code||Apply|
|Thursday 18 October 2012||18:30 - 20:30||10 weekly classes||£390.00||CE1579||Course Cancelled|
|Thursday 24 January 2013||18:30 - 20:30||10 weekly classes||£390.00||CE1579||Apply Now|
|Thursday 2 May 2013||18:30 - 20:30||10 weekly classes||£390.00||CE1579||Apply Now|
Strong computer literacy.
English RequirementsApplicants must be proficient in written and spoken English.
What will I learn?
- Database management systems and the relational model
- Basic design and entity-relationship modeling
- The SQL*Plus environment: editing using the buffer and Oracle scripting
- Data manipulation language: select statements; filtering rows with where, using predicate logic (and, or and not operators)
- Using (inner, equi-) joins to extract data from more than one table
- Oracle functions and statements: text functions and conversion functions; nesting functions; the describe statement
- Report writing: formatting output using SQL and SQL*Plus
- Data definition language: creating tables, altering tables, dropping tables
- Data manipulation language: inserting, updating, deleting and copying rows in a table
- Views: creating views, describing views, dropping views
- SQL Aggregate functions, group by and having
- The SQL standard and Oracle-specific SQL; review of differences in key SQL statements between vendors.
By the end of the course, you will be able to:
- Use command-line based operating environments
- Understand the basic of database theory and design
- Manipulate and define data in tables using SQL
- Use effectively core features of Oracle's SQL*Plus utility
- Gain enough basic knowledge to explore and learn more SQL independently.