What You Need to Know Before
You Start

Starts 5 June 2025 18:48

Ends 5 June 2025

00 days
00 hours
00 minutes
00 seconds
course image

SQL Fundamentals

Focus on the skills you need to get started with SQL as a data analyst, allowing you to read & transform data and gather insights from a company database
via Corporate Finance Institute

28 Courses


4 hours 7 minutes

Optional upgrade avallable

Not Specified

Progress at your own speed

Paid Course

Optional upgrade avallable

Overview

SQL Fundamentals Course OverviewDelve 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 syntaxTransform data with the help of numerical, date, and text functionsUnderstand essential terminology related to SQL, databases, and data warehousesCombine 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 requirementshttps:

//learn.microsoft.com/en-us/azure-data-studio/download-azure-data-studio?tabs=win-install%2Cwin-user-install%2Credhat-install%2Cwindows-uninstall%2Credhat-uninstall

Syllabus

  • Introduction
  • Basic SQL Queries
  • Manipulating Values with Functions
  • SQL Theory
  • Working with Multiple Tables
  • Advanced Functions and Queries
  • Qualified Assessment

Taught by

Sebastian Taylor and Pavel Nacev


Subjects

Programming