Python 3000: Tactical SQL Quick-Start
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
13 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Python 3000: Tactical SQL Quick-Start to your Wishlist.

Add to Wishlist

Python 3000: Tactical SQL Quick-Start

Techniques, Technologies and More Programming Topics
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
13 students enrolled
Created by Randall Nagy
Last updated 8/2016
Curiosity Sale
Current price: $10 Original price: $45 Discount: 78% off
30-Day Money-Back Guarantee
  • 1.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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!
View Curriculum
  • Students should be comfortable using Python to import native Modules
  • Students should be familiar with the use of the "yield" keyword
  • The completion of or Python 1000 & Python 2000 training is encouraged

No matter if we are collecting testing results, or managing contact & business data, software developers who 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 / or 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 on their own workstation. Commonly known as "SQL," by reviewing the most-used features, this 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 technology uses SQLite 3, while learning how to use SQL in Python the student will also discover how to 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 clear-text SQL database scripts.

Who is the target audience?
  • Student should be familiar with Python 3
Students Who Viewed This Course Also Viewed
Curriculum For This Course
11 Lectures
Python 3000: SQL Quick-Start
11 Lectures 01:15:46

Join us for a quick overview of what you will learn in these lessons, as well as how you can use the same database technology used at sites like The Quote For Today!

Preview 04:47

The ability to quickly add a database to our Python programming activities is an important part of topic mastery. More importantly however, understanding how to add only as much relational technology as we need for the task at hand allows us to fine-tune the performance of our data collection activities.

In this lesson, we will:

  • Discover the spirit & history behind the SQL Standard
  • Understand the spirit behind the NoSQL movement
  • Learn about “Vendor Lock,” as well as how to avoid it
  • Review the high-points of data normalization
  • Understand why primary keys are important, and when to use them
  • Start planning for the creation and migration of your data
Preview 07:22

When using any SQL technology, the first thing one often needs to do is to get a database connection. Once we have a database connection in Python 3, not only can we submit SQL Statements, but we can also look-up meta-data information, as well.

In this lesson, we will:

  • Review the concepts of connection sharing
  • Understand how to to encapsulate database selection so as to support local, group, and enterprise database strategies
  • Learn how connections can be used to encapsulate database locations
  • Discover the difference between embedded and server database
  • Review the entire set of Sqliet's native data types
  • Discover how Pythonic data may converted, saved, and restored to Sqlite database tables
SQL Concepts

It is not too uncommon to start using Python to start collecting data quickly into a single table, only to export data for use elsewhere and / or perhaps to a more multi-table data-relationship strategy.

In this lesson, we will:

  • Review the “fast and easy” way to use Sqlite to save and search database
  • Discover how to encapsulate database operation using the classic open, write, read, and close paradigm
  • Understand the need & use of a “database cursor”
  • Learn how to create and remove database tables
  • Discover how to insert data as fast as possible
  • Learn how to create a Generator to enumerate through database selections
  • Discover how to demonstrate data storage performance improvement
  • Learn how to use Generators to manage database selections
The Fastest "Tank"?

Review the test case for the LogDB Class.

In this lesson, we will also:

  • Build upon the previous example to add primary keys
  • Learn how to ensure that primary keys are auto-created, as well as automatically increments
  • Learn why defining the complete data collection requirement is important in Python
  • Add an automatically-converted data type into the Sqlite database
Primary Keys

When used as a mnemonic, each of the operations defined by the C.R.U.D acronym need not be named as such! Yet in as much as several SQL Commands do indeed match their C.R.U.D monikers, in this lesson we will provide the "missing operations," as they map to SQL.

In this lesson, we will also:

  • Review how to retrieve that number of rows in the database
  • Delve deeper into the database Cursor Object, as used in Python
  • Learn how to return the number of rows affected by an SQL Statement

Final C.R.U.D

Software developers are often surprised to discover that database tables may also support the full C.R.U.D set of operations. Yet while the support for creating & deleting database tables is well known, the support for modifying and reading the content of database tables is typically extremely technology specific.

In this lesson, we will:

  • Discover how to download & install the SQLite Console Application
  • (we will use Python, as well as the console application to complete the table management routines in the next lesson)
Reading & Changing Table Definitions

While it is great to use Python to manage database collection activities, from time to time it is simply faster & easier to perform database modification using Python's console user interface.

In this lesson, we will:

  • Discover how to create tables & enter data using the Console Application
  • Learn how SQLite allows us to alter, as well as to read, or database definition
  • Learn how to backup databases from the operating system
  • Enjoy a musical review of SQL Commands & Primary Key Concepts

Console Concept Review

Discover the absolute fastest way to collect data. Often destined for migration over to more analytical schema strategies, many software developers can benefit from the application of both “keyed,” as well as “unkeyed” data collection activities.

SQL Keys & Constraints (SQL Console Review)

Altering database tables is not typically done from Python. For the sake of completeness however, we can indeed alter, as well as read, database schema form Python.

  • Understand how to read and modify database schema using the Console user interface.
  • Discover how to use Python to read, as well as to alter, database tables
  • Discover the limitations of table alterations in SQLite
  • Learn how to change database schema without necessarily breaking existing applications!

Table Alteration

In this final lesson, we will review the "Big Ideas" covered by the SQL Quick-Start Training Opportunity. The final solution to our database activities is also included. -Feel free to modify & re-use LogDB in your own database creations!

Topical Review
About the Instructor
Randall Nagy
4.1 Average rating
147 Reviews
8,441 Students
14 Courses
Consulting Engineer & Educator

I've over 30 years of experience.

"Mr. Nagy presently earns his keep in the world by providing technology mentoring, training, hands-on consulting / software development, & customized content creation services.

Mr. Nagy has served as both a Principal Trainer & Principal Software Development Engineer. His "Linked In" recommendations testify to a 30+ year track record of excellent personal communication skills, design & analysis abilities, as well as superior consulting & training results.

Though tenured, Mr. Nagy is most often described as being extremely technical, yet very personable & easy to get along with.

The author of over 26 Open-Source Projects, Mr. Nagy's hands-on experience includes topics such as C/C++, Python, SO / SOA, Security, Testing, UML, Java/JEE, .NET (C# and VB.NET), LAMP, Hadoop, jQuery, HTML 5, Android, and more. Maintaining techniques in embedded engineering, Mr. Nagy has experience creating custom training for such expert-level, high-performance technologies as IBM Rhapsody.

Technically speaking, "... from the best Service-Oriented practices to embedded engineering, I maintain an extensive hands-on skill set. From Java and C/ C++, C#, PHP, Python, Ruby, HTML 5 and Web 2.0, I have both designed and implemented architectures from the UI / RIA to the server, well into the RFC Layer. …

I also have over 150 successful training / mentoring, publication, and speaking engagements to my credit. Recent experience includes such state-of-the art technologies as Hadoop, Android, WSO2, and TFS."