Databases: Difference between revisions

From Computer Science Wiki
No edit summary
Line 23: Line 23:
== Looking to learn more ==
== Looking to learn more ==


# Please take a look at our [[sql]] page
# Please take a look at our [[SQL]] page


== Data Vs. Information ==  
== Data Vs. Information ==  

Revision as of 12:05, 13 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]

  1. Data modeling
  2. Entity relationship diagramming
  3. Entity relationships
  4. Working with entity relationships
  5. Unique identifiers and Normalization
  6. Transforming From Conceptual Model to Physical Model
  7. Introduction to SQL
  8. SELECT Statements and Relational Database Technology
  9. Using the WHERE Clause
  10. Restricting Rows and Introduction to Functions
  11. Using Character, Number, and Date Functions
  12. Using Single Row Functions
  13. Fundamentals of Database Security
  14. Understanding Database Transactions
  15. MySQL: monitoring and performance
  16. MySQL: security

Looking to learn more[edit]

  1. 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]

References[edit]