Python 3000: SQLite Quick-Start

Rating 3.83 out of 5 (9 ratings in Udemy)

What you'll learn

Understand how to Create, Alter, Delete, and otherwise manage SQL Tables using Python
Be able to use Python to Create, Read, Update & Delete SQL Records (C.R.U.D)
Understand how to select, sort & create distinct record collections using SQL
Know how to download & use console tools to manage Python 3 databases
Leverage Python so as to encapsulate (hide) low-level SQL commands
Discover how to quickly backup relational databases …

Rating 3.83 out of 5 (9 ratings in Udemy)

What you'll learn

Understand how to Create, Alter, Delete, and otherwise manage SQL Tables using Python
Be able to use Python to Create, Read, Update & Delete SQL Records (C.R.U.D)
Understand how to select, sort & create distinct record collections using SQL
Know how to download & use console tools to manage Python 3 databases
Leverage Python so as to encapsulate (hide) low-level SQL commands
Discover how to quickly backup relational databases
Understand how to generate SQL Scripts used to both backup & migrate data
Enumerate through SQL data selections using a "Pythonic Generator"
Enjoy re-using our code to completely encapsulate SQL Table & Row management
Understand what Python's "Database Cursor" is, & why it is important
Understand what a "primary key" is, and why they are important
Understand the difference between a "Foreign Key" and a "Primary Key"
Learn how to change database schema without necessarily breaking existing applications!

Description

No matter if we are managing a list of friends, collecting testing results, or managing complex business data, software developers who need to know how to use Python's built-in SQL Database support will find this quick-start invaluable.

In addition to discovering how to create and manage existing databases, this Python 3000 topic includes everything a software developer will need to know in order to get started using the Structured Query Language, or SQL, on their workstations.

By reviewing the most-used features slowly, our quick-start will also prepare a Python Programmer to use the most portable set of SQL Statements; concepts & statements that can be used across virtually all SQL Technologies.

Because Python's database default technology set includes SQLite 3, while learning how to use SQL students will also discover how to install & use the SQLite Console Application. In addition to demonstrating how to create database tables & rows, the student will also use the console application to generate database scripts using Python 3.

NOTE: By understanding the methods behind the magic, students familiar with the Soft9000 / PyDAO project on GitHub, will also enjoy this training opportunity.

Duration 2 Hours 58 Minutes

Paid

Self paced

Intermediate Level

English (US)

3364

Rating 3.83 out of 5 (9 ratings in Udemy)

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.