Python Exception Handling, File Handling (CSV & Binary), and MySQL Introduction

Comprehensive vocabulary flashcards covering Python exception handling, CSV file manipulation, MySQL fundamentals and datatypes, and binary file handling with pickling.

Exception

An error that occurs during program execution (runtime) that disrupts and interrupts the normal flow of a program.

try block

A block in Python used to enclose suspicious lines of code that might cause or raise an exception during execution.

except block

A block in Python used to catch and handle exceptions that occur within an associated try block.

finally block

A block in Python placed at the end of a try block that is always executed regardless of whether an exception occurs, is caught, or if return, break, or continue statements are executed.

else clause (try-except)

An optional clause placed with try-except that executes only if no exception is raised in the try block.

raise and assert statements

Statements used in Python to deliberately raise exceptions during code execution.

SyntaxError

A built-in Python parsing error that is raised when there is an error in the syntax of the code.

ValueError

A built-in Python exception raised when a built-in method or operation argument receives the right data type but an inappropriate value.

IOError

A built-in Python exception raised when a file specified in a program cannot be opened.

KeyboardInterrupt

A built-in Python exception raised when the user interrupts program execution by accidentally hitting an interrupt key such as the Delete key.

ImportError

A built-in Python exception raised when a requested module definition is not found.

EOFError

A built-in Python exception raised when the end of file condition is reached without reading any data from input.

ZeroDivisionError

A built-in Python exception raised when the denominator in a division operation is zero.

IndexError

A built-in Python exception raised when an index or subscript in a sequence is out of range.

NameError

A built-in Python exception raised when a local or global variable name is not defined.

TypeError

A built-in Python exception raised when an operator or function is supplied with a value of an incorrect data type.

CSV (Comma Separated Values)

A human-readable text file format extensively used to store tabular data in a spreadsheet or database, where each line represents a record consisting of fields.

Delimiter

The separator character in CSV files that separates fields, with comma (',') being the default, and others including Tab ('\t'), Colon (':'), Pipe ('|'), and Semicolon (';').

csv.reader()

A Python csv module function that returns a reader object which loads and parses delimited data from a CSV file into an iterable.

csv.writer()

A Python csv module function that returns a writer object to convert user data into a delimited string for writing into CSV files.

writerow()

A CSV writer object method that writes a single row of data to the open CSV file.

writerows()

A CSV writer object method that writes multiple rows of data to the open CSV file.

MySQL

A freely available open-source Relational Database Management System (RDBMS) that operates on a client-server architecture and uses Structured Query Language (SQL).

DDL (Data Definition Language)

A category of SQL commands (such as CREATE, ALTER, and DROP) that allow users to perform tasks related to table structure and definitions.

DML (Data Manipulation Language)

A category of SQL commands (such as SELECT, UPDATE, INSERT, and DELETE) that allow users to perform tasks related to data stored inside tables.

TCL (Transaction Control Language)

A category of SQL commands (such as SAVEPOINT, COMMIT, and ROLLBACK) that allow users to manage and control database transactions.

Character Literal

Fixed text or character data values that are enclosed in quotation marks in SQL (such as 'computer' or '10').

Numeric Literal

Fixed numbers in SQL not enclosed in quotation marks, comprising integer literals (without a decimal point) and real literals (with a decimal point).

CHAR

A fixed-length string data type in MySQL where values shorter than the declared length are padded with blank spaces while retaining the specified storage size.

VARCHAR

A variable-length string data type in MySQL where no blank spaces are added if a value is shorter than the declared length, allowing unused space to be reused.

Null (SQL)

A marker indicating that a specific column or row contains no value.

Binary File

A file stored in binary format (bits and bytes) that is computer-readable but not human-readable, where each byte is written in ASCII code.

Pickling (Serializing)

The process in Python where a Python object (such as a list, dictionary, or tuple) is converted into a byte stream.

Unpickling (Deserializing)

The reverse process of pickling in Python, where a byte stream is converted back into an original Python object.

pickle.dump()

A function in the Python pickle module used to write a pickled byte-stream representation of an object to an open file object using the syntax pickle.dump(object, file_object).

pickle.load()

A function in the Python pickle module used to read one record at a time from a binary file and reconstruct the original Python object.

seek()

A binary file method in Python that moves the file pointer to a specified byte position, taking arguments for byte offset and reference position (0 for start, 1 for current, 2 for end).

tell()

A file method in Python that returns the current byte position of the file pointer.

Exception

An error that occurs during program execution (runtime) that disrupts and interrupts the normal flow of a program.

try block

A block in Python used to enclose suspicious lines of code that might cause or raise an exception during execution.

except block

A block in Python used to catch and handle exceptions that occur within an associated try block.

finally block

A block in Python placed at the end of a try block that is always executed regardless of whether an exception occurs, is caught, or if return, break, or continue statements are executed.

else clause (try-except)

An optional clause placed with try-except that executes only if no exception is raised in the try block.

raise and assert statements

Statements used in Python to deliberately raise exceptions during code execution.

SyntaxError

A built-in Python parsing error that is raised when there is an error in the syntax of the code.

ValueError

A built-in Python exception raised when a built-in method or operation argument receives the right data type but an inappropriate value.

IOError

A built-in Python exception raised when a file specified in a program cannot be opened.

