<< Chapter < Page Chapter >> Page >
This module explains how SQLite fits into this course.

Table of contents

Discussion

This module is one in a collection of modules on Python designed for teaching ITSE 1359 Introduction to Scripting Languages: Python at Austin Community College in Austin, TX.

SQL stands for Structured Query Language . SQL is used to communicate with a database. According to ANSI (American National Standards Institute) , it is the standard language for relational database management systems.

According to The Python Standard Library - 12.6. SQLite3 - DB-API 2.0 interface for SQLitedatabases ,

SQLite is a C library that provides a lightweight disk-based database that doesn't require a separate server process and allows accessing the databaseusing a nonstandard variant of the SQL query language.

SQL is a very broad topic. Considerable time, effort, and experience is required to master SQL. As evidence of this fact, see the somewhat voluminous W3Schools SQL Tutorial .

Knowledge of SQL is a prerequisite for understanding SQLite. It is unreasonable to expect a student to learn SQL during a small portion of aone-semester course in Python.

Take-home assignments requiring the use of SQLite may be based on the material on any of the following websites:

However, because knowledge of SQL is a prerequisite for understanding SQLite, and it is unreasonable to expect a student to learn SQL during a small portionof a one-semester course in Python, tests in this course will not include questions about SQL or SQLite. Therefore, this module does notcontain review questions regarding SQLite.

Miscellaneous

This section contains a variety of miscellaneous information.

Housekeeping material
  • Module name: Itse1359-1950-SQLite Database
  • File: Itse1359-1950.htm
  • Published: 11/10/14
  • Revised: 12/29/14
Disclaimers:

Financial : Although the Connexions site makes it possible for you to download aPDF file for this module at no charge, and also makes it possible for you to purchase a pre-printed version of the PDF file, youshould be aware that some of the HTML elements in this module may not translate well into PDF.

I also want you to know that, I receive no financial compensation from the Connexions website even if you purchase the PDF version ofthe module.

In the past, unknown individuals have copied my modules from cnx.org, converted them to Kindle books, and placed them for sale onAmazon.com showing me as the author. I neither receive compensation for those sales nor do I know who does receive compensation. If youpurchase such a book, please be aware that it is a copy of a module that is freely available on cnx.org and that it was made andpublished without my prior knowledge.

Affiliation : I am a professor of Computer Information Technology at Austin Community College in Austin, TX.

-end-

Get Jobilize Job Search Mobile App in your pocket Now!

Get it on Google Play Download on the App Store Now




Source:  OpenStax, Itse 1359 introduction to scripting languages: python. OpenStax CNX. Jan 22, 2016 Download for free at https://legacy.cnx.org/content/col11713/1.32
Google Play and the Google Play logo are trademarks of Google Inc.

Notification Switch

Would you like to follow the 'Itse 1359 introduction to scripting languages: python' conversation and receive update notifications?

Ask