- decks
- flashcards
- learners
Decks in this class (9)
Session 1 - data types and tables
Current_timestamp 1,
Getdate 2,
Sysdatetime 3
61
cards
Session 2 - Creating, querying data
What is the syntax for adding a c...,
What is the syntax for updating t...,
What is the delete syntax 3
26
cards
Session 3 - Constraints, views, triggers
What is the syntax for creating a...,
What is the syntax you can use in...,
What can t you have when creating...
40
cards
Session 4 - Combine datasets, Stored Procs, Error Checking
What are the criteria for using u...,
What s the difference between uni...,
Where do you put the order by in ...
30
cards
Session 5 - Aggregate Functions, spatial aggregates
List all window functions 1,
Cume_dist function 2,
Dense_rank function 3
48
cards
Session 6 - Sub queries, with, CTE, pivot, functions, GUIDS, XML, JSON, Temporal Tables
What are the keywords you can use...,
What is the equivalent word for a...,
What is the equivalent word for a...
95
cards
Session 7 - Transactions, Indexes, Optimize Queries, dynamic views, cursors
What is the term for when a datab...,
What is the term for when a datab...,
What are the characteristics of a...
72
cards
Final Study Topics
What are the 4 types of table exp...,
What are the 3 millisecond values...,
What is the only type of function...
12
cards
Temporal Tables
What is the syntax for creating a...,
What are the necessary elements f...,
How do you drop a temporal table 3
4
cards
More about
Sql 70-761 Certification
- Company name Unspecified
- Training purpose Unspecified
- Industry Unspecified
- Number of employees who could use this Unspecified
The creator of this class did not yet add a description for what is included in this class.
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
- 3 decks
- 274 flashcards
- 13 learners
Decks:
Create Transact Sql Select Queries, Query Data With Advanced T Sql Component, Program Databases By Using T Sql, 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!
70-461
- 17 decks
- 934 flashcards
- 76 learners
Decks:
Chapter 1 Foundations Of Querying, Chapter 2 Using The From And Select Clau, Chapter 3 Filtering And Sorting Data, And more!
Programação SQL
- 46 decks
- 1419 flashcards
- 4 learners
Decks:
Historia Do Sql E Introducao, Entidades De Um Banco De Dados, Estrutura Oracle Sql, And more!
