1Z0-071 Oracle SQL Developer: Certified Associate (Database)
The SELECT statement, functions and more. Oracle Database 11g, 12c, 19c, 21c using Oracle SQL Developer. 1Z0-071 exam.
4.52 (2182 reviews)
13,078
students
19.5 hours
content
Dec 2024
last update
$84.99
regular price
What you will learn
Create tables in a database and ALTER columns in the table.
Know what data type to use in various situations, and use functions to manipulate date, number and string data values.
Retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
JOIN two or more tables together, finding missing data.
INSERT new data, UPDATE and DELETE existing data, and export data into a new table.
Create constraints, views and sequences, subqueries and CTEs
Use UNION, CASE, MERGE and error checking
Apply ranking and analytic functions, grouping
Learn about transactions, indexes, users, privileges, roles and more
Screenshots
2347206
udemy ID
5/1/2019
course created date
11/21/2019
course indexed date
Bot
course submited by