Python Programming Beginners 1-Day Course, Birmingham

The Python basics course is fully customisable
This course covers the essential Python Basics, in our interactive, instructor led Live Virtual online, instructor-led .
This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language.
These concepts are daily used by programmers and is your first step to working as a programmer.
By the end, you’ll be comfortable in programming Python code.
You will have done small projects.
This will serve for you as examples and samples that you can use to build larger projects.
Location: Instructor-led, Online.
Our Style: Hands-on, Practical Course.
Group Size: Max 4 people per group.
Qualification: PCWorkshops Beginners Certification
Hours: Negotiate your time and date
Download: anaconda.com

Session 1: Basics
Python Data Types and Variables: Working with variables and its scope; Conversion and casting types in Python.
Operators and Expressions.
Decision Making: If statement; If - else statement; If- elif - else statement; Nested if - else.
Using Loops: The while, while-else. For loop; Jump statements: break, continue; Nesting loops.

Session 2: Data Structures
Lists.
Tuples.
Sets.
Dictionary. Nested Dictionary.
Json Files.

Session 3: Python Built-in functions
Strings Functions.
Maths Functions.
Random Functions.
Python Date functions.

Session 4: OOP: Using Modules, functions, classes
Creating and using custom Functions.
Using parameters and return values.
Introduction to Classes and Objects:
Creating a Class. Creating and using Objects.
Class Constructors.
Inheritance. Overload.

Session 5: Access SQL Database Via Python
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.


Session 6: 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.
Dataframe basics:
Slicing Dataframes, Querying, filter and sort a dataframe,
Working with duplicates and null-values, Sampling, Group by, Join.

• Python Beginners Certificate on completion
• Python Beginners Notes
• Python Code Examples
• Practical Python Beginners exercises