Databases

Databases

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.

Big Ideas in Databases

• 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

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

A unit of abstract mathematical system subject to the laws of arithmetic.

Represent by means of a labelled, accurate diagram or graph, using a pencil. A ruler (straight edge) should be used for straight lines. Diagrams should be drawn to scale. Graphs should have points correctly plotted (if appropriate) and joined in a straight line or smooth curve.

Reach a conclusion from the information given.