Learn how to query and manage data in the Oracle Database Using SQL. Practical, concept-building examples and quizzes.
Video 8.5 hours
Skill Level Beginner Level
Includes Lifetime access
30 day money back guarantee!
Available on iOS and Android
Certificate of Completion
This introductory course teaches you how to work with data in your Oracle Database using Oracle’s proprietary SQL language. It starts with the basic overview of what SQL is all about and then covers basic queries and common things you might be expected to do on a job. We then proceed to learn complex queries and data management such as inserting/updating/deleting data.
All the SQL examples and the power point slides are available for download and there are a few exercises/queries at the end of each chapter for you to test your understanding. I’ll try and add more each week. At the end of the course, we also discuss some of the frequently asked questions in Oracle SQL to assess our understanding of the course and various topics and to understand some of the frequently asked interview questions.
The course should take about 2 weeks to complete, with 2-3 hours dedicated each day to go through the examples and work them out yourself.
Understand the different components of an Oracle Database and how it works
Connect to an Oracle Database and run queries from different tools or from a file
Write basic queries involving Select, where, group by and other constructs
Write complex queries involving multiple tables, joins, subqueries and other techniques
Manage data using DML (insert, delete, update) and transaction control statements
Answer most of the frequently asked questions that are asked in interviews 🙂
Oracle Database developers
Software developers (java/.net/python) interacting with the Oracle Database
BI and ETL developers