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.
Understand the role of common table expressions in managing complicated queries
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.
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.
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.
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,
|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.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 : SQL Fundamentals for Business Intelligence||00:40:00|
|Exam : SQL Fundamentals for Business Intelligence||00:40:00|