Other
Linkedin - Querying Microsoft SQL Server 2022
Torrent info
Torrent Files List
1. Introduction (Size: 869.03 MB) (Files: 71)
1. Introduction
1. Turn data into information with queries.mp4
2. What you should know.mp4
3. Download the sample database.mp4
4. Exploring the code challenge environment.mp4
10. Result Set Operators
1. Combine results with UNION.mp4
2. Return distinct rows with EXCEPT.mp4
3. Return common rows with INTERSECT.mp4
11. Conclusion
1. Next steps.mp4
2. Introduction to T-SQL Queries
1. What is Transact SQL.mp4
10. Solution- Query information from a database.mp4
2. The SQL querying environment.mp4
3. Return records with SELECT and FROM.mp4
4. Filter records with WHERE.mp4
5. Sort records with ORDER BY.mp4
6. Column aliases.mp4
7. Create values with constants and math.mp4
8. Challenge- Write a SELECT query.mp4
9. Solution- Write a SELECT query.mp4
3. Additional Filter Techniques
1. Limit results with TOP.mp4
2. Remove duplicates with DISTINCT.mp4
3. Comparison operators.mp4
4. Understand NULL values.mp4
5. Match text with LIKE and wildcards.mp4
6. Challenge- Retrieve matching text strings.mp4
7. Solution- Retrieve matching text strings.mp4
8. Solution- Filter results from a query result.mp4
4. Retrieve Records from Multiple Tables
1. Table joins and relationships.mp4
2. Inner joins.mp4
3. Left right and full outer joins.mp4
4. Cross joins.mp4
5. Challenge- Return data from multiple tables.mp4
6. Solution- Return data from multiple tables.mp4
7. Solution- Join data in multiple tables.mp4
5. Group Records
1. Understand record grouping.mp4
2. Use GROUP BY and COUNT.mp4
3. Aggregate functions.mp4
4. Explore data with SUM.mp4
5. Filter groups with HAVING.mp4
6. Challenge- Obtain order summaries.mp4
7. Solution- Obtain order summaries.mp4
8. Solution- Group rows and aggregate data.mp4
6. Manipulate Data with Functions
1. Use functions in T-SQL.mp4
10. Create a series of values.mp4
11. The IIF logical function.mp4
12. Write a CASE statement.mp4
13. Challenge- Use functions in a SQL query.mp4
14. Solution- Use functions in a SQL query.mp4
15. Solution- Use functions in a query.mp4
2. String functions.mp4
3. Text concatenation.mp4
4. Round with mathematical functions.mp4
5. Find the GREATEST or LEAST value.mp4
6. Work with date functions.mp4
7. FORMAT date and times.mp4
8. Group dates into buckets.mp4
9. Return random records with NEWID.mp4
7. Writing SQL Scripts
1. Change database context with USE.mp4
2. Add comments to a script.mp4
3. When to use square brackets.mp4
8. SQL Subqueries
1. What is a subquery.mp4
2. Use a subquery in a HAVING clause.mp4
3. Correlated subqueries.mp4
4. PIVOT the result set.mp4
5. Challenge- Write a query with a subquery.mp4
6. Solution- Write a query with a subquery.mp4
7. Solution- Obtain information with a subquery.mp4
9. Work with Variables
1. Create and use variables in a query.mp4
2. Create a counter for a looping statement.mp4
3. Challenge- Use variables in a query.mp4
4. Solution- Use variables in a query.mp4
Ex_Files_Querying_Microsoft_SQL_Server_2022.zip
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch Linkedin - Querying Microsoft SQL Server 2022 Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
