Databases: Difference between revisions

Revision as of 14:51, 20 August 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
ACID
CRUD
NoSQL (Advanced)

Looking to learn more[edit]

Please take a look at our SQL page

References[edit]

[1] ttp://www.flaticon.com/

[2] ttps://en.wikipedia.org/wiki/Database

[1]

[2]

@@ Line 28: / Line 28: @@
 # Please take a look at our [[SQL]] page
-== Data Vs. Information ==
-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.<ref>https://academy.oracle.com/en/oa-web-overview.html</ref>
 == References ==