Vind een opleiding

Python & Excel: Easily migrate spreadsheets to a database - Udemy

Doelgroep: Beginner
Duur: 18 colleges - 1 uur
Richtprijs: € 34,99
Taal: Engels
Aanbieder: Udemy

>> proefles

Welcome! Learn to use Python for migrating your excel files in almost any format to a relational database.

  • The first section of this course is a basic introduction to
    openpyxl: the ideas behind reading and writing data from and to Excel.
  • In the second section we will see how to read from multiple Excel
    documents and save them to a database. The database could be any relational database, but for this section we will use SQLite, as it's fast to setup and easy to use.
  • The third section is a more advanced case, where we will learn how to deal with a more 'messy' Excel document and with a more complex database structure using a foreign key.
  • For the next sections, I like to hear from you what you would like! :-) At the moment I'm first thinking of some other kind of databases, like MySQL and PostgreSQL. But let me know


>> Meer info