MDP on Data Analytics- SQL–
Introduction to Oracle Database
Retrieve Data using the SQL SELECT Statement
Learn to Restrict and Sort Data
Usage of Single-Row Functions to Customize Output
Invoke Conversion Functions and Conditional Expressions
Aggregate Data Using the Group Functions
Display Data from Multiple Tables Using Joins
Use Sub-Queries to Solve Queries
The SET Operators
Data Manipulation Statements
Use of DDL Statements to Create and Manage Tables
Other Schema Objects
Control User Access
Management of Schema Objects
Manage Objects with Data Dictionary Views
Manipulate Large Data Sets
Data Management in Different Time Zones
Retrieve Data Using Sub-queries
Regular Expression Support.