Oracle Database SQL Certified Associate 1Z0-071
Become Oracle SQL Certified ( OCA ) / Covers ORACLE university track 100%. All the presentations + scripts are attached
4.54 (8378 reviews)
34,948
students
20 hours
content
May 2024
last update
$129.99
regular price
What you will learn
The Full track of Oracle Database 12c: Introduction to SQL Ed 2.
You will be prepared 100% to pass exams Oracle Database SQL 1Z0-071 And also exam Oracle Database 12c: SQL Fundamentals 1Z0-061
Very strong introduction to make you understand the oracle database and RDBMS.
Oracle Database 12c Architecture
Downloading and installing oracle database 12c in details
Connecting to the Database
Retrieving data using the select statement / Restricting and Sorting Data
Substitution Variables
Using Single-Row Functions to Customize Output
Reporting Aggregated Data Using the Group Functions
Displaying Data from multiple tables using joins
Using Subqueries to Solve Queries
Using the Set Operators
Managing tables using DML Statments ( Insert, Update, Delete )
Data Definition Language / Creating tables
Data Dictionary Views
Creating sequences, synonyms, and indexes
Creating Views in details
Managing Schema Objects
Retrieving Data By Using Subqueries
Manipulating Data By Using Subqueries
Controlling User Access in details
Manipulating Data
Managing Data in Different Time Zones
Exam information / Exams Details / Exam Practice
many other information, you can see the full curriculum
Screenshots
Related Topics
1312042
udemy ID
8/3/2017
course created date
10/12/2019
course indexed date
Bot
course submited by