Course Description
Working with databases, regular expressions, and XML data are common tasks for DevOps in Python. This course demonstrates how to perform these common tasks.
Learning Objectives
Database Operations
- start the course
- create a database and a user in MySQL from Python
- build a table and perform CRUD operations from Python
- perform a transactional query with commit in Python
- handle errors returned from database queries in Python
Regular Expressions
- work with regular expression search syntax using the standard RE module
- perform a search and replace using various regular expression modifiers
XML Processing
- parse XML data with SAX using the standard XML module
- use the DOM with the standard XML module to parse XML data
Practice: Databases and XML
- read data from XML and save it in a MySQL database