4.2 Read 58 reviews
Overview
What you will study
The SQL and Relational Databases with Oracle course offered by City, University of London 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.
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.
Programme Structure
The program focuses on:
- 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.
Key information
Duration
- Part-time
- 2 months
Start dates & application deadlines
- Starting
- Apply before
-
- Starting
- Apply before
-
Language
English
Delivered
Online
Disciplines
Data Science & Big Data View 43 other Short Courses in Data Science & Big Data in United KingdomAcademic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
- 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.
- Applicants must be proficient in written and spoken English.
Tuition Fee
To always see correct tuition fees
-
International
520 GBP/fullTuition FeeBased on the tuition of 520 GBP for the full programme during 2 months. -
National
520 GBP/fullTuition FeeBased on the tuition of 520 GBP for the full programme during 2 months.
Funding
Improve page content