Database Programming with Python udemy course free download
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
Requirements::
- You should be able to use a PC at a beginner level
- Have access to an Internet connection to download necessary software applications
- Exercise files and support PowerPoint presentations are provided as additional resources at the beginning of each lecture.
Description:
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.
Who this course is for:
- Beginner to intermediate Python developers curious about integrating databases into their workflows.
- This course is not intended for experienced Python developers already familiar with relational and object-oriented database development with Python.
Course Details:
-
8.5 hours on-demand video
-
6 downloadable resources
-
Full lifetime access
-
Access on mobile and TV
-
Certificate of completion