Percorso Data Analyst with SQL - Apprentissaggio Online con Certificato

Data Analyst with SQL

Beginner

4.2

11 reviews

41 Learners

A comprehensive beginner-level learning track designed for aspiring data analysts and junior data professionals. This track introduces the core concep…

148

Chapters

Learning hours

202

Assignments

AI Assistant

Shareable Certificate

Risultati

Track content

Related courses and projects

Testimonianze

Caratteristiche

Prezzi

Risultati

Track content

Related courses and projects

Testimonianze

Caratteristiche

Prezzi

Cosa imparerai

Understand the basics of data, the data lifecycle, and the role of a data analyst

Apply filtering, sorting, and aggregation techniques to analyze datasets

Build analytical reports and dashboards using SQL and BI tools

Grasp the structure and organization of relational databases

Combine data from multiple tables using SQL joins

Write and execute basic SQL queries to retrieve and manipulate data

Clean and transform data using essential SQL functions

Learning track content

What is Data?

Types of Data

The Data Lifecycle

Introduction to Data Analysis

Why Data Analysis Matters

The Data Analysis Process

Key Roles in Data Analysis

The Data Analyst: Responsibilities and Skills

Tools and Technologies for Data Analysis

Data-Driven Decision Making

Retrieving Individual Columns

Retrieving Multiple Columns

Retrieving All Columns

Retrieving Distinct Rows

Limiting Results

Challenge: Find the Population of the Countries

Challenge: Find All Countries

Challenge: Find All Countries With Their IDs

Challenge: Find Country Capitals

Challenge: Find the Regions in Which All Countries Are Located

Sorting Data

Challenge: Population Sort

Sorting by Multiple Columns

Challenge: Dual-Sort Query

Specifying Sort Direction

Challenge: Sort the Countries by Region and Capital

Challenge: Sort Capitals in Descending Order

Challenge: Sort Countries in Ascending Order

Challenge: Find Countries, Their IDs, and Their Populations

Challenge: Find Countries, IDs, Populations, Regions, and Sort Them

Challenge: Find All Continents and Sort Them in Ascending Order

Using the WHERE Clause

Challenge: North America Population Sort

The WHERE Clause Operators

Challenge: Population Threshold Query

Checking for a Range of Values

Checking for NO Value

Using the AND Operator

Challenge: Europe Region Sort

Using the OR operator

Challenge: America Regions Filter

Using the NOT Operator

Challenge: Non-Europe Capitals Sort

The AVG() Function

Challenge: Surface Area Selection

The COUNT() Function

Challenge: Continental Count

The MAX() Function

The MIN() Function

Challenge: Large Surface Area Average

The SUM() Function

Clausola Group By

Ordine delle Istruzioni

Sfida: Tempo Totale di Percorrenza per Ciascuna Linea della Metropolitana

Sfida: Media dei Voti degli Studenti

Ricerca Dei Migliori Studenti Di Matematica - Sfida

Clausola Having

Diverse Funzioni di Aggregazione nella Query

Filtraggio Più Complesso

Introduction to Subqueries

Subqueries in SELECT and WHERE Clauses

Challenge: Top Customers by Order Count

Challenge: Products Never Ordered

Challenge: Customers from Specific Cities with Orders

Challenge: Most Popular Product Category

Non-correlated vs Correlated Subqueries

Subqueries in FROM Clauses

Challenge: Recently Hired Employees

Challenge: Departments with Above-average Salaries

Challenge: Employees Without Recent Salary Increase

Challenge: Highest Paid Employee per Department

Subqueries for Aggregation and Filtering

Subqueries for Existence and Non-existence

Challenge: Most Active Members

Challenge: Books Borrowed in the Last Month

Challenge: Members with No Borrowings

Challenge: Most Popular Genre

Understanding INNER JOIN

Challenge: Find Customers with Orders

Exploring LEFT JOIN

Challenge: List All Customers and Their Orders

RIGHT and FULL OUTER JOIN in Action

Challenge: Orders Without Customers

Joining More Than Two Tables

Challenge: Employee Project Assignments

Self-Joins for Hierarchical Data

Challenge: Manager-Employee Relationships

