Step by Step Practical Oracle SQL with real life exercises
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
6 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Step by Step Practical Oracle SQL with real life exercises to your Wishlist.

Add to Wishlist

Step by Step Practical Oracle SQL with real life exercises

Explains both the what and why of an Oracle SQL concept. Deals with real-life situations.
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
6 students enrolled
Created by Ramesh R
Last updated 6/2017
English
Current price: $10 Original price: $35 Discount: 71% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 27 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Fundamentals of SQL commands and their nuances.
  • Appreciate that real-life SQL is not always a "Yes/No" problem. There is also a "May be". A solution that works for scenario X could have issues in scenario Y.
  • Code backend DB for applications.
  • Think in "SQL" terms. More importantly, think practically.
  • CREATE Tables and INSERT data into them.
  • SELECT data from tables and FILTER them using WHERE clause
  • JOIN data across multiple tables
  • Use GROUP BY to group results and calculate aggregates
  • Use functions to act on data.
  • Control access to users using GRANTs and SYNONYMs.
  • Create INDEXes for performance reasons and CONSTRAINTS on data to protect data integrity
  • Much more things..
View Curriculum
Requirements
  • Basic knowledge of computers.
  • No programming knowledge necessary.
Description

Relational databases have spread across the software world. Learning SQL means you know how to access them. This skill enables you to stay competitive.

The course teaches you Oracle SQL. But, SQL is a standard that is used for other relational databases also. So, you can re-use the SQL learning (not 100% though) for other DBs as well with some tweaks specific to those DBs. 

The course tries to impart knowledge using two methods.

1. Video lectures. The lectures introduce you to the basics of Oracle SQL and also the important nuances. For e.g. apart from learning what a NULL value means, you will also learn the situations the NULL values can be problematic. 

2. Exercises - PDFs -> The exercises deal with the concepts introduced in the videos and their nuances.  

- The answer for a question and the explanation will be provided in the next page. Occasionally, some questions can also ask you to do some self-exploration (recommended) on a topic related to the lecture. If you do not have time to do that, you can look at the answer with the explanation in the next page. 

- The exercises vary in complexity. Some of them can seem quite complex for a beginner. Some questions have been made intentionally confusing. A confusion/complexity now is better than the one at an examination hall or work. Isn't it?.  

- Several questions deal with real-life situations and their handling. Please attempt them using logical and practical reasoning, and if needed, take the help of the answer and the explanation in the next page. You can always contact me for any doubts.

I believe, the course will help in preparing you for the complexity and ambiguity in the real-life database world.

Good luck. Enjoy the course.

PS: Exercises are attached as PDF resources in the videos. And not all videos will have a PDF. Questions across lectures could be clubbed together and uploaded against a single video lecture.

Who is the target audience?
  • Anyone who wants to learn Oracle SQL.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
37 Lectures
04:03:03
+
Welcome to the world of SQL
1 Lecture 03:01
+
Oracle SQL: Getting Started
5 Lectures 21:11

Why do we need a database? Why not store in simple excel sheets? How does a database help?

Preview 03:37

Install Oracle
03:47

Install SQL developer
01:13

+
Oracle SQL: Creating, Altering and Dropping the table
4 Lectures 11:49
Data Model for the videos
02:06

Create table statement
02:33

What are Data Types? (Why does Oracle expect us to provide it?)
03:16

Create Table, Alter table, Drop Table in action
03:54
+
Oracle SQL: Inserting into a table, Commit and Rollback
1 Lecture 07:51
+
Oracle SQL: Read data from table
3 Lectures 15:03
SELECT statement
03:53

SELECT with WHERE clause, AND condition, OR condition (Truth Tables)
07:41

ORDER BY clause
03:29
+
Oracle SQL: Read data from table (continued..) - More complex operations
3 Lectures 23:23
LIKE (with variants), NOT LIKE, IN, NOT IN
07:30

Relational operators, Arithmetic operators, Concatenation
05:20

NULL Values (Scenarios where you have to be careful)
10:33
+
Oracle SQL: Updates, Deletes and Truncates
1 Lecture 06:03
Update statement, Delete vs Truncate
06:03
+
Oracle SQL: Pseudocolumns and Functions
3 Lectures 29:11

Functions - Lower(), Upper(), length() - empty string?,substr(), INSTR(), trim()
08:41

Functions - nvl(), round(), floor(), to_date()/ to_char() -datatype, to_number()
11:40
+
Oracle SQL: Aggregate Functions
2 Lectures 14:46
min(), max(), sum(), avg(), count(), common mistake with count(*)
04:53

Group by on single/multiple columns, Having clause vs whereclause
09:53
+
Oracle SQL: Joins
2 Lectures 18:16
Join 2 tables, Inner Join (old vs new), Left Join, Right Join, Full outer join
12:45

Joins across multiple tables
05:31
5 More Sections
About the Instructor
Ramesh R
0.0 Average rating
0 Reviews
6 Students
1 Course
Senior Architect at an IT Major

Am a senior architect in an IT major with specialisation in database technologies, particularly Oracle. I have anchored & led several key transformations, performance tuning exercises, data migrations and application architecture initiatives. I have also consistently contributed to the knowledge sharing forums in whatever institutions I have been part of, and so, I believe, I have the right mix of hands-on experience with technologies + experience teaching the knowledge I have gained.