Step by Step Practical Oracle SQL with real life exercises

Step by Step Practical Oracle SQL with real life exercises, available at $39.99, has an average rating of 4.35, with 37 lectures, based on 280 reviews, and has 10735 subscribers.

You will learn about 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.. This course is ideal for individuals who are Anyone who wants to learn Oracle SQL. It is particularly useful for Anyone who wants to learn Oracle SQL.

Enroll now: Step by Step Practical Oracle SQL with real life exercises

Summary

Title: Step by Step Practical Oracle SQL with real life exercises

Price: $39.99

Average Rating: 4.35

Number of Lectures: 37

Number of Published Lectures: 37

Number of Curriculum Items: 37

Number of Published Curriculum Objects: 37

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will 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..

Who Should Attend

Anyone who wants to learn Oracle SQL.

Target Audiences

Anyone who wants to learn Oracle SQL.

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.

Course Curriculum

Chapter 1: Welcome to the world of SQL

Lecture 1: Introduction

Chapter 2: Oracle SQL: Getting Started

Lecture 1: What is data?

Lecture 2: Why do we need a database and SQL?

Lecture 3: Install Oracle

Lecture 4: Install SQL developer

Lecture 5: Connect to DB (Why do we need Hostname, Port, SID), Users, Schemas

Chapter 3: Oracle SQL: Creating, Altering and Dropping the table

Lecture 1: Data Model for the videos

Lecture 2: Create table statement

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

Lecture 4: Create Table, Alter table, Drop Table in action

Chapter 4: Oracle SQL: Inserting into a table, Commit and Rollback

Lecture 1: Insert, commit and rollback (with a visual representation)

Chapter 5: Oracle SQL: Read data from table

Lecture 1: SELECT statement

Lecture 2: SELECT with WHERE clause, AND condition, OR condition (Truth Tables)

Lecture 3: ORDER BY clause

Chapter 6: Oracle SQL: Read data from table (continued..) – More complex operations

Lecture 1: LIKE (with variants), NOT LIKE, IN, NOT IN

Lecture 2: Relational operators, Arithmetic operators, Concatenation

Lecture 3: NULL Values (Scenarios where you have to be careful)

Chapter 7: Oracle SQL: Updates, Deletes and Truncates

Lecture 1: Update statement, Delete vs Truncate

Chapter 8: Oracle SQL: Pseudocolumns and Functions

Lecture 1: DUAL table (what's the need?), Rownum (why doesn't it work sometimes), Sysdate

Lecture 2: Functions – Lower(), Upper(), length() – empty string?,substr(), INSTR(), trim()

Lecture 3: Functions – nvl(), round(), floor(), to_date()/ to_char() -datatype, to_number()

Chapter 9: Oracle SQL: Aggregate Functions

Lecture 1: min(), max(), sum(), avg(), count(), common mistake with count(*)

Lecture 2: Group by on single/multiple columns, Having clause vs whereclause

Chapter 10: Oracle SQL: Joins

Lecture 1: Join 2 tables, Inner Join (old vs new), Left Join, Right Join, Full outer join

Lecture 2: Joins across multiple tables

Chapter 11: Oracle SQL: Views, Subqueries

Lecture 1: Views, Inline views, With clause, Subqueries

Lecture 2: EXISTS (vs join), NOT EXISTS, IN, NOT IN revisited

Chapter 12: Oracle SQL: Scalar Subqueries, UNIONs, INTERSECT, MINUS

Lecture 1: Scalar Subqueries

Lecture 2: Union, Union All, Intersect, Minus

Chapter 13: Oracle SQL: Indexes and Constraints

Lecture 1: Indexes (Are indexes always good?)

Lecture 2: NOT null, Unique/Primary Key constraints, Index+constraint vs Just Constraint

Lecture 3: Check conditions, Foreign Key Constraints (& types)

Chapter 14: Oracle SQL: Other interesting concepts

Lecture 1: Create table as (potential use case), Insert into commands

Lecture 2: Oracle SEQUENCES

Lecture 3: UPDATE from another table, MERGE from another table

Lecture 4: Grants and Synonyms (why both are necessary?)

Chapter 15: What next?

Lecture 1: What next?

Instructors

Ramesh R
Senior Architect at an IT Major

Rating Distribution

1 stars: 0 votes
2 stars: 5 votes
3 stars: 25 votes
4 stars: 114 votes
5 stars: 136 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu