Rating 3.6 out of 5 (107 ratings in Udemy)
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 …
Rating 3.6 out of 5 (107 ratings in Udemy)
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 :)
DescriptionCourse 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.
