Brief Introduction
Use SQLite to create & manage relational databases in Python 3!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.
Requirements
- Requirements
- Students should be comfortable using Python to import native Modules
- Students should be familiar with the use of the "yield" keyword
- The prior completion of Python 1000 & Python 2000 training is encouraged
Knowledge
- 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!
Randall Nagy
4 Raiting
Django 2.2 & Python | The Ultimate Web Development Bootcamp
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Build three complete websites, learn back and front-end web development, and publish your site online with DigitalOcean THEN THIS IS THE COURSE FOR YOU! I care about your learning, but even more importantly....
Python 3000: SQLite Quick-Start
- 4
-
![]()
![]()
![]()
![]()
![]()
Use SQLite to create & manage relational databases in Python 3! Understand how to Create, Alter, Delete, and otherwise manage SQL Tables using Python...
Django 3 - Full Stack Websites with Python Web Development
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Build 3 stunning websites, learn Back and Front End Web Development, deploy your site with HTML5, CSS3 and Bootstrap 4 THEN THIS IS THE COURSE FOR YOU!...
