This class was created by Brainscape user Juliet D. Visit their profile to learn more about the creator.
By:
Juliet D
- decks
- flashcards
- learners
Decks in this class (12)
Introduction to Databases
What is data 1,
What is information 2,
What is a database 3
15
cards
Introduction to Select Statements
What is a select statement 1,
What are some ways you can use th...,
What order will your columns be d...
32
cards
Table Components
What are some characteristics of ...,
What is a primary key 2,
What is a foreign key 3
33
cards
WHERE Syntax
What is the where statement syntax 1,
When do you need to add quotes ar...,
When do you not need to add quote...
23
cards
Concatenation
What does concatenation mean 1,
What happens if you try to concat...,
What are the two ways to concaten...
7
cards
Scalar Functions
What is a function in a sql state...,
What does concat do 2,
What does the left and right func...
64
cards
Linking Multiple Tables
What is a relational database 1,
How are the data in the tables re...,
What is a one to one relationship...
19
cards
Union, Intercept, Except
What does the union statement do 1,
What defines the column 2,
What two things must the data set...
8
cards
CASE Statements
How does a case statement work 1,
What are the two case statement e...,
What s the simple case syntax 3
9
cards
Working with Aggregates
What s an aggregate function 1,
In databases when you have a lot ...,
List everything you need to know ...
11
cards
Data Manipulation Language
What does select into do 1,
What does the into keyword do 2,
Where do you place the into keywo...
13
cards
Data Definition Language
0
cards
More about
SQL
- Class purpose General learning
Learn faster with Brainscape on your web, iPhone, or Android device. Study Juliet D'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?
SQL
- 5 decks
- 81 flashcards
- 293 learners
Decks:
Sql Basics, Fetch Data Insert Edit Rows And Tables, Filter Queries Operators And Wildcards, And more!
Sql Advanced DataBase
- 8 decks
- 598 flashcards
- 554 learners
Decks:
Test 1, Definitions Sql Test 1 1, Test 2, And more!
SQL
- 45 decks
- 888 flashcards
- 9 learners
Decks:
Intro To Databases Coursera Meta Backend, From Gpt, W3 Sql Intro, And more!
