Oracle SQL for beginners
What you'll learn
- 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 :)
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
Description
Course Summary
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.
Who this course is for:
- Oracle Database developers
- Data analysts
- Software developers (java/.net/python) interacting with the Oracle Database
- BI and ETL developers
Instructor
About the company :
A Data Guru (http://adata.guru) is an attempt at creating a learning community around all things data. To be job ready, learning one particular language or one skill usually is not sufficient and the same is true about data.
On a usual day, most analysts, databsae developers/engineers and data scientists work on SQL, work with BI tools, look at ETL code, use EXCEL and do much more.
Our attempt is at creating a resource that will help you be industry ready for a career in data. Stay tuned!