Final Exam: Dynamic Data Handling with Python

Python 3.6+    |    Intermediate
  • 1 Video | 32s
  • Includes Assessment
  • Earns a Badge
Final Exam: Dynamic Data Handling with Python will test your knowledge and application of the topics presented throughout the Dynamic Data Handling with Python track of the Skillsoft Aspire Pythonista to Python Master Journey.

WHAT YOU WILL LEARN

  • insert data into views
    perform various import and export operations on CSV, TSV, and TXT files.
    perform various grouping operations on the data in a table
    perform various update and replace operations on petl data tables by defining functions to perform transformations
    install petl and create a basic petl data table out of toy data
    create a table in SQLite and read it into petl using SQLAlchemy and SQLite3
    identify the different options available to stream large volumes of data in an HTTP response
    submit data to a remote server using a POST request with HTTPX
    map fields in a petl table to transformation based on functions
    create and invoke stored procedures
    use the HTTPX AsynClient to download a set of files asynchronously
    create and use a SQL primary key constraint with autoincrement
    get data from MS Excel and perform basic operations on the data
    insert and edit columns and rows in petl data tables
    use the fetchmany() function to retrieve the output of a select query
    recognize when a redirect has taken place upon submitting an HTTP request
    implement insert and delete operations
    recall the types of exceptions that can be encountered when sending and processing requests with HTTPX
    install SQLAlchemy and connect to MySQL
    query data using object relational mapping
    configure an httpx.Cookies instance to send a collection of properties to a remote server
    implement check constraints
    read in data from the serialized pickle and XML file formats
    create tables using object relational mapping
    work with transaction aborts
    define and submit a POST request containing JSON and binary data
    insert rows into a table
    read JSON data, perform various operations, and export it to a persistent format
    limit the amount of time your app spends waiting to get served a response to an HTTP request using timeouts
    identify when a redirect has taken place upon submitting an HTTP request
  • create a table and insert rows into it
    recognize the types of exceptions that can be encountered when sending and processing requests with HTTPX
    install the latest available version of HTTPX on your system
    explore different ways to use logical operators for querying data
    implement an httpx.Cookies instance to send a collection of properties to a remote server
    use triggers to automate operations
    implement slicing, dicing, and merging operations on petl data tables
    use the aggregate function to calculate aggregate statistics for a field in a table
    perform SQL like equi-joins on petl data tables
    perform insert and delete operations
    create SQL indexes on tables
    add a foreign key constraint between tables
    retrieve information about a remote resource using a HEAD request
    implement split operations on data stored within petl tables
    use the facet petl function to define filters on specific fields in a table
    recognize the messages conveyed in the different status codes sent in an HTTP response
    download a set of files sequentially using HTTPX
    implement specialized types of joins such as anti joins and cross joins
    drop a table, recreate it, and insert rows into it
    execute alter operations to add constraints and indices to tables
    analyze the common and distinct values in two tables using various petl functions
    insert and edit rows and columns in petl data tables
    perform joins based on overlapping intervals rather than absolute values
    automate operations using triggers
    install SQLAlchemy and connect to MySQL
    use slicing, dicing, and merging operations on petl data tables
    use an httpx.Cookies instance to send a collection of properties to a remote server
    submit HTTP GET requests with one or more parameters using HTTPX
    make use of the rowreduce() function to reduce rows and compute aggregate statistics
    calculate aggregate statistics for a field in a table using the aggregate function

IN THIS COURSE

  • Playable
    1. 
    Dynamic Data Handling with Python
    33s
    UP NEXT

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.