<< Chapter < Page Chapter >> Page >
In theoretical computer science and formal language theory, a regular expression (abbreviated regex or regexp) and sometimes called a rational expression is a sequence of characters that forms a search pattern,mainly for use in pattern matching with strings, or string matching, i.e. "find and replace"-like operations.

The topic of regular expressions in Python is complex with two main threads:

  1. How do you create a combination of characters that form a search pattern to accomplish a given objective?
  2. Given such a search pattern , how to you use the Python programming language to carry out the search?

Creating the search pattern is pretty much the same no matter what programming language you are using. The character combinations used for creatingthe necessary search patterns are very similar from one programming language to the next.

Because this is a course in Python programming and is not a course in regular expression search patterns, only the simple search patterns highlightedin the module titled Itse1359-1850-Regular Expressions will be included on tests. (However there will be no such restriction on take-home assignments.)

The main thrust of the Text Processing portion of this course insofar as regular expressions is concerned, will be on Item 2 above -- learning how to use the Python programming language to implement theeffective use of regular expression search patterns.

SQLite database

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 database using a nonstandard variant of the SQL query language.

SQL is also 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 a one-semestercourse in Python. Therefore, the module titled Itse1359-1950-SQLite Database will barely scratch the surface and will provide only a cursory introduction tothe use of SQLite.

Miscellaneous

This section contains a variety of miscellaneous information.

Housekeeping material
  • Module name: Itse1359-1900-Preface to Networking and Databases
  • File: Itse1359-1900.htm
  • Published: 11/11/14
  • Revised: 12/29/14
Disclaimers:

Financial : Although the Connexions site makes it possible for you to download a PDF file for thismodule at no charge, and also makes it possible for you to purchase a pre-printed version of the PDF file, you should beaware 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 of the module.

In the past, unknown individuals have copied my modules from cnx.org, converted them to Kindle books, and placed them for sale on Amazon.com showing me as the author. Ineither receive compensation for those sales nor do I know who does receive compensation. If you purchase such a book, please beaware that it is a copy of a module that is freely available on cnx.org and that it was made and published withoutmy 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