Practical SQL With Python In 3 Days | Udemy


Practical SQL With Python In 3 Days | Udemy [Update 11/2022]
English | Size: 6.26 GB
Genre: eLearning

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

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 SQLiteMySQL 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

nitroflare.com/view/C39F9CC5B0C7F31/PracticalSQLWithPythonIn3Days.part1.rar
nitroflare.com/view/44186400AC71931/PracticalSQLWithPythonIn3Days.part2.rar
nitroflare.com/view/AD532959F5C6510/PracticalSQLWithPythonIn3Days.part3.rar
nitroflare.com/view/EECCA9460CCD017/PracticalSQLWithPythonIn3Days.part4.rar
nitroflare.com/view/1D5E8250F477F68/PracticalSQLWithPythonIn3Days.part5.rar
nitroflare.com/view/C233E790AE5A490/PracticalSQLWithPythonIn3Days.part6.rar
nitroflare.com/view/E47855039DF2FFF/PracticalSQLWithPythonIn3Days.part7.rar

rapidgator.net/file/2c079546d6c365f78b5ae4e50436099a/PracticalSQLWithPythonIn3Days.part1.rar.html
rapidgator.net/file/7af4c0672e411f9a9cb0a8bc13ed565c/PracticalSQLWithPythonIn3Days.part2.rar.html
rapidgator.net/file/94d0295d679eb4ac90cac4277020ea88/PracticalSQLWithPythonIn3Days.part3.rar.html
rapidgator.net/file/efd49feb3a3b3e5e551a13da285ca23e/PracticalSQLWithPythonIn3Days.part4.rar.html
rapidgator.net/file/3b989e721c105703e4bc2001531519f2/PracticalSQLWithPythonIn3Days.part5.rar.html
rapidgator.net/file/1525c0a29a31cdfd7333e5d7e87b4acd/PracticalSQLWithPythonIn3Days.part6.rar.html
rapidgator.net/file/9f1c44c853b06a9b3dcf1cf373aa252e/PracticalSQLWithPythonIn3Days.part7.rar.html

If any links die or problem unrar, send request to
forms.gle/e557HbjJ5vatekDV9

Leave a Comment