17 OCT 2024 - Welcome Back to TorrentFunk!
Get your pirate hat back out. Streaming is dying and torrents are the new trend.
Account Registration works again and so do Torrent Uploads.
We invite you all to start uploading torrents again!

TORRENT DETAILS

Linkedin - Querying Microsoft SQL Server 2022

TORRENT SUMMARY

	Status:	This torrent has NOT been verified.
Category:	Other
Infohash	8a0b7078f94e6f14d638ed8057d422ed2f7d3840
Size:	869 MB in 71 files
Release Date(s):	Torrent Release: 11-01-2025 by user
Swarm:	20 Seeds & 2 Peers
Vote:	No votes yet.

DESCRIPTION

Course details

Want to learn more about how to query data from SQL Server tables? In this course, instructor Adam Wilbert covers how to retrieve information stored in a Microsoft SQL Server database using the Transact-SQL (T-SQL) language and the updated features of SQL Server 2022.

Learn the fundamental structure of a successful query, from ideation to execution. Find out how to manipulate data through the use of built-in functions, operators, filters, and other language features to return a data set, ensuring that it’s properly formatted and applicable to a wide variety of needs and perspectives. Along the way, Adam gives you tips and pointers on how to get the most out of your queries. Upon completing this course, you'll be equipped with the commands and keywords you need to know to analyze your data more effectively.

VISITOR COMMENTS (0

)

FILE LIST

