种子简介

种子名称： [FreeCourseSite.com] Udemy - SQL and PostgreSQL The Complete Developer's Guide
文件类型： 视频
文件数目： 280个文件
文件大小： 7.57 GB
收录时间： 2021-2-18 18:32
已经下载： 3次
资源热度： 222
最近下载： 2024-6-14 18:20

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:7137537c2364bb83e449e6813b2f00bb4fea13d0&dn=[FreeCourseSite.com] Udemy - SQL and PostgreSQL The Complete Developer's Guide 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

[FreeCourseSite.com] Udemy - SQL and PostgreSQL The Complete Developer's Guide.torrent

1. Simple - But Powerful - SQL Statements/10. Calculated Columns.mp418.69MB

1. Simple - But Powerful - SQL Statements/11. Calculating Phone Revenue.mp45.5MB

1. Simple - But Powerful - SQL Statements/13. Exercise Solution.mp44.22MB

1. Simple - But Powerful - SQL Statements/14. String Operators and Functions.mp424.4MB

1. Simple - But Powerful - SQL Statements/2. What is PostgreSQL All About.mp421.76MB

1. Simple - But Powerful - SQL Statements/3. Database Design.mp435.4MB

1. Simple - But Powerful - SQL Statements/5. Creating Tables.mp418.63MB

1. Simple - But Powerful - SQL Statements/6. Analyzing CREATE TABLE.mp419.14MB

1. Simple - But Powerful - SQL Statements/7. Inserting Data Into a Table.mp419.74MB

1. Simple - But Powerful - SQL Statements/8. Retrieving Data with Select.mp49.25MB

10. Selecting Distinct Records/1. Selecting Distinct Values.mp417.97MB

10. Selecting Distinct Records/2. Exercise Overview.mp42.02MB

10. Selecting Distinct Records/4. A Distinct Solution.mp42.69MB

11. Utility Operators, Keywords, and Functions/1. The Greatest Value in a List.mp414.57MB

11. Utility Operators, Keywords, and Functions/2. And the Least Value in a List!.mp48.69MB

11. Utility Operators, Keywords, and Functions/3. The Case Keyword.mp419.04MB

12. Local PostgreSQL Installation/1. PostgreSQL Installation on macOS.mp426.89MB

12. Local PostgreSQL Installation/2. PGAdmin Setup on macOS.mp424.23MB

12. Local PostgreSQL Installation/3. Postgres installation on Windows.mp426.58MB

13. PostgreSQL Complex Datatypes/1. What'd We Just Do.mp422.86MB

13. PostgreSQL Complex Datatypes/2. Data Types.mp424.48MB

13. PostgreSQL Complex Datatypes/3. Fast Rules on Numeric Data Types.mp412.88MB

13. PostgreSQL Complex Datatypes/4. More on Number Data Types.mp455.56MB

13. PostgreSQL Complex Datatypes/5. Reminder on Character Types.mp424.84MB

13. PostgreSQL Complex Datatypes/6. Boolean Data Types.mp413.12MB

13. PostgreSQL Complex Datatypes/7. Times, Dates, and Timestamps.mp427.13MB

13. PostgreSQL Complex Datatypes/8. Really Awesome Intervals.mp423.92MB

14. Database-Side Validation and Constraints/1. Thinking About Validation.mp428.67MB

14. Database-Side Validation and Constraints/10. Adding a Validation Check.mp423.6MB

14. Database-Side Validation and Constraints/11. Checks Over Multiple Columns.mp423.63MB

14. Database-Side Validation and Constraints/13. So Where Are We Applying Validation.mp431MB

14. Database-Side Validation and Constraints/2. Creating and Viewing Tables in PGAdmin.mp436.26MB

14. Database-Side Validation and Constraints/3. Applying a Null Constraint.mp432.09MB

14. Database-Side Validation and Constraints/4. Solving a Gotcha with Null Constraints.mp420.54MB

14. Database-Side Validation and Constraints/6. Default Column Values.mp418.73MB

14. Database-Side Validation and Constraints/7. Applying a Unique Constraint to One column.mp431.04MB

14. Database-Side Validation and Constraints/8. Multi-Column Uniqueness.mp421.3MB