KeyboardInterrupt

A built-in Python exception raised when the user interrupts program execution by accidentally hitting an interrupt key such as the Delete key.

ImportError

A built-in Python exception raised when a requested module definition is not found.

EOFError

A built-in Python exception raised when the end of file condition is reached without reading any data from input.

ZeroDivisionError

A built-in Python exception raised when the denominator in a division operation is zero.

IndexError

A built-in Python exception raised when an index or subscript in a sequence is out of range.

NameError

A built-in Python exception raised when a local or global variable name is not defined.

TypeError

A built-in Python exception raised when an operator or function is supplied with a value of an incorrect data type.

FileNotFoundError

A built-in Python exception raised when an attempt to open or access a file that does not exist fails.

Parsing Error

Another name for a Syntax Error occurring during code parsing prior to program execution.

Multiple except blocks

A Python structure where several except blocks follow a single try block to catch distinct types of exceptions independently.

CSV (Comma Separated Values)

A human-readable text file format extensively used to store tabular data in a spreadsheet or database, where each line represents a record consisting of fields.

Delimiter

The separator character in CSV files that separates fields, with comma (',') being the default, and others including Tab, Colon, Pipe, and Semicolon.

csv.reader()

A Python csv module function that returns a reader object which loads and parses delimited data from a CSV file into an iterable.

csv.writer()

A Python csv module function that returns a writer object to convert user data into a delimited string for writing into CSV files.

writerow()

A CSV writer object method that writes a single row of data to the open CSV file.

writerows()

A CSV writer object method that writes multiple rows of data to the open CSV file.

Record (CSV)

A complete horizontal row in a CSV file that comprises one set of related data fields.

Field (CSV)

An individual item of data within a CSV record separated from other items by a delimiter.

newline parameter in open()

An argument in Python's open() function set to an empty string when writing CSV files to prevent blank lines between rows.

MySQL

A freely available open-source Relational Database Management System (RDBMS) that operates on a client-server architecture and uses Structured Query Language (SQL).

DDL (Data Definition Language)

A category of SQL commands (such as CREATE, ALTER, and DROP) that allow users to perform tasks related to table structure and definitions.

DML (Data Manipulation Language)

A category of SQL commands (such as SELECT, UPDATE, INSERT, and DELETE) that allow users to perform tasks related to data stored inside tables.

TCL (Transaction Control Language)

A category of SQL commands (such as SAVEPOINT, COMMIT, and ROLLBACK) that allow users to manage and control database transactions.

MySQL Server

The database component that processes incoming requests from clients over a network and provides controlled access to database contents.

MySQL Client

A program or interface that connects to a database server to submit queries and instructions in a prespecified format.

Character Literal

Fixed text or character data values that are enclosed in quotation marks in SQL (such as 'computer' or '10').

Numeric Literal

Fixed numbers in SQL not enclosed in quotation marks, comprising integer literals and real literals.

Integer Literal (SQL)

A numeric constant in SQL without a decimal point, such as 17 or 25.

Real Literal (SQL)

A numeric constant in SQL containing a decimal point, such as 17.5 or 25.2.

CHAR

A fixed-length string data type in MySQL where values shorter than the declared length are padded with blank spaces while retaining the specified storage size.

VARCHAR

A variable-length string data type in MySQL where no blank spaces are added if a value is shorter than the declared length, allowing unused space to be reused.

Null (SQL)

A marker indicating that a specific column or row contains no value.

SQL Keywords

Reserved words with predefined, specific meanings in SQL syntax, such as WHERE, SELECT, and FROM.

Single-line SQL comments

SQL documentation markers that start with a hash (#) or double dashes (--) to comment out the rest of the line.

Multi-line SQL comments

An SQL commenting style enclosed between /* and */ spanning one or more lines.

DATE data type

A MySQL data type used to store calendar dates in the standard format YYYY-MM-DD.

TIME data type

A MySQL data type used to store time values in the format HH:MM:SS.

DATETIME data type

A MySQL data type used to store combined date and time values in the format YYYY-MM-DD HH:MM:SS.

Binary File

A file stored in binary format (bits and bytes) that is computer-readable but not human-readable, where each byte is written in ASCII code.

Binary mode indicator

The character 'b' appended to file access modes in open() (such as 'rb' or 'wb') to designate binary stream handling.

Pickling (Serializing)

The process in Python where a Python object (such as a list, dictionary, or tuple) is converted into a byte stream.

Unpickling (Deserializing)

The reverse process of pickling in Python, where a byte stream is converted back into an original Python object.

pickle.dump()

A function in the Python pickle module used to write a pickled byte-stream representation of an object to an open file object using the syntax pickle.dump(object, file_object).

pickle.load()

A function in the Python pickle module used to read one record at a time from a binary file and reconstruct the original Python object.

seek()

A binary file method in Python that moves the file pointer to a specified byte position, taking arguments for byte offset and reference position.

tell()

A file method in Python that returns the current byte position of the file pointer.

seek() offset reference point 0

The reference position parameter in seek() specifying that movement is calculated from the beginning of the file.

seek() offset reference point 1

The reference position parameter in seek() specifying that movement is calculated relative to the current file pointer location.

seek() offset reference point 2

The reference position parameter in seek() specifying that movement is calculated relative to the end of the file.