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.
4.51 (282 reviews)
10 737
students
4 hours
content
Jun 2017
last update
$39.99
regular price
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..
Course Gallery
Loading charts...
Related Topics
1207502
udemy ID
07/05/2017
course created date
22/11/2019
course indexed date
Bot
course submited by