Introduction to SQL and Relational Databases with Oracle

Program Overview

This Oracle database course provides a comprehensive introduction to SQL and database management, covering concepts like entity modeling, SQL statements, and Oracle metadata. Led by industry professionals, the program offers online learning in small groups and awards a City, University of London certificate upon completion. It is ideal for individuals seeking to advance their careers in various sectors where database system management is a valuable skill.

Program Outline

Outline:

Utilizing the industry-standard Oracle Relational Database Management System, this short course instructs learners in database design and manipulation concepts encompassing:

• Entity modeling
• Normalization
• Table creation and integrity constraints
• SQL statements: joins, nested queries, group by
• Oracle metadata and security privileges
• Employing views and main principles in performance management
This highly sought-after Oracle database course serves as a leading introductory pathway into the realm of SQL and database management. It provides a comprehensive foundation in the subject and caters to individuals seeking a cohesive introduction to SQL and aiming to develop practical knowledge of Oracle.

Assessment:

Completion of over 70% of the class sessions leads to the award of an official City, University of London certificate. No formal accreditation is associated with the course. Assessment occurs informally through group discussions, classroom activities, and question-and-answer sessions guided by the tutor.

Teaching:

• Delivery Format: This short course is delivered online in the evenings, once per week, for a duration of 10 consecutive weeks.
The schedule is as follows: > Autumn term: October > Spring term: January > Summer term: April
• Faculty: The course is led by professionals from the sector and provides accessible, online learning in small groups.

Careers:

This program is ideal for individuals aiming to advance their careers across a spectrum of sectors, as database system management is a technical skill utilized across various industries.

Other:

• Starting Dates: Starting dates are confirmed upon the commencement of the program.
• Fees: The course fee is confirmed as £520.
• Location: The course is delivered online.
• Benefits: This program offers numerous benefits, including being led by industry professionals, accessible online learning in small groups, and the award of a City, University of London certificate upon successful completion.

Course Content:

• Database management systems and the relational model: Understanding the fundamental concepts of database management systems and how data is organized in a relational model.
• Basic database design and entity-relationship modeling: Learning how to design databases using entity-relationship modeling techniques to represent real-world entities and their relationships.
• The SQL Plus environment: Familiarizing yourself with the Oracle SQL Plus environment, the command-line interface used to interact with Oracle databases.
• Data manipulation language (DML): Mastering basic DML statements for selecting, filtering, joining, and manipulating data in relational databases.
• DML with joins: Employing joins to extract data from multiple related tables and create complex queries.
• Oracle functions and statements: Utilizing various Oracle functions and statements for data manipulation and processing.
• Report writing: Formatting output using SQL and SQL Plus to generate informative reports.
• Data definition language (DDL): Creating, altering, and dropping tables and other database objects.
• DML for inserting, updating, deleting, and copying data: Managing data within tables using INSERT, UPDATE, DELETE, and other DML statements.
• Views: Creating and managing views for simplified data access and security purposes.
• SQL aggregate functions and group by: Employing aggregate functions like SUM, AVG, and COUNT together with the group by clause to summarize data and generate reports.
• Understanding differences in SQL statements between vendors: Recognizing potential variations in SQL syntax and features across different database management systems.

Expected Learning Outcomes:

Upon successful completion of the course, participants will be able to:

• Operate confidently in command-line based operating environments.
• Grasp the core principles of database theory and design.
• Utilize SQL effectively to manipulate and define data in tables.
• Employ central features of Oracle's SQL Plus utility with efficiency.
• Gain substantial foundational knowledge to independently explore and learn more advanced SQL concepts.

Course Completion Requirements:

Participants are awarded an official City, University of London certificate upon attending over 70% of the class sessions. No formal accreditation is associated with the course. Assessment occurs informally through class discussions, classroom activities, and question-and-answer sessions as guided by the tutor.

Program Eligibility:

To be eligible for this program, strong computer literacy is essential.

English Language Requirements:

Applicants must possess proficiency in written and spoken English.

Tutor Profile:

• George K. Lekeas serves as a visiting lecturer at City, University of London in the Department of Computer Science within the School of Science & Technology.
Concurrently, he holds the position of Systems Administrator at University College London, where his responsibilities encompass administration of Office365 solutions, including SharePoint, and he collaborates with the University of Athens as a research collaborator.
• Dr. Lekeas' academic credentials include a PhD in Computing, and his research pursuits are concentrated within the domain of Multi-Agent Systems and Web Services.
• His extensive teaching experience includes courses at various levels covering software development methodologies, programming, and software engineering in general (C#, C, C++, Unix, Systems Administration, PHP, Perl, Java, Oracle, MySQL, XML, CMS, Web Services), alongside other computing topics.
He additionally contributes as a freelance Unix and web scripting languages consultant.