If you have a database and want to perform data analytics or business reporting, you just in the right course. This course will help you to know many details of how extract and retrieve data from the database, which will get most of your report done. The course will start refreshing the mind on important database concepts for data analytics. After that an introduction about SQL will be given. Then, the structure of DML queries will be explained. This will be followed by going through many commands for basic extraction, conditional retrieval, retrieval based on comparisons, data manipulation, sorting data, extracting unique values, performing calculations, extracting summarized data, extracting data from different resources. After, there be important highlight in optimizing the data extraction performance with making use of Indexes and views. This course will share many tips, tricks and secrets that are a result of many year of work and research. In addition, this course will be prepared with many real-life examples from industry to give the real experience. Also, several free source and custom developed databases will be used to explain the different concepts and scenarios.
Who should take this course?
This course is important for:
Professionals who need to deal with data extraction & retrieval.
Professionals who need to deal with business reporting.
Professionals who need to create business intelligence outcomes.
The course delivery method
The course is available with the following modes:
Online live instructor-led mode:
The course will be delivered using ZOOM application. Participants are required to install ZOOM application to their computers.
Face to face instructor-led mode:
The course will be held in a training venue at reputable hotel or business center. The participants will be informed about the venue details after registration. Participants are required to bring their own computing devices. This option is available for Ottawa, Montreal and Toronto.
One day, from 9 AM - 5 PM, including refreshments and lunch break.
Participants are required to have the following software to be installed prior to the course session:
To have good understanding for the course, it is helpful to have basic computer skills and basic understanding for relational database concepts.