Introduction to SQL and relational databases with Oracle

Short course

In Islington

Price on request

Description

  • Type

    Short course

  • Location

    Islington

Using the industry-standard Oracle Relational Database Management System, the course teaches database design and manipulation concepts, including entity modelling, normalisation, table creation and integrity constraints and SQL statements such as joins, nested queries and group by. There is also an overview of Oracle metadata and security privileges, using views and main principles in performance management.Software version: Oracle 11g. Course Information Start DateStart TimeDurationCostCourse CodeApply Tuesday 4 October 2016 18:30 - 20:30 10 weekly classes £480.00 CS1579 Apply Now Thursday 19 January 2017 18:30 - 20:30 10 weekly classes £480.00 CS1579 Apply Now Thursday 4 May 2017 18:30 - 20:30 10 weekly classes £480.00 CS1579 Apply Now Tutor Info Sokratis Karkalas holds a BA in Education, a BSc in Economics, an MBA and an MSc in Computer Science. Nowadays he is working towards the completion of a PhD in artificial intelligence and educational technologies at Birkbeck, University of London. In parallel he works as a teaching assistant for Birkbeck and he is a member of the London Knowledge Lab. He has been working since 1991 both in the industry and in the academia holding various posts. He was a chief IT manager for a multi-national group of industrial companies for several years. He contributed as a scientific associate in large scale EU projects at the University of Thessaly in Greece. He has teaching experience in secondary, tertiary and vocational education for many years mainly teaching programming languages and related technologies (Assembly, C, C++, Pascal, Java, VB6, Excel VBA, Access VBA, Project VBA, VBScript, JavaScript, Windows Shell...

Facilities

Location

Start date

Islington (London)
See map
Northampton Square, EC1V 0HB

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Management
  • C++
  • Basic
  • IT
  • Basic IT training
  • Database Management
  • Database
  • SQL
  • Database training
  • Basic IT
  • Teaching
  • Design
  • University
  • Industry
  • IT Management

Course programme

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.

Additional information

Teaching and Assessment

Informal assessment will take place through group discussion, class room activities, and questions and answers sessions as guided by your tutor.

Introduction to SQL and relational databases with Oracle

Price on request