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.
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
17 Lectures
22 Lectures
11 Lectures
12 Lectures
12 Lectures
My name is Zak Ruvalcaba and I have been researching, designing, and developing for the Web since 1995. I specialize in web and mobile web site and application development focusing on responsive user interface design, user experience, and usable presentation. I hold a Bachelor's degree from San Diego State University and a Master of Science in Instructional Technology from National...
nice
The course material was somewhat helpful, but it seems like the instructor was thinking-through the code as he was typing onto the screen ... thinking twice about something, deleting a line, re-working it, etc. Granted, that is what real-world coding is like, but I expect an instructor to have planned out a lecture before delivering it. And making a typing error is expected, but it seems like he can't type two consecutive words without having to fix it.
This course was a good match for me because I was completely new to Python, Eclipse, and SQLite.
Too slow and too basic. The lecturer is just reading the text on the slides, couple of times making a comment besides the text. If it is about programming I should learn about programming and not about what a database is. I am at lecture 22 and still nothing about coding. Nothing about sql, just learning what a column and what a row is.... that should be in a course of databases not coding databases, even if it is beginner one.
Be warned - if you have mac, you need to find your way around, he talks only windows and nothing about other operating systems.
The resources are just powerpoint files no text files or code yet.
Even with an increased speed on video I find it boring and slow.
Last but not least, received a standard welcome message which I followed up with a question, and no luck with getting an answer.
Excellent!
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.
good
A little slow but that is because it is through and covers everything in great detail. Good for anyone new to the information.
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.
Your email address will not be published. Required fields are marked *
Pratik H.
good