Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
Using SQL with Python

Using SQL with Python

1h 39mIntermediate2021-07-12

Authors

Bill Weinman

Bill Weinman

Tech Advocate, Entrepreneur, Programming Expert

Course details

Are you familiar with SQL? Do you know Python? Are you interested in understanding how these two languages work together? Then join Bill Weinman in this course as he shows the power of these two languages combined. Bill starts with some basics—connecting to a database, performing simple queries, and reading rows from a table. He covers how to use prepared statements and cursors, how to build a wrapper class to streamline the SQL interface and support multiple different database engines, and how to build a CRUD class and a full-featured web application using what you've learned. Many applications require a combination of SQL and Python, and after finishing Bill’s course, you’ll have a better understanding of why and how you can leverage the power of these two languages together.

Skills covered

SQLDatabase AdministrationDatabase DevelopmentPythonDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off

Concepts

0. Introduction

  • 01 - Use SQL with Python
  • 02 - Using the exercise files
  • 03 - What do you need for this course
  • 04 - Installing the tools

1. Common Interface

  • 05 - The Python DB-API
  • 06 - Creating a connection
  • 07 - Simple queries
  • 08 - Prepared statements
  • 09 - Hello, SQLite
  • 10 - Hello, MySQL
  • 11 - Challenge
  • 12 - Solution

2. A CRUD Class

  • 13 - The essential four
  • 14 - SQL Wrapper
  • 15 - Adding CRUD methods
  • 16 - Using the module
  • 17 - Challenge
  • 18 - Solution

3. Final Project - URL Shortener

  • 19 - Defining the project
  • 20 - Testing a web application
  • 21 - Code demonstration
  • 22 - Touring the code
  • 23 - Challenge
  • 24 - Solution

Conclusion

  • 25 - Thank you

Related courses

Related learn paths

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
zarinpal
zibal