Linkedin - Querying Microsoft SQL Server 2022
File List
| File | Size |
|---|---|
| 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 |
Trackers
No trackers found.