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:
Training 2 or more people?Try DataCamp for Business
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
April 17, 2025
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
March 6, 2025
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
January 22, 2025
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
January 16, 2025
CASE Statement in SQL Explained
Understand how to exploit SQL’s CASE statement to create categorical columns.
Eugenia Anello
January 16, 2025
SQL String Functions: A Beginner's Guide
Understand how to use SQL String Functions to clean and process text data efficiently.
Eugenia Anello
January 15, 2025
Understanding SQL Transactions: A Comprehensive Guide
Discover SQL transactions, their importance, and how to implement them for reliable database management.
Oluseye Jeremiah
January 14, 2025
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
January 13, 2025
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
January 9, 2025
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
January 9, 2025
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
January 8, 2025
What is Second Normal Form (2NF)?
Learn how second normal form (2NF) can improve your database design by eliminating partial dependencies.
Marie Fayard
January 6, 2025