15. Database Structure Design Patterns/1. Approaching More Complicated Designs.mp415.68MB

15. Database Structure Design Patterns/2. Using a SQL Design Tool.mp438.19MB

15. Database Structure Design Patterns/3. A Config-based Schema Designer.mp435.63MB

15. Database Structure Design Patterns/4. Here's the Plan.mp414.52MB

15. Database Structure Design Patterns/5. Rebuilding Some Schema.mp431.24MB

16. How to Build a 'Like' System/1. Requirements of a Like System.mp430.06MB

16. How to Build a 'Like' System/10. So Which Approach.mp424.82MB

16. How to Build a 'Like' System/2. How Not to Design a Like System.mp419.63MB

16. How to Build a 'Like' System/3. Designing a Like System.mp430.33MB

16. How to Build a 'Like' System/5. Making a Reaction System Instead.mp48.98MB

16. How to Build a 'Like' System/6. Polymorphic Associations.mp436.24MB

16. How to Build a 'Like' System/7. Polymorphic Association Alternative Implementation.mp442.41MB

16. How to Build a 'Like' System/8. The Simplest Alternative.mp421.64MB

17. How to Build a 'Mention' System/1. Additional Features Around Posts.mp456.37MB

17. How to Build a 'Mention' System/2. Adding Captions and Locations.mp411.82MB

17. How to Build a 'Mention' System/3. Photo Mentions vs Caption Mentions.mp463.23MB

17. How to Build a 'Mention' System/4. Considerations on Photo Tags vs Caption Tags.mp447.45MB

17. How to Build a 'Mention' System/5. Update For Tags.mp430.36MB

18. How to Build a 'Hashtag' System/1. Designing a Hashtag System.mp467.51MB

18. How to Build a 'Hashtag' System/2. Tables for Hashtags.mp416.81MB

18. How to Build a 'Hashtag' System/3. Including the Hashtag Table.mp420.3MB

18. How to Build a 'Hashtag' System/4. A Few More User Columns.mp444.56MB

18. How to Build a 'Hashtag' System/5. Why No Number of Followers or Posts.mp422.09MB

19. How to Design a 'Follower' System/1. Designing a Follower System.mp433.56MB

2. Filtering Records/1. Filtering Rows with Where.mp416.88MB

2. Filtering Records/10. Calculations in Where Clauses.mp46.42MB

2. Filtering Records/12. Solving Calculations.mp48.28MB

2. Filtering Records/13. Updating Rows.mp420.87MB

2. Filtering Records/14. Deleting Rows.mp418.06MB

2. Filtering Records/16. A Solution for Updating Rows.mp47.28MB

2. Filtering Records/18. Solution for Deleting Rows.mp45.44MB

2. Filtering Records/2. More on the Where Keyword.mp413.1MB

2. Filtering Records/3. Compound Where Clauses.mp424.06MB

2. Filtering Records/4. A Where Exercise Overview.mp42.47MB

2. Filtering Records/6. A Where Solution.mp43.68MB

2. Filtering Records/7. Where With Lists.mp42.09MB

2. Filtering Records/9. A Where With Lists Solution.mp47.31MB

20. Implementing Database Design Patterns/1. Back to Postgres.mp410.08MB

20. Implementing Database Design Patterns/2. Creating Tables with Checks.mp467.52MB

20. Implementing Database Design Patterns/3. Posts Creation.mp445.39MB

20. Implementing Database Design Patterns/4. Comments Creation.mp410.41MB

20. Implementing Database Design Patterns/5. Likes Creation.mp435.37MB

20. Implementing Database Design Patterns/6. Photo Tags and Caption Tags.mp428.45MB

20. Implementing Database Design Patterns/7. Creating Hashtags, Hashtag Posts, and Followers.mp429.37MB

21. Approaching and Writing Complex Queries/2. Adding Some Data.mp421.47MB

21. Approaching and Writing Complex Queries/3. Restoring from Scratch.mp423.76MB

21. Approaching and Writing Complex Queries/4. Highest User ID's Exercise.mp47.87MB

21. Approaching and Writing Complex Queries/5. Solution for User ID's.mp46.37MB

21. Approaching and Writing Complex Queries/6. Posts by a Particular User.mp46.87MB

