|  

SQL and MySQL Subquery: Understanding the Weird Parts



Size :2.8 GB
Peers : Seeders : 0      Leechers : 0
Added : 1 year ago » by tutsnode » in Other
Language : English
Last Updated :6 months ago
Info_Hash :51BA420DABE2A44C9C7CA8EE017FCF2F6ADFFDB5

Torrent File Contents

SQL and MySQL Subquery: Understanding the Weird Parts
  [TutsNode.net] - 1. Introduction/3. Beginning Subquery - With Example I.mp4
  -  210.49 MB

  TutsNode.net.txt
  -  63 Bytes

  [TutsNode.net] - 1. Introduction/1. Database (Datasets) for the course.html
  -  248 Bytes

  [TutsNode.net] - 1. Introduction/1.2 northwind-er-relationship.png
  -  164.58 KB

  [TutsNode.net] - 1. Introduction/68. CODE Nested Subquery - Customer Ordered Beverages Products.html
  -  686 Bytes

  [TutsNode.net] - 1. Introduction/62. CODE Nested Subquery - Suppliers who supplied products to a customers.html
  -  679 Bytes

  [TGx]Downloaded from torrentgalaxy.buzz .txt
  -  585 Bytes

  [TutsNode.net] - 1. Introduction/4. CODE Beginning Subquery - With Example I.html
  -  203 Bytes

  [TutsNode.net] - 1. Introduction/70. CODE Nested Subquery - Suppliers for London Customers.html
  -  667 Bytes

  [TutsNode.net] - 1. Introduction/6. CODE Beginning Subquery - With Example II.html
  -  430 Bytes

  [TutsNode.net] - 1. Introduction/66. CODE Nested Subquery - Employees with same territory.html
  -  568 Bytes

  [TutsNode.net] - 1. Introduction/8. CODE Beginning Subquery - With Example III.html
  -  206 Bytes

  [TutsNode.net] - 1. Introduction/64. CODE Nested Subquery - Customers who placed order more than 30.html
  -  511 Bytes

  [TutsNode.net] - 1. Introduction/10. CODE Nested Subquery - SubQuery with LIKE.html
  -  208 Bytes

  [TutsNode.net] - 1. Introduction/56. CODE Nested Subquery - Employees who have the same territories.html
  -  380 Bytes

  [TutsNode.net] - 1. Introduction/12. CODE Nested Subquery - Mangers of Employee SubQueries.html
  -  144 Bytes

  [TutsNode.net] - 1. Introduction/44. CODE Nested Subquery - Customers who placed orders.html
  -  364 Bytes

  [TutsNode.net] - 1. Introduction/14. CODE Nested Subquery- Employee Territories.html
  -  163 Bytes

  [TutsNode.net] - 1. Introduction/54. CODE Nested Subquery - Order Placed in 2008.html
  -  334 Bytes

  [TutsNode.net] - 1. Introduction/16. CODE Nested Subquery - CategoryName.html
  -  135 Bytes

  [TutsNode.net] - 1. Introduction/58. CODE Nested Subquery - Products ordered by customers.html
  -  326 Bytes

  [TutsNode.net] - 1. Introduction/18. CODE Nested Subquery - Suppliers.html
  -  134 Bytes

  [TutsNode.net] - 1. Introduction/30. CODE Nested Subquery - Supplied categories of seafood.html
  -  298 Bytes

  [TutsNode.net] - 1. Introduction/20. CODE Nested Subquery - Product Ordered.html
  -  114 Bytes

  [TutsNode.net] - 1. Introduction/40. CODE Nested Subquery - Territories names Assigned to Employees.html
  -  275 Bytes

  [TutsNode.net] - 1. Introduction/22. CODE Nested Subquery - Employee Without Orders.html
  -  119 Bytes

  [TutsNode.net] - 1. Introduction/60. CODE Nested Subquery - Employees Managed by Funk.html
  -  218 Bytes

  [TutsNode.net] - 1. Introduction/24. CODE Nested Subquery - Employees with same region.html
  -  131 Bytes

  [TutsNode.net] - 1. Introduction/36. CODE Nested Subquery - Products with reorderLevel.html
  -  208 Bytes

  [TutsNode.net] - 1. Introduction/26. CODE Nested Subquery - Territories not assigned to employee.html
  -  137 Bytes

  [TutsNode.net] - 1. Introduction/52. CODE Nested Subquery - Employees not assigned to Territories.html
  -  205 Bytes

  [TutsNode.net] - 1. Introduction/28. CODE Nested Subquery - Freight of orders.html
  -  163 Bytes

  [TutsNode.net] - 1. Introduction/48. CODE Nested Subquery - Territories never assign to Employees.html
  -  199 Bytes

  [TutsNode.net] - 1. Introduction/42. CODE Nested Subquery - Products Supplied by Same Company.html
  -  197 Bytes

  [TutsNode.net] - 1. Introduction/50. CODE Nested Subquery - Customers Who Never Placed Orders.html
  -  187 Bytes

  [TutsNode.net] - 1. Introduction/32. CODE Nested Subquery - customers in the same city.html
  -  118 Bytes

  [TutsNode.net] - 1. Introduction/46. CODE Nested Subquery - Products never ordered.html
  -  185 Bytes

  [TutsNode.net] - 1. Introduction/34. CODE Nested Subquery - Employees with same manager.html
  -  154 Bytes

  [TutsNode.net] - 1. Introduction/38. CODE Nested Subquery - Supplier who live in Spain.html
  -  124 Bytes

  .pad/0
  -  350.12 KB

  [TutsNode.net] - 1. Introduction/11. Nested Subquery - Mangers of Employee SubQueries.mp4
  -  210.26 MB

  [TutsNode.net] - 1. Introduction/1.1 1 Database_Tables_Dataset.original
  -  606.68 KB

  .pad/1
  -  153.38 KB

  [TutsNode.net] - 1. Introduction/43. Nested Subquery - Customers who placed orders.mp4
  -  120.98 MB

  .pad/2
  -  21 KB

  [TutsNode.net] - 1. Introduction/5. Beginning Subquery - With Example II.mp4
  -  119.28 MB

  .pad/3
  -  736.82 KB

  [TutsNode.net] - 1. Introduction/2. Importance of Subquery.mp4
  -  116.52 MB

  .pad/4
  -  486.7 KB

  [TutsNode.net] - 1. Introduction/9. Nested Subquery - SubQuery with LIKE.mp4
  -  115.57 MB

  .pad/5
  -  443.18 KB

  [TutsNode.net] - 1. Introduction/13. Nested Subquery - Employee Territories.mp4
  -  110.92 MB

  .pad/6
  -  81.96 KB

  [TutsNode.net] - 1. Introduction/7. Beginning Subquery - With Example III.mp4
  -  101.87 MB

  .pad/7
  -  135.57 KB

  [TutsNode.net] - 1. Introduction/61. Nested Subquery - Suppliers who supplied products to a customers.mp4
  -  99.65 MB

  .pad/8
  -  355.57 KB

  [TutsNode.net] - 1. Introduction/29. Nested Subquery - Supplied categories of seafood.mp4
  -  96.2 MB

  .pad/9
  -  822.58 KB

  [TutsNode.net] - 1. Introduction/39. Nested Subquery - Territories names Assigned to Employees.mp4
  -  95.74 MB

  .pad/10
  -  264.93 KB

  [TutsNode.net] - 1. Introduction/67. Nested Subquery - Customer Ordered Beverages Products.mp4
  -  89.33 MB

  .pad/11
  -  687.94 KB

  [TutsNode.net] - 1. Introduction/37. Nested Subquery - Supplier who live in Spain.mp4
  -  72.08 MB

  .pad/12
  -  941.93 KB

  [TutsNode.net] - 1. Introduction/15. Nested Subquery - CategoryName.mp4
  -  71.98 MB

  .pad/13
  -  18.98 KB

  [TutsNode.net] - 1. Introduction/55. Nested Subquery - Employees who have the same territories.mp4
  -  71.92 MB

  .pad/14
  -  81.81 KB

  [TutsNode.net] - 1. Introduction/17. Nested Subquery - Suppliers.mp4
  -  70.49 MB

  .pad/15
  -  519.89 KB

  [TutsNode.net] - 1. Introduction/69. Nested Subquery - Suppliers for London Customers.mp4
  -  69.95 MB

  .pad/16
  -  54.14 KB

  [TutsNode.net] - 1. Introduction/53. Nested Subquery - Order Placed in 2008.mp4
  -  68.86 MB

  .pad/17
  -  144.52 KB

  [TutsNode.net] - 1. Introduction/35. Nested Subquery - Products with reorderLevel.mp4
  -  67.7 MB

  .pad/18
  -  305.94 KB

  [TutsNode.net] - 1. Introduction/59. Nested Subquery - Employees Managed by Funk.mp4
  -  64.95 MB

  .pad/19
  -  52.93 KB

  [TutsNode.net] - 1. Introduction/65. Nested Subquery - Employees with same territory.mp4
  -  62.63 MB

  .pad/20
  -  380.78 KB

  [TutsNode.net] - 1. Introduction/63. Nested Subquery - Customers who placed order more than 30.mp4
  -  62.02 MB

  .pad/21
  -  1008.17 KB

  [TutsNode.net] - 1. Introduction/47. Nested Subquery - Territories never assign to Employees.mp4
  -  57.77 MB

  .pad/22
  -  240.29 KB

  [TutsNode.net] - 1. Introduction/41. Nested Subquery - Products Supplied by Same Company.mp4
  -  57.59 MB

  .pad/23
  -  421.21 KB

  [TutsNode.net] - 1. Introduction/33. Nested Subquery - Employees with same manager.mp4
  -  57.11 MB

  .pad/24
  -  908.53 KB

  [TutsNode.net] - 1. Introduction/23. Nested Subquery - Employees with same region.mp4
  -  56.41 MB

  .pad/25
  -  600.16 KB

  [TutsNode.net] - 1. Introduction/21. Nested Subquery - Employee Without Orders.mp4
  -  53.51 MB

  .pad/26
  -  505.66 KB

  [TutsNode.net] - 1. Introduction/31. Nested Subquery - customers in the same city.mp4
  -  53.29 MB

  .pad/27
  -  731.96 KB

  [TutsNode.net] - 1. Introduction/49. Nested Subquery - Customers Who Never Placed Orders.mp4
  -  49.48 MB

  .pad/28
  -  528 KB

  [TutsNode.net] - 1. Introduction/19. Nested Subquery - Product Ordered.mp4
  -  48.73 MB

  .pad/29
  -  280.8 KB

  [TutsNode.net] - 1. Introduction/27. Nested Subquery - Freight of orders.mp4
  -  46.78 MB

  .pad/30
  -  220.86 KB

  [TutsNode.net] - 1. Introduction/45. Nested Subquery - Products never ordered.mp4
  -  45.55 MB

  .pad/31
  -  456.5 KB

  [TutsNode.net] - 1. Introduction/25. Nested Subquery - Territories not assigned to employee.mp4
  -  44.66 MB

  .pad/32
  -  344.69 KB

  [TutsNode.net] - 1. Introduction/57. Nested Subquery - Products ordered by customers.mp4
  -  37.59 MB

  .pad/33
  -  419.24 KB

  [TutsNode.net] - 1. Introduction/51. Nested Subquery - Employees not assigned to Territories.mp4
  -  32.06 MB



