4.4 Read 7 reviews
Overview
What you will study
The SQL and Relational Databases with Oracle course offered by City St George's, 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
We did our best, but couldn't find the next application deadline and start date information online.
More details
Due to run in October; Booking is expected to open in August
Language
English
Delivered
Online
Campus Location
- London, United Kingdom
Disciplines
Data Science & Big Data View 49 other Short Courses in Data Science & Big Data in United KingdomWhat students do after studying
Join for free or log in to access our complete career info list.
Academic 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 Fees
Funding
Improve page content