This class was created by Brainscape user Cat’s of Death. Visit their profile to learn more about the creator.
By:
Cat’s of Death
- decks
- flashcards
- learners
Decks in this class (13)
Lesson 1: Intro to Database Design and SQL
Data,
Database,
Database management system
16
cards
Lesson 2: SQL Server
Sql server management studio ssms,
Relational database management sy...,
New query button
10
cards
Lesson 3: Retrieving Data Result-Set
Keywords,
Select,
From
11
cards
Lesson 4: Sorting Data
Sort or sorting,
Order by,
Desc
5
cards
Lesson 5: Designing SQL Data Tables
Create table,
Alter table,
Constraint
14
cards
SQL Server Constraints
Not null,
Unique,
Primary key
8
cards
Lesson 6: Designing Data Rows
Insert into values,
Column list,
Value list
4
cards
Lesson 7: Getting Data From Two Tables
Table relationships,
Join,
Inner join
5
cards
Lesson 8:Retrieving Data From Multiple Tables
Subquery,
Select subquery,
Outer query
13
cards
Lesson 9: Keeping the Database Up to Date
Integrity,
Accuracy,
Consistency
8
cards
Lesson 10: Aggregate Functions
Aggregate function,
Built in function,
Count
9
cards
Lesson 11: SQL Views
View,
Virtual table,
Base table
9
cards
Lesson 12: Maximize Database Integrity and Performance
Constraints,
Default constraint,
Check column constraint
8
cards
More about
SQL
- Class purpose General learning
Learn faster with Brainscape on your web, iPhone, or Android device. Study Cat’s of Death's SQL 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?
BEGINNING SQL
- 6 decks
- 114 flashcards
- 59 learners
Decks:
Basic Select Worlddb, Advanced Select Worlddb, Functions Friendsdb, And more!
Interview Prep - SQL
- 26 decks
- 553 flashcards
- 5 learners
Decks:
Foundations Of Relational Sql, Logical And Physical Query Processing, Identifiers, And more!
T-SQL Transaction
- 14 decks
- 723 flashcards
- 22 learners
Decks:
Chapter 5 Grouping And Windowing, Chapter 7 Querying And Managing Xml Data, Chapter 8 Creating Tables And Enforcing, And more!
