SQL Fundamentals for Business Intelligence
Access Duration - 365 Days
Accredited By "CPD & iAP"
Guided Learning Hours (02)
Course Material
Number of Modules 03
Mock Exam Included
Final Exam Included
4.5( 4 REVIEWS )
128 STUDENTS
Accredited By
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/career-path-planner,
- 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 | ||
| Certificate Download Guide | |||
| Certificate Download Guide | 00:03:00 | ||
Samuel Lent
This course was brilliant for giving a rounded introduction into some of the statements required for querying databases for Business Intelligence. The course wasn’t too long as to be a burden for people working full-time and the course tutor was very quick to reply to emails regarding any issues or questions with the material.
Just based on the active part the tutor played in supporting me with this course, I would highly recommend it to anyone looking to get into SQL.
Harrison Phillips
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.
Maggie Shaw
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.
Zachary Dawson
Very concise course, but the tutor had a very basic approach. I guess it felt too simplistic to me.