Linkedin - Querying Microsoft SQL Server 2022

• Linkedin - Querying Microsoft SQL Server 2022
• 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

No comments yet.