Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Database Programming with Python
Rating: 4.3 out of 5(312 ratings)
1,558 students
Created byZak Ruvalcaba
Last updated 10/2018
English

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

Course content

5 sections • 74 lectures • 8h 21m total length

  • Introduction4:51
  • The Importance of Data3:53
  • Introduction to Python3:14
  • What can I do with Python?6:54
  • Introduction to Databases9:34
  • Database and RDBMS Options6:55
  • SQLite and SQLite Studio3:46
  • MySQL and PhpMyAdmin12:03
  • SQL Server and Management Studio7:43
  • ODBC, DB API, and pyodbc4:20
  • Installing the Tools for this Course1:58
  • Installing Python4:01
  • Installing Eclipse5:55
  • Installing PyDev4:56
  • Installing the pyodbc Module1:28
  • Installing the MySQL Driver3:11
  • Installing the Microsoft ODBC Driver1:25

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.

Report abuse