Databases
Databases[1]
A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views and other objects. The data are typically organized to model aspects of reality in a way that supports processes requiring information, such as modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies.[2]
- Data modeling
- Entity relationship diagramming
- Entity relationships
- Working with entity relationships
- Unique identifiers and Normalization
- Transforming From Conceptual Model to Physical Model
- Introduction to SQL
- SELECT Statements and Relational Database Technology
- Using the WHERE Clause
- Restricting Rows and Introduction to Functions
- Using Character, Number, and Date Functions
- Using Single Row Functions
- Fundamentals of Database Security
- Understanding Database Transactions
- MySQL: monitoring and performance
- MySQL: security