- Exam(s) / assessment(s) not included in price, and must be purchased separately
Oracle Database 12c: SQL Fundamentals 1Z0-061
Gain an understanding of multitenant architecture and Cloud provisioning.
StudyOnline247
Summary
Overview
This course will teach students about multitenant architecture and Cloud provisioning using an Oracle Database. Students will also learn about the retrieval of data, data manipulation language, the combination of queries and SQL functions.
Certification
Oracle Database 12c Administrator Certified Associate
Description
What you will learn:
The structure of SQL
Creating objects in the database
Object privileges
Multi row functions
Conversion functions
Why study online?
Technological improvements and advances in educational design mean that studying online is no longer just a low cost alternative to traditional training methods. In many respects our online courses offer training which is superior to the majority of available “classroom” options.
Not only is the effectiveness of the training process enhanced, but also the convenience and overall cost efficiency of studying online makes it a compelling option for training. You can learn at your own pace and can repeat each section as many times as required unlike in a classroom environment.
Studying at your own pace, rewinding and going over the material as often as you need improves your long-term memory retention and makes studying more rewarding.
Curriculum for the Oracle 12c OCP 1Z0-061: SQL Fundamentals course:
Module 1: Introduction To Oracle 12c SQL
Introduction To Course
Intro To Oracle 12c SQL Fundamentals
Structure Of SQL
Basic Select Statements
Basic Select Statements Demo
Module 2: Retrieving Data
Modifying Reported Output
The Where Clause
The Order By Clause
Left And Right Outer Joins
The Where Clause Demo
Multi Table Selection Demo
Module 3: SQL Functions
Single Row Functions
Aggregate Functions
Single Row Functions Demo
Multi Row Functions Demo
Group By
Grouping Demo
Conversion Functions
Conversion Functions Demo
Date time Functions
Date time Functions Demo
Module 4: Subqueries
Single Row Subqueries
Single Row Subqueries Demo
Multi Row Subqueries
Multi Row Subqueries Demo
Other Subquery Types
Other Subquery Types Demo
Module 5: Data Manipulation Language
Adding Data
Changing Data
Deleting Data
DML Demo
Module 6: Data Control Language
Security
Object Privileges
DCL Demo
Module 7: Data Definition Language
Creating Objects In The Database
Creating Objects In The Database Demo
Sequences
Sequenced Demo
Indexes
Views
Module 8: Combining Queries
Combining Queries
Module 9: Oracle 12C SQL Fundamentals
Oracle 12c SQL Fundamentals Review - Part 1
Oracle 12c SQL Fundamentals Review - Part 2
Oracle 12c SQL Fundamentals Review - Part 3
Conclusion
Please note that the official exam is not included, however for those who complete the course, they will receive a completion certificate upon request.
Who is this course for?
Anyone that wishes to familiarise themselves with Oracle SQL fundamentals.
Requirements
There are no formal prerequisites to undertaking this course.
Career path
Database Administrator
Oracle Database Engineer
Database Specialist
Database Analyst
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.
FAQs
Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2024. All rights reserved.