TorBT - Torrents and Magnet Links Search Engine
Linkedin - Querying Microsoft SQL Server 2022
- Date: 2025-08-30
- Size: 869 MB
- Files: 71
File Name
Size
1. Introduction/1. Turn data into information with queries.mp4
4.0 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 MB
10. Result Set Operators/3. Return common rows with INTERSECT.mp4
10 MB
11. Conclusion/1. Next steps.mp4
2.0 MB
2. Introduction to T-SQL Queries/1. What is Transact SQL.mp4
7.0 MB
2. Introduction to T-SQL Queries/10. Solution- Query information from a database.mp4
18 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 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
14 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 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
13 MB
3. Additional Filter Techniques/5. Match text with LIKE and wildcards.mp4
11 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
15 MB
3. Additional Filter Techniques/8. Solution- Filter results from a query result.mp4
12 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
24 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 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
22 MB
4. Retrieve Records from Multiple Tables/7. Solution- Join data in multiple tables.mp4
11 MB
5. Group Records/1. Understand record grouping.mp4
5.9 MB
5. Group Records/2. Use GROUP BY and COUNT.mp4
15 MB
5. Group Records/3. Aggregate functions.mp4
6.2 MB
5. Group Records/4. Explore data with SUM.mp4
23 MB
5. Group Records/5. Filter groups with HAVING.mp4
10 MB
5. Group Records/6. Challenge- Obtain order summaries.mp4
2.6 MB
5. Group Records/7. Solution- Obtain order summaries.mp4
42 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
17 MB
6. Manipulate Data with Functions/11. The IIF logical function.mp4
10 MB
6. Manipulate Data with Functions/12. Write a CASE statement.mp4
15 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
49 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
12 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
16 MB
6. Manipulate Data with Functions/6. Work with date functions.mp4
18 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 MB
6. Manipulate Data with Functions/9. Return random records with NEWID.mp4
7.0 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 MB
8. SQL Subqueries/2. Use a subquery in a HAVING clause.mp4
20 MB
8. SQL Subqueries/3. Correlated subqueries.mp4
20 MB
8. SQL Subqueries/4. PIVOT the result set.mp4
12 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 MB
8. SQL Subqueries/7. Solution- Obtain information with a subquery.mp4
14 MB
9. Work with Variables/1. Create and use variables in a query.mp4
13 MB
9. Work with Variables/2. Create a counter for a looping statement.mp4
15 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
15 MB
Ex_Files_Querying_Microsoft_SQL_Server_2022.zip
28 kB