EN
Start unlimited
Catalog Courses Books Assets Newsletter Merch About Contact Blogs
Cart Sign in Start unlimited
Catalog / All levels / Automate Databases with Python
Mammoth Club All levels 8 sections 25 lectures

Automate Databases with Python

Build a professional backend for your data. Master database automation today.

Created by Team Mammoth
01
Skill level
All levels
02
Sections
8
03
Lectures
25
04
Instructor
Team Mammoth
What's inside

This course includes.

✓
8
Sections
✓
25
Lectures
✓
25
Resources
✓
Certificate of completion
Included
✓
Mobile and desktop access
Included
✓
AI learning assistance
Included
Unlock all courses with our Subscription Bundle! Get unlimited access to entire course library, books and assets. Learn more and subscribe today!
Course content

Curriculum & lectures.

8 sections · 25 lectures
+ 01 Work with text files 4 lectures
01 Create And Read A New Text File Locked
02 Read And Write A Text File With A Loop Locked
03 Copy Contents Of A File Locked
Full Course Source files Locked
+ 02 Work with CSV files 3 lectures
01 Print CSV Contents Locked
02 Print CSV As List Locked
03 Create A CSV File Locked
+ 03 Work with JSON files 1 lecture
01 Read And Write To A JSON File Locked
+ 04 Work with Excel files 5 lectures
01 Inspect Excel Sheets Locked
02 Merge Excel Files Locked
03 Get Value From Cell In Excel Sheet Locked
04 Display Entire Excel Sheet Contents Locked
05 Create A New Excel File With Values Locked
+ 05 Automate files with OS Module 6 lectures
01 Find A File By Name Locked
02 Check If File Or Directory Path Exists Locked
03 List All Files And Directories At A Path Locked
04 Find All Files Of Given Type Locked
05 Delete Old Files With Datetime Module Locked
06 Bulk Rename Files Locked
+ 06 Work with exceptions 2 lectures
01 Handle Exceptions Locked
02 Use Asserts Locked
+ 07 Search documents for words 2 lectures
01 Search Txt File Locked
02 Search CSV File Locked
+ 08 Format data 2 lectures
01 Format Data Into Table Locked
02 Visualize Product Sales Per Quarter Locked
Description

About this course.

Excel is not a database. Learn to move your data into SQL and NoSQL environments and manage it automatically using Python scripts.

• Automate ETL (Extract, Transform, Load) processes.

• Query databases and export results to reports.

• Sync data between your app and your database.

✔️ Lifetime access

✔️ Source files included

✔️ Human-made HD video and crystal-clear audio

Instructors

Taught by people who ship.

Team Mammoth

Team Mammoth

Instructor

Produced by a team of Mammoth Club industry experts. Over 15 years, Mammoth Club has built a global student community in 190+ countries with 9+ million courses sold, releasing over 1,000+ courses and 5,000+ hours of video content.

Ready to start building?

Build a professional backend for your data. Master database automation today.

Buy lifetime access →