SQL Fundamentals for Business Intelligence

Overview

SQL is a domain-specific language that is used in programming and managing data that is maintained in relational databases. SQL is important to manage huge amounts of data that are stored by many companies in databases and hence, is a significant skill that will help you progress substantially within the Business intelligence industry. If you came here looking to gain a fundamental knowledge on SQL to up your business intelligence skills, you are heading the right way with this course, as this course is set to educate you on the fundamentals of SQL to effectively answer real-world business queries.

This course will start by guiding you on how to install postgres and pgAdmin on Mac and Windows operating systems, followed by instruction on how to import the first dataset which is the DVD rental database. This course will then move you onto explore the SELECT, WHERE, GROUP BY and COUNT clauses and the common JOINs that are essential in building an SQL model, along with an insight into the common JOIN and filtering Gotchas mistakes that might occur in SQL programming, to avoid them.

The subqueries is a data filtering method that is revered for its usability and flexibility. This course will walk you through how to use it in filtering data effectively, after which the strategies used in sorting data into dates and time for analysis purposes will be duly covered. You will also get to study the role of common table strategy in managing complicated queries into organised codes. By the end of this course, you will walk away with a considerable knowledge on SQL to effectively use it in your business intelligence activities.

• Study the subqueries strategy that is very useful and flexible in filtering data

Understand the role of common table expressions in managing complicated queries

Why study at Global Edulink?

Global Edulink offers the most convenient path to gain recognised skills and training that will give you the opportunity to put into practice your knowledge and expertise in an IT or corporate environment. You can study at your own pace at Global Edulink and you will be provided with all the necessary material, tutorials, qualified course instructor, narrated e-learning modules and free resources which include Free CV writing pack, free career support and course demo to make your learning experience more enriching and rewarding.

Course Curriculum

• Section 1: Installing Postgres And Our Initial Dataset
• Section 2: Putting Sql Clauses Into Practice
• Section 3: The Big Picture Of Non-Trivial Sql With Examples

Access duration

The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course.  The course is self-paced and you can complete it in stages, revisiting the lectures at any time.

Who is this course aimed at?

This course is aimed at individuals aspiring to or already in the business intelligence field

Method of assessment

The course is assessed online with a final, multiple-choice test, which is marked automatically. You will know instantly whether you have passed the course.

Certification

Those who pass this test will get a certificate in SQL Fundamentals for Business Intelligence

Other Benefits

• High-quality e-learning study materials and mock exams.
• Tutorials/materials from the industry leading experts.
• 24/7 Access to the Learning Portal.
• The benefit of applying for TOTUM extra Discount Card.
• Recognised Accredited Qualification.
• Excellent customer service and administrative support