Enquiry Form

    Complete the form below to receive more details about this course.





    Yes, I’d like Study247.co.uk to contact me via email and phone about course-related topics. Please read our privacy notice for more information.


    0844 264 3600
    nformation.

    Buying for Your Team ?

    You can buy this course for your colleague or members of your team by selecting the number of users you require and adding the course to your shopping basket.

    Once we received your order, we’ll send you a learner’s details spreadsheet to enter your learner’s details.

    Oracle Database 12c SQL Fundamentals

    Oracle Database 12c SQL Fundamentals

    Teachers
    Study247
    Category:
    Oracle Courses/
    Original price was: £295.00.Current price is: £99.00.
    Oracle Database 12c SQL Fundamentals

    Trusted by professionals from some of the world's leading companies

    Original price was: £295.00.Current price is: £99.00.

    Bulk Discounts

    Bigger orders = better discounts

    Courses Discount
    3 - 14 10%
    15 - 49 20%
    50 - 99 30%
    100 - 999 40%

    Enquire
    Duration: 35 Hours
    Awarded By : Oracle
    Access : 12 Months
    Type : Online Course
    Eligible to Apply : Yes
    Learn How It Works Book Your Exam Buying for your team?

    Course Description

    Oracle Database technology is used by the world's leading companies to manage critical business functions, systems and processes.

    • Oracle Database is the number one database in the world.
    • Over 305,000 top companies trust their critical systems to Oracle Database.
    • Oracle Database is the number one embedded database technology.

    Over 50,000 IT professionals per year become certified on Oracle Database.

    With Oracle Database 12c: SQL Fundamentals, you experience the benefits of an Oracle Database that is re-engineered for Cloud computing. Multitenant architecture brings enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning. Oracle Database 12c: SQL Fundamentals certifications emphasize the full set of skills that DBAs need in today's competitive marketplace.

    This course will provide learner with everything that is needed to pass the Oracle 12c OCP 1Z0-061: SQL Fundamentals.

    Certification Details

    In order to earn your certification, you’ll have to sit an exam after completing your course with us. To prepare you for your exam, we provide interactive quizzes after each module and a mock exam at the end of your course to ensure you’re fully prepared for the real thing. Once you’ve passed with at least 85%, you’ll be ready to book your exam as a private candidate.

    Booking your exam is pretty simple, just purchase your exam voucher and schedule your exam. To make life easier, we can help you find an appropriate exam centre and give you all the information you need to secure your place.

    Please note that the exam fees aren’t included in the course price.

    Got a question about exams? Contact one of our course advisors. We’re happy to help!

    Requirements

    Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.

    For the best viewing experience on our state-of-the-art eLearning platform we recommend an internet connection of 10Mbps or better. Please also use Google Chrome or Mozilla Firefox as your browser with Adobe Flash Player.

    Get Certified with Study247 today!

    It’s simple, effective and affordable.

    Course Outline

    Course Syllabus

    Module 1 Introduction To Oracle 12c SQL
    Fundamentals

    • 1.1 Introduction To Course
    • 1.2 Intro To Oracle 12c SQL Fundamentals
    • 1.3 Structure Of SQL
    • 1.4 Basic Select Statements
    • 1.5 Basic Select Statements Demo

    Module 2 Retrieving Data

    • 2.1 Modifying Reported Output
    • 2.2 The Where Clause
    • 2.3 The Order By Clause
    • 2.4 Left And Right Outer Joins
    • 2.5 The Where Clause Demo
    • 2.6 MultiTable Selection Demo

    Module 3 SQL Functions

    • 3.1 Single Row Functions
    • 3.2 Aggregate Functions
    • 3.3 SingleRow Functions Demo
    • 3.4 MultiRow Functions Demo
    • 3.5 Group By
    • 3.6 Grouping Demo
    • 3.7 Conversion Functions
    • 3.8 Conversion Functions Demo
    • 3.9 Datetime Functions
    • 3.10 Datetime Functions Demo

    Module 4 Subqueries

    • 4.1 SingleRow Subqueries
    • 4.2 SingleRow Subqueries Demo
    • 4.3 MultiRow Subqueries
    • 4.4 MultiRow Subqueries Demo
    • 4.5 Other Subquery Types
    • 4.6 Other Subquery Types Demo

    Module 5 Data Manipulation Language

    • 5.1 Adding Data
    • 5.2 Changing Data
    • 5.3 Deleting Data
    • 5.4 DML Demo

    Module 6 Data Control Language

    • 6.1 Security
    • 6.2 Object Privileges
    • 6.3 DCL Demo

    Module 7 Data Definition Language

    • 7.1 Creating Objects In The Database
    • 7.2 Creating Objects In The Database Demo
    • 7.3 Sequences
    • 7.4 Sequenced Demo
    • 7.5 Indexes
    • 7.6 Views

    Module 8 Combining Queries

    • 8.1 Combining Queries

    Module 9 Oracle 12C SQL FundamentalsReview

    • 9.1 Oracle 12c SQL Fundamentals Review-Part 1
    • 9.2 Oracle 12c SQL Fundamentals Review-Part 2
    • 9.3 Oracle 12c SQL Fundamentals Review-Part 3
    • 9.4 Conclusion
    Career Path

    We've put together a list of relevant job titles you can apply for after achieving the Oracle Database 12c SQL Fundamentals certification (note that some careers may require further study, training and/or work experience):

    • Database Administrator
    Training Features

    • Flexible Learning

      Study247 anytime, anywhere on any device.

    • World Class E-learning Platform

      Study in a user friendly, state-of-the-art e-learning platform.

    • Expert Instructor-Led Training

      Access step-by-step video tutorials delivered by leading industry experts.

    • Visual Demonstrations & Multimedia Presentations

      Develop your skills based on real world scenarios.

    • Quizzes & Mock Exam

      Interactive quizzes after each module and a mock exam at the end of your course to ensure you're fully prepared for your final certification exam.

    • Flash Cards & Educational Games

      Allow you to train in ways that keep you engaged and focus.

    • Social Learning & Networking

      Interact and collaborate with other students, form study groups, engage in discussions, rate different courses and stay up to date with all the latest industry knowledge.

    • Navigation & Controls

      Allows you to study in bite-size chunks. You can pause, rewind or fast forward your tutorials, take study notes and more.

    Need Practical Experience?

    As a bolt-on option, we offer Practice Labs as it provides users with an online lab platform to develop their practical skills in IT technologies such as CompTIA, Microsoft, Cisco and VMWare.

    In addition to the hardware you require, you also gain access to high quality practical exercises covering exam topics to help you to maximize your study time and increase your results. Practice Labs are highly effective and offer a cheaper alternative to setting up your own test environment.

    You will gain unlimited access to the Practice Labs for 12 months- helping you to consolidate your learning and prepare you for work. Learn More

    Apply for an XO Student Discount Card

    When you enrol on a course with us, you automatically qualify for an XO student discount card which will enable you to enjoy savings from not only high street retailers, bars and restaurants, but also travel companies across the United Kingdom. Learn More

    Want to try before you buy?

    Start a FREE 2-days trial

    No credit card details required. No contracts. No obligations.

    Get Started Today