Practical SQL With Python In 3 Days

Focused View

Andy Bek

17:00:28

204 View

1. Day 0 - Two Minute Welcome

1. 2-min Introduction.mp4

02:22

2.1 all resources.zip

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

2. Day 1 - Freight Manager

1. Section Overview.mp4

00:39

2.1 day1 - lecture resources.zip

2. Lecture Resources.html

3. Introduction to SQLIite.mp4

02:31

4. sqlite3 In Python.mp4

04:16

5. DBAPI 2.0.mp4

02:57

6. Connections And Cursors.mp4

07:07

7. Inserts.mp4

03:13

8. DML vs DDL (and DCL and DQL).mp4

03:42

9. Fetching.mp4

07:27

10. Column Names Would Be Nice.mp4

11:22

11. The Transaction Lifecycle.mp4

03:48

12. Parameterized Statements.mp4

07:46

13. A Different Flavor.mp4

03:00

14. Various Ways To Execute.mp4

07:26

15. Database Dump.mp4

06:03

16. Context Managed Connections.mp4

04:58

17. Lets Build!.mp4

01:28

18.1 day 1 - challenges.zip

18. Project Resources - All Solution Challenges.html

19. Creating A Virtual Environment.mp4

04:35

20. Challenge 1 - Interface.mp4

01:34

21. The Interface.mp4

05:46

22. Sketching Out The Basics.mp4

01:52

23. Challenge 2 - DDL.mp4

00:45

24. Executing the DDL.mp4

09:48

25. Foreign Key Gotcha.mp4

03:13

26. The Add Box Menu.mp4

07:12

27. Challenge 3 - Add Box To Database.mp4

00:39

28. Add Box Helper.mp4

05:53

29. Challenge 4 - Displaying Box Types.mp4

01:49

30. Displaying All Boxes.mp4

05:55

31. A Prettier Display.mp4

04:11

32. Challenge 5 - Loading Boxes With Validation.mp4

02:08

33. Load Box Menu.mp4

10:53

34. The Containers Database View.mp4

05:55

35. Container Constraints.mp4

08:36

36. The Final Stretch.mp4

05:31

37. Quick Note.html

38. Challenge 6 - Seed Data.mp4

00:37

39. Seeding Some Boxes.mp4

04:41

40. Challenge 7 - Containers.mp4

00:32

41. Displaying Containers.mp4

04:25

42. Business Summary.mp4

02:22

43. The Bottom Line.mp4

13:02

44. Challenge 9 - Configurable Constants.mp4

01:41

45. Refactoring Configuration.mp4

11:10

3. Day 2 - Course Registrar

1. Section Overview.mp4

00:42

2.1 day 2 - lectures.zip

2. Lecture Resources.html

3. Welcome To MySQL.mp4

02:59

4. Local Vs Cloud MySQL.mp4

04:54

5. Connecting From Python.mp4

05:20

6. URL Parsing.mp4

04:14

7. Cursors Again.mp4

06:16

8. Context Managers Revisited.mp4

08:33

9. Parameterized Inserts.mp4

04:16

10. Prepared Statements.mp4

05:58

11. Lets Fetch.mp4

04:04

12. Buffering.mp4

03:07

13. Dict Cursors.mp4

03:32

14. A Named Alternative.mp4

04:23

15. .executescript() Please.mp4

09:46

16. Best Multi With Autocommit.mp4

11:23

17. Lets Build!.mp4

02:17

18.1 day 2 - all challenges.zip

18.2 playground.zip

18. Project Resources - All Challenge Solutions.html

19. Setting Up.mp4

01:18

20. The Interface.mp4

08:54

21. Challenge 1 - Connection Helper.mp4

00:25

22. Writing The Helper.mp4

08:33

23. Challenge 2 - Prepare The DDL.mp4

01:25

24. Wiring Up The DDL.mp4

09:11

25. Challenge 3 - The Reset Command.mp4

00:57

26. Resetting The Database.mp4

05:14

27. Challenge 4 - Add Student.mp4

00:39

28. Adding New Students.mp4

07:22

29. Challenge 5 - Add Course.mp4

00:37

30. Adding New Courses.mp4

03:24

31. Challenge 6 - Prerequisites.mp4

02:13

32. Prereq DDL And Command.mp4

10:51

33. Addressing A Small Inconsistency.mp4

04:12

34. Challenge 7 - Querying.mp4

02:15

35. The Query Helper.mp4

08:09

36. Challenge 8 - Seeding Data.mp4

02:25

37. Initializing Data.mp4

13:19

38. no-with-data.mp4

02:33

39. Challenge 9 - Show Prerequisites For Course.mp4

01:12

40. Displaying Prereqs.mp4

04:56

41. Pretty Tables.mp4

09:14

42. Challenge 10 - Show Students And Courses.mp4

01:36

43. Displaying Students And Courses.mp4

08:09

44. Challenge 11 - Course Enrollment Part I.mp4

02:31

45. Naive Enrollment.mp4

10:29

46. Challenge 12 - Grading.mp4

01:46

47. The Grade Command.mp4

04:15

48. Challenge 13 - Course Enrollment Part II.mp4

00:55

49. Prereq-aware Enrollment.mp4

20:33

50. Hiding Internals, Colorizing Externals.mp4

06:57

51. Verbose Query Execution.mp4

06:05

52. Challenge 14 - Unenroll.mp4

00:34

53. Unenrolling Students.mp4

03:29

54. Challenge 15 - Courses By Student.mp4

00:39

55. Current Enrollment Report.mp4

04:28

56. Challenge 16 - Transcripts.mp4

01:00

57. Generating Transcripts.mp4

07:26

58. Challenge 17 - Letter Grades.mp4

00:46

59. Approach.mp4

09:49

60. Implementation.mp4

05:28

61. Challenge 18 - Most Popular Courses.mp4

00:51

62. Most Enrolled Courses.mp4

06:18

63. Challenge 19 - Top Students.mp4

00:41

64. Top Performers.mp4

05:39

4. Day 3 - Guestbook API

1. Section Overview.mp4

00:55

2.1 day 3 - lectures.zip

2. Lecture Resources.html

3. PostgreSQL.mp4

02:55

4. The Precompiled Alternative.mp4

04:20

5. Database Server.mp4

03:07

6. Connecting.mp4

04:40

7. Query Execution.mp4

09:19

8. Parametrization.mp4

09:33

9. Dynamic Query Generation.mp4

10:22

10. Dynamic Queries Part II.mp4

14:15

11. Quick Refactor.mp4

03:12

12. Lets Build!.mp4

02:24

13.1 day 3 - challenges.zip

13.2 playground.zip

13. Project Resources - All Challenge Solutions.html

14. New Virtual Env.mp4

02:10

15. The Web-based API.mp4

07:49

16. Automatic Documentation.mp4

02:40

17. Our Database.mp4

02:26

18. Object-Oriented Helper Part I.mp4

08:20

19. Object-Oriented Helper Part II.mp4

04:27

20. Connection URL As Env Variable.mp4

04:31

21. Dependency Injection.mp4

09:54

22. Challenge 1 - DDL.mp4

01:45

23. Creating Our First Tables.mp4

03:42

24. The Register Endpoint.mp4

06:24

25. Data Validation With Pydantic.mp4

04:39

26. User Registration Data Validation.mp4

07:38

27. Hashing Passwords.mp4

10:36

28. Registration With Hashed Passwords.mp4

04:49

29. Challenge 2 - Persisting To Database.mp4

00:44

30. Inserting Users.mp4

05:56

31. Adding The UNIQUE Constraint.mp4

05:10

32. HTTPExceptions And Status Codes.mp4

06:32

33. Challenge 3 - Object-Oriented Refactor.mp4

03:07

34. OOP Write Returning Id.mp4

13:54

35. Challenge 4 - Registration Tokens.mp4

01:14

36. Saving Tokens.mp4

03:20

37. The Activate Endpoint + Cleanup.mp4

06:22

38. Challenge 5 - Get One.mp4

02:27

39. Implementing Database get_one().mp4

15:16

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

02:10

41. Implementing A Generalized Get.mp4

06:41

42. Challenge 7 - Update.mp4

02:47

43. Implementing Database .update().mp4

10:02

44. Challenge 8 - Endpoint Integration.mp4

01:10

45. The Activate Flow.mp4

07:45

46. Challenge 9 - Activate Once.mp4

00:59

47. Enforcing One Time Activation.mp4

07:07

48. Messages Prep.mp4

05:33

49. Form vs Query Params.mp4

04:09

50. Code Reorg Using Routers.mp4

11:43

51. Challenge 10 - Messages DDL + Path.mp4

01:53

52. Persisting Messages.mp4

10:14

53. Fixing A Typo.mp4

00:35

54. Authentication.mp4

12:46

55. Authenticated POST messages.mp4