Advanced Join Conditions

Challenge: Complex Assignment Matching

Challenge: Employees Without Projects

Dealing with NULLs in Joins

Join Performance and Optimization

Challenge: Optimize a Join Query

Real-World Join Scenarios

Challenge: Student Performance Dashboard

Introduction to String Functions

Challenge: Standardize Customer Names

Challenge: Extract Email Domains

Advanced String Manipulation

Challenge: Mask Sensitive Information

Challenge: Clean Up City Names

Working with Dates and Times

Challenge: Calculate Order Age

Challenge: Find Late Deliveries

Advanced Date and Time Calculations

Challenge: Monthly Order Summary

Challenge: Predict Delivery Dates

Introduction to Numeric Functions

Challenge: Calculate Discounted Prices

Challenge: Find Low Stock Products

Advanced Numeric Operations

Challenge: Analyze Price Distribution

Challenge: Calculate Inventory Value

Introduction to Logical Functions

Challenge: Categorize Transactions

Challenge: Handle Missing Payment Methods

Advanced Logical Expressions

Challenge: Flag Suspicious Transactions

Challenge: Summarize Transaction Status

Understanding Null Functions

Challenge: Assign Default Bonuses

Challenge: Find Employees Without Managers

Advanced Null Handling

Challenge: Calculate Average Bonus

Challenge: Prevent Division by Zero

Introduction to JSON Functions

Challenge: Extract User Interests

Challenge: Find Users by City

Advanced JSON Manipulation

Challenge: Update User Age

Multi-level Aggregations for Business Reports

Window Functions: ROW_NUMBER, RANK, DENSE_RANK

Running Totals and Moving Averages

Period-over-Period Comparisons (MoM, YoY)

Cohort Analysis

Funnel Analysis with CASE WHEN + SUM

Customer Segmentation (RFM-style Logic)

Top-N per Group Reports

Pivot-Style Reports with CASE WHEN

KPI Calculations: Conversion, Retention, Churn, ARPU

Multi-step Analytical Pipelines with CTEs

Data Quality Checks as Analytical Queries

Advanced Window Functions: NTILE, PERCENT_RANK, CUME_DIST

Time Series Analysis: Gaps and Islands

Churn Prediction with SQL

Retention Curve Analysis

Dynamic Date Bucketing for Reports

Combining Multiple Analytical Techniques

Migliora le tue Competenze Tecnologiche!

con fino al 55% di sconto

Features:

*Tracks not included in Pro plan

500+ corsi Top-RatedCopilota AI all'avanguardia

Percorsi di studio personalizzati40+ progetti pratici reali

Senza cancellazione, prima della scadenza del piano scontato selezionato, accetto che Codefinity addebiti automaticamente $104 ogni 3 mesi fino a quando non annulli. Scopri di più sulla politica di cancellazione e rimborso in Termini di abbonamento.

Recommended Courses and Projects

Introduzione a SQL

Questo corso è perfetto per principianti pronti a esplorare il mondo di SQL. Che tu stia iniziando a gestire database o desideri utilizzare SQL per progetti di sviluppo applicazioni, questo corso copre gli elementi essenziali. Imparerai rapidamente a sfruttare tutto il potenziale di SQL, dalla consultazione e gestione dei dati all'integrazione fluida nelle applicazioni reali. Al termine del corso, avrai la sicurezza e le competenze per risolvere problemi pratici con SQL e migliorare il tuo processo di sviluppo.

SQL Intermedio

Questo corso è perfetto per coloro che hanno già una comprensione di base di SQL e vogliono approfondire concetti più avanzati per creare query più potenti. Durante il corso, diventerai familiare con il raggruppamento dei dati e il filtraggio dei dati raggruppati. Imparerai anche a lavorare con più tabelle contemporaneamente, incluso come combinarle. Inoltre, esplorerai diversi tipi di join di tabelle e come applicarli nella pratica.

Relational Database and Normalization

This course delves into the theory behind relational databases. You'll learn what they are and see how they differ from non-relational databases. Throughout the course, we'll walk you through the ins and outs of database design and familiarize you with various types of relationships. Additionally, you'll explore the concepts of normalization and normal forms, equipping you with the knowledge to craft efficient and optimized databases.