21. Approaching and Writing Complex Queries/7. Solving for Posts by User.mp413.73MB

21. Approaching and Writing Complex Queries/8. Likes Per User.mp44.78MB

21. Approaching and Writing Complex Queries/9. Solution for Likes Per User.mp48.17MB

22. Understanding the Internals of PostgreSQL/1. Thinking About Performance.mp49.48MB

22. Understanding the Internals of PostgreSQL/2. Where Does Postgres Store Data.mp438.93MB

22. Understanding the Internals of PostgreSQL/3. Heaps, Blocks, and Tuples.mp417.91MB

22. Understanding the Internals of PostgreSQL/5. Block Data Layout.mp420.98MB

22. Understanding the Internals of PostgreSQL/6. Heap File Layout.mp4345.28MB

23. A Look at Indexes for Performance/1. Full Table Scans.mp426.78MB

23. A Look at Indexes for Performance/10. Behind the Scenes of Indexes.mp4249.21MB

23. A Look at Indexes for Performance/2. What's an Index.mp412.93MB

23. A Look at Indexes for Performance/3. How an Index Works.mp457.11MB

23. A Look at Indexes for Performance/4. Creating an Index.mp419.34MB

23. A Look at Indexes for Performance/5. Benchmarking Queries.mp427.74MB

23. A Look at Indexes for Performance/6. Downsides of Indexes.mp424.79MB

23. A Look at Indexes for Performance/7. Index Types.mp49.83MB

23. A Look at Indexes for Performance/8. Automatically Generated Indexes.mp421.16MB

24. Basic Query Tuning/1. The Query Processing Pipeline.mp433.28MB

24. Basic Query Tuning/2. Explain and Explain Analyze.mp430.56MB

24. Basic Query Tuning/4. Solving an Explain Mystery.mp465.38MB

25. Advanced Query Tuning/1. Developing an Intuitive Understanding of Cost.mp484.44MB

25. Advanced Query Tuning/2. Calculating Cost by Hand.mp441.84MB

25. Advanced Query Tuning/3. A Touch More on Costs.mp458.19MB

25. Advanced Query Tuning/5. Startup vs Total Costs.mp435.79MB

25. Advanced Query Tuning/6. Costs Flow Up.mp413.45MB

25. Advanced Query Tuning/7. Use My Index!.mp442.47MB

26. Simple Common Table Expressions/1. Common Table Expressions.mp411.93MB

26. Simple Common Table Expressions/2. A Quick Solution.mp420.69MB

26. Simple Common Table Expressions/3. So What's a CTE.mp427.27MB

27. Recursive Common Table Expressions/1. Recursive CTE's.mp416.97MB

27. Recursive Common Table Expressions/2. Recursive CTE's Step by Step.mp470.12MB

27. Recursive Common Table Expressions/3. Why Use Recursive CTE's.mp429.1MB

27. Recursive Common Table Expressions/4. Writing the Query.mp445.23MB

27. Recursive Common Table Expressions/5. Walking Through Recursion.mp477.08MB

28. Simplifying Queries with Views/1. Most Popular Users.mp430.02MB

28. Simplifying Queries with Views/2. A Possible Solution for Merging Tables.mp430.29MB

28. Simplifying Queries with Views/3. Creating a View.mp436.46MB

28. Simplifying Queries with Views/4. When to Use a View.mp426.1MB

28. Simplifying Queries with Views/5. Deleting and Changing Views.mp416.51MB

29. Optimizing Queries with Materialized Views/1. Materialized Views.mp411.04MB

29. Optimizing Queries with Materialized Views/2. Grouping by Week.mp425.27MB

29. Optimizing Queries with Materialized Views/3. Reminder on Left Joins.mp424.53MB

29. Optimizing Queries with Materialized Views/4. Writing a Slow Query.mp462.54MB

29. Optimizing Queries with Materialized Views/5. Creating and Refreshing Materialized Views.mp447.82MB

3. Working with Tables/1. The Plan Moving Forward.mp48.81MB

3. Working with Tables/11. Auto-Generated ID's.mp431.58MB

3. Working with Tables/12. Creating Foreign Key Columns.mp423.25MB

