Practical SQL With Python In 3 Days

سرفصل های دوره

Build 3 Python Projects In 3 Days Using SQLite, MySQL, and PostgreSQL

1. Day 0 - Two Minute Welcome

1. 2-min Introduction

2.1 all resources.zip

2. All Course Resources - Lectures + Project Challenges.html

2. Day 1 - Freight Manager

1. Section Overview

2.1 day1 - lecture resources.zip

2. Lecture Resources.html

3. Introduction to SQLIite

4. sqlite3 In Python

5. DBAPI 2.0

6. Connections And Cursors

7. Inserts

8. DML vs DDL (and DCL and DQL)

9. Fetching

10. Column Names Would Be Nice

11. The Transaction Lifecycle

12. Parameterized Statements

13. A Different Flavor

14. Various Ways To Execute

15. Database Dump

16. Context Managed Connections

17. Lets Build!

18.1 day 1 - challenges.zip

18. Project Resources - All Solution Challenges.html

19. Creating A Virtual Environment

20. Challenge 1 - Interface

21. The Interface

22. Sketching Out The Basics

23. Challenge 2 - DDL

24. Executing the DDL

25. Foreign Key Gotcha

26. The Add Box Menu

27. Challenge 3 - Add Box To Database

28. Add Box Helper

29. Challenge 4 - Displaying Box Types

30. Displaying All Boxes

31. A Prettier Display

32. Challenge 5 - Loading Boxes With Validation

33. Load Box Menu

34. The Containers Database View

35. Container Constraints

36. The Final Stretch

37. Quick Note.html

38. Challenge 6 - Seed Data

39. Seeding Some Boxes

40. Challenge 7 - Containers

41. Displaying Containers

42. Business Summary

43. The Bottom Line

44. Challenge 9 - Configurable Constants

45. Refactoring Configuration

3. Day 2 - Course Registrar

1. Section Overview

2.1 day 2 - lectures.zip

2. Lecture Resources.html

3. Welcome To MySQL

4. Local Vs Cloud MySQL

5. Connecting From Python

6. URL Parsing

7. Cursors Again

8. Context Managers Revisited

9. Parameterized Inserts

10. Prepared Statements

11. Lets Fetch

12. Buffering

13. Dict Cursors

14. A Named Alternative

15. .executescript() Please

16. Best Multi With Autocommit

17. Lets Build!

18.1 day 2 - all challenges.zip

18.2 playground.zip

18. Project Resources - All Challenge Solutions.html

19. Setting Up

20. The Interface

21. Challenge 1 - Connection Helper

22. Writing The Helper

23. Challenge 2 - Prepare The DDL

24. Wiring Up The DDL

25. Challenge 3 - The Reset Command

26. Resetting The Database

27. Challenge 4 - Add Student

28. Adding New Students

29. Challenge 5 - Add Course

30. Adding New Courses

31. Challenge 6 - Prerequisites

32. Prereq DDL And Command

33. Addressing A Small Inconsistency

34. Challenge 7 - Querying

35. The Query Helper

36. Challenge 8 - Seeding Data

37. Initializing Data

38. no-with-data

39. Challenge 9 - Show Prerequisites For Course

40. Displaying Prereqs

41. Pretty Tables

42. Challenge 10 - Show Students And Courses

43. Displaying Students And Courses

44. Challenge 11 - Course Enrollment Part I

45. Naive Enrollment

46. Challenge 12 - Grading

47. The Grade Command

48. Challenge 13 - Course Enrollment Part II

49. Prereq-aware Enrollment

50. Hiding Internals, Colorizing Externals

51. Verbose Query Execution

52. Challenge 14 - Unenroll

53. Unenrolling Students

54. Challenge 15 - Courses By Student

55. Current Enrollment Report

56. Challenge 16 - Transcripts

57. Generating Transcripts

58. Challenge 17 - Letter Grades

59. Approach

60. Implementation

61. Challenge 18 - Most Popular Courses

62. Most Enrolled Courses

63. Challenge 19 - Top Students

64. Top Performers

4. Day 3 - Guestbook API

1. Section Overview

2.1 day 3 - lectures.zip

2. Lecture Resources.html

3. PostgreSQL

4. The Precompiled Alternative

5. Database Server

6. Connecting

7. Query Execution

8. Parametrization

9. Dynamic Query Generation

10. Dynamic Queries Part II

11. Quick Refactor

12. Lets Build!

13.1 day 3 - challenges.zip

13.2 playground.zip

13. Project Resources - All Challenge Solutions.html

14. New Virtual Env

15. The Web-based API

16. Automatic Documentation

17. Our Database

18. Object-Oriented Helper Part I

19. Object-Oriented Helper Part II

20. Connection URL As Env Variable

21. Dependency Injection

22. Challenge 1 - DDL

23. Creating Our First Tables

24. The Register Endpoint

25. Data Validation With Pydantic

26. User Registration Data Validation

27. Hashing Passwords

28. Registration With Hashed Passwords

29. Challenge 2 - Persisting To Database

30. Inserting Users

31. Adding The UNIQUE Constraint

32. HTTPExceptions And Status Codes

33. Challenge 3 - Object-Oriented Refactor

34. OOP Write Returning Id

35. Challenge 4 - Registration Tokens

36. Saving Tokens

37. The Activate Endpoint + Cleanup

38. Challenge 5 - Get One

39. Implementing Database get_one()

40. Challenge 6 - Get One As Special Case Of Get

41. Implementing A Generalized Get

42. Challenge 7 - Update

43. Implementing Database .update()

44. Challenge 8 - Endpoint Integration

45. The Activate Flow

46. Challenge 9 - Activate Once

47. Enforcing One Time Activation

48. Messages Prep

49. Form vs Query Params

50. Code Reorg Using Routers

51. Challenge 10 - Messages DDL + Path

52. Persisting Messages

53. Fixing A Typo

54. Authentication

55. Authenticated POST messages

56. Fixing An Old Bug

57. Challenge 11 - Updating Messages

58. PATCH messages

59. Challenge 12 - Get Message By Id

60. Getting Public + Own Messages

61. Challenge 13 - Get All Messages

62. Getting Public And Own Messages

63. or_where Refactor

64. Challenge 14 - Database Delete

65. Implementing .delete()

66. Refactoring Database Methods

67. Challenge 15 - Integrating Delete

68. Deleting Messages From The Interface

69. Challenge 16 - New Get Contains

70. Implementing Get With Like Operator

71. Challenge 17 - Get With Contains

72. Refactoring Get

73. Challenge 18 - Search Messages

74. Implementing Message Search

75. A More Coherent Database .get()

76. The Final .get() Refactor

77. Challenge 19 - Upvotes

78. Upvotes DDL

79. Challenge 20 - Upvoting

80. The Upvote Interface

81. Quick Bug Fix

82. Challenge 21 - Most Popular Messages

83. Most Upvoted

84. Preparing To Send Emails

85. Sending Generated Tokens

86. Two Little Tweaks

87. Preparing To Deploy

88. Deployment

5. Thank you!

1. Outro + Sqlalchemy Musings

2. My Other Courses.html

53,700 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training