The database is an organized collection of related data or information that is treated as a single unit. The main purpose of the database is to store, collect, and retrieve information to be used by database-related applications.
This page will guide you through various topics one needs for learning Database and its related Topics.
- What is a Database?
- What is Relational Database(RDBMS)?
- What is an ACID property in the Database?
- What are Keys in a Database Table?
- What do you understand by Entity and Table Relationship(E-R) Model?
- What is Isolation Level in Database?
- Database Constraints
- What is Database View?
- What is Database Indexes ?
- Aggregate and Scalar Functions in Database
Advanced Topics
- What are Joins in SQL?
- What is Slowly Changing Dimensions?
- Database Normalizations
- Analyze retail DB using Structured Query Language(SQL)
- How to Run SQL Query Using Bash Script and Command-Line?
- What is CAP Theorem?
- What are SQL Unions ?
- What is Polyglot Persistence?
- What is NoSQL Database? NoSQL Database Explained
- Important difference between SQL and NoSQL Database
- What do you understand by Data Steward?
- What is Data Modelling? Overview and Concepts
- What is Stored Procedure?
- What is ETL Testing and its Importance?
- What is Metadata and why it’s important?
- Fill Factor in SQL Server