3. Working with Tables/13. Running Queries on Associated Data.mp431.66MB

3. Working with Tables/14. Exercise Overview.mp411.6MB

3. Working with Tables/16. Foreign Key Creation Solution.mp411.57MB

3. Working with Tables/17. Foreign Key Constraints Around Insertion.mp427.51MB

3. Working with Tables/18. Constraints Around Deletion.mp429.38MB

3. Working with Tables/2. Approaching Database Design.mp450.45MB

3. Working with Tables/20. Testing Deletion Constraints.mp425.58MB

3. Working with Tables/21. Setting Foreign Keys to Null on Delete.mp414.71MB

3. Working with Tables/23. Adding Some Complexity.mp413.22MB

3. Working with Tables/4. One-to-Many and Many-to-One Relationships.mp438.57MB

3. Working with Tables/6. One-to-One and Many-to-Many Relationships.mp435.68MB

3. Working with Tables/8. Primary Keys and Foreign Keys.mp434.34MB

3. Working with Tables/9. Understanding Foreign Keys.mp450.51MB

30. Handling Concurrency and Reversibility with Transactions/1. What are Transactions Used For.mp418.78MB

30. Handling Concurrency and Reversibility with Transactions/2. Some Sample Data.mp47.61MB

30. Handling Concurrency and Reversibility with Transactions/3. Opening and Closing Transactions.mp454.67MB

30. Handling Concurrency and Reversibility with Transactions/4. Transaction Cleanup on Crash.mp427.59MB

30. Handling Concurrency and Reversibility with Transactions/5. Closing Aborted Transactions.mp49.9MB

31. Managing Database Design with Schema Migrations/1. A Story on Migrations.mp4112.29MB

31. Managing Database Design with Schema Migrations/2. Migration Files.mp432.41MB

31. Managing Database Design with Schema Migrations/3. Issues Solved by Migrations.mp413.4MB

31. Managing Database Design with Schema Migrations/4. A Few Notes on Migrations Libraries.mp428.89MB

31. Managing Database Design with Schema Migrations/6. Project Creation.mp413.86MB

31. Managing Database Design with Schema Migrations/7. Generating and Writing Migrations.mp438.62MB

31. Managing Database Design with Schema Migrations/8. Applying and Reverting Migrations.mp443MB

31. Managing Database Design with Schema Migrations/9. Generating and Applying a Second Migration.mp420.05MB

32. Schema vs Data Migrations/1. Schema vs Data Migrations.mp421.38MB

32. Schema vs Data Migrations/10. Updating Values.mp419.54MB

32. Schema vs Data Migrations/12. Updating the App Server.mp422.55MB

32. Schema vs Data Migrations/13. Dropping the Last Columns.mp414.48MB

32. Schema vs Data Migrations/2. Dangers Around Data Migrations.mp458.12MB

32. Schema vs Data Migrations/3. Properly Running Data and Schema Migrations.mp427.16MB

32. Schema vs Data Migrations/4. Creating a Posts Table.mp424.14MB

32. Schema vs Data Migrations/5. A Small Web Server.mp471.67MB

32. Schema vs Data Migrations/7. Adding the Loc Column.mp418.15MB

32. Schema vs Data Migrations/8. Writing Values to Both Columns.mp421.57MB

32. Schema vs Data Migrations/9. Transaction Locks.mp471.18MB

33. Accessing PostgreSQL From API's/1. Section Goal.mp43.31MB

33. Accessing PostgreSQL From API's/2. Initial Setup.mp43.46MB

33. Accessing PostgreSQL From API's/3. One Fast Migration.mp429.7MB

33. Accessing PostgreSQL From API's/4. Building the Users Router.mp425.24MB

33. Accessing PostgreSQL From API's/5. Understanding Connection Pools.mp424.21MB

33. Accessing PostgreSQL From API's/6. Validating Connection Credentials.mp432.43MB

33. Accessing PostgreSQL From API's/7. Query and Close.mp48.85MB

34. Data Access Pattern - Repositories/1. The Repository Pattern.mp421MB

34. Data Access Pattern - Repositories/2. Creating a Repository.mp438.19MB

34. Data Access Pattern - Repositories/3. Accessing the API.mp417.16MB

34. Data Access Pattern - Repositories/4. Casing Issues.mp423.21MB

34. Data Access Pattern - Repositories/5. Fixing Casing.mp439.39MB

34. Data Access Pattern - Repositories/6. Finding Particular Users.mp428.4MB

35. Security Around PostgreSQL/1. SQL Injection Exploits.mp433.19MB

35. Security Around PostgreSQL/2. Handling SQL Injection with Prepared Statements.mp441.57MB

35. Security Around PostgreSQL/3. Preventing SQL Injection.mp440.04MB

35. Security Around PostgreSQL/4. Reminder on Post Requests.mp416.28MB

35. Security Around PostgreSQL/5. Inserting Users.mp424.82MB

35. Security Around PostgreSQL/6. Handling Updates.mp429.95MB

35. Security Around PostgreSQL/7. And, Finally, Delete.mp425.91MB

36. Fast Parallel Testing/1. A Note on Testing.mp410.52MB

36. Fast Parallel Testing/10. Controlling Schema Access with Search Paths.mp434.01MB

36. Fast Parallel Testing/11. Routing Schema Access.mp426.3MB

36. Fast Parallel Testing/12. Strategy for Isolation.mp425.18MB

36. Fast Parallel Testing/13. Programmatic Schema Creation.mp476.23MB

36. Fast Parallel Testing/14. Escaping Identifiers.mp429.82MB

36. Fast Parallel Testing/15. Test Helpers.mp435.54MB

36. Fast Parallel Testing/16. Cleaning up Schemas and Roles.mp445.03MB

36. Fast Parallel Testing/17. Finally... Parallel Tests!.mp426.53MB

36. Fast Parallel Testing/2. Assertions Around User Count.mp435.32MB

36. Fast Parallel Testing/3. Connecting to a DB For Tests.mp434.03MB

36. Fast Parallel Testing/4. Disconnecting After Tests.mp416.94MB

36. Fast Parallel Testing/5. Multi-DB Setup.mp428.2MB

36. Fast Parallel Testing/6. Assumptions Around Content.mp427.27MB

36. Fast Parallel Testing/7. Issues with Parallel Tests.mp429.55MB

36. Fast Parallel Testing/8. Isolation with Schemas.mp422.08MB

36. Fast Parallel Testing/9. Creating and Accessing Schemas.mp430.01MB

4. Relating Records with Joins/10. Why Wasn't It Included.mp420.81MB

4. Relating Records with Joins/11. Four Kinds of Joins.mp486.43MB

4. Relating Records with Joins/12. Each Join in Practice.mp434.27MB

4. Relating Records with Joins/13. Does Order Matter.mp437.26MB

4. Relating Records with Joins/15. Exercise Overview.mp43.44MB

4. Relating Records with Joins/17. Two Possible Solutions.mp421.13MB

4. Relating Records with Joins/18. Where with Join.mp437.79MB

4. Relating Records with Joins/19. Three Way Joins.mp454.37MB

4. Relating Records with Joins/2. Queries with Joins and Aggregations.mp421.75MB

4. Relating Records with Joins/20. A Bit of Practice.mp426.29MB

4. Relating Records with Joins/22. Exercise Solution.mp411.96MB

4. Relating Records with Joins/3. Joining Data from Different Tables.mp448.14MB

4. Relating Records with Joins/4. Another Quick Join.mp414.22MB

4. Relating Records with Joins/5. Exercise Overview.mp47.84MB

4. Relating Records with Joins/7. A Joinful Solution.mp48.71MB

4. Relating Records with Joins/8. Alternate Forms of Syntax.mp428.03MB

4. Relating Records with Joins/9. Missing Data in Joins.mp436.75MB

5. Aggregation of Records/1. Aggregating and Grouping.mp49.89MB

5. Aggregation of Records/10. Grouping Solution.mp44.38MB

5. Aggregation of Records/11. Adding a Layer of Difficulty.mp42.7MB

5. Aggregation of Records/13. Solution.mp45.01MB

5. Aggregation of Records/14. Filtering Groups with Having.mp426.01MB

5. Aggregation of Records/15. Having In Action.mp411.76MB

