Database Programming with Python

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.

What You Will 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

Who Should Attend!

• 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.

TAKE THIS COURSE