Linkedin - Querying Microsoft SQL Ser...

Description

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

Files (71)

1. Introduction/1. Turn data into information with queries.mp43.99 MiB
1. Introduction/2. What you should know.mp41.49 MiB
1. Introduction/3. Download the sample database.mp47.91 MiB
1. Introduction/4. Exploring the code challenge environment.mp44.14 MiB
10. Result Set Operators/1. Combine results with UNION.mp48.92 MiB
10. Result Set Operators/2. Return distinct rows with EXCEPT.mp412.34 MiB
10. Result Set Operators/3. Return common rows with INTERSECT.mp410.32 MiB
11. Conclusion/1. Next steps.mp42.03 MiB
2. Introduction to T-SQL Queries/1. What is Transact SQL.mp46.95 MiB
2. Introduction to T-SQL Queries/10. Solution- Query information from a database.mp417.69 MiB
2. Introduction to T-SQL Queries/2. The SQL querying environment.mp425.98 MiB
2. Introduction to T-SQL Queries/3. Return records with SELECT and FROM.mp424.15 MiB
2. Introduction to T-SQL Queries/4. Filter records with WHERE.mp415.03 MiB
2. Introduction to T-SQL Queries/5. Sort records with ORDER BY.mp49.78 MiB
2. Introduction to T-SQL Queries/6. Column aliases.mp46.38 MiB
2. Introduction to T-SQL Queries/7. Create values with constants and math.mp413.92 MiB
2. Introduction to T-SQL Queries/8. Challenge- Write a SELECT query.mp42.27 MiB
2. Introduction to T-SQL Queries/9. Solution- Write a SELECT query.mp414.37 MiB
3. Additional Filter Techniques/1. Limit results with TOP.mp413.03 MiB
3. Additional Filter Techniques/2. Remove duplicates with DISTINCT.mp47.94 MiB
3. Additional Filter Techniques/3. Comparison operators.mp49.52 MiB
3. Additional Filter Techniques/4. Understand NULL values.mp412.67 MiB
3. Additional Filter Techniques/5. Match text with LIKE and wildcards.mp411.13 MiB
3. Additional Filter Techniques/6. Challenge- Retrieve matching text strings.mp41.55 MiB
3. Additional Filter Techniques/7. Solution- Retrieve matching text strings.mp414.9 MiB
3. Additional Filter Techniques/8. Solution- Filter results from a query result.mp411.62 MiB
4. Retrieve Records from Multiple Tables/1. Table joins and relationships.mp45.59 MiB
4. Retrieve Records from Multiple Tables/2. Inner joins.mp423.47 MiB
4. Retrieve Records from Multiple Tables/3. Left right and full outer joins.mp414.98 MiB
4. Retrieve Records from Multiple Tables/4. Cross joins.mp413.17 MiB
4. Retrieve Records from Multiple Tables/5. Challenge- Return data from multiple tables.mp41.88 MiB
4. Retrieve Records from Multiple Tables/6. Solution- Return data from multiple tables.mp421.51 MiB
4. Retrieve Records from Multiple Tables/7. Solution- Join data in multiple tables.mp410.57 MiB
5. Group Records/1. Understand record grouping.mp45.88 MiB
5. Group Records/2. Use GROUP BY and COUNT.mp414.9 MiB
5. Group Records/3. Aggregate functions.mp46.18 MiB
5. Group Records/4. Explore data with SUM.mp422.85 MiB
5. Group Records/5. Filter groups with HAVING.mp410.2 MiB
5. Group Records/6. Challenge- Obtain order summaries.mp42.58 MiB
5. Group Records/7. Solution- Obtain order summaries.mp442.19 MiB
5. Group Records/8. Solution- Group rows and aggregate data.mp48.05 MiB
6. Manipulate Data with Functions/1. Use functions in T-SQL.mp47.41 MiB
6. Manipulate Data with Functions/10. Create a series of values.mp416.65 MiB
6. Manipulate Data with Functions/11. The IIF logical function.mp410.49 MiB
6. Manipulate Data with Functions/12. Write a CASE statement.mp414.8 MiB
6. Manipulate Data with Functions/13. Challenge- Use functions in a SQL query.mp41.45 MiB
6. Manipulate Data with Functions/14. Solution- Use functions in a SQL query.mp448.83 MiB
6. Manipulate Data with Functions/15. Solution- Use functions in a query.mp49.91 MiB
6. Manipulate Data with Functions/2. String functions.mp411.51 MiB
6. Manipulate Data with Functions/3. Text concatenation.mp411.01 MiB
6. Manipulate Data with Functions/4. Round with mathematical functions.mp49.7 MiB
6. Manipulate Data with Functions/5. Find the GREATEST or LEAST value.mp415.74 MiB
6. Manipulate Data with Functions/6. Work with date functions.mp418.39 MiB
6. Manipulate Data with Functions/7. FORMAT date and times.mp49.61 MiB
6. Manipulate Data with Functions/8. Group dates into buckets.mp420.21 MiB
6. Manipulate Data with Functions/9. Return random records with NEWID.mp46.98 MiB
7. Writing SQL Scripts/1. Change database context with USE.mp48.83 MiB
7. Writing SQL Scripts/2. Add comments to a script.mp410.04 MiB
7. Writing SQL Scripts/3. When to use square brackets.mp45.32 MiB
8. SQL Subqueries/1. What is a subquery.mp415.42 MiB
8. SQL Subqueries/2. Use a subquery in a HAVING clause.mp419.67 MiB
8. SQL Subqueries/3. Correlated subqueries.mp420.2 MiB
8. SQL Subqueries/4. PIVOT the result set.mp412.48 MiB
8. SQL Subqueries/5. Challenge- Write a query with a subquery.mp42.05 MiB
8. SQL Subqueries/6. Solution- Write a query with a subquery.mp430.37 MiB
8. SQL Subqueries/7. Solution- Obtain information with a subquery.mp414.46 MiB
9. Work with Variables/1. Create and use variables in a query.mp412.8 MiB
9. Work with Variables/2. Create a counter for a looping statement.mp414.7 MiB
9. Work with Variables/3. Challenge- Use variables in a query.mp41.26 MiB
9. Work with Variables/4. Solution- Use variables in a query.mp414.66 MiB
Ex_Files_Querying_Microsoft_SQL_Server_2022.zip27.58 KiB

Linkedin - Querying Microsoft SQL Server 2022

Continue browsing

Description

Files (71)