5. Aggregation of Records/16. More on Having!.mp436.51MB

5. Aggregation of Records/17. A Having Exercise Overview.mp419.45MB

5. Aggregation of Records/19. A Quick Solution.mp410.52MB

5. Aggregation of Records/2. Picturing Group By.mp433.17MB

5. Aggregation of Records/4. Aggregate Functions.mp415.21MB

5. Aggregation of Records/5. Combining Group By and Aggregates.mp422.2MB

5. Aggregation of Records/6. A Gotcha with Count.mp48.09MB

5. Aggregation of Records/7. Visualizing More Grouping.mp415.19MB

5. Aggregation of Records/8. Exercise Overview.mp42.65MB

6. Working with Large Datasets/2. Investigating This Dataset.mp411.06MB

6. Working with Large Datasets/3. Some Group By Practice.mp44.28MB

6. Working with Large Datasets/5. Group By Review Solution.mp412.55MB

6. Working with Large Datasets/6. Remember Joins.mp414.53MB

6. Working with Large Datasets/8. Of Course You Remember!.mp46.95MB

7. Sorting Records/1. The Basics of Sorting.mp410.62MB

7. Sorting Records/2. Two Variations on Sorting.mp414.18MB

7. Sorting Records/3. Offset and Limit.mp427.57MB

7. Sorting Records/4. Exercise Overview.mp41.55MB

7. Sorting Records/6. Exercise Solution.mp45.02MB

8. Unions and Intersections with Sets/1. Handling Sets with Union.mp426.97MB

8. Unions and Intersections with Sets/2. A Few Notes on Union.mp421MB

8. Unions and Intersections with Sets/3. Commonalities with Intersect.mp417.12MB

8. Unions and Intersections with Sets/4. Removing Commonalities with Except.mp429.65MB

8. Unions and Intersections with Sets/5. Union Exercise Overview.mp46.06MB

8. Unions and Intersections with Sets/7. Exercise Solution.mp46.99MB

9. Assembling Queries with SubQueries/1. What's a Subquery.mp435.43MB

9. Assembling Queries with SubQueries/10. Example of a Subquery in a From.mp444.56MB

9. Assembling Queries with SubQueries/11. Exercise Overview.mp45.03MB

9. Assembling Queries with SubQueries/13. Exercise Solution.mp47.5MB

9. Assembling Queries with SubQueries/14. Subqueries in a Join Clause.mp424.44MB

9. Assembling Queries with SubQueries/15. More Useful - Subqueries with Where.mp442.98MB

9. Assembling Queries with SubQueries/16. Data Structure with Where Subqueries.mp435.39MB

9. Assembling Queries with SubQueries/17. Exercise Overview.mp44.3MB

9. Assembling Queries with SubQueries/19. Exercise Solution.mp49.14MB

9. Assembling Queries with SubQueries/2. Thinking About the Structure of Data.mp426.03MB

9. Assembling Queries with SubQueries/20. The Not In Operator with a List.mp425.08MB

9. Assembling Queries with SubQueries/21. A New Where Operator.mp443.51MB

9. Assembling Queries with SubQueries/22. Finally Some!.mp435.3MB

9. Assembling Queries with SubQueries/24. Exercise Overview.mp41.72MB

9. Assembling Queries with SubQueries/26. A Quick Solution.mp46.02MB

9. Assembling Queries with SubQueries/27. Probably Too Much About Correlated Subqueries.mp4120.99MB

9. Assembling Queries with SubQueries/28. More on Correlated Subqueries.mp454.17MB

9. Assembling Queries with SubQueries/29. A Select Without a From.mp412.47MB

9. Assembling Queries with SubQueries/30. Exercise Overview.mp42.95MB

9. Assembling Queries with SubQueries/32. Exercise Solution.mp45.08MB

9. Assembling Queries with SubQueries/4. Subqueries in a Select.mp428.13MB

9. Assembling Queries with SubQueries/5. Exercise Overview.mp45.17MB

9. Assembling Queries with SubQueries/7. Select Solution.mp45.66MB

9. Assembling Queries with SubQueries/8. Subqueries in a From.mp446.93MB

9. Assembling Queries with SubQueries/9. From Subqueries that Return a Value.mp413.37MB