CSV & Data Import
Import CSV files into a database safely, with validation and error reports.
What you'll learn
- Parse CSV files with headers
- Validate rows before inserting
- Report import errors
About this course
In two weeks you build an import script for customer data. You parse CSV, validate each row and report what failed.
Course curriculum
3 modules and 9 lessons over 2 weeks. Plan for about 6 learning hours.
01ParsingWeek 1 · 3 lessons
- CSV structure
- Encoding
- Headers
02ValidationWeek 1 · 3 lessons
- Required fields
- Formats
- Duplicates
03ImportWeek 2 · 3 lessons
- Batch inserts
- Error report
- Exercise set
Project
CSV importer. A script that imports customer CSV files and writes an error report.
Who this course is for
Developers who move data between spreadsheets and databases.
Prerequisites
You know basic SQL and JavaScript or Python.
What's included
- 90-day course access
- Guided lessons
- Coding exercises
- Starter files
- Solution examples
- A digital completion certificate
Learning format
Self-paced mini-course, part of our self-paced courses. Guided lessons, exercises and student support.
Access and delivery
- Digital access is activated within 15 minutes after successful payment.
- Student support replies are targeted within 2 business days.
- The completion certificate is issued within 2 business days after the final exercise is submitted.
Certificate
You receive a digital completion certificate. The completion certificate is issued within 2 business days after the final exercise is submitted.
Frequently asked questions
When does access start?
Digital access is activated within 15 minutes after successful payment.
Is payment taken on this website?
No. After you submit your enrollment request, we reply by email with payment details and enrollment confirmation.
Does this course guarantee a job or income?
No. It is an education and training service and does not include employment, income or placement guarantees.
Can I cancel?
Our Refund and Cancellation Policy lists the terms for self-paced mini-course programs.
