Linkedin - Querying Microsoft SQL Server 2022
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
1. Introduction/1. Turn data into information with queries.mp4 3.99 MiB 1. Introduction/2. What you should know.mp4 1.49 MiB 1. Introduction/3. Download the sample database.mp4 7.91 MiB 1. Introduction/4. Exploring the code challenge environment.mp4 4.14 MiB 10. Result Set Operators/1. Combine results with UNION.mp4 8.92 MiB 10. Result Set Operators/2. Return distinct rows with EXCEPT.mp4 12.34 MiB 10. Result Set Operators/3. Return common rows with INTERSECT.mp4 10.32 MiB 11. Conclusion/1. Next steps.mp4 2.03 MiB 2. Introduction to T-SQL Queries/1. What is Transact SQL.mp4 6.95 MiB 2. Introduction to T-SQL Queries/10. Solution- Query information from a database.mp4 17.69 MiB 2. Introduction to T-SQL Queries/2. The SQL querying environment.mp4 25.98 MiB 2. Introduction to T-SQL Queries/3. Return records with SELECT and FROM.mp4 24.15 MiB 2. Introduction to T-SQL Queries/4. Filter records with WHERE.mp4 15.03 MiB 2. Introduction to T-SQL Queries/5. Sort records with ORDER BY.mp4 9.78 MiB 2. Introduction to T-SQL Queries/6. Column aliases.mp4 6.38 MiB 2. Introduction to T-SQL Queries/7. Create values with constants and math.mp4 13.92 MiB 2. Introduction to T-SQL Queries/8. Challenge- Write a SELECT query.mp4 2.27 MiB 2. Introduction to T-SQL Queries/9. Solution- Write a SELECT query.mp4 14.37 MiB 3. Additional Filter Techniques/1. Limit results with TOP.mp4 13.03 MiB 3. Additional Filter Techniques/2. Remove duplicates with DISTINCT.mp4 7.94 MiB 3. Additional Filter Techniques/3. Comparison operators.mp4 9.52 MiB 3. Additional Filter Techniques/4. Understand NULL values.mp4 12.67 MiB 3. Additional Filter Techniques/5. Match text with LIKE and wildcards.mp4 11.13 MiB 3. Additional Filter Techniques/6. Challenge- Retrieve matching text strings.mp4 1.55 MiB 3. Additional Filter Techniques/7. Solution- Retrieve matching text strings.mp4 14.90 MiB 3. Additional Filter Techniques/8. Solution- Filter results from a query result.mp4 11.62 MiB 4. Retrieve Records from Multiple Tables/1. Table joins and relationships.mp4 5.59 MiB 4. Retrieve Records from Multiple Tables/2. Inner joins.mp4 23.47 MiB 4. Retrieve Records from Multiple Tables/3. Left right and full outer joins.mp4 14.98 MiB 4. Retrieve Records from Multiple Tables/4. Cross joins.mp4 13.17 MiB 4. Retrieve Records from Multiple Tables/5. Challenge- Return data from multiple tables.mp4 1.88 MiB 4. Retrieve Records from Multiple Tables/6. Solution- Return data from multiple tables.mp4 21.51 MiB 4. Retrieve Records from Multiple Tables/7. Solution- Join data in multiple tables.mp4 10.57 MiB 5. Group Records/1. Understand record grouping.mp4 5.88 MiB 5. Group Records/2. Use GROUP BY and COUNT.mp4 14.90 MiB 5. Group Records/3. Aggregate functions.mp4 6.18 MiB 5. Group Records/4. Explore data with SUM.mp4 22.85 MiB 5. Group Records/5. Filter groups with HAVING.mp4 10.20 MiB 5. Group Records/6. Challenge- Obtain order summaries.mp4 2.58 MiB 5. Group Records/7. Solution- Obtain order summaries.mp4 42.19 MiB 5. Group Records/8. Solution- Group rows and aggregate data.mp4 8.05 MiB 6. Manipulate Data with Functions/1. Use functions in T-SQL.mp4 7.41 MiB 6. Manipulate Data with Functions/10. Create a series of values.mp4 16.65 MiB 6. Manipulate Data with Functions/11. The IIF logical function.mp4 10.49 MiB 6. Manipulate Data with Functions/12. Write a CASE statement.mp4 14.80 MiB 6. Manipulate Data with Functions/13. Challenge- Use functions in a SQL query.mp4 1.45 MiB 6. Manipulate Data with Functions/14. Solution- Use functions in a SQL query.mp4 48.83 MiB 6. Manipulate Data with Functions/15. Solution- Use functions in a query.mp4 9.91 MiB 6. Manipulate Data with Functions/2. String functions.mp4 11.51 MiB 6. Manipulate Data with Functions/3. Text concatenation.mp4 11.01 MiB 6. Manipulate Data with Functions/4. Round with mathematical functions.mp4 9.70 MiB 6. Manipulate Data with Functions/5. Find the GREATEST or LEAST value.mp4 15.74 MiB 6. Manipulate Data with Functions/6. Work with date functions.mp4 18.39 MiB 6. Manipulate Data with Functions/7. FORMAT date and times.mp4 9.61 MiB 6. Manipulate Data with Functions/8. Group dates into buckets.mp4 20.21 MiB 6. Manipulate Data with Functions/9. Return random records with NEWID.mp4 6.98 MiB 7. Writing SQL Scripts/1. Change database context with USE.mp4 8.83 MiB 7. Writing SQL Scripts/2. Add comments to a script.mp4 10.04 MiB 7. Writing SQL Scripts/3. When to use square brackets.mp4 5.32 MiB 8. SQL Subqueries/1. What is a subquery.mp4 15.42 MiB 8. SQL Subqueries/2. Use a subquery in a HAVING clause.mp4 19.67 MiB 8. SQL Subqueries/3. Correlated subqueries.mp4 20.20 MiB 8. SQL Subqueries/4. PIVOT the result set.mp4 12.48 MiB 8. SQL Subqueries/5. Challenge- Write a query with a subquery.mp4 2.05 MiB 8. SQL Subqueries/6. Solution- Write a query with a subquery.mp4 30.37 MiB 8. SQL Subqueries/7. Solution- Obtain information with a subquery.mp4 14.46 MiB 9. Work with Variables/1. Create and use variables in a query.mp4 12.80 MiB 9. Work with Variables/2. Create a counter for a looping statement.mp4 14.70 MiB 9. Work with Variables/3. Challenge- Use variables in a query.mp4 1.26 MiB 9. Work with Variables/4. Solution- Use variables in a query.mp4 14.66 MiB Ex_Files_Querying_Microsoft_SQL_Server_2022.zip 27.58 KiB