Linkedin - Querying Microsoft SQL Server 2022
大小
869.03 MB
文件数
71
Info Hash:
8A0B7078F94E6F14D638ED8057D422ED2F7D3840
收录时间
2026-01-13 01:41:18
更新时间
2026-01-13 02:02:33
文件列表 (71)
1. Introduction/1. Turn data into information with queries.mp4
3.99 MB
1. Introduction/2. What you should know.mp4
1.49 MB
1. Introduction/3. Download the sample database.mp4
7.91 MB
1. Introduction/4. Exploring the code challenge environment.mp4
4.14 MB
10. Result Set Operators/1. Combine results with UNION.mp4
8.92 MB
10. Result Set Operators/2. Return distinct rows with EXCEPT.mp4
12.34 MB
10. Result Set Operators/3. Return common rows with INTERSECT.mp4
10.32 MB
11. Conclusion/1. Next steps.mp4
2.03 MB
2. Introduction to T-SQL Queries/1. What is Transact SQL.mp4
6.95 MB
2. Introduction to T-SQL Queries/10. Solution- Query information from a database.mp4
17.69 MB
2. Introduction to T-SQL Queries/2. The SQL querying environment.mp4
25.98 MB
2. Introduction to T-SQL Queries/3. Return records with SELECT and FROM.mp4
24.15 MB
2. Introduction to T-SQL Queries/4. Filter records with WHERE.mp4
15.03 MB
2. Introduction to T-SQL Queries/5. Sort records with ORDER BY.mp4
9.78 MB
2. Introduction to T-SQL Queries/6. Column aliases.mp4
6.38 MB
2. Introduction to T-SQL Queries/7. Create values with constants and math.mp4
13.92 MB
2. Introduction to T-SQL Queries/8. Challenge- Write a SELECT query.mp4
2.27 MB
2. Introduction to T-SQL Queries/9. Solution- Write a SELECT query.mp4
14.37 MB
3. Additional Filter Techniques/1. Limit results with TOP.mp4
13.03 MB
3. Additional Filter Techniques/2. Remove duplicates with DISTINCT.mp4
7.94 MB
3. Additional Filter Techniques/3. Comparison operators.mp4
9.52 MB
3. Additional Filter Techniques/4. Understand NULL values.mp4
12.67 MB
3. Additional Filter Techniques/5. Match text with LIKE and wildcards.mp4
11.13 MB
3. Additional Filter Techniques/6. Challenge- Retrieve matching text strings.mp4
1.55 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.62 MB
4. Retrieve Records from Multiple Tables/1. Table joins and relationships.mp4
5.59 MB
4. Retrieve Records from Multiple Tables/2. Inner joins.mp4
23.47 MB
4. Retrieve Records from Multiple Tables/3. Left right and full outer joins.mp4
14.98 MB
4. Retrieve Records from Multiple Tables/4. Cross joins.mp4
13.17 MB
4. Retrieve Records from Multiple Tables/5. Challenge- Return data from multiple tables.mp4
1.88 MB
4. Retrieve Records from Multiple Tables/6. Solution- Return data from multiple tables.mp4
21.51 MB
4. Retrieve Records from Multiple Tables/7. Solution- Join data in multiple tables.mp4
10.57 MB
5. Group Records/1. Understand record grouping.mp4
5.88 MB
5. Group Records/2. Use GROUP BY and COUNT.mp4
14.9 MB
5. Group Records/3. Aggregate functions.mp4
6.18 MB
5. Group Records/4. Explore data with SUM.mp4
22.85 MB
5. Group Records/5. Filter groups with HAVING.mp4
10.2 MB
5. Group Records/6. Challenge- Obtain order summaries.mp4
2.58 MB
5. Group Records/7. Solution- Obtain order summaries.mp4
42.19 MB
5. Group Records/8. Solution- Group rows and aggregate data.mp4
8.05 MB
6. Manipulate Data with Functions/1. Use functions in T-SQL.mp4
7.41 MB
6. Manipulate Data with Functions/10. Create a series of values.mp4
16.65 MB
6. Manipulate Data with Functions/11. The IIF logical function.mp4
10.49 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.45 MB
6. Manipulate Data with Functions/14. Solution- Use functions in a SQL query.mp4
48.83 MB
6. Manipulate Data with Functions/15. Solution- Use functions in a query.mp4
9.91 MB
6. Manipulate Data with Functions/2. String functions.mp4
11.51 MB
6. Manipulate Data with Functions/3. Text concatenation.mp4
11.01 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.74 MB
6. Manipulate Data with Functions/6. Work with date functions.mp4
18.39 MB
6. Manipulate Data with Functions/7. FORMAT date and times.mp4
9.61 MB
6. Manipulate Data with Functions/8. Group dates into buckets.mp4
20.21 MB
6. Manipulate Data with Functions/9. Return random records with NEWID.mp4
6.98 MB
7. Writing SQL Scripts/1. Change database context with USE.mp4
8.83 MB
7. Writing SQL Scripts/2. Add comments to a script.mp4
10.04 MB
7. Writing SQL Scripts/3. When to use square brackets.mp4
5.32 MB
8. SQL Subqueries/1. What is a subquery.mp4
15.42 MB
8. SQL Subqueries/2. Use a subquery in a HAVING clause.mp4
19.67 MB
8. SQL Subqueries/3. Correlated subqueries.mp4
20.2 MB
8. SQL Subqueries/4. PIVOT the result set.mp4
12.48 MB
8. SQL Subqueries/5. Challenge- Write a query with a subquery.mp4
2.05 MB
8. SQL Subqueries/6. Solution- Write a query with a subquery.mp4
30.37 MB
8. SQL Subqueries/7. Solution- Obtain information with a subquery.mp4
14.46 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.26 MB
9. Work with Variables/4. Solution- Use variables in a query.mp4
14.66 MB
Ex_Files_Querying_Microsoft_SQL_Server_2022.zip
27.58 KB