Databases: Difference between revisions
| Line 5: | Line 5: | ||
== Big Ideas in Databases == | == Big Ideas in Databases == | ||
# Data modeling | # Data modeling | ||
# Entity relationship diagramming | # [[Entity relationship diagramming]] | ||
# Entity relationships | # Entity relationships | ||
# Working with entity relationships | # Working with entity relationships | ||
Revision as of 08:16, 22 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]
Big Ideas in Databases[edit]
- Data modeling
- Entity relationship diagramming
- Entity relationships
- Working with entity relationships
- Normalization
- Unique identifiers
- 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
Looking to learn more[edit]
- Please take a look at our SQL page
Data Vs. Information[edit]
The words "data" and "information" are often used as if they are synonyms. Nevertheless, they have different meanings.
- Data is raw material from which you can draw conclusions; facts from which you can deduce new facts.
- Information is knowledge, intelligence, a particular piece of data with a special meaning or function. Information is often the result of combining, comparing, and performing calculations on data.[3]