My-T-SQL 70-761 Exam

This class was created by Brainscape user Stefan Belulescu. Visit their profile to learn more about the creator.

Decks in this class (12)

A1-Create Transact-SQL Select queries
What is the difference between un...,
What are the characteristics of o...,
Offset fetch def syntax 3
17  cards
A2-Query multiple tables by using joins
What does the coalesce statement ...,
From where can inner and outer jo...,
Do columns used in a join conditi...
7  cards
A3-Implement functions and aggregate data
What is sargable 1,
What can prevent a predicate from...,
What can prevent an predicate bec...
35  cards
A4-Modify data
What staments are required when m...,
Mention one insert restrictions 2,
What is set identity_intert and w...
22  cards
B1-Query data by using the subqueries and APPLY
What does the apply operator do 1,
What is a subquery 2,
What are comparison operators tra...
9  cards
B2-Query data by using table expressions
What are common table expressions 1,
Where are cte s used 2,
What is the structure of a cte 3
16  cards
B3-Group and pivot data by using queries
What is select over clause and wh...,
What is pivot and unpivot 2,
What is the syntax for pivot 3
13  cards
B4-Query temporal data non-temporal-relational data
What are temporal tables 1,
What is a system versioned tempor...,
How does temporal work 3
34  cards
C1-Create database programmability objects by using Transact-SQL
What is an output parameter 1,
What does with check option do 2,
What is collate command 3
54  cards
C2-Implement error handling and transactions
What is trycatch and what are som...,
What is error and how would you u...,
What is begin transaction and wha...
21  cards
C3-Implement data types and NULLs
Should you use smallint as a prim...,
What spacial data can sql server ...,
What is set xact_abort 3
13  cards
General
What is a predicate 1,
Where can we use predicates 2,
What is execute time parse time a...
12  cards

More about
My-T-SQL 70-761 Exam

  • Class purpose General learning

Learn faster with Brainscape on your web, iPhone, or Android device. Study Stefan Belulescu's My-T-SQL 70-761 Exam 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 70-761 Certification
  • 9 decks
  • 388 flashcards
  • 10 learners
Decks: Session 1 Data Types And Tables, Session 2 Creating Querying Data, Session 3 Constraints Views Triggers, And more!
MYSQL
  • 19 decks
  • 505 flashcards
  • 49 learners
Decks: Retrieving Data From A Single Table, Retrieving Data From Multiple Tables, Inserting Updating And Deleting Data, And more!
T-SQL Transaction
  • 14 decks
  • 723 flashcards
  • 23 learners
Decks: Chapter 5 Grouping And Windowing, Chapter 7 Querying And Managing Xml Data, Chapter 8 Creating Tables And Enforcing, And more!
DPT 761 - Neuro Rehab II
  • 17 decks
  • 635 flashcards
  • 9 learners
Decks: Vestibular Anatomy And Overview, Vestibular Examination, Common Peripheral And Central Vestibular, And more!
Make Flashcards