Oracle SQL for Data Analytics and Data warehousing overview
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
Requirements
- Some programming background would be beneficial
- For optimum results use headphone speaker
- Does not require any installs on your laptop/ PC
Description
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!!
Who this course is for:
- Beginner interested to get into the most sought and on-demand career in Data analytics using Oracle SQL
- Student who wish to enter into the career as Oracle Developer (analytics) and get an understanding on Data warehousing / analytics
Instructor
![Guha Rajan M., B.Engg, MBA, PMP](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 3.8 Instructor Rating
- 1,108 Reviews
- 5,970 Students
- 45 Courses
Having over 25 + years of IT industry experience (Product development, Consulting & Training).
His last engagement was with Oracle India (initially with consulting and then with Oracle university) , which was for more than 12 years. Prior to this, had worked with Cap Gemini (formerly iGate Global Solution), GE to name a few.
Had managed projects and programs in Enterprise Resource Planning and Business Intelligence implementations in the range of 3000 man days with revenue about 6mil US$ per year. These projects are on industry domains, such as Oil and Gas, Process Manufacturing, Hi-Tech Retail & Telecom across the globe.
Was awarded with "pace setter" , "best managed " project awards in recognition of efforts in project management.
He was also instrumental in design, development and roll-out of Graduate Hire program on Oracle Products stack for partner IT services companies in recent times.
Right from college was fascinated about devices and sensor interaction with computer, which made him focus on micro-controller in early 90's and that eventually attracted him towards field of Internet of things and Machine learning, AI these days.
Due to his vast experience, he has crafted varied unique courses in Udemy related project management, Internet of things, ERP & BI, Database modeling and design, SQL, Linux and more importantly on Cloud Infrastructure. Has plans to create more, as his passion has been on knowledge acquisition and sharing.
He is certified as
Oracle Cloud Infrastructure 2021 Architect Professional.
Oracle Cloud Infrastructure 2021 Architect Associate.
Oracle Cloud Infrastructure 2021 Cloud Operations Associate.
Oracle Cloud Infrastructure Security 2021 Certified Associate
Oracle Autonomous Database Cloud 2021 Certified Specialist
Oracle Machine Learning using Autonomous Database 2021 Certified Specialist
Also certified in Python, IOT by NPTEL (Govt of India ) recently.
He holds a degree in engineering (Computer science) with MBA and a certified PMP since 2007