Data Processing

Python    |    Intermediate
  • 9 videos | 48m 13s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 55 users Rating 4.7 of 55 users (55)
Working with databases, regular expressions, and XML data are common tasks for DevOps in Python. Explore how to perform these common tasks.

WHAT YOU WILL LEARN

  • 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
    Work with regular expression search syntax using the standard re module
  • Perform a search and replace using various regular expression modifiers
    Parse xml data with sax using the standard xml module
    Use the dom with the standard xml module to parse xml data
    Read data from xml and save it in a mysql database

IN THIS COURSE

  • 4m 42s
    Learn how to create a database and user in MySQL from Python. FREE ACCESS
  • 5m 57s
    During this video, you will learn how to build a table and perform CRUD operations using Python. FREE ACCESS
  • Locked
    3.  Database Transactions
    4m 49s
    Learn how to perform a transactional query with a commit in Python. FREE ACCESS
  • Locked
    4.  Database Error Management
    4m 7s
    In this video, you will learn how to handle errors returned from database queries in Python. FREE ACCESS
  • Locked
    5.  Regular Expression Search Syntax
    5m 13s
    During this video, you will learn how to work with regular expression search syntax using the standard RE module. FREE ACCESS
  • Locked
    6.  Regular Expression Search and Replace
    4m 13s
    Learn how to perform a search and replace using various regular expression modifiers. FREE ACCESS
  • Locked
    7.  XML Parsing with SAX
    6m 36s
    In this video, you will parse XML data with SAX using the XML module. FREE ACCESS
  • Locked
    8.  XML Parsing with DOM
    5m 10s
    In this video, you will learn how to use the DOM with the standard XML module to parse XML data. FREE ACCESS
  • Locked
    9.  Exercise: Loading Data from XML
    7m 25s
    During this video, you will learn how to read data from XML and save it in a MySQL database. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Journey Programming Python in Action
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Journey The Complete Data Structures and Algorithms in Python
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Journey Prompt Engineering for Programmers to Learn Python
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Conditional Statements & Loops: The Basics of for Loops in Python
Rating 4.6 of 436 users Rating 4.6 of 436 users (436)
Course Functions in Python: Gaining a Deeper Understanding of Python Functions
Rating 4.6 of 255 users Rating 4.6 of 255 users (255)
Course Python - Introduction to NumPy for Multi-dimensional Data
Rating 4.5 of 543 users Rating 4.5 of 543 users (543)