Ottimizzazione SQL e Funzionalità delle Query

Inizia un entusiasmante percorso attraverso SQL con Tecniche Avanzate in SQL. Approfondisci le proprietà fondamentali ACID che garantiscono l'integrità dei dati nelle transazioni di database. Scopri metodi avanzati per ottimizzare le query e migliorare le prestazioni del database. Esplora funzionalità speciali di SQL come funzioni di finestra, trigger, Data Control Language (DCL) e database NoSQL. Questo ti permetterà di gestire la moderna amministrazione dei database con sicurezza ed efficacia.

SQL Joins in Depth

Master the art of SQL joins with engaging, real-world examples and hands-on challenges. This course takes you from foundational join concepts to advanced multi-table queries, ensuring you can confidently analyze and combine data from multiple sources.

Introduction to Data Engineering with Azure

Master the essentials of data engineering with Microsoft Azure in this comprehensive course. Starting with foundational concepts like cloud computing, resource management, and storage solutions, you'll progress to hands-on training in Azure Data Factory (ADF), mastering ETL/ELT workflows, and advanced data transformations. Through practical examples and real-world problem-solving, you'll gain the skills to design, implement, and optimize scalable data solutions using Azure.

Functions in SQL

Master the use of built-in SQL functions to manipulate strings, dates, numbers, logical values, nulls, and JSON data. This course provides a hands-on approach to understanding and applying SQL functions in real-world scenarios, enhancing your data querying and transformation skills.

SQL for Data Analysis

A comprehensive beginner-friendly course designed to teach SQL from the ground up, focusing on practical data analysis skills. Through engaging explanations, real-world examples, and hands-on challenges, learners will master querying, transforming, and analyzing data using SQL.

Mastering CASE WHEN in SQL

A comprehensive course designed to help you master the CASE WHEN statement in SQL, from basic conditional logic to advanced use cases in data analysis and reporting. Through engaging theory and real-world tasks, you'll learn to write expressive, powerful queries that adapt to complex business requirements.

Window Functions in SQL

Master the art of analyzing data with SQL window functions. This course guides you through the core concepts, syntax, and practical applications of window functions, empowering you to perform advanced analytics and reporting directly in SQL.

Introduzione a SQL

SQL Data Types Explained

A beginner-friendly course that demystifies SQL data types, guiding you through their purpose, usage, and best practices. Learn how to choose the right data type for your data, avoid common pitfalls, and build robust, efficient databases.

Discover more Learning Tracks

traccia

Sviluppo di Giochi con Unity

Principiante

Produzione Video con Adobe

Principiante

Strumenti di Design UI/UX

Principiante

Competenze Essenziali per l'Ufficio

Principiante

Digital Marketing Essentials

Principiante

Complete Social Media Management

Principiante

Business AI Toolkit

Principiante

Sviluppo di Siti Web Senza Codice

Principiante

DevOps Specialist

Principiante

Supervised Learning Foundations

Principiante

Python from Zero to Hero

Principiante

C Programming Fundamentals

Principiante

Perché le Persone Scelgono Codefinity

Web Developer

Kwizera Mugisha

The teaching methodology at Codefinity is excellent, and I particularly appreciate how it has prepared me to handle real-world coding problems. Currently, I am delving into Node.js and eagerly anticipate building full-stack projects that integrate all the knowledge I have gained.

Senior Business Analyst

Sherry Barnes-Fox

My first course was 4 hours, I did it in a few days, "nugget-style". The instructions are very clear and easy to understand. There is even a hint to help you get the answer. I love the learning style that is used, it engages me.

Accounts Payable Specialist

Bill Wagner

I have really liked the browser-based lessons that allow me to code within the lesson. The RUN button allows me to test the code I write before submitting for a grade.

IT Support Specialist

Daniel Chinea

I have gained a lot of practical and logical thinking skills, along with patience for myself and confidence in myself that I can learn programming. Years ago, I would have never thought that I could learn programming in any way, shape or form, and I was able to obtain these certifications and skills with Codefinity.

Technology Project Manager

Steve Bruening

