Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
8 Hour(s) 21 Minute(s)
Language
English
Taught by
Zak Ruvalcaba
Rating
Course Overview
Learn how to integrate free and enterprise databases into your Python workflow including SQLite, MySQL, and SQL Server
It's not often that you get to use a language as powerful and as versatile as Python. Python is a great language for writing web applications, cross-platform desktop applications, Artificial Intelligence software, shell scripts, perform scientific computation, games, and even connect to and work with a myriad of relational and document-oriented database solutions. This course gets you up and running with using Python to program against relational and document-oriented databases such as SQLite, MySQL, SQL Server, and MongoDB. It teaches you the basic concepts of relational data, databases, tables, SQL, and walks you through the code required to connect to these databases and perform CRUD (create, retrieve, update, and delete) operations within them using Python. When you're finished with this course, you'll have a solid foundation to go out and start building your own database applications using Python.
Course Content
- 5 section(s)
- 74 lecture(s)
- Section 1 Introduction to Python, Databases, and Tools
- Section 2 Creating Databases and Tables
- Section 3 Introduction to SQL
- Section 4 Python and Relational Databases
- Section 5 Project
What You’ll Learn
- Install and configure the tools required for working with Python and databases including development tools, drivers, and modules
- Design a database within SQLite, MySQL, and SQL Server
- Normalize a database including establishing keys and relationships
- Use an RDBMS to manually add data to a database
- Use the Structured Query Language (SQL) to write create, retrieve, update, and delete (CRUD) statements
- Use Eclipse and Python to connect to a database and perform CRUD operations
- Build out a full-functioning Help Desk application using Python and SQLite
Skills covered in this course
Reviews
-
RRick Walker
Very clear compelling introduction.
-
TTodd Peterson
This course is very beginner for python. I don't need that. However I need beginner level for the database part. My biggest complaint is that the teacher basicly just reads the slides, with little other comentary.
-
JJoel Vigil
Excelente contenido. Me ha enseñado herramientas clave relacionadas con el manejo de bases de datos. Puntos de mejora muy importantes: la edición del video, tanto en el audio (muy bajo y difícil de escuchar en algunos videos) como en la imagen: resulta molesto ver borrar una y otra vez una palabra mal escrita.
-
IIsrael Oyeboade
TLDR: Great introductory course (might be boring at the beginning) but needs more engagements in terms of exercises and we don't need to see the pdf; use illustrations, diagrams, animations etc. Also needs a NoSQL & ORM section and the instructor needs to talk about the common stumbling blocks when setting up a DB. Really worth it. This is a really good introductory course for anyone who's new to databases and has fair knowledge of Python but the course instructor (while attempting to explain the fundamentals of database technology, ) spent too much time dully reading the course material. If he was reading the material in the background without showing it to the students and added a few diagrams of illustration or animations, it wouldn't have felt like a lecture. Again, I'll reiterate that this is a really good course. I suggest adding exercises to the SQL section so students can get more conversant with the queries. To add to it, I think the course should be updated with more modules like NoSQL databases like MongoDB and more importantly ORMs like SQLAlchemy. Some of the course contents need to be updated as well. I'm really grateful for having bought this course. Thank you Zac.
