Python Beginners Course. Come join us, learn to code, and upgrade your career prospects.

The Python basics course is fully customisable on request.

For more information: https://pcworkshopslondon.co.uk (https://pcworkshopslondon.co.uk)

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

Python Beginners Course, Course Outline.

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.Included:

Python Beginners Certificate on completion

Python Beginners Notes

Python Code Examples

Practical Python Beginners exercises

For more information: https://pcworkshopslondon.co.uk (https://pcworkshopslondon.co.uk) #python #pcworkshops #pythonprogramming #pcw

Description supplied by the event organiser.