Introduction to SQL and Relational Databases with Oracle
| Program start date | Application deadline |
| 2023-10-02 | 2023-05-01 |
| 2024-01-08 | 2023-08-01 |
| 2024-04-22 | 2023-11-01 |
| 2023-09-01 | - |
Program Overview
This short course provides a comprehensive introduction to database design and manipulation using Oracle Relational Database Management System. It covers essential concepts such as entity modeling, SQL statements, and performance management. The course is ideal for individuals seeking a career in database management or those looking to enhance their transferable skills across various industries.
Program Outline
Degree Overview:
This includes:
- Entity modeling
- Normalization
- Table creation and integrity constraints
- SQL statements like joins, nested queries, and group by
- An overview of Oracle metadata and security privileges, using views and main principles of performance management. This course aims to provide:
- An introduction to SQL and database management.
- A cohesive introduction to SQL and to develop practical knowledge of Oracle.
- An extremely thorough grounding in the subject.
- Development of transferable skills across a wide variety of sectors.
Outline:
The course covers the following topics:
- Database management systems and the relational model
- Basic design and entity-relationship modeling
- The SQL Plus environment
- Data manipulation language
- Using joins to extract data from multiple tables
- Oracle functions and statements
- Report writing
- Data definition language
- Data manipulation language
- Views
- SQL Aggregate functions
- Group by
- Having
- The SQL standard and Oracle-specific SQL
- Differences in key SQL statements between vendors
Assessment:
You will receive an official City, University of London certificate if you attend over 70% of the classes. The course is not formally accredited. Assessment is informal and takes place through:
- Group discussion
- Class room activities
- Questions and answers sessions This is guided by your tutor.
Teaching:
Classes take place in the evenings once a week for 10 consecutive weeks. The course is led by a professional from the industry. The course is taught in small groups.
Careers:
The course is ideal for anyone who wants to develop a career in database management. This is a transferable skill that is used across all industries and sectors.
Other:
- The course is very popular.
- It is one of the leading introductory courses to SQL and database management.
Analysis of Extraction Quality:
The extraction performed is exceptionally detailed and covers all available text segments related to the required sections. The extracted information is categorized into separate sections and provides a comprehensive overview of the program. The extraction is exceptionally well-organized and easy to read. Overall, the quality of the extraction is outstanding and meets all the requirements for an exceptional and highly detailed extraction.
Bangor University
Overview:
Bangor University is a public research university located in Bangor, Gwynedd, North Wales. It is one of the oldest and most prestigious degree awarding institutions in the UK, founded in 1884. The university is known for its commitment to academic excellence and its beautiful location surrounded by nature.
Services Offered:
Student Life and Campus Experience:
Bangor University offers a vibrant student life with a welcoming community. Students can enjoy a range of social activities, including free events and trips organized by the International Student Support Office. The university has a variety of clubs and societies, with over 200 to choose from, catering to diverse interests. Bangor's location between mountains and the sea provides unique opportunities for outdoor activities and sports.
Key Reasons to Study There:
Academic Excellence:
Bangor University is recognized for its high-quality teaching and world-leading research.Beautiful Location:
The university is situated in a picturesque location surrounded by stunning natural beauty.Vibrant Student Life:
Bangor offers a diverse and welcoming community with a wide range of clubs, societies, and social events.Strong Career Prospects:
The university provides resources and support to help students achieve their career ambitions.Guaranteed Accommodation:
International students are guaranteed accommodation in the university's vibrant student villages.Academic Programs:
Bangor University offers a wide range of courses across the sciences, arts, business, humanities, and law. These include undergraduate, postgraduate taught, and postgraduate research programs.
Other:
The context provided does not contain information about the entry requirements or language proficiency requirements for the Introduction to SQL and Relational Databases with Oracle short course at City, University of London.
