The SELECT statement, functions and more. Oracle Database 11g, 12c, 19c, 21c using Oracle SQL Developer. 1Z0-071 exam.
Instructed by Phillip Burton 19 hours on-demand video, 30 articles & 16 downloadable resources
After completing the course, you will…
-
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
Who this course is for:
- This SQL course is meant for you, if you have not used Oracle SQL Database much (or at all), and want to learn SQL.
- This course is also for you if you want a refresher on SQL. However, no prior Oracle SQL Database knowledge is required.
Similar Udemy Course Coupons
- The Complete Oracle SQL Bootcamp (2024)
- The Complete Oracle SQL Certification Course
- Oracle Database 12c SQL Certified Associate 1Z0-071
- Advanced SQL : The Ultimate Guide
Deal Score0
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.