Python 3000: SQLite Quick-Start

Python 3000: SQLite Quick-Start, available at $22.99, has an average rating of 3.83, with 22 lectures, based on 9 reviews, and has 3466 subscribers.

You will learn about 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 This course is ideal for individuals who are Student should be familiar with Python 3 It is particularly useful for Student should be familiar with Python 3.

Enroll now: Python 3000: SQLite Quick-Start

Summary

Title: Python 3000: SQLite Quick-Start

Price: $22.99

Average Rating: 3.83

Number of Lectures: 22

Number of Published Lectures: 22

Number of Curriculum Items: 22

Number of Published Curriculum Objects: 22

Original Price: $22.99

Quality Status: approved

Status: Live

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

Who Should Attend

Student should be familiar with Python 3

Target Audiences

Student should be familiar with Python 3

Once we have learned any programming language, the next task is to become familiar with the most common activities.

Relational Databases

Required to get our jobs done, we’re often required to manage large amounts of data. Important to know as well as practice, saving records into data to files is often an important part of any significant data processing activity.

S.Q.L Defined

In this 3000 level training opportunity, we will begin by discovering how to simply and quickly create, read, update, and delete records (“rows”) in to files on our workstation using the Structured Query Language – or S.Q.L.

Types of Data

No matter if we are managing a list of friends, collecting testing results, or managing complex business data, software all developers need to know how to use Python’s built-in SQL Database support.

Workstations & Clouds

In addition to discovering how to create and manage existing databases, this Python 3000 topic includes everything a software developer will need to know to get started using the SQL on their workstations. No matter the type of data you can imagine, practicing how to create, read, update, and delete (C.R.U.D) your own database is a great way to impress friends and future employers. Better still, SQLite database we create on our own computers can be used on others – even taken to the cloud!

Fast Start

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

Always Included!

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 3000 Level educational opportunity.

Course Curriculum

Chapter 1: Python 3000: SQL Quick-Start

Lecture 1: 3700: Welcome to SQL Quick Start!

Lecture 2: 3702: Training Intorduction & SQL Overview

Lecture 3: 3704: SQL & C.R.U.D

Lecture 4: 3706: Table & Row Relationships

Lecture 5: 3708: A Tour of SQLite

Lecture 6: 3710: Tables & Railroad Diagrams

Lecture 7: 3712: "Bottom Up" Data Normalization & Access Speeds (OPTIONAL)

Lecture 8: 3714: SQL Instertion & More SQLite "Dot Commands"

Lecture 9: 3716: Lab Review & Primary Keys

Lecture 10: 3718: Lab Review & Data Selections / Joins

Lecture 11: 3720: Python Database Connections

Lecture 12: 3722: Database Path on Microsoft

Lecture 13: 3724: Classes, Connections, and Cursors

Lecture 14: 3726: Create SQLite Data Class (LAB)

Lecture 15: 3728: Managing Schema Change

Lecture 16: 3730: Ripple Effects of Table Modification (Lab)

Lecture 17: 3732: The Data Access Object (DAO) (Optional)

Lecture 18: 3734: SQLite Object Operations

Lecture 19: 3736: Tables – The Ultimate C.R.U.D?

Lecture 20: 3738: Reading & Changing Table Definitions

Lecture 21: 3740: Topical Review

Lecture 22: 3742 – BONUS: Generating Python from Data Files

Instructors

Randall Nagy
Software Engineer & Educator

Rating Distribution

1 stars: 1 votes
2 stars: 1 votes
3 stars: 0 votes
4 stars: 4 votes
5 stars: 3 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu