Using SQL with Python

Focused View

Bill Weinman

1:39:05

0 View

[1] Introduction

[1] Use SQL with Python.mp4

00:53

[2] Using the exercise files.mp4

01:13

[3] What do you need for this course.mp4

01:35

[4] Installing the tools.mp4

09:19

[2] 1. Common Interface

[1] The Python DB-API.mp4

02:16

[2] Creating a connection.mp4

05:19

[3] Simple queries.mp4

05:13

[4] Prepared statements.mp4

05:13

[5] Hello, SQLite.mp4

05:43

[6] Hello, MySQL.mp4

04:52

[7] Challenge.mp4

01:01

[8] Solution.mp4

05:12

[3] 2. A CRUD Class

[1] The essential four.mp4

01:00

[2] SQL Wrapper.mp4

09:40

[3] Adding CRUD methods.mp4

06:43

[4] Using the module.mp4

03:53

[5] Challenge.mp4

02:31

[6] Solution.mp4

04:07

[4] 3. Final Project URL Shortener

[1] Defining the project.mp4

03:35

[2] Testing a web application.mp4

03:51

[3] Code demonstration.mp4

03:37

[4] Touring the code.mp4

08:13

[5] Challenge.mp4

00:36

[6] Solution.mp4

02:41

[5] Conclusion

[1] Thank you.mp4

00:49

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Python

Bill Weinman

Instructor's Courses

I cleverly manipulate unsuspecting electrons to teach you about technology and other cool things. I'm primarily an educator, I teach online courses and write books on computer languages and programming. I built my first computer in 1972, using an Intel 4004 4-bit microprocessor and parts from a local Radio Shack. Over a 45+ year career, I've consulted for major corporations, including NASA, IBM, Bank of America, the US Navy, and KWHY-TV, where I designed the world’s first broadcast lower-third stock ticker. I've written popular books and courseware on C, C++, Perl, Python, SQL, and more. My courses have consistently been ranked in the top-10 on lynda.com and Linkedin Learning’s training sites. // Students: Please do not direct message me on Linkedin for technical support with my lynda.com/Linkedin Learning courses. I rarely see my Linkedin messages. You may tag me in a post or use the course Q&A system. // Recruiters: Please do not contact me for captive positions. I occasionally do some consulting, but mostly I am booked at least a year in advance. If you need to contact me directly, please see my web site https://bw.org/contact

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.