Databases: Difference between revisions
Mr. MacKenty (talk | contribs) |
Mr. MacKenty (talk | contribs) |
||
| Line 25: | Line 25: | ||
* [[NoSQL]] (Advanced) | * [[NoSQL]] (Advanced) | ||
== | == See also == | ||
# Please take a look at our [[SQL]] page | # Please take a look at our [[SQL]] page | ||
Revision as of 15:53, 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)
See also[edit]
- Please take a look at our SQL page