Python Beginners Course, 1-Day

Description

This course covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom.
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: 1 Day, 10am-5pm
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 is the Easiest Programming Language to Learn Anybody can learn how to use it and entry-level coders get access to the industry in a fast-tacked manner and can from there migrate to other languages.
Learning to code is now more important than ever, since a growing number of application and
digital products require programmers.
Additionally, as an interpreted coding language, Python allows you to run each line of code
after writing it, rather than other compiled languages, such as C++.
This is particularly useful for beginners, as they can test their work and gain instant feedback,
to make amendments where required and continuously improve. A Python Course will explain to you how to do this

Python is a Versatile Coding Language
Use it for :
Data mining , Data analytics , Data visualisation , AI and machine learning, Building apps , Web development and web application development , Developing games, Quantitative and qualitative analysis, Data Engineering, A Python Course is the start of all of the above.

Learning Python will Improve Your Job Prospects
As the fastest-growing computer programming language in the world, Python is also one of the most in-demand jobs. According to 2022 LinkedIn data, Python is the second most in-demand programming language, after Java. All of this makes a Python Course essential.