Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

My-T-SQL 70-761 Exam

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

By: Stefan Belulescu
Start Studying

Decks in this class (12)

A1-Create Transact-SQL Select queries
Union union all,
Offset fetch,
Offset fetch def syntax remarks
17  cards
A2-Query multiple tables by using joins
What does the coalesce statement ...,
Inner outer joins,
Join conditions
7  cards
A3-Implement functions and aggregate data
What is sargable,
Sargable in general,
Sargable concretly
35  cards
A4-Modify data
Modifing an identity column,
Insert restrictions,
Insert identity restrictions
22  cards
B1-Query data by using the subqueries and APPLY
Using apply,
What is a subquery,
What are comparison operators tra...
9  cards
B2-Query data by using table expressions
What are common table expressions,
Where are ctes used,
What is the structure of a cte
16  cards
B3-Group and pivot data by using queries
Select over clause,
What is pivot and unpivot,
What is the syntax for pivot
13  cards
B4-Query temporal data non-temporal-relational data
Temporal tables,
System versioned temporal tablesy...,
How does temporal work
34  cards
C1-Create database programmability objects by using Transact-SQL
Output parameter,
What does with check option do,
Collate
54  cards
C2-Implement error handling and transactions
Try catch,
Error,
What is begin transaction
21  cards
C3-Implement data types and NULLs
Smallint,
Spacial data,
What is set xact_abort
13  cards
General
What is a predicate,
Where should predicates be used,
Execute parse runtime
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.

Learn more about spaced repetition

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 Data With Transact-SQL Exam ...
  • 2 decks
  • 103 flashcards
  • 1 learners
Decks: Manage Data With Transact Sql, Box Mastery, And more!
MySQL
  • 3 decks
  • 58 flashcards
  • 6 learners
Decks: Cluster, Tunning And Performance, Administracion, And more!
CVM 761
  • 2 decks
  • 100 flashcards
  • 1 learners
Decks: Exam 1, Exam 3, And more!
T-SQL
  • 1 decks
  • 27 flashcards
  • 2 learners
Decks: Beginning T Sql, And more!
Find Flashcards
Make Flashcards
Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions