Python 3000: SQLite Quick-Start

Use SQLite to create & manage relational databases in Python 3!

Ratings 3.96 / 5.00

What You Will Learn!

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

Description

Once we have learned any programming language, the next task is to become familiar with the most common activities required to get our jobs done. Saving data to files is often an important part of any significant data processing activity. In this training opportunity, we will begin by discovering how to simply and quickly create, read, update, and delete records ("rows") in to files on our local hard drive using the Structured Query Language - or S.Q.L.

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