Oracle 12c OCP 1Z0-061: SQL Fundamentals


Add to wishlist

    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.

    Course Syllabus

    Module 1: Introduction To Oracle 12c SQL Fundamentals

    1. Introduction
    2. Intro To Oracle 12c-SQL Fundamentals
    3. Structure Of SQL
    4. Basic Select Statements
    5. Basic Select Statements Demo

    Module 2: Retrieving Data

    1. Modifying Reported Output
    2. The Where Clause
    3. The Order By Clause
    4. Left And Right Outer Joins
    5. The Where Clause Demo
    6. Multi-Table Selection Demo

    Module 3: SQL Functions

    1. Single Row Functions
    2. Aggregate Functions
    3. Single Row Functions Demo
    4. Muiltrow Functions Demo
    5. Group By
    6. Grouping Demo
    7. Conversion Functions
    8. Conversion Functions Demo
    9. Datetime Functions
    10. Datetime Functions Demo

    Module 4: Subqueries

    1. Single-Row Subqueries
    2. Single-Row Subqueries Demo
    3. Multi-Row Subqueries
    4. Multi-Row Subqueries Demo
    5. Other Subquery Types
    6. Other Subquery Types Demo

    Module 5: Data Manipulation Language

    1. Adding Data
    2. Changing Data
    3. Deleting Data
    4. DML Demo

    Module 6: Data Control Language

    1. Security
    2. Object Privileges
    3. DCL Demo

    Module 7: Data Definition Language

    1. Creating Objects In The Database
    2. Creating Objects In The Database Demo
    3. Sequences
    4. Sequenced Demo
    5. Indexes

    Module 8: Combining Queries

    1. Combining Queries

    Module 9: Oracle 12C SQL Fundamentals Review

    1. Oracle 12c SQL Fundamentals Review – Part 1
    2. Oracle 12c SQL Fundamentals Review – Part 2
    3. Oracle 12c SQL Fundamentals Review – Part 3
    4. Conclusion

    Who this course is for:

    Candidates for the Oracle Database 12c: SQL Fundamentals (OCA) exam are developers, database administrators, system analysts, and functional implementers with familiarity with data process concepts and techniques, and programming languages. This certification is a prerequisite to Oracle Database 11g Administrator Certified Associate, Oracle PL/SQL Developer Certified Associate, and Oracle Database 12c Administrator Certified Associate.

    Prepare for the Oracle Certified Associate Oracle Database 12c SQL Fundamentals I exam with this Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-061, including:

    1. Data retrieval using the SQL SELECT statement
    2. Restricting and sorting data
    3. Single-row functions
    4. Using conversion functions and conditional expressions
    5. Reporting aggregated data with the group functions
    6. Displaying data from multiple tables with joins
    7. Using subqueries to solve problems
    8. Using the set operators
    9. Manipulating data with DML statements
    10. Using DDL statements to create and manage tables

    Electronic content includes:

    1. 150+ practice exam questions with detailed answers and explanations
    2. Score report performance assessment tool
    3. PDF copy of the book

    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.

    What you’ll learn

    1. The Full track of Oracle Database 12c: Introduction to SQL Ed 2.
    2. You will be prepared 100% to pass exams Oracle Database SQL 1Z0-071 And also exam Oracle Database 12c: SQL Fundamentals 1Z0-061
    3. Very strong introduction to make you understand the oracle database and RDBMS.
    4. Oracle Database 12c Architecture
    5. Downloading and installing oracle database 12c in details
    6. Connecting to the Database
    7. Retrieving data using the select statement / Restricting and Sorting Data


    There are no reviews yet.

    Be the first to review “Oracle 12c OCP 1Z0-061: SQL Fundamentals”

    Your email address will not be published. Required fields are marked *