Study at City
  1. Courses
  2. Applying
  3. Fees and funding
  4. Living in London
  5. Visit us
  6. Student support
  7. International students
  8. Order a prospectus
  1. Short courses
  2. Courses
Study at City

Introduction to SQL and relational databases with Oracle Short Course

Key information

Choose a start date
Days:
To be confirmed
Duration:
To be confirmed
Time:
To be confirmed
Fees:
To be confirmed
Course Code:
To be confirmed
Location:
To be confirmed
Booking Deadline:
To be confirmed
To be confirmed

Oracle is a world-leading object-relational database management system. Since its first release in the late 70s, Oracle has been at the forefront of database management systems.

Why choose this course?

This very popular Introduction to SQL and Relational Databases with Oracle short course is a leading introductory course into the world of SQL and database management.

It provides an extremely thorough grounding in the subject and is aimed at those looking for a cohesive introduction to SQL and to develop practical knowledge of Oracle.

The short course is ideal for anyone looking to develop their career across a wide variety of sectors. Although a technical skill, database system management is used across all industries and sectors.

Classes take place in the evenings once a week for ten weeks, in our central London location.

Course overview

Using the industry-standard Oracle Relational Database Management System, the short course teaches database design and manipulation concepts, including:

  • Entity modelling
  • Normalisation
  • Table creation and integrity constraints
  • 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.
  • “ Excellent presentation and materials ”

    John

    Former student

  • “ Sokratis is a great teacher ”

    Priyant

    Former student

What will I learn?

What will I learn?

  • Database management systems and the relational model;
  • Basic design and entity-relationship modelling;
  • 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.

Eligibility

Eligibility

Prerequisite knowledge

Strong computer literacy.

English requirements

You must be proficient in written and spoken English.

Teaching & assessment

Teaching & assessment

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

Tutor information

  • George K. Lekeas

    George K. Lekeas is a visiting lecturer at City, University of London in the Department of Computer Science in the School of Mathematics, Computer Science & Engineering. He is also working as a Systems Administrator with University College London, where part of his duties includes administration of Office365 solutions, including SharePoint, and is a research collaborator with the University of Athens.

    He holds a PhD in Computing and conducts research in the area of Multi-Agent Systems and Web Services.

    He has taught courses at all levels in software development methods, programming, and software engineering in general (C#, C, C++, Unix, Systems Administration, PHP, Perl, Java, Oracle, MySQL, XML, CMS, Web Services) and other areas of computing. He also works as a freelance Unix and web scripting languages consultant.