Step by Step Practical Oracle SQL with real life exercises
What you'll 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..
- Basic knowledge of computers.
- No programming knowledge necessary.
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 this course is for:
- Anyone who wants to learn Oracle SQL.
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.