Linkedin - Querying Microsoft SQL Server 2019

seeders: 13
leechers: 4
updated:
Download torrent
Added by xHOBBiTx in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...

Files

Linkedin - Querying Microsoft SQL Server 2019 01 - Introduction
  • 01 - Turn data into information with queries.mp4 (5.4 MB)
  • 01 - Turn data into information with queries.srt (1.9 KB)
  • 02 - What you should know.mp4 (1,013.3 KB)
  • 02 - What you should know.srt (1.3 KB)
  • 03 - Download the sample database.mp4 (5.5 MB)
02 - Introduction to T-SQL Queries
  • 01 - What is Transact SQL.mp4 (3.9 MB)
  • 02 - The SQL querying environment.mp4 (15.5 MB)
  • 03 - Return records with SELECT and FROM.mp4 (17.0 MB)
  • 04 - Filter records with WHERE.mp4 (12.9 MB)
  • 05 - Sort records with ORDER BY.mp4 (6.5 MB)
  • 06 - Column aliases.mp4 (5.4 MB)
  • 07 - Create values with constants.mp4 (9.4 MB)
03 - Additional Filter Techniques
  • 01 - Limit results with TOP.mp4 (9.8 MB)
  • 02 - Remove duplicates with DISTINCT.mp4 (7.2 MB)
  • 03 - Comparison operators.mp4 (7.9 MB)
  • 04 - Understand NULL values.mp4 (10.4 MB)
  • 05 - Match text with LIKE and wildcards.mp4 (9.3 MB)
04 - Retrieve Records from Multiple Tables
  • 01 - Table joins and relationships.mp4 (4.5 MB)
  • 02 - Inner joins.mp4 (19.7 MB)
  • 03 - Left, right, and full outer joins.mp4 (11.8 MB)
  • 04 - Cross joins.mp4 (10.4 MB)
05 - Grouping Records
  • 01 - Understand record grouping.mp4 (4.2 MB)
  • 02 - Use GROUP BY and COUNT.mp4 (12.2 MB)
  • 03 - Aggregate functions.mp4 (3.5 MB)
  • 04 - Explore data with SUM.mp4 (19.6 MB)
  • 04 - Explore data with SUM.srt (12.3 KB)
  • 05 - Filter groups with HAVING.mp4 (8.1 MB)
06 - Manipulate Data with Functions
  • 01 - Use functions in T-SQL.mp4 (5.5 MB)
  • 02 - String functions.mp4 (8.8 MB)
  • 03 - Text concatenation.mp4 (9.0 MB)
  • 04 - Round with mathematical functions.mp4 (7.1 MB)
  • 05 - Work with date functions.mp4 (12.4 MB)
  • 06 - FORMAT date and times.mp4 (7.1 MB)
  • 07 - Return random records with NEWID.mp4 (5.2 MB)
  • 08 - The IIF logical function.mp4 (7.7 MB)
07 - Writing SQL Scripts
  • 01 - Change database context with USE.mp4 (5.8 MB)
  • 02 - Add comments to a script.mp4 (7.3 MB)
  • 03 - When to use square brackets.mp4 (3.7 MB)
  • 03 - When to use square brackets.srt (2.7 KB)
08 - SQL Subqueries
  • 01 - What is a subquery.mp4 (10.8 MB)
  • 02 - Use a subquery in a WHERE clause.mp4 (13.2 MB)
  • 03 - Correlated subqueries.mp4 (13.8 MB)
  • 04 - PIVOT the result set.mp4 (9.7 MB)
09 - Work with Variables
  • 01 - Create and use variables in a query.mp4 (10.0 MB)
  • 02 - Create a counter for a looping statement.mp4 (8.6 MB)
10 - Result Set Operators
  • 01 - Combine results with UNION.mp4 (6.3 MB)
  • 02 - Return distinct rows with EXCEPT.mp4 (9.6 MB)
  • 03 - Return common rows with INTERSECT.mp4 (9.3 MB)
11 - Conclusion
  • 01 - Next steps.mp4 (1.9 MB)
  • 01 - Next steps.srt (3.0 KB)

Description

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.







Download torrent
394.1 MB
seeders:13
leechers:4
Linkedin - Querying Microsoft SQL Server 2019
Loading...