Torrent Description


Description

Master the Art of SQL Subqueries with this Comprehensive Course – Take Your Data Management Skills to the Next Level! Whether you’re a beginner or an experienced SQL user, learn to effectively use subqueries to extract and manipulate data from your databases.

With this course, you will delve into different types of subqueries, including nested, correlated, scalar, row, column, and inline view subqueries. You’ll also learn essential SQL techniques such as JOIN, EXISTS, WHERE, HAVING, GROUP BY, and many more. Our expert instructor will show you how to use these techniques to solve real-world problems and how to combine subqueries with other SQL techniques for maximum efficiency.

By the end of this course, you will have a deep understanding of how subqueries work and how to use them to extract the information you need from your databases. You’ll be able to create complex and powerful queries to analyze and manage your data like never before.

The course is designed for users of all levels, from beginner to experienced SQL users, and covers a wide range of databases including MySQL, PostgreSQL, Microsoft SQL Server, and Oracle Database. Our step-by-step approach starts with the basics and builds up to more advanced techniques, providing you with a comprehensive understanding of SQL subqueries.

With hands-on exercises and practical projects, you’ll gain hands-on experience working with subqueries. Our experienced instructor and supportive online community are always available to answer your questions.

Enroll in this course now and take your data management skills to the next level. Master SQL subqueries and become an expert in extracting and manipulating data from your databases.
Who this course is for:

Those with basic SQL knowledge who wish to improve
Data analysts, business intelligence professionals, and aspiring SQL developers who want to improve their SQL skills
Database administrators who want to write more efficient and complex SQL queries
Anyone who has struggled with SQL subqueries in the past and wants to learn how to use them effectively
Individuals who want to become an expert in using SQL subqueries for data analysis and data management tasks.

Requirements

Basic SQL knowledge. This includes familiarity with SQL syntax and basic SQL commands
MySQL WorkBench

Last Updated 2/2023