•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.
•The Importance of Data
•What can I do with Python?
•Database and RDBMS Options
•SQLite and SQLite Studio
•MySQL and PhpMyAdmin
•SQL Server and Management Studio
•ODBC, DB API, and pyodbc
•Installing the Tools for this Course
•Installing Python
•Installing Eclipse
•Installing PyDev
•Installing the pyodbc Module
•Installing the MySQL Driver
•Installing the Microsoft ODBC Driver
•Creating Databases and Tables
•Planning and Designing a Database
•Tables, Records, and Columns
•Assigning Data Types
•Normalization
•Keys and Relationships
•An Overview of the Vecta Corp. Help Desk Database Structure
•The Employees Table
•The Roles Table
•The Tickets Table
•The Solutions Table
•The Status Table
•Lab 1a: Creating the Database and Tables in SQLite
•Lab 1b: Creating the Database and Tables in SQL Server
•Lab 1c: Creating the Database and Tables in MySQL
•Lab 2a: Establishing the Relationships in SQLite
•Lab 2b: Establishing the Relationships in SQL Server
•Lab 2c: Establishing the Relationships in MySQL
•Lab 3a: Manually Adding Data to the Tables in SQLite
•Lab 3b: Manually Adding Data to the Tables in SQL Server
•Lab 3c: Manually Adding Data to the Tables in MySQL
•The SELECT Command
•Filtering and Ordering Data with Clauses
•Operators for Advanced Querying
•The INSERT INTO Command
•The UPDATE Command
•The DELETE Command
•SQL Expressions and Aliases
•Common SQL Functions
•Joining Related Tables
•Python and Relational Databases
•Lecture Introduction
•Setting Up and Importing the Required Modules
•Connecting to a SQLite Database
•Connecting to a MySQL Database
•Connecting to a SQL Server Database
•How to Execute SELECT Statements
•How to Get the Rows in a Result Set
•How to Get Data from a Database View
•How to Insert Data into a Database
•How to Update Data in a Database
•How to Delete Data from a Database
•How to Handle Database Exceptions
•Project
•Setting Up the Administrative Dashboard
•Creating the Database Layer
•Creating the Object Layer
•Creating the User Interface (UI) Layer
•Lab 1: On Your Own! Displaying the User Role
•Lab 2: On Your Own! Logging In the Admin
•Setting Up the Help Desk Dashboard
•Lab 3: On Your Own! Getting Employees When Adding Tickets
•Introduction to Python, Databases, and Tools
•Introduction to Python
•Introduction to Databases
•Introduction to SQL
•