| 01 - Change database context with USE.mp4 | 5.8 MB | ||
| 01 - Combine results with UNION.mp4 | 6.3 MB | ||
| 01 - Create and use variables in a query.mp4 | 10 MB | ||
| 01 - Limit results with TOP.mp4 | 9.8 MB | ||
| 01 - Next steps.mp4 | 1.9 MB | ||
| 01 - Next steps.srt | 3 KB | ||
| 01 - Table joins and relationships.mp4 | 4.5 MB | ||
| 01 - Turn data into information with queries.mp4 | 5.4 MB | ||
| 01 - Turn data into information with queries.srt | 1.9 KB | ||
| 01 - Understand record grouping.mp4 | 4.2 MB | ||
| 01 - Use functions in T-SQL.mp4 | 5.5 MB | ||
| 01 - What is Transact SQL.mp4 | 3.9 MB | ||
| 01 - What is a subquery.mp4 | 10.8 MB | ||
| 02 - Add comments to a script.mp4 | 7.3 MB | ||
| 02 - Create a counter for a looping statement.mp4 | 8.6 MB | ||
| 02 - Inner joins.mp4 | 19.7 MB | ||
| 02 - Remove duplicates with DISTINCT.mp4 | 7.2 MB | ||
| 02 - Return distinct rows with EXCEPT.mp4 | 9.6 MB | ||
| 02 - String functions.mp4 | 8.8 MB | ||
| 02 - The SQL querying environment.mp4 | 15.5 MB | ||
| 02 - Use GROUP BY and COUNT.mp4 | 12.2 MB | ||
| 02 - Use a subquery in a WHERE clause.mp4 | 13.2 MB | ||
| 02 - What you should know.srt | 1.3 KB | ||
| 03 - Aggregate functions.mp4 | 3.5 MB | ||
| 03 - Comparison operators.mp4 | 7.9 MB | ||
| 03 - Correlated subqueries.mp4 | 13.8 MB | ||
| 03 - Download the sample database.mp4 | 5.5 MB | ||
| 03 - Left, right, and full outer joins.mp4 | 11.8 MB | ||
| 03 - Return common rows with INTERSECT.mp4 | 9.3 MB | ||
| 03 - Return records with SELECT and FROM.mp4 | 17 MB | ||
| 03 - Text concatenation.mp4 | 9 MB | ||
| 03 - When to use square brackets.mp4 | 3.7 MB | ||
| 03 - When to use square brackets.srt | 2.7 KB | ||
| 04 - Cross joins.mp4 | 10.4 MB | ||
| 04 - Explore data with SUM.mp4 | 19.6 MB | ||
| 04 - Explore data with SUM.srt | 12.3 KB | ||
| 04 - Filter records with WHERE.mp4 | 12.9 MB | ||
| 04 - PIVOT the result set.mp4 | 9.7 MB | ||
| 04 - Round with mathematical functions.mp4 | 7.1 MB | ||
| 04 - Understand NULL values.mp4 | 10.4 MB | ||
| 05 - Filter groups with HAVING.mp4 | 8.1 MB | ||
| 05 - Match text with LIKE and wildcards.mp4 | 9.3 MB | ||
| 05 - Sort records with ORDER BY.mp4 | 6.5 MB | ||
| 05 - Work with date functions.mp4 | 12.4 MB | ||
| 06 - Column aliases.mp4 | 5.4 MB | ||
| 06 - FORMAT date and times.mp4 | 7.1 MB | ||
| 07 - Create values with constants.mp4 | 9.4 MB | ||
| 07 - Return random records with NEWID.mp4 | 5.2 MB | ||
| 08 - The IIF logical function.mp4 | 7.7 MB | ||
| ▲ 49 total files | |||
Code:
Title: Querying Microsoft SQL Server 2019
Publisher: Linkedin.Learning
Size: 395M (413209747 B)
Files: 9F
Date: 11/14/2019
Course #: Linkedin.Learning
Type: N/A
Published: November 14, 2019
Modified: N/A
URL: www.linkedin.com/learning/querying-microsoft-sql-server-2019
Author: Adam Wilbert
Duration:
Skill: Intermediate
Exer/Code: [ ]
Description:
Discover how to query data from SQL Server tables. In this
course, Adam Wilbert covers how to retrieve information stored in a
Microsoft SQL Server database using the Transact-SQL (T-SQL)
language. Learn the fundamental structure of a query and see how to
manipulate data through the use of built-in functions,
operators, filters, and other language features to return a
dataset that's formatted to meet a wide variety of needs and
perspectives. Upon wrapping up this course, you'll be equipped
with the commands and keywords you need to know to
effectively analyze your data.

| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 869 MB | xHOBBiTx | 1 year | 8 | 0 |
All Comments