Filename		Size
	1. Introduction/1. Turn data into information with queries.mp4	4 MB
	1. Introduction/2. What you should know.mp4	1.5 MB
	1. Introduction/3. Download the sample database.mp4	7.9 MB
	1. Introduction/4. Exploring the code challenge environment.mp4	4.1 MB
	10. Result Set Operators/1. Combine results with UNION.mp4	8.9 MB
	10. Result Set Operators/2. Return distinct rows with EXCEPT.mp4	12.3 MB
	10. Result Set Operators/3. Return common rows with INTERSECT.mp4	10.3 MB
	11. Conclusion/1. Next steps.mp4	2 MB
	2. Introduction to T-SQL Queries/1. What is Transact SQL.mp4	7 MB
	2. Introduction to T-SQL Queries/10. Solution- Query information from a database.mp4	17.7 MB
	2. Introduction to T-SQL Queries/2. The SQL querying environment.mp4	26 MB
	2. Introduction to T-SQL Queries/3. Return records with SELECT and FROM.mp4	24.1 MB
	2. Introduction to T-SQL Queries/4. Filter records with WHERE.mp4	15 MB
	2. Introduction to T-SQL Queries/5. Sort records with ORDER BY.mp4	9.8 MB
	2. Introduction to T-SQL Queries/6. Column aliases.mp4	6.4 MB
	2. Introduction to T-SQL Queries/7. Create values with constants and math.mp4	13.9 MB
	2. Introduction to T-SQL Queries/8. Challenge- Write a SELECT query.mp4	2.3 MB
	2. Introduction to T-SQL Queries/9. Solution- Write a SELECT query.mp4	14.4 MB
	3. Additional Filter Techniques/1. Limit results with TOP.mp4	13 MB
	3. Additional Filter Techniques/2. Remove duplicates with DISTINCT.mp4	7.9 MB
	3. Additional Filter Techniques/3. Comparison operators.mp4	9.5 MB
	3. Additional Filter Techniques/4. Understand NULL values.mp4	12.7 MB
	3. Additional Filter Techniques/5. Match text with LIKE and wildcards.mp4	11.1 MB
	3. Additional Filter Techniques/6. Challenge- Retrieve matching text strings.mp4	1.5 MB
	3. Additional Filter Techniques/7. Solution- Retrieve matching text strings.mp4	14.9 MB
	3. Additional Filter Techniques/8. Solution- Filter results from a query result.mp4	11.6 MB
	4. Retrieve Records from Multiple Tables/1. Table joins and relationships.mp4	5.6 MB
	4. Retrieve Records from Multiple Tables/2. Inner joins.mp4	23.5 MB
	4. Retrieve Records from Multiple Tables/3. Left right and full outer joins.mp4	15 MB
	4. Retrieve Records from Multiple Tables/4. Cross joins.mp4	13.2 MB
	4. Retrieve Records from Multiple Tables/5. Challenge- Return data from multiple tables.mp4	1.9 MB
	4. Retrieve Records from Multiple Tables/6. Solution- Return data from multiple tables.mp4	21.5 MB
	4. Retrieve Records from Multiple Tables/7. Solution- Join data in multiple tables.mp4	10.6 MB
	5. Group Records/1. Understand record grouping.mp4	5.9 MB
	5. Group Records/2. Use GROUP BY and COUNT.mp4	14.9 MB
	5. Group Records/3. Aggregate functions.mp4	6.2 MB
	5. Group Records/4. Explore data with SUM.mp4	22.9 MB
	5. Group Records/5. Filter groups with HAVING.mp4	10.2 MB
	5. Group Records/6. Challenge- Obtain order summaries.mp4	2.6 MB
	5. Group Records/7. Solution- Obtain order summaries.mp4	42.2 MB
	5. Group Records/8. Solution- Group rows and aggregate data.mp4	8.1 MB
	6. Manipulate Data with Functions/1. Use functions in T-SQL.mp4	7.4 MB
	6. Manipulate Data with Functions/10. Create a series of values.mp4	16.6 MB
	6. Manipulate Data with Functions/11. The IIF logical function.mp4	10.5 MB
	6. Manipulate Data with Functions/12. Write a CASE statement.mp4	14.8 MB
	6. Manipulate Data with Functions/13. Challenge- Use functions in a SQL query.mp4	1.5 MB
	6. Manipulate Data with Functions/14. Solution- Use functions in a SQL query.mp4	48.8 MB
	6. Manipulate Data with Functions/15. Solution- Use functions in a query.mp4	9.9 MB
	6. Manipulate Data with Functions/2. String functions.mp4	11.5 MB
	6. Manipulate Data with Functions/3. Text concatenation.mp4	11 MB
	6. Manipulate Data with Functions/4. Round with mathematical functions.mp4	9.7 MB
	6. Manipulate Data with Functions/5. Find the GREATEST or LEAST value.mp4	15.7 MB
	6. Manipulate Data with Functions/6. Work with date functions.mp4	18.4 MB
	6. Manipulate Data with Functions/7. FORMAT date and times.mp4	9.6 MB
	6. Manipulate Data with Functions/8. Group dates into buckets.mp4	20.2 MB
	6. Manipulate Data with Functions/9. Return random records with NEWID.mp4	7 MB
	7. Writing SQL Scripts/1. Change database context with USE.mp4	8.8 MB
	7. Writing SQL Scripts/2. Add comments to a script.mp4	10 MB
	7. Writing SQL Scripts/3. When to use square brackets.mp4	5.3 MB
	8. SQL Subqueries/1. What is a subquery.mp4	15.4 MB
	8. SQL Subqueries/2. Use a subquery in a HAVING clause.mp4	19.7 MB
	8. SQL Subqueries/3. Correlated subqueries.mp4	20.2 MB
	8. SQL Subqueries/4. PIVOT the result set.mp4	12.5 MB
	8. SQL Subqueries/5. Challenge- Write a query with a subquery.mp4	2.1 MB
	8. SQL Subqueries/6. Solution- Write a query with a subquery.mp4	30.4 MB
	8. SQL Subqueries/7. Solution- Obtain information with a subquery.mp4	14.5 MB
	9. Work with Variables/1. Create and use variables in a query.mp4	12.8 MB
	9. Work with Variables/2. Create a counter for a looping statement.mp4	14.7 MB
	9. Work with Variables/3. Challenge- Use variables in a query.mp4	1.3 MB
	9. Work with Variables/4. Solution- Use variables in a query.mp4	14.7 MB
	Ex_Files_Querying_Microsoft_SQL_Server_2022.zip	27.6 KB

RELATED DOWNLOADS

Torrent Name

Added

Size

Seeds

Peers

Uploader

Health