Skip to main content
Category
Technologies

SQL Tutorials

Keep up to date with the latest techniques and resources for SQL Server. Our tutorials are full of free SQL Server training tips to help you learn, build, & grow.
Other technologies:
Artificial IntelligenceAWSAzureBusiness IntelligenceChatGPTDatabricksdbtDockerExcelGenerative AIGitGoogle Cloud PlatformHugging FaceJavaJuliaKafkaKubernetesLarge Language ModelsOpenAIPostgreSQLPower BIPythonRScalaSnowflakeSpreadsheetsSQLiteTableau
GroupTraining 2 or more people?Try DataCamp for Business
SQL

SQL Server Index: Boosting Database Performance

Discover the essentials of SQL Server indexes to optimize your database queries. Learn how to implement and manage indexes effectively. Enhance your skills with practical examples and expert tips.
Allan Ouko's photo

Allan Ouko

April 17, 2025

SQL

SQL INNER JOIN vs. OUTER JOIN: Key Differences

Understand SQL INNER JOIN vs. OUTER JOIN with examples and visual aids to enhance your database management skills.
Allan Ouko's photo

Allan Ouko

March 6, 2025

Data Engineering

What is First Normal Form (1NF)?

Learn how first normal form (1NF) can improve your database design by enforcing atomicity in your tables.
Marie Fayard's photo

Marie Fayard

January 22, 2025

SQL

SQL Subquery: A Comprehensive Guide

Discover how to master SQL subqueries to enhance your database queries. Learn about correlated, non-correlated, and recursive subqueries. Learn about execution order and how to combine SQL subqueries with other SQL features.
Allan Ouko's photo

Allan Ouko

January 16, 2025

SQL

CASE Statement in SQL Explained

Understand how to exploit SQL’s CASE statement to create categorical columns.
Eugenia Anello's photo

Eugenia Anello

January 16, 2025

SQL

SQL String Functions: A Beginner's Guide

Understand how to use SQL String Functions to clean and process text data efficiently.
Eugenia Anello's photo

Eugenia Anello

January 15, 2025

Data Engineering

Understanding SQL Transactions: A Comprehensive Guide

Discover SQL transactions, their importance, and how to implement them for reliable database management.
Oluseye Jeremiah's photo

Oluseye Jeremiah

January 14, 2025

SQL

Cartesian Product in SQL: A Comprehensive Guide

Discover the fundamentals of Cartesian products in SQL. Learn when and how to use them effectively, and explore best practices to optimize performance.
Allan Ouko's photo

Allan Ouko

January 13, 2025

SQL

SQL Materialized View: Enhancing Query Performance

Understand how materialized views improve query performance in SQL databases. Learn the limitations and best practices of materialized views in different databases.
Allan Ouko's photo

Allan Ouko

January 9, 2025

SQL

How to Join 3 Tables in SQL: Methods and Examples

Learn how to effectively join three tables in SQL. Discover practical methods and examples to enhance your data manipulation skills. Master SQL joins with ease.
Allan Ouko's photo

Allan Ouko

January 9, 2025

SQL

SQL Stored Procedure: Automate and Optimize Queries

Learn the basics of SQL stored procedures and how to implement them in different databases, including MySQL and SQL Server.
Allan Ouko's photo

Allan Ouko

January 8, 2025

Data Engineering

What is Second Normal Form (2NF)?

Learn how second normal form (2NF) can improve your database design by eliminating partial dependencies.
Marie Fayard's photo

Marie Fayard

January 6, 2025