Learn about enhanced functions of Oracle SQL for Data analytics and get an overview about Data warehousing
Enterprise worldwide has huge data on their business application be it in the from of ERP or Data warehousing information. The heart of these system are Relational data base and enterprise world over are looking for expert who can derive meaningful information from the system, so as to grow and drive the business.
What you’ll learn
- Oracle SQL – Extensively about select statement (DML) from Data analytics point of view.
- An overview about Data warehousing concepts..
- Understanding about other sql statement like DDL, DMLs.
- Basic understanding of ER diagrams, Oracle Instance and Database.
Course Content
- Introduction –> 1 lecture • 4min.
- Whats a business application? –> 2 lectures • 13min.
- Relational Database and SQL –> 4 lectures • 22min.
- What is an Oracle Instance? –> 1 lecture • 6min.
- Quiz 1 –> 0 lectures • 0min.
- Difference environment to practice Oracle SQL –> 2 lectures • 13min.
- Oracle SQL : Select statement – Arithmetic, Concatenate, Distinct functions –> 2 lectures • 12min.
- Oracle SQL: Select Statement – Filtering data – using where clause –> 2 lectures • 13min.
- Oracle SQL: Select statement – Functions –> 3 lectures • 21min.
- Quiz 2 –> 0 lectures • 0min.
- Analytics function used in Data warehousing / Business Intelligence –> 8 lectures • 48min.
- Oracle SQL : Retrieving Data from multiple tables – JOINS –> 10 lectures • 39min.
- Quiz 3 –> 0 lectures • 0min.
- Data Definition Language –> 2 lectures • 16min.
- DB – Schema, Synonym, Sequence, Index – Overview –> 1 lecture • 11min.
- Do’s, Don’t and Tuning Sql – Overview –> 1 lecture • 9min.
- What is Data Dictionary? –> 1 lecture • 5min.
- Quiz 4 –> 0 lectures • 0min.
- DataWarehouse and Business Intelligence : An overview –> 4 lectures • 36min.
- Quiz 5 –> 0 lectures • 0min.
- Bonus Lecture: Concluding remarks & Next steps –> 1 lecture • 5min.
Requirements
Enterprise worldwide has huge data on their business application be it in the from of ERP or Data warehousing information. The heart of these system are Relational data base and enterprise world over are looking for expert who can derive meaningful information from the system, so as to grow and drive the business.
An Oracle SQL expert from data analytics perspective is always on high demand. Considering this, the course is packed with all the necessary details.
Apart from regular sql ‘select statement ‘ which is called DML statement it also covers business analytics statement such as:
- Roll Up group.
- Cube – commonly referred in Data warehousing towards multi-dimensional data analytics
- Hierarchical functions.
Additionally it also has an overview about Data warehousing concepts, which provides you with basic knowledge, which can then be used to acquire Datawarehouse – ETL tools and OLAP tools knowledge.
One can learn Oracle SQL without any install through Cloud Oracle DB along with data set for easier practice.
Happy Learning!!