This course will introduce students to the basics of structured query language (SQL), as well as basic database design for storing data as part of a collection effort, multi-step data processing and analysis.
The course will use SQLite3 as the database. We will also create web crawlers and multi-step data collection and display processes. We will use the D3.js library for basic data visualization.
This course will cover the chapters 14-15 of the book “Python for everyone”. To be successful in this course, must be familiar with the material covered in Chapters 1-13 of the textbook and the first three courses of this specialization. This course covers Python 3.
Object-oriented Python: for
start this class, We cover the basics of Object Oriented Python.
We will not write our own objects, but since many of the things we use, as BeautifulSoup, chains, dictionaries, database connections, all use object-oriented patterns (OO), we should at least understand some of its patterns and terminology.
Basic structured query language:
we learn the four main operations of CRUD (create, read, update and delete) to manage the data stored in a database.
Data models and relational SQL: in
this section we learn how data is stored in various tables in a database and how the rows are linked (that is to say, we establish relationships) in the database.
Many-to-many relationships in SQL
-In this section we explore how to model situations such as students enrolling in courses where each course has many students and each student is enrolled in many courses..
Databases and visualization: in
this section, we put it all together, we retrieve and process some data and then use the Google Maps API to visualize our data.
To be able to access the course for free you must select the option “AUDIT COURSE“, in this way you will be able to see its content without having to pay, although if you want a certificate of completion it will be necessary to pay the subscription.