This class was created by Brainscape user Heather Smith. Visit their profile to learn more about the creator.
By:
Heather Smith
- decks
- flashcards
- learners
Decks in this class (26)
Foundations of Relational SQL
Why write sql in a standard way w...,
What mathematical model is standa...,
How is a relation from the relati...
34
cards
Logical and Physical Query Processing
What are the two processing sides...,
What is logical query processing,
What is physical query processing
9
cards
Identifiers
What is an identifier,
What are the characteristics of a...,
If an identifier doesn t follow t...
13
cards
Alias
When aliasing a table what should...,
If you alias a table can you stil...,
What are three options for assign...
5
cards
SELECT
What are the two main roles of th...,
Why is using select considered a ...,
What is the difference between st...
3
cards
FROM Clause
What are the two main roles of th...,
When you select a table in the fr...,
What happens when you omit the sc...
5
cards
JOINS
What does a cross join do,
What is the syntax for a cross join,
What do you need to do in a self ...
21
cards
Filtering Data
What is returned if you only spec...,
How does the not operator treat n...,
What is the proper form of a pred...
35
cards
Sorting Data
How can you guarantee data is sor...,
Which of these two clauses are co...,
What is the difference between a ...
16
cards
Keys
What is the difference between an...,
What are the typical options used...,
What does the identity column pro...
16
cards
Data Types
Name 6 high level categories of d...,
What is important to consider whe...,
Where should formatting of a valu...
26
cards
Literals
What is another name for a literal,
Why is it important to use the co...,
Give some examples of how the int...
10
cards
Date and Time Functions
Which functions return the curren...,
Getdate,
Current_timestamp
8
cards
Cast, Convert and Parse
What are some functions that can ...,
What is the difference between th...,
What is the proper syntax for the...
8
cards
TOP and OFFSET-FETCH
What data type is the number that...,
What happens if the percent top r...,
What clause do you typically also...
25
cards
Subquery
What is a self contained subquery,
What is a scalar subquery,
Where can a self contained scalar...
13
cards
Table Expressions
What is special about the table e...,
What are the four types of table ...,
Of the four table expressions whi...
54
cards
Views
How do you reference an existing ...,
Is the result set from the view o...,
What is the general structure use...
35
cards
UNION, UNION ALL, EXCEPT, INTERSECT
How does union work,
What is the general format of two...,
How is union all different from u...
14
cards
Grouped Queries
What is a grouped query,
How many rows are returned per group,
What is the difference between wh...
33
cards
Pivot and UnPivot
Of the three elements you should,
How does the for in work,
What if the distinct spreading va...
14
cards
Window Functions
What are the various window aggre...,
What are the three main parts in ...,
When using over with none of the ...
47
cards
Tables and Schemas
How many databases does a sql ser...,
What is meant by base tables,
What are two ways you can create ...
36
cards
Data Integrity Enforcement, Constraints and Indexes
Should you use rules or declarati...,
How are table constraints like vi...,
What are the 5 different types of...
39
cards
Synonyms
What is a synonym,
Syntax to create a synonym,
Does the object the synonym will ...
17
cards
INSERT and SELECT INTO
Which sql statements can you use ...,
Which of the four insert statemen...,
Do you need to specify a value fo...
17
cards
More about
interview prep - sql
- Class purpose General learning
Learn faster with Brainscape on your web, iPhone, or Android device. Study Heather Smith's Interview Prep - 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?
MSSQL Exam 70-461: Querying Microsoft...
- 17 decks
- 934 flashcards
- 115 learners
Decks:
Chapter 1 Foundations Of Querying, Chapter 2 Using The From And Select Clau, Chapter 3 Filtering And Sorting Data, And more!
Interview Prep
- 34 decks
- 570 flashcards
- 39 learners
Decks:
Tell Me About Yourself, Metrics, Defect Life Cycle, And more!
