1. Database Fundamentals and SQL
A database is an organized collection of structured data stored and accessed electronically from a computer system. To work with this data efficiently, applications rely on a Datab...
Read full chapter →The essential SQL And Databases cheat sheet: 8 concise chapters you can read in minutes, distilled from the full deck. When you're ready, drill the flashcards or test yourself under exam conditions.
A database is an organized collection of structured data stored and accessed electronically from a computer system. To work with this data efficiently, applications rely on a Datab...
Read full chapter →Inside a relational database, the table is the primary unit of structured storage. A table is composed of rows, which are individual records, and columns, which are named attribute...
Read full chapter →Data Definition Language, or DDL, is the part of SQL used to define and manage the structure of a database, including tables, indexes, and views. The three commands at the heart of...
Read full chapter →Data Manipulation Language, or DML, is the part of SQL used to read and change the data stored in tables. Its four main commands are SELECT for reading, INSERT for adding new rows,...
Read full chapter →SQL is not limited to reading individual rows. Aggregate functions such as COUNT(), SUM(), AVG(), MAX(), and MIN() perform calculations across sets of rows, producing summary value...
Read full chapter →As tables grow, raw scans become expensive, and indexes are the primary tool for speeding up lookups. An index is a data structure, much like the index at the back of a book, that...
Read full chapter →A transaction is a unit of work that takes the database from one consistent state to another, and it must satisfy the ACID properties. Atomicity guarantees that all of the operatio...
Read full chapter →The choice between SQL and NoSQL databases depends on the shape of the data and the demands of the application. SQL databases are relational and use a fixed schema, making them ide...
Read full chapter →Done reading?
Test yourself with the SQL And Databases practice exam — timed questions, instant score, full review of wrong answers. Free.
🎯 Take the Practice Exam →