T-SQL for Querying Microsoft SQL Server: Selected Topics
With exercises, Case Studies and a unique teaching method to get you deeply involved and in control of your studies
4.07 (7 reviews)
24
students
11 hours
content
Nov 2021
last update
$59.99
regular price
What you will learn
Understand the foundations of T-SQL. Understand the logical query processing of T-SQL
Filter and sorting data: Filter with predicates; filter data with TOP and OFFSET-FETCH; Sorting data
Combining set: Using joins (CROSS, INNER, OUTER joins) Multi-Join queries; Subqueries, Table Expressions, APPLY operator; Set operators (UNION, INTERSECT etc.)
Perform complex data analysis with Window functions: Window aggregate functions, Window Offset functions; LAG, LEAD, PARTITION, FIRST_VALUE, LAST_VALUE
Create tables and enforce data integrity: Create and alter tables; enforce data integrity; Check constraints, Default constraints, Primary/Foreign Key, Unique,
Understand various ways to insert data into tables: INSERT...VALUES; INSERT...SELECT; INSERT...EXEC (for stored procedures); SELECT...INTO;
Understand various ways to update data: Simple update; UPDATE statement; UPDATE based on joins; Nondeterministic UPDATE
Understand the UPDATE All-at-Once concept; UPDATE and Table Expression; UPDATE based on a variable
Understand the different ways to delete data: Simple data; using the DELETE statement; TRUNCATE statement; delete based on a join; delete using Table Expression
Screenshots
Related Topics
4399468
udemy ID
11/16/2021
course created date
1/3/2022
course indexed date
Bot
course submited by