08:20

56. Fixing An Old Bug.mp4

03:29

57. Challenge 11 - Updating Messages.mp4

01:19

58. PATCH messages.mp4

11:29

59. Challenge 12 - Get Message By Id.mp4

01:44

60. Getting Public + Own Messages.mp4

08:29

61. Challenge 13 - Get All Messages.mp4

01:17

62. Getting Public And Own Messages.mp4

06:01

63. or_where Refactor.mp4

09:19

64. Challenge 14 - Database Delete.mp4

01:21

65. Implementing .delete().mp4

04:16

66. Refactoring Database Methods.mp4

11:21

67. Challenge 15 - Integrating Delete.mp4

00:50

68. Deleting Messages From The Interface.mp4

06:22

69. Challenge 16 - New Get Contains.mp4

03:45

70. Implementing Get With Like Operator.mp4

10:39

71. Challenge 17 - Get With Contains.mp4

04:40

72. Refactoring Get.mp4

04:55

73. Challenge 18 - Search Messages.mp4

00:54

74. Implementing Message Search.mp4

14:30

75. A More Coherent Database .get().mp4

11:36

76. The Final .get() Refactor.mp4

17:48

77. Challenge 19 - Upvotes.mp4

00:56

78. Upvotes DDL.mp4

03:31

79. Challenge 20 - Upvoting.mp4

00:56

80. The Upvote Interface.mp4

12:57

81. Quick Bug Fix.mp4

01:47

82. Challenge 21 - Most Popular Messages.mp4

01:45

83. Most Upvoted.mp4

10:34

84. Preparing To Send Emails.mp4

08:06

85. Sending Generated Tokens.mp4

13:32

86. Two Little Tweaks.mp4

02:52

87. Preparing To Deploy.mp4

05:58

88. Deployment.mp4

06:26

5. Thank you!

1. Outro + Sqlalchemy Musings.mp4

04:00

2. My Other Courses.html

Description

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

What You'll Learn?

Work with SQL databases confidently in python applications
Build and deploy a web-based API using FastAPI and PostgreSQL
Understand cursors, transactions, connections, and query execution in depth
Explore more advanced topics around dynamic SQL generation, prepared statements, and non-tuple cursors

Who is this for?

Anyone interested in learning how to work with SQL productively in python

Anyone interested in building python applications that use relational databases

More details

Description
Welcome to the best resource online for learning to work with SQL in python.

Python and SQL are two of the most in-demand skills in any data-related or data-adjacent role today.

In this course, we'll use SQLite, MySQL and PostreSQL to build three projects of increasing complexity that will give you a solid foundation in using SQL in python applications.

Over 17 hours and 50 coding assignments, you will gain practical mastery of, not only SQL and python, but also tens of programming and computer science concepts.

In building these projects, you wonâ€™t be copy/pasting code. Instead, we will be writing code from scratch, and we will be writing lots of it.

This "forced" practice will help solidify your understanding of the concepts and techniques we cover. Each assignment will be followed by a detailed solution and explanation.

By the end of the course, after 3 immersive days, SQL and python will be on your resume!

â€“â€“â€“â€“â€“ Structure & Curriculum â€“â€“â€“â€“â€“

Â· Day 1: SQLite
Â· understanding connections, cursors, transactions in sqlite3
Â· parameterizing and executing queries
Â· understanding and preventing SQL injections
Â· introduction to DBAPI
Â· building the Freight Manager (9 coding assignments)

Â· Day 2: MySQL
Â· revisiting connections, cursors, transactions with mysql-connector
Â· building prepared statements
Â· exploring dictionary, buffered and namedtuple cursors
Â· building the School Registrar (19 coding assignments)

Â· Day 3: PostgreSQL
Â· revisiting connections, cursors, transactions with psycopg2
Â· generating dynamic SQL from python code
Â· building the Guestbook API (22 coding assignments)
Â· with object oriented programming, password hashing, and more

This is the ultimate, immersive introduction to two of the most valuable skills today.

I'll see you inside!
Who this course is for:
Anyone interested in learning how to work with SQL productively in python
Anyone interested in building python applications that use relational databases

User Reviews

Rating

average 0

Total votes0

Focused display

Hi! I'm Andy. I'm freelance software developer and capital markets consultant. I've spent close to a decade working with data, using code to automate business workflows, and consulting financial institutions on data-intensive applications.Aside from teaching, I run a AI and data consulting firm that targets fintechs in the post-trade services niche.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.