This class was created by Brainscape user Cloy Fernandez. Visit their profile to learn more about the creator.
By:
Cloy Fernandez
- decks
- flashcards
- learners
Decks in this class (14)
Entities, Attributes, Data Type
What is a primary key pk in a dat...,
What is a foreign key fk,
Define a composite key
12
cards
From logical to physical
3 level of access,
Table creation order,
Data insertion order
10
cards
JOINs
Data query language dql,
Data manipulation language dml,
Data definition language ddl
16
cards
Data Manipulation
Filtering,
Condition,
Where
15
cards
GROUPING
Group by,
Having,
Union
4
cards
AGGREGATE FUNCTIONS
values of multiple rows are grouped together
6
cards
VIEWs, Indexing & Advanced Searching
View,
Advantages of using views,
Disadvantages of using views
6
cards
Nested Queries
What is a subquery in sql,
What are the advantages of using ...,
What are the disadvantages of usi...
11
cards
Database_Security_Flashcards
What are the key components of da...,
What are the main elements to ens...,
What is sql injection
15
cards
Database_Security_Flashcards_More
What is encryption,
Why is encryption important,
What are the types of data that r...
19
cards
Data Manipulation 6 - Complex Queries -
What is a complex query in sql,
What are some keywords and concep...,
What is the syntax for a case sta...
14
cards
database performacne
What is database performance,
Why is database tuning important,
What is database design in the co...
14
cards
Databases The Good, The Bad, the Ugly
What are the benefits of quick ac...,
How do databases ensure data inte...,
What are the advantages of data s...
19
cards
Database_Backups_Recovery_Flashcards
What is a database backup,
Why are backups important,
What are the types of backups
15
cards
More about
Databases
- Class purpose General learning
Learn faster with Brainscape on your web, iPhone, or Android device. Study Cloy Fernandez's Databases flashcards now!
How studying works.
Brainscape's adaptive web mobile flashcards system will drill you on your weaknesses, using a pattern guaranteed to help you learn more in less time.
Add your own flashcards.
Either request "Edit" access from the author, or make a copy of the class to edit as your own. And you can always create a totally new class of your own too!
What's Brainscape anyway?
Brainscape is a digital flashcards platform where you can find, create, share, and study any subject on the planet.
We use an adaptive study algorithm that is proven to help you learn faster and remember longer....
Looking for something else?
DATABASE SYSTEMS
- 14 decks
- 231 flashcards
- 4 learners
Decks:
Introduction To Databases, Introduction To Databases Ansi Sparc, Introduction To The Relational Model, And more!
Database
- 8 decks
- 78 flashcards
- 7 learners
Decks:
T Sql Denormalisering Og Redundans, Terminologi, Performance, And more!
