Step by Step Practical Oracle SQL with real life exercises

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.

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.

TAKE THIS COURSE