SQL from Zero to Hero
Beginner
0.0
0 reviews
0 Learners
This track covers both fundamental and advanced SQL techniques, enabling confident data management, query optimization, and data analysis. It explores…
188
Chapters
24
Learning hours
316
Assignments
AI Assistant
Shareable Certificate
Resultater
Resultater
Track content
Related courses and projects
Udtalelser
Funktioner
Priser
Resultater
Resultater
Track content
Related courses and projects
Udtalelser
Funktioner
Priser
Hvad du vil lære
Retrieving data with SQL SELECT statement
Using aggregate functions for data summary
Joining tables with INNER, LEFT, RIGHT, FULL JOIN
Sorting data using ORDER BY clause
Grouping data with GROUP BY and HAVING
Understanding relational database design
Filtering data with WHERE clause
Creating nested subqueries for complex queries
Applying SQL functions for data manipulation
Learning track content
Hentning af Individuelle Kolonner
Hentning af Flere Kolonner
Hentning af Alle Kolonner
Hentning af Unikke Rækker
Begrænsning af Resultater
Udfordring: Find Befolkningen i Landene
Udfordring: Find Alle Lande
Udfordring: Find Alle Lande med Deres Id'er
Udfordring: Find Landehovedstæder
Udfordring: Find de Regioner, Hvor Alle Lande er Placeret
Sortering af Data
Udfordring: Populationsortering
Sortering Efter Flere Kolonner
Udfordring: Dobbelt-Sorteringsforespørgsel
Angivelse af Sorteringsretning
Udfordring: Sorter Landene Efter Region og Hovedstad
Udfordring: Sorter Hovedstæder i Faldende Rækkefølge
Udfordring: Sorter Lande i Stigende Rækkefølge
Udfordring: Find Lande, Deres Id'er og Deres Befolkninger
Udfordring: Find Alle Kontinenter og Sorter Dem i Stigende Rækkefølge
Brug af WHERE-Klausulen
Udfordring: Nordamerikansk Befolkningssortering
WHERE-sætningens Operatorer
Udfordring: Populationsgrænseforespørgsel
Kontrol af et Interval af Værdier
Kontrol for Ingen Værdi
Brug af AND-Operatoren
Udfordring: Sortering af Europa-Regionen
Brug af OR-Operatoren
Udfordring: Filtrering af Amerikanske Regioner
Brug af NOT-Operatoren
Udfordring: Sortering af Ikke-Europæiske Hovedstæder
AVG()-Funktionen
Udfordring: Valg af Overfladeareal
COUNT()-Funktionen
Udfordring: Kontinental Optælling
MAX()-Funktionen
MIN()-Funktionen
Udfordring: Gennemsnit for Stort Overfladeareal
SUM()-Funktionen
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
DBMS Overview
Difference between Relational and Non-relational Databases
Entity-Relationship Model
Entity-Relationship Model. Relationships
Structure. Primary Key and Foreign Key
Foreign Key Constraints. ON DELETE Options
Many-to-One and One-to-Many
One-to-One and Many-to-Many
Normalization
First Normal Form
Second Normal Form
Third Normal Form
Understanding CASE WHEN Syntax
Challenge: Categorize Sales Volume
Challenge: Regional Discount Flag
CASE WHEN in SELECT Clauses
Challenge: Price Tier Assignment
Challenge: Sales Performance Label
Nested and Multiple CASE WHEN Conditions
Challenge: Employee Bonus Eligibility
Challenge: Departmental Salary Bands
CASE WHEN with NULL and Missing Data
Challenge: Handle Missing Employee Data
Challenge: Custom Welcome Messages
CASE WHEN in WHERE Clauses
Challenge: Genre-Specific Movie Selection
Challenge: Blockbuster Filter
CASE WHEN in ORDER BY Clauses
Challenge: Custom Movie Ranking
Challenge: Release Year Priority
CASE WHEN with Aggregate Functions
Challenge: Customer Spending Analysis
Challenge: High-Value Transaction Count
CASE WHEN for Custom Reports
Challenge: Transaction Type Breakdown
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
What is ACID?
Atomicity
Challenge: Transaction Creation
Consistency
Isolation
Isolation. Repeatable Read and Serializable Levels
Challenge: Specifying Isolation Level for Transaction
What are Indexes
B-tree Indexing
Challenge: Creating B-tree Index
Hash Indexing
Data Caching
General Optimization Strategies
Challenge: Query Optimization
Triggers
NoSQL
Tables and Data Organization
Primary Keys and Uniqueness
Foreign Keys and Relationships
One-to-Many and Many-to-Many Relationships
Normalization: Eliminating Redundancy
Denormalization and Performance Trade-offs
Self-Referencing Tables and Hierarchies
Polymorphic Associations
Inheritance Mapping Strategies
Handling Many-to-Many Relationships with Attributes
Temporal Data and History Tables
Soft Deletes and Data Archiving
Vertical and Horizontal Partitioning
Database Sharding
Schema Versioning and Evolution
Flexible Data Models: EAV and JSON Columns
Multi-Tenancy Patterns
Read/Write Optimization Patterns
Boost dine Tech Færdigheder!
med op til 55% rabat
Features:
*Tracks not included in Pro plan
500+ Topbedømte kurserBanebrydende AI Copilot
Personlige studieveje40+ praktiske virkelige projekter
Uden afbestilling, før den valgte rabatplan udløber, accepterer jeg, at Codefinity automatisk opkræver $104 hver 3. måned indtil jeg annullerer. Læs mere om afbestillings- og refunderingspolitikken på Abonnementsvilkår.
Recommended Courses and Projects
kursus
Introduktion til SQL
Dette kursus er ideelt for begyndere, der er klar til at udforske SQL-verdenen. Uanset om du lige er startet med databaseadministration eller ønsker at bruge SQL i dine applikationsudviklingsprojekter, dækker dette kursus det grundlæggende. Du lærer hurtigt at udnytte det fulde potentiale i SQL, fra forespørgsler og håndtering af data til problemfri integration i virkelige applikationer. Ved kursets afslutning vil du have selvtilliden og færdighederne til at løse praktiske problemer med SQL og forbedre din udviklingsproces.
4 timer
41 kapitlerBegynder
88 STUDERER NU
kursus
Mellemliggende SQL
Dette kursus er perfekt for dem, der allerede har en grundlæggende forståelse af SQL og ønsker at dykke ned i mere avancerede begreber for at skabe mere kraftfulde forespørgsler. Gennem kurset vil du blive fortrolig med datagruppering og filtrering af grupperede data. Du vil også lære at arbejde med flere tabeller samtidigt, herunder hvordan man kombinerer dem. Derudover vil du udforske forskellige typer tabelsammenføjninger og hvordan man anvender dem i praksis.
3 timer 25 kapitlerMellemniveau
52 STUDERER NU
kursus
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.
1 time 12 kapitlerBegynder
13 STUDERER NU
kursus
SQL-optimering og Forespørgselsfunktioner
Begynd en spændende rejse gennem SQL med avancerede teknikker i SQL. Lær om de vigtige ACID-egenskaber, der sikrer datanøjagtighed i databasetransaktioner. Opdag avancerede metoder til at optimere dine forespørgsler for at forbedre databaseydelsen. Udforsk særlige SQL-funktioner som vinduesfunktioner, triggere, Data Control Language (DCL) og NoSQL-databaser. Dette vil hjælpe dig med at håndtere moderne databasestyring sikkert og effektivt.
4 timer 22 kapitlerAvanceret
2 STUDERER NU
kursus
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.
2 timer 21 kapitlerBegynder
15 STUDERER NU
kursus
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.
3 timer 24 kapitlerMellemniveau
2 STUDERER NU
kursus
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.
2 timer 18 kapitlerMellemniveau
7 STUDERER NU
kursus
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.
3 timer 35 kapitlerBegynder
9 STUDERER NU
kursus
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.
3 timer 24 kapitlerMellemniveau
7 STUDERER NU
kursus
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.
4 timer 22 kapitlerAvanceret
2 STUDERER NU
kursus
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.
2 timer 18 kapitlerBegynder
1 STUDERER NU
kursus
SQL Query Execution
Explore the internal workings of SQL query execution. This course demystifies what happens after you write a SELECT statement, covering parsing, planning, optimization, execution, and result delivery. Gain a deep understanding of the SQL engine's processes and how queries are transformed from text to results.
1 time 12 kapitlerBegynder
1 STUDERER NU
Discover more Learning Tracks
spor
C++ Grundlæggende
6 Kurser
124 OpgaverBegynder
4.3
(1328)
spor
Spiludvikling med Unity
4 Kurser164 OpgaverBegynder
4.4
(299)
spor
Bliv En React-Udvikler
4 Kurser73 OpgaverMellemniveau
4.3
(124)
spor
Full Stack Webudvikling
7 Kurser386 OpgaverBegynder
4.6
(1485)
spor
Frontend Udviklingsgrundlag
6 Kurser374 OpgaverBegynder
4.6
(1418)
spor
Java Web
6 Kurser240 OpgaverAvanceret
4.7
(4437)
spor
Bliv QA-Ingeniør
5 Kurser315 OpgaverBegynder
4.6
(1209)
spor
Videoproduktion med Adobe
4 Kurser123 OpgaverBegynder
5.0
(13)
spor
UI/UX Designværktøjer
4 Kurser161 OpgaverBegynder
4.8
(24)
spor
Essentielle Kontorfærdigheder
3 Kurser75 OpgaverBegynder
4.5
(884)
spor
Digital Marketing Essentials
6 Kurser293 OpgaverBegynder
4.4
(28)
spor
Complete Social Media Management
5 Kurser206 OpgaverBegynder
4.7
(19)
Hvorfor Folk Vælger 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
Interaktivt kodningsmiljø
Dyk ned i vores interaktive miljø: skriv og kør din kode med feedback i realtid og succesmålinger—lær ved at gøre på hvert trin.
AI-drevet support
Udnyt den indbyggede AI-assistent til at forklare fejl, foreslå rettelser eller besvare spørgsmål om din kode—så du forbliver produktiv og aldrig går i stå.
Check your progress
Afslut hvert modul med en hurtig quiz, der giver øjeblikkelig feedback, sporer din fremgang og sikrer, at du har mestret nøglekoncepter.
Promote your expertise
Tjen dit brancheanerkendte certifikat ved afslutning og del det på LinkedIn med ét klik—lad dit netværk se, hvad du kan.
Betroet af Medarbejdere fra Ledende Virksomheder
og Studerende fra Topuniversiteter
Fuld adgang til kataloget
Et abonnement åbner dette kursus og hele vores katalog af projekter og færdigheder.Features:
500+ Topbedømte kurserBanebrydende AI Copilot
Personlige studieveje40+ praktiske virkelige projekter
Uden afbestilling, før den valgte rabatplan udløber, accepterer jeg, at Codefinity automatisk opkræver $104 hver 3. måned indtil jeg annullerer. Læs mere om afbestillings- og refunderingspolitikken på Abonnementsvilkår.
Prøv Codefinity med tillid – 30-dages pengene-tilbage-garanti inkluderet
For at byde dig velkommen til Codefinity, tilbyder vi op til 64% rabat på vores kurser. Plus, vi har en 30-dages pengene-tilbage-garanti, så du kan prøve os uden risiko.Vi ser virkelig frem til at byde dig velkommen til vores platform og er engagerede i at gøre din læringsoplevelse nem, interaktiv og sjov.
Ready to get started?
Pro
Best intro offer
Ultimate
A complete experience
to kickstart your career
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
Få øjeblikkelig adgang til 500+ kurser
Ubegrænset Læring, Øjeblikkelig AdgangFå fuld adgang til alle kurser og spor, inklusive videoindhold, quizzer og dybdegående materialer—start læring når som helst.
Brancheanerkendte CertifikaterTjen certifikater, der validerer din ekspertise og styrker din karriere inden for tech, AI, data, marketing og mere.
KI-assisteret læringFå personlige hints, feedback i realtid og AI-drevne forklaringer for at fremskynde din fremgang.
Konstant Udvidelse: Nye Kurser & KarriereforløbHold dig foran med konstant opdaterede kurser, karriereplaner, udfordringer og praktiske prøver.
Opbyg Færdigheder Der TællerMestre efterspurgte færdigheder med kurser i AI, datavidenskab, programmering, marketing, automatisering, webudvikling og mere.
Interaktiv & Problemfri LæringEngager dig med praktiske projekter, virkelige øvelser og en intuitiv læringsoplevelse — ingen ekstra værktøjer nødvendige.
