This class was created by Brainscape user a a. Visit their profile to learn more about the creator.
By:
a a
- decks
- flashcards
- learners
Decks in this class (17)
Chapter 1 Foundations Of Querying
What are the mathematical branche...,
What is the difference between t ...,
What is a predicate
22
cards
Chapter 2 Using The From And Select Clauses
What is implicit schema name reso...,
How do you alias a queried table,
Why is the asterisks a bad practi...
88
cards
Chapter 3 Filtering and Sorting Data
What are the 3 query clauses that...,
What is two valued logic,
What is three valued logic
44
cards
Chapter 4 Combining Sets
What is database normalization,
What is a cross join,
In a self join is table aliasing ...
54
cards
Chapter 5 Grouping and Windowing
What is a data analysis function,
When does a query become a groupe...,
What happens when you invoke a gr...
71
cards
Chapter 6 Querying Full-Text Data
What is full text search,
What are the prerequisites before...,
What does full text search allow ...
39
cards
Chapter 7 Querying and Managing XML Data
What is xquery,
What are elements,
What are tags
81
cards
Chapter 8 Creating Tables and Enforcing Data Integrity
What is the main method used for ...,
How do tables work with the sql s...,
What are the system tables
78
cards
Chapter 9 Designing and Creating Views, Inline Functions, and Synonyms
What are views,
How do you create a view,
Does the create view statement ha...
41
cards
Chapter 10 Inserting, Updating, and Deleting Data
What are the 4 ways to insert dat...,
What is the insert values statement,
With insert values why should you...
37
cards
Chapter 11 Other Data Modification Aspects
What is the identity property,
What do you do when you want to s...,
What are the functions that you c...
57
cards
Chapter 12 Implementing Transactions, Error Handling, and Dynamic SQL
What is a transaction,
What do the terms commit and roll...,
What does the acid acronym stand for
98
cards
Chapter 13 Designing and Implementing T-SQL Routines
What is a stored procedure,
What types of stored procedures d...,
What are the important features o...
51
cards
Chapter 14 Using Tools to Analyze Performance
What is the relational engine,
What is the storage engine,
What are the 4 query execution ph...
43
cards
Chapter 15 Implementing Indexes and Statistics
What is a page,
What is an extent,
What are the two types of logical...
61
cards
Chapter 16 Understanding Cursors, Sets, and Temporary Tables
What is meant by the term set based,
What is meant by the term iterati...,
Why are set based solutions gener...
25
cards
Chapter 17 Understanding Further Optimization Aspects
What are iterators,
If a table is organized as a heap...,
What is a table scan
44
cards
More about
mssql exam 70-461: querying microsoft sql server 2012
- Class purpose General learning
Learn faster with Brainscape on your web, iPhone, or Android device. Study a a's MSSQL Exam 70-461: Querying Microsoft SQL Server 2012 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?
Querying Microsoft SQL Server 2012 Ex...
- 3 decks
- 37 flashcards
- 2 learners
Decks:
Chapter 1 Foundation Of Querying, Chapter 2 Getting Started With The Selec, Chapter 3 Filtering And Sorting Data, And more!
SQL Server 2012
- 3 decks
- 31 flashcards
- 5 learners
Decks:
Relational Database Concepts, Chapter 1 Intro To Relational Databases, Chapter 2 How To Use Management Studio, And more!
