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 10g
Course Information
| Start Date | Start Time | Duration | Cost | Course Code | Apply |
|---|---|---|---|---|---|
| Thursday 6 October 2011 | 18:30 - 20:30 | 10 weekly classes | £360.00 | CE1579 | Apply Now |
| Thursday 19 January 2012 | 18:30 - 20:30 | 10 weekly classes | £360.00 | CE1579 | Apply Now |
| Thursday 26 April 2012 | 18:30 - 20:30 | 10 weekly classes | £360.00 | CE1579 | Course Full |
Tutor Info
George K. Lekeas is a Visiting Lecturer with the Department of Computing in the School of Informatics and research collaborator with the University of Athens. He holds a Ph.D. in Computing and conducts research in the area of Multi-Agent Systems and Web Services. He taught extensively at all levels courses in software development methods, programming and software engineering in general (C#, C, C++, Unix, Systems Administration, PHP, Perl, Java, Oracle, MySQL, XML, CMS) and other computing areas. He, also, works as a freelance Unix and Web Scripting Languages consultant.
Eligibility
Strong computer literacy.
English Requirements
Applicants 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.