Overview
SQL Fundamentals Course Overview
Delve into the world of SQL, the cornerstone of Business Intelligence, with our SQL Fundamentals course. Designed for beginners and aspiring data professionals, this course introduces you to the foundational syntax and transformative capabilities of SQL. You’ll learn how to effectively extract and manipulate data from databases, a critical skill for any analyst.
Starting with basic data retrieval and filtering techniques, the course progressively guides you through more complex aspects of SQL, including data transformation functions and combining data from multiple tables. We provide hands-on experience through an accessible Azure Data Studio data warehouse, ensuring you can practice your skills in a real-world environment, regardless of your operating system.
By the end of this course, you’ll possess the fundamental skills necessary to navigate and manipulate database data confidently. You’ll understand best practices and common pitfalls in SQL, equipping you with the knowledge to become a proficient business analyst and a valuable asset in any data-driven role.
SQL Fundamentals Learning Objectives
Upon completing this course, you will be able to:- Retrieve and filter data using basic SQL syntax
- Transform data with the help of numerical, date, and text functions
- Understand essential terminology related to SQL, databases, and data warehouses
- Combine data from multiple tables efficiently for a more advanced analysis
Who should take this course?
This SQL Fundamentals course is ideal for beginners in data analysis, business professionals seeking to understand database interactions, and Excel users venturing into more advanced data management. It’s crafted to provide foundational skills in SQL, setting the stage for anyone looking to deepen their business intelligence and data analysis capabilities. The course lays the groundwork for transforming raw database information into meaningful insights, making it a crucial first step for aspiring data analysts and business intelligence professionals.Software requirements
https://learn.microsoft.com/en-us/azure-data-studio/download-azure-data-studio?tabs=win-install%2Cwin-user-install%2Credhat-install%2Cwindows-uninstall%2Credhat-uninstall
Get Recognized With CFI
See All Certification ProgramsWhat you'll learn
Lesson
Multimedia
Exams
Files
Introduction
Basic SQL Queries
Using HAVING to Filter Grouped Rows
Checking the Impact of a WHERE Filter
Creating a Column Alias
Using WHERE to Filter Rows
Student Exercise 1c
Filtering Grouped Invoices with HAVING
SELECT and FROM
Free Preview
Student Exercise 1b
ORDER BY Another Column
Using GROUP BY to Combine Rows
Student Exercise 1c Review
What is Adventure Works?
Free Preview
Limiting Results to 1 Invoice Number for Testing
Using GROUP BY to Combine Invoice Numbers
Chapter Introduction
Free Preview
SQL Order of Operations
Creating a Connection to a Database
Free Preview
Using ORDER BY to Sort Query Rows
Filtering Rows TOP N
Recap and Common Errors
Installation and Introduction to Azure Data Studio
Free Preview
Filtering Rows DISTINCT
Filtering Rows TOP N Percent
Saving Your Queries in Notepad
Free Preview
Filtering Rows OFFSET FETCH
Example SQL Code
Free Preview
SELECT Specific Columns
Chapter Summary & Student Exercise 1a
Student Exercise 1b Review
Student exercise 1a review
Manipulating Values with Functions
Advanced Logical Operators - LIKE
Chapter Review and Student Exercise 2a
Date Parts
Student Exercise 2b
Recap of Aggregate Functions
Student Exercise 2a Review
The Importance of Data Types
Chapter Introduction
Basic SQL Formatting
Date and Time Functions
Using IIF Statements to Create a Conditional Column
Numeric Data Types
Logical Operators
Using a NATIONAL for UNICODE Best Practice
Date and Time Data Types
String Functions
Student Exercise 2b Review
How Aggregate Functions Respond to NULL Values
Using CAST to Change the Data Type
Counting Rows with COUNT( ) Aggregation
Working with Specific Dates
Advanced Logical Operators - IN and BETWEEN
Where is the Boolean Data Type
The DATEADD Function
Numeric Functions
Text or String Data Types
Comparison Operators
The CONCAT String Function
Practical Examples Using CAST
Replacing NULL Using IIF, ISNULL and COALESCE
LIKE in Practice
LEN UPPER LOWER REPLACE String functions
Date and Time Functions in Practice
IN and BETWEEN in Practice
Comparison Operators - Dealing with NULL
Flexible LEFT and RIGHT Functions
Using a CASE Statement for Multiple Conditions
Server Properties Collation
Logical Operators - Common Errors
Using IIF in a WHERE Statement
Working with Multiple Tables
Appending Data with a UNION
Chapter Summary and Student Exercise 4a
Other Types of JOIN
Reading SQL Code
Student Exercise 4b
Exploring the Reseller Schema
Student Exercise 4b Review
Exercise 4a Review
Creating Dynamic Results Using Subqueries
Using ORDER BY with a UNION
Caution with Duplicate Data
Querying a View
Order of Operations Review
HAVING or WHERE
Internet Sales Schema
Purpose of DW Relationships
LEFT JOIN vs RIGHT JOIN
RIGHT JOIN to Retrieve Full Product Catalogue
Creating JOINS Across Bridge Tables
Creating a View
Identifying the Source of Each UNION Row
When INNER JOIN Doesn't Work
INNER JOIN the Currency Table
Creating a UNION between Internet and Reseller Sales
Returning Only the TOP 100 Customers
A Basic INNER JOIN Using Sales and Customers
Chapter Introduction
Types of JOIN
Relationships and ER Diagrams
Bridge Tables for Many-to-many Relationships
Advanced Functions and Queries
Student Exercise 5b
Student Exercise 5a
Using CUBE to Return Subtotals and Totals
Connecting to SQL Server from Power BI
Student Exercise 5a Review
Using ROLLUP to Return Subtotals and Totals
Connecting to SQL Server from Excel
Introducing the Finance Schema
Common Scenario Percent of total
Student Exercise 5b Review
Chapter Introduction
Connecting to SQL from Tableau
Qualified Assessment
This Course is Part of the Following Programs
Why stop here? Expand your skills and show your expertise with the professional certifications, specializations, and CPE credits you’re already on your way to earning.
Business Intelligence & Data Analyst (BIDA)® Certification
SQL Fundamentals is part of the Business Intelligence & Data Analyst (BIDA)® certification, which includes 25 courses.
- Skills Learned Data visualization, data warehousing and transformation, data modeling and analysis
- Career Prep Business intelligence analyst, data scientist, data visualization specialist
Business Intelligence Analyst Specialization
- Skills learned Data Transformation & Automation, Data Visualization, Coding, Data Modeling
- Career prep Data Analyst, Business Intelligence Specialist, Finance Analyst, Data Scientist
Learner Reviews
So Intense
First time coming across SQL. Perfect intro but you need a lot of time and effort to thoroughly get the concepts. Loved every minute of it.
First time coming across SQL. Perfect intro but you need a lot of time and effort to thoroughly get the concepts. Loved every minute of it.
Samuel Mbogo
Last few contents are not included in the student file package such as subquery
Last few contents are not included in the student file package such as subquery
Last few contents are not included in the student file package such as subquery
Yi De Chia
very informative
The instructor took his time to explain the various concepts
The instructor took his time to explain the various concepts
Ferdinand Santah
It was interesting
I passed my exam once
I passed my exam once