The learning was progressive and made it easy to follow along and make progress. I could feel my skills increasing and building on each other as the course went along.

Project Manager

Stephanie Chan

As I went through the first course of the Python track, I liked the way the course was lay out (in easy and digestible modules) with little exercises at the end of each concept.

Step-by-Step to Stellar Results

Ambiente di codifica interattivo

Entra nel nostro ambiente interattivo: scrivi ed esegui il tuo codice con feedback in tempo reale e metriche di successo—impara facendo ad ogni passo.

Supporto potenziato dall'AI

Sfrutta l'assistente AI integrato per spiegare errori, suggerire correzioni o rispondere a qualsiasi domanda sul tuo codice—così rimani produttivo e non ti blocchi mai.

Check your progress

Concludi ogni modulo con un quiz rapido che fornisce feedback immediato, traccia i tuoi progressi e assicura che tu abbia padroneggiato i concetti chiave.

Promote your expertise

Ottieni il tuo certificato riconosciuto dall'industria al completamento e condividilo su LinkedIn con un clic—fai vedere alla tua rete cosa sai fare.

Fidato dai Dipendenti delle Aziende Leader
e Studenti delle Università di Eccellenza

Accesso completo al catalogo

Un abbonamento ti consente di accedere a questo corso e all'intero catalogo di progetti e competenze.

Features:

500+ corsi Top-RatedCopilota AI all'avanguardia

Percorsi di studio personalizzati40+ progetti pratici reali

Prova Codefinity con fiducia – garanzia di rimborso di 30 giorni inclusa

Per darti il benvenuto su Codefinity, offriamo fino a 64% di sconto sui nostri corsi. Inoltre, abbiamo una garanzia di rimborso di 30 giorni, così puoi provarci senza rischi.Non vediamo l'ora di darti il benvenuto sulla nostra piattaforma e ci impegniamo a rendere la tua esperienza di apprendimento facile, interattiva e divertente.

Ready to get started?

Pro

Best intro offer

Ultimate

A complete experience
to kickstart your career

500+ Top-Rated courses

Completion certificates

Early access to new courses

40+ hands-on Real-world projects

Personalized study tracks

Unlimited workspaces

Accedi istantaneamente a 500+ corsi

Apprendimento Illimitato, Accesso ImmediatoOttieni pieno accesso a tutti i corsi e percorsi, inclusi contenuti video, quiz e materiali approfonditi—inizia a imparare in qualsiasi momento.

Certificati Riconosciuti dall'IndustriaOttieni certificati che convalidano la tua esperienza e potenziano la tua carriera in tecnologia, AI, dati, marketing e oltre.

Apprendimento assistito da IAOttieni suggerimenti personalizzati, feedback in tempo reale e spiegazioni potenziate dall'AI per accelerare i tuoi progressi.

In Costante Espansione: Nuovi Corsi e Percorsi di CarrieraRimani avanti con corsi costantemente aggiornati, roadmaps di carriera, sfide e test pratici.

Costruisci Competenze Che ContanoPadroneggia competenze richieste con corsi in AI, data science, programmazione, marketing, automazione, sviluppo web e altro.

Apprendimento Interattivo e Senza Soluzione di ContinuitàCoinvolgiti con progetti pratici, esercizi reali e un'esperienza di apprendimento intuitiva — senza bisogno di strumenti extra.

Cosa imparerai

Sviluppo di Giochi con Unity

Produzione Video con Adobe

Strumenti di Design UI/UX

Competenze Essenziali per l'Ufficio

Digital Marketing Essentials

Complete Social Media Management

Business AI Toolkit

Sviluppo di Siti Web Senza Codice

DevOps Specialist

Supervised Learning Foundations

Python from Zero to Hero

C Programming Fundamentals

Perché le Persone Scelgono Codefinity

Fidato dai Dipendenti delle Aziende Leader e Studenti delle Università di Eccellenza

Accesso completo al catalogo

Prova Codefinity con fiducia – garanzia di rimborso di 30 giorni inclusa

Accedi istantaneamente a 500+ corsi

Fidato dai Dipendenti delle Aziende Leader
e Studenti delle Università di Eccellenza