Decks in this Class (17):
-
Chapter 1 Foundations Of Querying
Chapter 1 Foundations Of Querying
Sample Cards:what are the mathematical branches th...,what is the difference between t sql and,what is a predicate22 CardsPreview Flashcards -
Chapter 2 Using The From And Select Claus
Chapter 2 Using The From And Select Clauses
Sample Cards:what is implicit schema name resolution,how do you alias a queried table,why is the asterisks a bad practice a...88 CardsPreview Flashcards -
Chapter 3 Filtering And Sorting Data
Chapter 3 Filtering and Sorting Data
Sample Cards:what are the 3 query clauses that enable,what is two valued logic,what is three valued logic44 CardsPreview Flashcards -
Chapter 4 Combining Sets
Chapter 4 Combining Sets
Sample Cards:what is database normalization,what is a cross join,in a self join is table aliasing mand...54 CardsPreview Flashcards -
Chapter 5 Grouping And Windowing
Chapter 5 Grouping and Windowing
Sample Cards:what is a data analysis function,when does a query become a grouped query,what happens when you invoke a group ...71 CardsPreview Flashcards -
Chapter 6 Querying Full Text Data
Chapter 6 Querying Full-Text Data
Sample Cards:what is full text search,what are the prerequisites before you...,what does full text search allow you ...39 CardsPreview Flashcards -
Chapter 7 Querying And Managing Xml Data
Chapter 7 Querying and Managing XML Data
Sample Cards:what is xquery,what are elements,what are tags81 CardsPreview Flashcards -
Chapter 8 Creating Tables And Enforcing D
Chapter 8 Creating Tables and Enforcing Data Integrity
Sample Cards:what is the main method used for storing,how do tables work with the sql serve...,what are the system tables78 CardsPreview Flashcards -
Chapter 9 Designing And Creating Views In
Chapter 9 Designing and Creating Views, Inline Functions, and Synonyms
Sample Cards:what are views,how do you create a view,does the create view statement have t...41 CardsPreview Flashcards -
Chapter 10 Inserting Updating And Deletin
Chapter 10 Inserting, Updating, and Deleting Data
Sample Cards:what are the 4 ways to insert data in...,what is the insert values statement,with insert values why should you spe...37 CardsPreview Flashcards -
Chapter 11 Other Data Modification Aspect
Chapter 11 Other Data Modification Aspects
Sample Cards:what is the identity property,what do you do when you want to speci...,what are the functions that you can u...57 CardsPreview Flashcards -
Chapter 12 Implementing Transactions Erro
Chapter 12 Implementing Transactions, Error Handling, and Dynamic SQL
Sample Cards:what is a transaction,what do the terms commit and rollback...,what does the acid acronym stand for98 CardsPreview Flashcards -
Chapter 13 Designing And Implementing T S
Chapter 13 Designing and Implementing T-SQL Routines
Sample Cards:what is a stored procedure,what types of stored procedures does sql,what are the important features of a ...51 CardsPreview Flashcards -
Chapter 14 Using Tools To Analyze Perform
Chapter 14 Using Tools to Analyze Performance
Sample Cards:what is the relational engine,what is the storage engine,what are the 4 query execution phases43 CardsPreview Flashcards -
Chapter 15 Implementing Indexes And Stati
Chapter 15 Implementing Indexes and Statistics
Sample Cards:what is a page,what is an extent,what are the two types of logical str...61 CardsPreview Flashcards -
Chapter 16 Understanding Cursors Sets And
Chapter 16 Understanding Cursors, Sets, and Temporary Tables
Sample Cards:what is meant by the term set based,what is meant by the term iterative s...,why are set based solutions generally...25 CardsPreview Flashcards -
Chapter 17 Understanding Further Optimiza
Chapter 17 Understanding Further Optimization Aspects
Sample Cards:what are iterators,if a table is organized as a heap wha...,what is a table scan44 CardsPreview Flashcards
Current Learners (3)
Popular Related Classes Brainscape Certified - ( See All )
Querying Microsoft SQL Server 2012 Ex...
3 Decks -
37 Cards -
2 Learners
Decks: Chapter 1 Foundation Of Querying, Chapter 2 Getting Started With The Se..., Chapter 3 Filtering And Sorting Data, And more!
Server 2012 MOAC 70-411
5 Decks -
155 Cards -
2 Learners
Decks: Lesson 1 Deploying And Managing Serve..., Lesson 2 Implementing Patch Management, Lesson 3 Monitoring Servers, And more!
Pro SQL Server 2012 Relational Databa...
2 Decks -
70 Cards -
1 Learners
Decks: Table Of Contents, Chapter 1 The Fundamentals, And more!