About this course
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.
What are the requirements?
- Access to a computer with 2-4 GB of RAM is preferred
- any knowledge of prior programming would help, though not required
- Basic knowledge of installing/unintsalling software and other usual system tasks
What am I going to get from this course?
- Over 39 lectures and 8.5 hours of content!
- 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 :)
What is the target audience?
- Oracle Database developers
- Data analysts
- Software developers (java/.net/python) interacting with the Oracle Database
- BI and ETL developers
