Oracle SQL for beginners
- 8 hours on-demand video
- 1 article
- 12 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- 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 :)
In this video, we take a look at some of the commonly used software that are used when working with the Oracle Database. Here's the list.
Oracle Database Server
Command line client tools (SQL*Plus)
IDEs (SQL Developer, Quest for Oracle, SQL Navigator and so on.
We also discuss a new term (Client-Server) which you might hear many times in the future when working with Database development or when working with a lot of other software like web servers.
In this video, we look at a new interesting way to set up your development environment using Oracle Virtual box and Developer VM.
virtual box : https://www.virtualbox.org/wiki/Downloads
Database application development VM : http://www.oracle.com/technetwork/community/developer-vm/index.html#dbapp
In this chapter we complete our understanding of the basic select statement by understanding a few more important concepts such as primary keys and column aliases. We also unlock a few other sample accounts that come with the Oracle Database, to be used in the upcoming chapters.
In this chapter we learn that each database object is owned by one (and only one)database user. We discuss grants, privileges and how one user can access another's objects. We complete our schema set up by making sure each user in our sample database has read access on all the other users' tables.
In this video, we focus on filtering the data based on our needs, using the "where clause" in SQL. Programming exercises are in the materials section.
In this section, we discuss some of the most commonly used Oracle date and time functions. We also understand how "function overloading" practically works. At the end, we look at two real-world examples of how we often need to use multiple functions together to achieve the desired result.
In this section, we discuss various oracle functions that help us easily convert data from one data type to another and functions that help us format data.
List of Oracle 11gr2 conversion functions
In this video, we start learning about joins. We look at how to identify the join columns and discuss inner-joins, which you can use to get matching data from 2 or more tables.
In this section, we take a look at the MODIFY statement in SQL and learn how to use it to modify attributes at the table level and column level.
In this section, we look at how to use the UPDATE clause in oracle to make changes to existing data in a table. We discuss different possible scenarios and how you can control which columns to update and which rows to update.
What do you do when you want to update or insert date in a table based on the input data? You use the "MERGE" command in oracle. It's a very interesting and powerful SQL Command.We'll take a look at a couple of reasonably advanced use cases and see how merge makes it so easy to implement them.
If you are using a VM or if your database instance is in IDLE state, you might see this error when trying to connect. This short video shows how you can fix it.
- 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
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.
- Oracle Database developers
- Data analysts
- Software developers (java/.net/python) interacting with the Oracle Database
- BI and ETL developers