Databases: Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
[[file:Database.png|right|frame| | [[file:Database.png|right|frame|Databases<ref>http://www.flaticon.com/</ref>]] | ||
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.<ref>https://en.wikipedia.org/wiki/Database</ref> | 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.<ref>https://en.wikipedia.org/wiki/Database</ref> | ||
Revision as of 15:16, 5 April 2016
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