English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 1h 39m | 288 MB
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.
Table of Contents
Introduction
1 Use SQL with Python
2 Using the exercise files
3 What do you need for this course
4 Installing the tools
1. Common Interface
5 The Python DB-API
6 Creating a connection
7 Simple queries
8 Prepared statements
9 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
Resolve the captcha to access the links!