Oracle Database 12c Administrator Certified Associate: 1Z0-071: Oracle Database 12c SQL
Certification Exam:
- 14 Courses | 13h 11m 27s
- 5 Books | 64h 9m
- Includes Lab
- Includes Test Prep
- 17 Courses | 16h 29m 28s
- Includes Test Prep
Discover essential database management skills as you prepare for the Oracle Database 12c Administrator Certified Associate certification.
GETTING STARTED
Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
-
1m 54s
-
3m 3s
COURSES INCLUDED
Oracle Database Instance Overview
To work with Oracle database instances, you must understand the new multitenant architecture in Oracle Database 12c. Explore the memory, process, and storage architectures and how they work together.
14 videos |
1h 7m
Assessment
Badge
Managing a Database Instance
Discover how to get started with Oracle Database 12c, configure initialization parameters, start up a database instance, work with log files, and use the various database views.
14 videos |
1h 14m
Assessment
Badge
Connecting to & Configuring a Database Instance
One key aspect of administering Oracle Database 12c includes managing client connections to database servers. Discover how to manage Oracle Net Services and server configurations.
8 videos |
39m
Assessment
Badge
Connectivity & Space Management
Optimizing how data is stored in Oracle Database 12c conserves space and improves system performance. Explore tablespaces and data files, and learn how to manage the space used by data blocks and segments.
15 videos |
1h 17m
Assessment
Badge
Undo Feature Overview
An Oracle Database 12c administrator will, at some point in time, need to roll back changes made to the database. Learn how this is done using the Undo feature in Oracle Database 12c.
5 videos |
25m
Badge
User Security Features & Configuration
Securing an Oracle Database 12c system involves controlling who can access the database and what they can do. Learn how to manage privileges, and use roles, profiles, quotas, and password security to make your databases secure.
13 videos |
1h 5m
Assessment
Badge
Auditing Features & Configuration
Monitoring database access is part of the process involved in securing an Oracle Database 12c system. Discover how to detect and resolve lock conflicts, and how to enable and manage auditing of database activity.
14 videos |
59m
Assessment
Badge
Backing Up & Recovering Data
A key responsibility of an Oracle database administrator is protecting databases from failure. Learn how to back up and recover databases, how to migrate and load data, and how to work with external tables in Oracle Database 12c.
17 videos |
1h 20m
Assessment
Badge
Importing & Exporting Data
An Oracle database administrator is responsible for ensuring data is secure and available. Explore working with Oracle data, including data migration, the Oracle Data Pump, SQL*Loader files, and external tables.
11 videos |
48m
Assessment
Badge
Database Maintenance
Oracle Database 12c includes many features that simplify routine database maintenance and performance tuning. Learn how to configure and use the automated database monitoring and maintenance features available in Oracle Database 12c.
11 videos |
40m
Assessment
Badge
Performance Tuning
Performance tuning is an important aspect of Oracle Database 12c administration. Learn how to monitor and tune both database and memory performance in Oracle Database 12c.
15 videos |
1h 5m
Badge
SQL Tuning
Proper monitoring and tuning of databases significantly improves system performance. Learn how to use SQL tuning, optimizer statistics, and the range of SQL advisors included in Oracle Database 12c.
10 videos |
53m
Assessment
Badge
Resource Management
Ensure efficient database performance by taking advantage of tuning tools available in Oracle Database 12c. Discover how to manage resources to optimize performance, including working with Resource Manager and monitoring statistics.
8 videos |
45m
Assessment
Badge
Job Scheduling
Keep your database performing efficiently by increasing your knowledge of Oracle Database 12c performance tuning, including how to use the Oracle Scheduler to create and schedule jobs.
9 videos |
48m
Assessment
Badge
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Explore the introductory concepts of working with Oracle Database 12c, including relational database management concepts and terminologies and Oracle Live SQL.
10 videos |
49m
Assessment
Badge
Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control Language
Once an Oracle 12c relational database has been created with objects, the data in these objects needs to be managed. Discover how to insert, update, delete, and truncate rows.
12 videos |
59m
Assessment
Badge
Oracle Database 12c R2 SQL: Using Basic SELECT statements
Explore how to retrieve data using SQL SELECT statements including arithmetic expressions, NULL values, column aliases, and literal strings. You will also learn how to deal with duplicate rows.
12 videos |
59m
Assessment
Badge
Oracle Database 12c R2 SQL: Conversion Functions & Conditional Expressions
Frequently when retrieving data stored in an Oracle database, the data needs to be converted, manipulated, or aggregated. Discover Oracle conversion functions and conditional expressions.
13 videos |
1h 6m
Assessment
Badge
Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables
Explore how to join tables together to view information across multiple tables and examine the more advanced features of the SELECT statements.
11 videos |
1h 6m
Assessment
Badge
Oracle Database 12c R2 SQL: Using the Set Operators
Discover how to write SQL queries by using set operators.
8 videos |
40m
Assessment
Badge
Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views
Explore the basics of data dictionary views. Discover how to create views on tables. Synonyms, sequences, and indexes, and how to create them is also covered.
6 videos |
34m
Assessment
Badge
Oracle Database 12c R2 SQL: Managing Schema Objects
Explore how to work with constraints and alter existing objects in Oracle Database 12c. Working with external tables and naming an index at time of creating a PRIMARY KEY constraint is also covered.
13 videos |
1h 11m
Assessment
Badge
Oracle Database 12c R2 SQL: Data Definition Language (DDL)
Explore how to create a table and work with the various constraints associated with a table in Oracle Database 12c.
12 videos |
1h 2m
Assessment
Badge
Oracle Database 12c R2 SQL: SQL*Plus
SQL*Plus is an interactive and batch query tool that is installed with every Oracle server and client installation. This course will teach you the features and functionality of SQL*Plus.
8 videos |
45m
Assessment
Badge
Oracle Database 12c R2 SQL: Restricting & Sorting Data
Database tables hold a large number of rows, which are often not sorted in any specific order. Learn how to selectively return only a subset of rows, sorted and customized.
12 videos |
59m
Assessment
Badge
Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize Output
Database tables may hold a large number of rows, which are often not sorted in any specific order. Discover how to selectively return only a subset of table rows, sorted and customized.
13 videos |
1h 10m
Assessment
Badge
Oracle Database 12c R2 SQL: Reporting Aggregated Data Using Group Functions
Discover how to obtain summary information, such as averages, for groups of rows in SQL. Explore how to group rows in a table into smaller sets and how to specify search criteria for groups of rows.
12 videos |
1h 6m
Assessment
Badge
Oracle Database 12c R2 SQL: Using Subqueries to Solve Queries
Subqueries are very useful when you need to select rows from a table with a condition that depends on the data in the table itself. Explore the types, syntax, and guidelines for using subqueries in Oracle.
11 videos |
1h 22m
Assessment
Badge
Oracle Database 12c R2 SQL: Creating Other Schema Objects
Explore the basics of creating and using sequences and views in Oracle Database 12c SQL.
12 videos |
49m
Assessment
Badge
Oracle Database 12c R2 SQL: Controlling User Access
Discover how to control database access to specific objects and add new users with different levels of access privileges.
11 videos |
37m
Assessment
Badge
Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries
Discover how to use the DEFAULT keyword in INSERT and UPDATE statements. Multitable INSERT statements, the MERGE statement, performing flashback operations, and tracking changes are also covered.
11 videos |
1h 7m
Assessment
Badge
SHOW MORE
FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.BOOKS INCLUDED
Book
OCA: Oracle Database 12c Administrator Certified Associate Study Guide (Exams 1Z0-061 and 1Z0-062)Authored by an industry expert with hands-on Oracle database experience, this comprehensive guide not only helps you prepare for the challenging 1Z0-061 and 1Z0-062 exams, but also prepares you for the day-to-day work world of a database administrator.
18h 42m
By Biju Thomas
Book
Beginning Oracle Database 12c Administration: From Novice to Professional, Second EditionYour entry point into a successful and satisfying career as an Oracle Database Administrator, this thorough guide will provide you not only technical information, but also guidance on work practices that are as vital to your success as are your technical skills.
5h 50m
By Ignatius Fernandez
Book
Pro Oracle Database 12c Administration, Second EditionTaking a results-oriented approach to getting things done, this book gives clear explanations on how to perform critical tasks and weaves in theory where necessary without bogging you down in unneeded detail to lay a foundation upon which to build a senior level of expertise.
13h 28m
By Darl Kuhn
Book
OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063)Including examples, practice questions, chapter summaries, and a two-minute drill to reinforce essential knowledge in each chapter, this Oracle Press guide covers all of the exam objectives on the Installation and Administration, SQL Fundamentals, and Advanced Administration exams in detail.
16h 14m
By Bob Bryla, John Watson, Roopesh Ramklass
Book
OCA Oracle Database 12c Installation and Administration Exam Guide (Exam 1Z0-062)Featuring challenging exercises, certification summaries, two-minute drills, and self-tests within each chapter to reinforce the topics presented, this authoritative resource helps you prepare for and pass the exam, and also serves as an essential, on-the-job reference.
9h 55m
By John Watson
SHOW MORE
FREE ACCESS
SKILL BENCHMARKS INCLUDED
Oracle Database 12c Administrator Certified Associate: RDBMS Concepts Literacy (Beginner Level)
The RDBMS Concepts Literacy benchmark measures whether a learner has fundamental knowledge of RDBMS concepts such as theoretical and physical aspects of a relational database, and retrieving and restricting data. A learner who scores high on this benchmark demonstrates that they have the skills to write basic SQL queries to retrieve and perform basic analysis of the data.
18m
| 18 questions
Oracle Database 12c Administrator Certified Associate: SQL Competency (Intermediate Level)
The SQL Competency benchmark measures whether a learner has had exposure to data analysis using SQL including tasks such as retrieving data, sorting and ordering the retrieved data, fetching data from multiple tables, grouping and aggregating data, applying functions and conditional expressions, and writing complex queries using subqueries. A learner who scores high on this benchmark demonstrates that they have essential data management and analysis skills.
22m
| 22 questions
Oracle Database 12c Administrator Certified Associate: SQL Proficiency (Advanced Level)
The SQL Proficiency benchmark measures whether a learner has exposure and experience in advanced data analysis using SQL such as fetching data from multiple tables, grouping and aggregating data, applying functions and conditional expressions, writing complex queries using subqueries, creating schema objects, controlling user access, and manipulating data using advanced queries. A learner who scores high on this benchmark demonstrates that they have the essential data management and analysis skills to perform data analysis independently.
22m
| 22 questions
