1Z0-071 Learn Oracle SQL: prepare for Certified Associate

1Z0-071 Learn Oracle SQL: prepare for Certified Associate, Learn about the SELECT statement, DDL, DML, functions + more using Oracle SQL Developer. For Oracle Database 11g to 19c.

• BESTSELLER
• Created by Phillip Burton
• English
• English

PREVIEW THIS COURSE - GET COUPON CODE

What you'll 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
• Requirements
• You need to know how to use a computer, and hopefully know how to use a spreadsheet.
• No prior knowledge of Oracle SQL Database or any other database required - although the more knowledge you do have, the better.
• Oracle SQL Database cannot easily be installed on the Mac OS. If you wish to install it on a Mac, you will need either to dual boot into Windows or be running Parallel Desktop.
• You don't even need Oracle SQL Database installed - I'll show you have to install it on your computer for free!
• There is a 30-day money back guarantee of this Udemy course.
• Why not have a look at the curriculum below and see what you can learn?