uCertify

Python Programming

(CTU-CD110.AJ1) / ISBN : 978-1-64459-828-3
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Instructor-Led (Add-on)
Get A Free Trial

Skills You’ll Get

Get the support you need. Enroll in our Instructor-Led Course.

Download Course Outline

1

Python Fundamentals

  • Introduction
  • Working with the Python Interactive Shell
  • Writing and Running Simple Scripts
  • Variables
  • User Input, Comments, and Indentations
  • Numerical Data
  • Strings
  • Lists
2

Python Conditional and Loop structures

  • Booleans
  • Control Statements
  • The if Statement
  • The while Statement
  • while Versus if
  • Loops
  • The for Loop
  • The range Function
  • Nesting Loops
  • Breaking Out of Loops
3

Functions in Python

  • Introduction to Functions
  • Built-In Functions
  • User-Defined Functions
  • Function Arguments
  • Anonymous Functions
  • Introduction to Dictionaries and Sets
  • Working with Dictionaries
  • Additional Dictionary Attributes
  • Ordered Dictionaries
  • The Basics of Sets
  • Set Operations
  • Frozen Sets
4

Python Object Oriented Programming

  • Introduction
  • A First Look at OOP
  • OOP in Python
  • Methods in a Class
  • Class Versus Instance Attributes
  • Class Versus Instance Methods
  • Class Inheritance
  • Multiple Inheritance
5

MySQL

  • Introducing databases
  • Exploring MySQL
  • Exercise 1.01: Organizing data in a relational format
  • Exploring MySQL architecture
  • Storage engines (InnoDB and MyRocks)
  • Data modeling
  • Normalization
  • Activity 1.01: Creating an optimized table for an employee project
  • Developing databases
  • The MySQL Workbench GUI
  • Creating a database
  • Using Workbench to add a table
  • MySQL table indexes and foreign keys
  • Activity 2.01 – modifying the EER diagram, the model, and the database
  • An introduction to working with databases using SQL
  • Working with data
  • Backing up databases
  • Restoring databases
  • Creating a new database
  • Creating and modifying tables
  • SQL queries to create indexes and foreign keys
  • Activity 3.1 – creating a table with indexes and foreign keys
  • Altering table queries
  • Adding data to a table
  • Updating data in a record
  • Deleting data from tables
  • An introduction to querying data
  • Querying tables in MySQL
  • Exercise 4.01 – working with simple queries
  • Accessing MySQL from Python
6

Flask

  • Introduction
  • Understanding API
  • RESTful API
  • HTTP Protocol
  • HTTP Methods and CRUD
  • The JSON Format
  • HTTP Status Codes
  • Open API
  • The Flask Web Framework
  • Building a Simple Recipe Management Application
  • Using curl or httpie to Test All the Endpoints
  • Postman

1

Python Fundamentals

  • Using the print Method
  • Displaying a Statement Multiple Times
  • Using Variable Assignment
  • Using Variables and Assigning Statements
  • Displaying the Multiplication Table
  • Using Arithmetic Operators
  • Performing String Slicing Tasks
  • Working with Strings
  • Manipulating Strings Using the strip Method
  • Working with Lists
2

Python Conditional and Loop structures

  • Using Boolean Operators
  • Working with the if Statement
  • Working with the while Statement
  • Using the for Loop and the range Function
  • Using Nested Loops
3

Functions in Python

  • Working with Function Arguments
  • Using Lambda Functions
  • Arranging and Presenting Data Using Dictionaries
  • Combining Dictionaries
  • Creating Intersections of Elements in a Collection
4

Python Object Oriented Programming

  • Defining Methods in a Class
  • Creating Class Attributes
  • Creating Class Methods and Using Information Hiding
  • Overriding Methods
  • Implementing Multiple Inheritance
5

MySQL

  • Creating a Database using MySQL Workbench
  • Creating a Table Using MySQL Workbench
  • Creating an Index
  • Creating a Foreign Key
  • Modifying an Existing Table
  • Adding a Record
  • Updating a Record
  • Deleting Data from a Table
6

Flask

  • Building a Flask Application Using PyCharm
  • Managing Recipes with Flask

Related Courses

All Courses