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..
Relational databases have spread across the software world. Learning SQL means you know how to access them.Thisskill enables you to stay competitive.
The course teaches you OracleSQL. But, SQL is a standard that is used for other relationaldatabasesalso. So, you can re-use the SQL learning (not 100% though)for other DBsas well with some tweaks specific to those DBs.
The course tries to impart knowledge using two methods.
1. Video lectures. The lecturesintroduce you to the basics of OracleSQLand also the important nuances.For e.g. apart from learning what a NULL value means,you will alsolearn 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 questionand the explanationwill beprovided 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 timeto do that, you canlook at the answer with the explanationin the next page.
-The exercises vary in complexity.Some of them can seem quitecomplex for a beginner. Somequestions have been made intentionally confusing. Aconfusion/complexitynow is better than the oneat an examination hall or work.Isn't it?.
-Several questions deal with real-life situations and their handling. Please attempt themusing 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 coursewill help in preparing you for the complexity and ambiguity in the real-life databaseworld.
Good luck.Enjoythe course.
PS:Exercises are attached as PDFresources in the videos. And not all videos will have a PDF. Questions across lecturescould be clubbed together and uploaded against a single video lecture.
