Databases: Difference between revisions

From Computer Science Wiki
Line 7: Line 7:
== Big Ideas in Databases ==
== Big Ideas in Databases ==


* [[Data modeling]]
* [[Data modeling]]
*  [[Entity relationship diagramming]]
*  [[Entity relationship diagramming]]
*  Entity relationships
*  Working with entity relationships
*  [[Normalization]]
*  [[Normalization]]
*  [[Unique identifiers]]  
*  [[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
*  [[ACID]]
*  [[CRUD]]
*  [[NoSQL]] (Advanced)
 


== See also ==
== See also ==

Revision as of 13:29, 17 August 2017

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

See also

  1. Please take a look at our SQL page

References