Exporting Data | Cave of Programming

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Learn Perl 5 By Doing It

Basic Perl: Getting Started

Installing Perl and Some Great Free Editors (11:56)
Hello World (6:19)
Downloading Text and Videos: Updated Version 2023 (14:26)
Downloading Text and Images With Perl (Old version!) (14:05)
Arrays and Checking Whether Files Exist (15:03)
Reading Files and Beginning Regular Expressions (17:25)
Writing Files and Replacing Text (20:17)
Wildcards in Regular Expressions (6:06)
Groups: Finding Out What You Actually Matched (6:58)
Quantifiers: Greedy vs. Non-Greedy (10:09)
Escape Sequences (14:42)
Numeric Quantifiers (9:26)
Test Your Perl and Regex Knowlege - First Test (25:02)

More on Reading Files Line By Line: Tips, Tricks and Vital Knowledge

Split and Reading CSV Files (10:51)
Join and Viewing Data Using Data::Dumper (7:21)
Chomp and Removing Spaces in Splits (9:28)
"Pushing" Onto Arrays (7:37)
Arrays of Arrays (16:14)
Hashes: Lookup Tables in Perl (16:22)
Iterating Over Hashes (12:48)
Arrays of Hashes (8:01)
Storing CSV Data in a Data Structure (12:37)
Validating CSV Data (11:32)
Cleaning CSV Data (17:37)
Test Your Perl and Regex Knowlege - Second Test (29:02)

Web Scraping and More Regular Expressions

Basic Web Scraping (12:36)
Character Classes (17:21)
Matching Repeatedly (17:07)
Collecting Repeated Matches All At Once (9:56)

Building a Complete Progam: Command Line Options

Getting Command Line Options (14:14)
Subroutines and Returning Values (6:46)
Multi-Line Strings and Comments (11:30)
Passing Arguments to Subroutines (11:39)
References to Hashes (12:33)
Checking Values in Hashes (13:39)

Parsing XML and Complex Data Structures

Finding All Files in a Directory and Filtering Arrays (20:34)
Processing Files One By One (10:55)
Parsing XML with Regular Expressions (22:27)
Using XML::Simple, and Extracting Data from Complex Structures (18:16)
Extracting Data from Complex Structures: A Complete Example (18:11)
Building Complex Data Structures (14:26)

Working with Databases

Free Databases to Use with Perl (9:19)
Creating Databases with MySQL (18:07)
Connecting to a Database (10:04)
Inserting Data into a Database (12:40)
Deleting Data and Executing Dataless SQL Commands (3:33)
Getting the IDs of Records You've Just Inserted (15:02)
Querying Databases (12:29)
Exporting Data (6:31)

Perl One-Liners

Running One-Line Perl Programs (7:22)
Replacing Text in Files (11:25)
Editing Files In-Place (8:39)

Modules and OO Perl

Modules (20:06)
Packages and Directories (13:15)
Object Orientation: A Brief Introduction (8:13)
Implementing OO in Perl (20:44)

Web Application Basics

Installing the Apache HTTP Server (12:17)
A Hello World Web App (10:27)
The CGI.pm Module (8:55)
Using URL Parameters (7:39)
Website Forms (20:15)

Basic Sysadmin Tasks

Moving, Copying and Deleting Files (9:43)
Executing System Commands (8:54)

Conclusion

Where to Find Documentation and More Modules (7:28)

Appendix 1: Example Data

XML Files

Appendix 2: Alternate Systems

Running Perl in UNIX, Linux, Mac and Cygwin (10:25)

Extras

Arrays and Hashes Review (6:42)
References to Hashes and Arrays Review (13:05)

Teach online with

Exporting Data

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock