codingstuff.io
ExploreTutorialsProblemsCS Subjects
Get Started
ExploreTutorialsProblemsCS Subjects
Get Started
codingstuff.io

Master the art of building software through interactive tutorials, real-world problems, and guided projects.

Pune, Maharashtra, India

codingstuffmail@gmail.com

Product

  • Explore
  • Tutorials
  • Problems
  • CS Subjects

Company

  • About
  • Contact
  • Privacy Policy
  • Terms & Conditions
  • Sitemap

© 2026 codingstuff.io. All rights reserved.

Built with ❤️ for developers everywhere

/
Tutorials/SQL & Databases
🗄️

SQL & Databases

The universal language of data — query, filter, join, and aggregate relational data across MySQL, PostgreSQL, and SQLite.

Start Learning

67 Topics

1Introduction to Databases2Types of Databases3Overview of SQL4Installing a SQL Database5Database Terminology6Creating a Database7Tables and Columns8Data Types9Primary Keys10Foreign Keys11Constraints12Creating Tables13Inserting Data14Selecting Data15Updating Data16Deleting Data17SQL Operators18SQL Functions19Aggregate Functions20Grouping Data21HAVING Clause22Joins Basics23INNER JOIN24LEFT JOIN25RIGHT JOIN26FULL OUTER JOIN27Self Join28Subqueries Basics29Correlated Subqueries30Views31Stored Procedures32Transactions33Indexing34Normalization35Denormalization36Database Backup and Restore37Performance Tuning38SQL Injection Prevention39Database Security Best Practices40Replication41Sharding42Partitioning43Clustering44NoSQL Databases Overview45Document Databases46Key-Value Stores47Column-Family Databases48Graph Databases49SQL vs NoSQL50Use Cases for SQL Databases51Use Cases for NoSQL Databases52Database Modeling Strategies53Data Integrity and Consistency54Query Optimization55Database Monitoring Tools56SQL Query Builders57ORMs Overview58Database Migration Tools59Cloud Databases60AWS RDS61Google Cloud SQL62Azure SQL Database63Database as a Service (DBaaS)64Serverless Databases65Database Automation and CI/CD66Continuous Integration for Databases67Database Version Control