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.
City University of London
Overview:
City, University of London is a public research university located in London, England. It is known for its focus on business, practice, and the professions, offering a wide range of undergraduate and postgraduate programs. The university is renowned for its strong academic reputation and its commitment to providing students with a high-quality learning experience.
Services Offered:
City University of London provides a comprehensive range of services to its students, including:
Library Services:
Access to extensive library resources, including books, journals, databases, and online resources.Moodle:
An online learning platform for accessing course materials, submitting assignments, and communicating with instructors.Email:
A university-provided email account for official communication.Staff Directory:
A searchable directory of staff members and their contact information.Term Dates:
Information on the academic year and term dates.Room Booking:
A system for booking rooms on campus for meetings, events, and other purposes.Schools and Departments:
Information on the various schools and departments within the university.Student Life and Campus Experience:
City University of London offers a vibrant and diverse student experience, with a strong emphasis on:
London Experience:
The university's location in London provides students with access to a wide range of cultural, social, and professional opportunities.Sports:
A variety of sports clubs and facilities are available for students to participate in, both competitively and non-competitively.Social Activities and Groups:
Numerous student societies and groups cater to diverse interests, providing opportunities for social interaction and personal development.Student Wellbeing:
The university offers a range of support services to ensure students' health and wellbeing, including learning support, personal tutoring, and counseling.Career Development:
The university provides career guidance and support services to help students prepare for their future careers.Key Reasons to Study There:
Strong Academic Reputation:
City University of London is consistently ranked highly in national and international rankings.Focus on Business, Practice, and the Professions:
The university's programs are designed to provide students with the skills and knowledge they need to succeed in their chosen careers.Location in London:
The university's location in the heart of London provides students with access to a wealth of opportunities.Vibrant Student Life:
City University of London offers a diverse and engaging student experience.Excellent Career Support:
The university provides comprehensive career guidance and support services.Academic Programs:
City University of London offers a wide range of academic programs across various disciplines, including:
Business and Management:
Bayes Business School is renowned for its programs in finance, accounting, marketing, and entrepreneurship.Law:
The City Law School is a leading institution for legal education, offering programs in law, international law, and legal practice.Health and Psychological Sciences:
The School of Health & Psychological Sciences offers programs in nursing, midwifery, psychology, and other health-related fields.Science and Technology:
The School of Science & Technology offers programs in computer science, engineering, mathematics, and other STEM fields.Communication and Creativity:
The School of Communication & Creativity offers programs in journalism, media, performing arts, and language studies.Other:
Merger with St George's:
City University of London has merged with St George's, University of London, forming a new institution called City St George's, University of London.Awards and Accreditations:
The university has received numerous awards and accreditations for its teaching, research, and commitment to equality and diversity.Global City:
City University of London is a global institution with a strong international presence.University of London:
City University of London is a member of the University of London, a federation of 18 independent colleges and institutes.Entry Requirements
Entry requirements vary depending on the course of study you are pursuing at City. Please ensure to refer to its website for the most updated and comprehensive information regarding the specific details and criteria for any given program.
This includes both entry and language proficiency requirements for both European Union (EU) and international applicants.
At present, however, the information you seek appears to be unavailable from the provided context. If you provide specific details concerning the exact course program you desire entry requirements for, I can then offer you a more targeted and thorough response regarding admission. Please note that it is essential to consult official sources to ensure accuracy and relevance to your precise circumstances.
