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.65 (2222 reviews)
13 356
students
19.5 hours
content
Dec 2024
last update
$89.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
Course Gallery
Loading charts...
2347206
udemy ID
01/05/2019
course created date
21/11/2019
course indexed date
Bot
course submited by