Enquire Now
Menu

SQL Fundamentals for Business Intelligence

3.7( 3 REVIEWS )
116 STUDENTS
Add To Cart
£199 £49 (inc. VAT)
Buy Now
  • 365 Days
  • Course Certificate
  • ACCREDITED BY CPD & iAP
  • 02Guided Learning Hours
  • Course Material
  • 03 Number of Modules
  • Exam Included

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.

 

  • Access Duration
  • Who is this course aimed at?
  • Entry Requirements
  • Method Of Assessment
  • Certification
  • Career Path
  • Other benefits

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.

This course is aimed at individuals aspiring to or already in the business intelligence field
  • Learners must be age 16 or over and should have basic understanding of the English Language, numeracy, literacy and ICT.
  • A basic knowledge on the SQL database is essential to follow up on this course

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.

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

This certificate will improve your eligibility for a number of jobs in business intelligence. You can also use this certificate to study further in the area or to make significant progress in your career. Below mentioned are some of the jobs this certificate will help you in, along with the average UK salary per annum according to https://www.payscale.com,

  • Business Intelligence (BI) developer – £35,618 per annum
  • BI analyst – £30,483 per annum
  • BI consultant – £43,880 per annum
  • BI Manager – £49,084 per annum
  • 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

Course Curriculum

section 1: installing postgres and our initial dataset
1.1. The Course Overview 00:00:00
1.2. Installation on Windows and Mac Via PostgresApp 00:00:00
1.3. Installing pgAdmin 00:00:00
1.4. Downloading and Restoring the DVD Rental Database 00:00:00
section 2: putting sql clauses into practice
2.1. SELECT, WHERE, GROUP BY, and COUNT Clauses 00:00:00
2.2. Most Common JOINs 00:00:00
2.3. More LEFT JOIN and SELF JOIN 00:00:00
2.4. Everything Is a Table 00:00:00
2.5. JOIN and Filtering Gotchas – Common Errors to Avoid 00:00:00
2.6. WHERE Versus HAVING for Filtering 00:00:00
section 3: the big picture of non-trivial sql with examples
3.1. Subqueries 00:00:00
3.2. Correlated Subqueries 00:00:00
3.3. Common Table Expressions (CTEs) 00:00:00
3.4. Dealing with Dates and Times 00:00:00
3.5. The CASE Statement 00:00:00
3.6. Inserting External Data 00:00:00
mock exam
Mock Exam : SQL Fundamentals for Business Intelligence 00:40:00
exam
Exam : SQL Fundamentals for Business Intelligence 00:40:00

Students feedback

3.7

Avarage rating (3)
3.7
5 Star
4 Star
3 Star
2 Star
1 Star
    H P

    Harrison Phillips

    June 05, 2019 - 3:40pm
    High Quality Course

    The content was of high quality. And I had a good experience learning at Global Edulink. I must say I’m very impressed with their support services, there are no delays whatsoever.

    M S

    Maggie Shaw

    June 01, 2019 - 5:38pm
    Good job

    The course was on-point for real-world applications. But the training went by very quickly, I would have preferred if it were slowed down.

    Z D

    Zachary Dawson

    May 27, 2019 - 11:36am
    Well presented course

    Very concise course, but the tutor had a very basic approach. I guess it felt too simplistic to me.

Add To Cart
£199 £49 (inc. VAT)
Buy Now
  • 365 Days
  • Course Certificate
  • ACCREDITED BY CPD & iAP
  • 02Guided Learning Hours
  • Course Material
  • 03 Number of Modules
  • Exam Included
WhatsApp chat