| 1. Change database context with USE.mp4 | 8.8 MB | ||
| 1. Combine results with UNION.mp4 | 8.9 MB | ||
| 1. Create and use variables in a query.mp4 | 12.8 MB | ||
| 1. Limit results with TOP.mp4 | 13 MB | ||
| 1. Next steps.mp4 | 2 MB | ||
| 1. Table joins and relationships.mp4 | 5.6 MB | ||
| 1. Turn data into information with queries.mp4 | 4 MB | ||
| 1. Understand record grouping.mp4 | 5.9 MB | ||
| 1. Use functions in T-SQL.mp4 | 7.4 MB | ||
| 1. What is Transact SQL.mp4 | 7 MB | ||
| 1. What is a subquery.mp4 | 15.4 MB | ||
| 10. Create a series of values.mp4 | 16.6 MB | ||
| 10. Solution- Query information from a database.mp4 | 17.7 MB | ||
| 11. The IIF logical function.mp4 | 10.5 MB | ||
| 12. Write a CASE statement.mp4 | 14.8 MB | ||
| 13. Challenge- Use functions in a SQL query.mp4 | 1.5 MB | ||
| 14. Solution- Use functions in a SQL query.mp4 | 48.8 MB | ||
| 15. Solution- Use functions in a query.mp4 | 9.9 MB | ||
| 2. Add comments to a script.mp4 | 10 MB | ||
| 2. Create a counter for a looping statement.mp4 | 14.7 MB | ||
| 2. Inner joins.mp4 | 23.5 MB | ||
| 2. Remove duplicates with DISTINCT.mp4 | 7.9 MB | ||
| 2. Return distinct rows with EXCEPT.mp4 | 12.3 MB | ||
| 2. String functions.mp4 | 11.5 MB | ||
| 2. The SQL querying environment.mp4 | 26 MB | ||
| 2. Use GROUP BY and COUNT.mp4 | 14.9 MB | ||
| 2. Use a subquery in a HAVING clause.mp4 | 19.7 MB | ||
| 2. What you should know.mp4 | 1.5 MB | ||
| 3. Aggregate functions.mp4 | 6.2 MB | ||
| 3. Challenge- Use variables in a query.mp4 | 1.3 MB | ||
| 3. Comparison operators.mp4 | 9.5 MB | ||
| 3. Correlated subqueries.mp4 | 20.2 MB | ||
| 3. Download the sample database.mp4 | 7.9 MB | ||
| 3. Left right and full outer joins.mp4 | 15 MB | ||
| 3. Return common rows with INTERSECT.mp4 | 10.3 MB | ||
| 3. Return records with SELECT and FROM.mp4 | 24.1 MB | ||
| 3. Text concatenation.mp4 | 11 MB | ||
| 3. When to use square brackets.mp4 | 5.3 MB | ||
| 4. Cross joins.mp4 | 13.2 MB | ||
| 4. Explore data with SUM.mp4 | 22.9 MB | ||
| 4. Exploring the code challenge environment.mp4 | 4.1 MB | ||
| 4. Filter records with WHERE.mp4 | 15 MB | ||
| 4. PIVOT the result set.mp4 | 12.5 MB | ||
| 4. Round with mathematical functions.mp4 | 9.7 MB | ||
| 4. Solution- Use variables in a query.mp4 | 14.7 MB | ||
| 4. Understand NULL values.mp4 | 12.7 MB | ||
| 5. Challenge- Return data from multiple tables.mp4 | 1.9 MB | ||
| 5. Challenge- Write a query with a subquery.mp4 | 2.1 MB | ||
| 5. Filter groups with HAVING.mp4 | 10.2 MB | ||
| 5. Find the GREATEST or LEAST value.mp4 | 15.7 MB | ||
| 5. Match text with LIKE and wildcards.mp4 | 11.1 MB | ||
| 5. Sort records with ORDER BY.mp4 | 9.8 MB | ||
| 6. Challenge- Obtain order summaries.mp4 | 2.6 MB | ||
| 6. Challenge- Retrieve matching text strings.mp4 | 1.5 MB | ||
| 6. Column aliases.mp4 | 6.4 MB | ||
| 6. Solution- Return data from multiple tables.mp4 | 21.5 MB | ||
| 6. Solution- Write a query with a subquery.mp4 | 30.4 MB | ||
| 6. Work with date functions.mp4 | 18.4 MB | ||
| 7. Create values with constants and math.mp4 | 13.9 MB | ||
| 7. FORMAT date and times.mp4 | 9.6 MB | ||
| 7. Solution- Join data in multiple tables.mp4 | 10.6 MB | ||
| 7. Solution- Obtain information with a subquery.mp4 | 14.5 MB | ||
| 7. Solution- Obtain order summaries.mp4 | 42.2 MB | ||
| 7. Solution- Retrieve matching text strings.mp4 | 14.9 MB | ||
| 8. Challenge- Write a SELECT query.mp4 | 2.3 MB | ||
| 8. Group dates into buckets.mp4 | 20.2 MB | ||
| 8. Solution- Filter results from a query result.mp4 | 11.6 MB | ||
| 8. Solution- Group rows and aggregate data.mp4 | 8.1 MB | ||
| 9. Return random records with NEWID.mp4 | 7 MB | ||
| 9. Solution- Write a SELECT query.mp4 | 14.4 MB | ||
| Ex_Files_Querying_Microsoft_SQL_Server_2022.zip | 27.6 KB | ||
| ▲ 71 total files | |||
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.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 394.1 MB | xHOBBiTx | 6 years | 4 | 1 |
All Comments