Oracle SQL for beginners

Learn how to query and manage data in the Oracle Database Using SQL. Practical, concept-building examples and quizzes.

4.05 (117 reviews)
Udemy
platform
English
language
Databases
category
Oracle SQL for beginners
695
students
8.5 hours
content
Nov 2016
last update
$59.99
regular price

What you will 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 :)

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.

Content

Introduction to the course and Promo video

Important stuff about the course

Setting up the environment

Tools of the trade - Introduction
Client Server
Oracle virtual box and developer VM
Setting up the database in the VM
Alternatives to Virtual Machine
SQL*Plus

(Select part 1) Let's write some SQL! Selecting data

Select statement : The very basics
Basic Select and Describe
Data Types
Data types Quiz
Aliases, Primary keys and unlocking other accounts
Chapter 3 Quiz

(select part-2) Grants, Filters, Groups and more.

Grants/Privileges - Accessing someone else's objects
Filtering data - "where clause" in SQL
Groups and aggregates - part 1
Groups and Aggregates - Part -2
Sorting Data - "Order by" Clause in Oracle

(select part-3) Oracle functions and SQL

Introduction to Oracle functions
Character and Numeric functions in Oracle
Date and Time functions in Oracle
Conversion Functions in Oracle
Null handling functions in Oracle
Conditional Logic functions in Oracle
Oracle Functions - Programming exercises

(Select part-4) Joins, Sub queries and more advanced SQL

Normalization
Introduction to Joins, Inner-joins (part-1)
Inner joins (Contd..), Self joins, and Cartesian Joins
Outer Joins
ANSI vs Oracle Syntax
Joins Quiz
Joins programming exercises
Subqueries
Set Operators

Creating and modifying objects (DDL commands)

Introduction to DDL statements
CREATE tables (and other objects)
Modifying objects - the alter command
Dropping objects (DROP Command)

Data Manipulation - Basic DML

Transaction Control in Oracle
the INSERT Statement
the UPDATE Statement
the MERGE statement
the DELETE statement
Oracle's TRUNCATE statement

Common Errors

ORA-12514: TNS:listener does not currently know of service requested in connect

Extra Resources

Big Data Pocket Reference

Reviews

Gerard
July 18, 2023
Can't get to the environment... Sent note regarding and have not received any response... Not being able to submit the queries, defeats the purpose...
Punit
January 31, 2023
Thank you for elaborating on every step, very helpful lectures to understand basic diagrams on Oracle SQL.
Daniel
July 29, 2018
I am a beginer of SQL and going through the videos is helping me to understand the commands requires to generate retrieve data for analytic purposes.
J
August 27, 2017
The instructor does not always explain how he gets to various screens and he goes too fast. Also, with things are loading in the beginning, he could edit the wait out.
Mickey
June 27, 2017
It's filled in a lot of blanks for me as an OJT-taught SQL user trying to get past beginner level, but I feel there are some elemental things I haven't seen explained yet. However, I like the instructor's pace and method a lot and I'm inclined to have faith in the course.
Fabrice
March 30, 2017
Je comprens bien le principe et la methode utilisé jusqu'ici. Mon seul souci pour le moment c'est l'accent vu que l'anglais c'est pas vraiment mon fort.
Vojtech
November 8, 2016
Very easy to follow examples, great way to learn basics about SQL. Logically structured and interesting. Would recommend to anyone who is trying to learn SQL, having not worked with it in the past, or only having used it on a few occasions. Taking away 1/2 star because it is a little outdated now (not including cdb vs. pdb) which is inconvenient e.g. when trying to follow SQLPlus commands, and also because there seem to be issues with the image installation (quite honestly, it is a lot easier to just download oracle and SQL developer). Over all, my first course at Udemy , and I would definitely recommend it to friends or colleagues.
Sharmistha.Roy@Gmail.Com
January 1, 2016
This is a good course for both beginners and anyone who wishes to brush up on their SQL skills. There are multiple examples and exercises to be done as part of the exercise. Overall a great learning opportunity.
Jacob
October 29, 2015
Took this course for a new position added to my other duties in IT and got me up and running quickly.
Eduardo
October 6, 2015
I feel like the introduction to this course needs to be updated. All the setup examples are about 2 years old, and could be confusing. However, Rajesh gave very clear examples and demonstrations. Assignments are stimulating, and the hands on training is a great teaching method. I do recommend! enjoy
Mary
April 9, 2015
I took this course in preparation for my OBIEE training and I think it was just what I needed. Well explained and the exercises help crystalize the infromation. The instructor is very responsive and will answers your questions promptly. My only problem was some video quality was not very clear (but legible enough to see). Overall a great course at an affordable price.
V
February 11, 2015
Really learned a lot going through the videos and practicing the exercises. The course is well designed and the instructor's explanation with examples is simply superb!
Mushfiqur
December 27, 2014
1. The course helped me achieve what I set out to learn. 2. The instructor was very much engaging and prepared. 3. I liked the production quality.
Sandeep
November 16, 2014
This was really a very nice course and learnt a lot from this course. I thought I knew a lot about SQL but was humbled when I learnt new pointers in this course considering that it's just Oracle SQL for beginners. I must also add that the instructor takes personal interest if you have any query. He will make sure that he gets back to you with a resolution. At least that's what I have found so far and hope Rajesh keeps up with this kind of service besides adding Advanced SQL and Informatica course in future.
Trina
May 29, 2014
This course is a great intro to SQL for those wishing to learn SQL. It took me about 2 weeks to complete the course at my own pace. I usually went through half a section each day. I would say the hardest part is just setting up your disk image in the beginning. I chose the VM option out of the three options available. I learn best by doing, so I really needed to write my own queries, and would recommend the same option for those who learn by doing. I also recommend doing the query exercises because having to write your own queries will reinforce what you watch. You will build on what you learn so I recommend watching the videos in sequence. For most videos, the instructor has some overview slides that are really helpful. They give the generic syntax for the queries you will learn in that video and examples of occasions that you might use those queries. The overview slides may also include common errors in using those particular queries. In the videos, the instructor goes over how to write those queries, as well as provide explanations for the why's, and where applicable, makes connections between concepts (e.g. what is the difference between a join and set operator). He is very responsive, if you happen to have questions or run into issues.

Charts

Price

Oracle SQL for beginners - Price chart

Rating

Oracle SQL for beginners - Ratings chart

Enrollment distribution

Oracle SQL for beginners - Distribution chart

Related Topics

35582
udemy ID
1/10/2013
course created date
10/29/2020
course indexed date
Bot
course submited by