Guide to Databases Last Updated : 30 Aug, 2025 Comments Improve Suggest changes 36 Likes Like Report This is a complete guide to databases, where you’ll learn the foundations and advanced concepts of the most widely used database technologies -SQL: The standard language to interact with relational databases.MySQL: A popular open-source database used in web applications and enterprises.PostgreSQL: An advanced open-source relational database known for reliability and performance.PL/SQL: Oracle’s procedural extension of SQL for writing powerful database programs.MongoDB: A NoSQL database that stores data in flexible, JSON-like documents.Here, you’ll understand how each of these works, what they’re used for, and how they fit into real-world applications.1. SQLSQL TutorialSQL Interview QuestionsSQL Cheat SheetSQL Exercises 2. MySQLMySQL Tutorial MySQL Interview Questions3. PostgreSQLPostgreSQL TutorialPostgreSQL Cheat Sheet PostgreSQL Exercises4. PL/SQLPL/SQL TutorialPL/SQL Interview Questions and Answers5. MongoDBMongoDB TutorialComplete MongoDB RoadmapMongoDB Interview Questions with Answers MongoDB Exercises Create Quiz Comment U udaymityym1 Follow 36 Improve U udaymityym1 Follow 36 Improve Article Tags : SQL Explore BasicsWhat is SQL?6 min readSQL Data Types3 min readSQL Operators4 min readSQL Commands | DDL, DQL, DML, DCL and TCL Commands4 min readSQL Database Operations3 min readSQL CREATE TABLE3 min readQueries & OperationsSQL SELECT Query3 min readSQL INSERT INTO Statement4 min readSQL UPDATE Statement3 min readSQL DELETE Statement3 min readSQL - WHERE Clause2 min readAliases in SQL2 min readSQL Joins & FunctionsSQL Joins (Inner, Left, Right and Full Join)4 min readSQL CROSS JOIN1 min readSQL | Date Functions3 min readSQL | String functions6 min readData Constraints & Aggregate FunctionsSQL NOT NULL Constraint2 min readSQL PRIMARY KEY Constraint5 min readSQL Count() Function4 min readSQL SUM() Function2 min readSQL MAX() Function3 min readAVG() Function in SQL2 min readAdvanced SQL TopicsSQL Subquery5 min readWindow Functions in SQL6 min readSQL Stored Procedures7 min readSQL Triggers5 min readSQL Performance Tuning6 min readSQL TRANSACTIONS6 min readDatabase Design & SecurityIntroduction of ER Model9 min readIntroduction to Database Normalization6 min readSQL Injection11 min readSQL Data Encryption5 min readSQL Backup4 min readWhat is Object-Relational Mapping (ORM) in DBMS?7 min read Like