Python Programming Beginners Course, 3 Days, Online
by PCWorkshops
Location
Online event
Refund policy
No Refunds
Excellent Python Programming Beginners Course, from start to efficient in one session. Hands-on, practical.
About this event
Workshops Description
Day 1 Session 1: Python Data Types and Variables:
- Primitive types; Characters & Strings; Boolean; Working with variables and its scope; Conversion and casting types in Python.
- Operators and Expressions:
- Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators; More in operators.
Day 1 Session 2 : Decision Making & Loops
- If statement; If - else statement; If- elif - else statement; Nested if - else;
- The while
- For loop
- Jump statements: break, continue;
- Nesting loops.
Day 1 Session 3: Data Structures
- Lists.
- Tuples.
- Sets.
- Dictionary. Nested Dictionary.
- Json Files.
Day 2 Session 1: Built in Functions: String, Regex, Math, Random, Dates
- Python built-in functions:
- Using Built-in modules and functions:
- Strings functions.
- Pattern matching with Regex.
- Maths functions.
- Random Functions.
- Working with dates using Python date functions.
Day 2 Session 2: OOP
- Using Modules and functions:
- Creating and using custom Functions.
- Creating a Module in class;
- Calling a Module;
- Using parameters;
- Returning value from a Module.
- Introduction to Classes and Objects:
- Creating a Class; Creating an Object; Using an Object; Adding Instance variables; Controlling accessibility; Naming conventions for class members. Inner Classes.
- Class Constructors; Parameterized Constructors.
- Inheritance. Overload.
Day 3 Session 1:
- Exception Handling, Exception types; Using try and Except.
- Files, streams: Open, Traverse, Read and Create Files: Csv, txt and Json Files.
- API: Connecting to API’s.
Day 3 Session 2: Databases
- Connection details: Connect to a database using access codes.
- Select Queries: Retrieving records and iterating results sets, using variables and parameters in queries.
- Working with DDL comands: Create a database, drop a database. Create a table, alter tables, drop a table.
- Working with DML Commands: Insert, delete, update records, query a database and display results.
Day 3 Session 3: Pandas Dataframe Basics
- Getting data into a dataframe: Dict to Dataframe, Dataframe to Dict. Excel To Dict, Dict to Excel , working with Excel data, multiple Excel sheets.
- Slicing Dataframes,
- Getting information about the dataframe,
- Filter, sort and query a Dataframes,
- Duplicate values,
- Working with null-values,
- Sampling,
- Group by,
- Join.
Dataframe basics:
This is only covering an introduction to Dataframes, more is covered in the data anlytics course.
Included:
- PCWorkshops's Python Programming Basics Certification
- Course notes, exercises and code examples
- Revision session after the course