Python 3 Complete Masterclass – Make Your Job Tasks Easier!

Python 3 Complete Masterclass – Make Your Job Tasks Easier!
Python 3 Complete Masterclass – Make Your Job Tasks Easier!
English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 15 Hours | 6.99 GB

Learn Python 100% hands-on. Exercises, quizzes, notebooks, cheat sheet and e-book included. New free content each month!

What’s this course all about?

Python 3 programming course aimed at anyone having little or no experience in coding and a great desire to start learning Python from scratch. This hands-on training takes you from “Hello World!” to advanced Python topics in just a few hours.

First, you will learn and practice every Python 3 key concept, which is explained in one or more video lectures, usually followed by a short quiz and several exercises.

Each video is filled with relevant examples, created in a learn-by-doing fashion and the quizzes, coding exercises and assignments will help you consolidate the main ideas behind each Python 3 topic.

After laying the foundation, you will start exploring some advanced Python 3 topics, thus quickly growing your skills from Zero to Beginner to Intermediate to Advanced to Superhero level.

Next, we will build a scientific calculator in Python 3, having a basic user menu and both simple and advanced math operations available: addition, subtraction, multiplication, division, modulo, raising to a power, square root, logarithm, as well as trigonometric functions like sin, cos and tan.

Finally, you will gain some real-life skills that you can use at most programming and IT-related jobs: Excel Automation, Database Automation, Data Analysis Automation, Test Automation, Web Scraping and Network Automation, among others, using Python 3.

You will also be able to download printable cheat sheets to have every Python 3 concept at hand whenever you need it, as well as a 200+ pages Python 3 e-book that can help you continue studying whenever you don’t feel like watching videos or solving coding exercises. What more can you ask for?

As a final bonus, you will also get all the Python 2 content in my older course, so you will be able to interact with systems still running the legacy “edition” of Python, which have not yet migrated to the latest version. It never hurts to be fluent in both versions of this amazingly popular programming language, although Python 3 is the most relevant version today.

This course is the first one in a trilogy especially designed for learning Python 3 from scratch and then using your skills and knowledge to solve 250 multiple-choice quizzes (course 2, live: ‘Python 3 Workout – Solve 250 Multiple-Choice Quizzes!’) and 250 coding exercises (course 3, in progress: ‘Python 3 Workout – Solve 250 Coding Exercises!’), respectively. So, check out these courses as well, for a complete and comprehensive learning experience.

What you’ll learn

  • You will GAIN CONFIDENCE when asking your manager for a RAISE or going to any Junior or Intermediate Python Developer INTERVIEW.
  • You will ultimately GAIN REAL-LIFE SKILLS: Excel Automation, Database Automation, Data Analysis and Visualization, Network Automation. No silly little games, no useless apps, no filler content!
  • You will MASTER all the Python 3 key concepts starting FROM SCRATCH. No prior Python knowledge is required.
  • You will get FREE NEW VIDEO LECTURES and RESOURCES ONCE A MONTH and learn the latest Python 3 concepts and use cases.
  • You will have MY FULL SUPPORT for every course-related question or suggestion, plus the help of the community.
  • You will have LIFETIME ACCESS TO COURSE UPDATES and new content, anytime, anywhere, on any device.
  • You will be able to apply for and get involved in most Python 3 PROJECTS.
  • You will be able to work with the Python interpreter and Python scripts.
  • You will be able to work with Python strings and string methods.
  • You will be able to work with Python lists, list methods and ranges.
  • You will be able to work with Python sets, set methods and frozensets.
  • You will be able to work with Python tuples and tuple methods.
  • You will be able to work with Python dictionaries and dictionary methods.
  • You will be able to work with Python control flow structures (if, for, while, break, continue, pass, exceptions, try-except-else-finally blocks).
  • You will learn everything about properly handling syntax errors and exceptions in Python 3.
  • You will be able to work with Python functions, namespaces and modules.
  • You will be able to work with Python file operations: create, read, write, append, truncate, close.
  • You will be able to work with Python patterns and regular expressions.
  • You will be able to work with Python classes, objects and inheritance.
  • You will be able to work with advanced Python tools (comprehensions, lambda functions, threading basics, iterators, generators, decorators).
  • You will be able to apply the Python 3 knowledge you get from this course in quizzes, coding exercises and real-life scenarios.
  • You will build a scientific, interactive calculator with a user menu and advanced math operations available.
  • You will be able to work with Microsoft Excel files and automate boring spreadsheet-related tasks using Python 3.
  • You will be able to work with PostgreSQL databases and automate boring database-related tasks using Python 3.
  • You will be able to work with network devices (switches/routers) and automate networking tasks using SSH.
  • You will be able to work with Pandas to perform data analysis operations on TXT, CSV, JSON, XLSX, HTML files and SQL databases.
  • You will be able to work with Bokeh to perform data visualization and generate line / bar / pie / range / stocks / candlesticks charts.
  • You will be able to work with Pytest to perform unit test automation, also learning advanced concepts like fixture functions or markers.
  • You will be able work with Requests, Pandas and BeautifulSoup to get, load and parse webpage content, perform web scraping tasks and build an Excel database.
  • You will get a Python 3 CHEAT SHEET filled with key concepts and examples.
  • You will get a Python 3 200+ PAGES E-BOOK for free, to keep learning offline.
  • You will learn 10 ways to earn money and build a portfolio with your Python skills.
Table of Contents

Introduction – What’s This Course All About?
1 What Will You Learn? What Benefits You Get From Taking This Course?
2 Upcoming Free Updates – More value for the price you already paid!
3 Quick Introductory Note
4 Watching the Course at the Best Resolution Possible
5 Join the PRIVATE DISCORD COMMUNITY!
6 FAQ – Check This First If You Run Into Any Issues

ZERO LEVEL: Python 3 – Basics
7 How to Install Python 3 on Windows
8 How to Install Python 3 on macOS
9 The Python Interpreter & IDLE in Windows
10 The Python Interpreter & IDLE in macOS
11 Python 3 Basics – Scripts in Windows
12 Python 3 Basics – Scripts in macOS
13 Coding Exercise Solution
14 Python 3 Basics – User Input
15 Notebook – User Input
16 Python 3 Basics – Variables
17 Notebook – Variables
18 Coding Exercise Solution
19 Python 3 Basics – Keywords
20 Python 3 – Data Types

BEGINNER LEVEL: Python 3 – Strings
21 Why learn about each of Python’s data types?
22 Python 3 Strings – Introduction
23 Python 3 Strings – Methods
24 Python 3 Strings – Operators & Formatting
25 Python 3 Strings – Formatting Using F-strings
26 Python 3 Strings – Slices
27 Python 3 Strings – Slicing Using a Step
28 Notebook – Strings
29 Coding Exercise Solution
30 Coding Exercise Solution
31 Coding Exercise Solution
32 Coding Exercise Solution

BEGINNER LEVEL: Python 3 – Numbers and Booleans
33 Python 3 Numbers – Math Operators
34 Notebook – Numbers and Math Operators
35 Coding Exercise Solution
36 Python 3 Booleans – Logical Operators
37 Notebook – Booleans and Logical Operators
38 Coding Exercise Solution
39 Coding Exercise Solution

BEGINNER LEVEL: Python 3 – Lists
40 Python 3 Lists – Introduction
41 Python 3 Lists – Methods
42 Python 3 Lists – Slices
43 Notebook – Lists
44 Coding Exercise Solution
45 Coding Exercise Solution
46 Coding Exercise Solution
47 Coding Exercise Solution

BEGINNER LEVEL: Python 3 – Sets
48 Python 3 Sets – Introduction
49 Python 3 Sets – Methods
50 Python 3 Sets – Frozensets
51 Notebook – Sets and Frozensets
52 Coding Exercise Solution
53 Coding Exercise Solution
54 Coding Exercise Solution
55 Coding Exercise Solution

BEGINNER LEVEL: Python 3 – Tuples
56 Python 3 Tuples – Introduction
57 Python 3 Tuples – Methods
58 Notebook – Tuples
59 Coding Exercise – Extract an Element From a Tuple (Positive Indexes)
60 Coding Exercise Solution
61 Coding Exercise Solution
62 Coding Exercise Solution
63 Coding Exercise Solution

BEGINNER LEVEL: Python 3 – Ranges
64 Python 3 Ranges – Introduction
65 Python 3 Ranges – Methods
66 Notebook – Ranges
67 Coding Exercise Solution
68 Coding Exercise Solution
69 Coding Exercise Solution
70 Coding Exercise Solution

BEGINNER LEVEL: Python 3 – Dictionaries
71 Python 3 Dictionaries – Introduction
72 Python 3 Dictionaries – Methods
73 Python 3 Dictionaries – Updates in v3.6 and v3.7
74 Python 3 – Conversions Between Data Types
75 Notebook – Dictionaries and Conversions Between Data Types
76 Coding Exercise Solution
77 Coding Exercise Solution
78 Coding Exercise Solution
79 Coding Exercise Solution

INTERMEDIATE LEVEL: Python 3 – Conditionals, Loops and Exceptions
80 Python 3 Conditionals – If / Elif / Else
81 Notebook – If / Elif / Else Conditionals
82 Python 3 Loops – For / For-Else
83 Notebook – For / For-Else Loops
84 Python 3 Loops – While / While-Else
85 Notebook – While / While-Else Loops
86 Python 3 Nesting – If / For / While
87 Notebook – Nesting
88 Python 3 – Break / Continue / Pass
89 Notebook – Break / Continue / Pass
90 Python 3 – Exceptions
91 Python 3 – Try / Except / Else / Finally
92 Notebook – Try / Except / Else / Finally
93 Coding Exercise Solution
94 Coding Exercise Solution
95 Coding Exercise Solution

INTERMEDIATE LEVEL: Python 3 – Handling Errors and Exceptions in Python
96 Python 3 – Fixing Syntax Errors
97 Python 3 – Fixing Exceptions

INTERMEDIATE LEVEL: Python 3 – Functions and Modules
98 Python 3 Functions – Basics
99 Python 3 Functions – Arguments
100 Notebook – Functions – Basics
101 Python 3 Functions – Namespaces
102 Python 3 Modules – Importing
103 Python 3 Modules – Helpful Functions: dir() and help()
104 Notebook – Modules and Importing
105 Python 3 Modules – Installing a Non-Default Module in Windows
106 Python 3 Modules – Installing a Non-Default Module in macOS
107 Coding Exercise Solution
108 Coding Exercise Solution
109 Coding Exercise Solution

INTERMEDIATE LEVEL: Python 3 – File Operations
110 Python 3 Files – Opening & Reading
111 Python 3 Files – Quick Note for Windows Users
112 Python 3 Files – Writing & Appending
113 Python 3 Files – Closing. The “with” Method
114 Python 3 Files – Deleting File Contents
115 Python 3 Files – Access Modes Summary
116 Notebook – File Operations
117 Coding Exercise Solution
118 Coding Exercise Solution
119 Coding Exercise Solution

ADVANCED LEVEL: Python 3 – Regular Expressions
120 Python 3 Regex – match() & search()
121 Python 3 Regex – findall() & sub()
122 Python 3 Regex – Regular Expressions Summary
123 Notebook – Regular Expressions
124 Coding Exercise Solution
125 Coding Exercise Solution
126 Coding Exercise Solution

ADVANCED LEVEL: Python 3 – Classes and Objects
127 Python 3 Classes – Objects
128 Python 3 Classes – Inheritance
129 Notebook – Classes and Objects
130 Coding Exercise Solution
131 Coding Exercise Solution
132 Coding Exercise Solution

ADVANCED LEVEL: Python 3 – Other Advanced Concepts
133 Python 3 – List / Set / Dictionary Comprehensions
134 Notebook – List / Set / Dictionary Comprehensions
135 Coding Exercise Solution
136 Python 3 – Lambda Functions
137 Notebook – Lambda Functions
138 Coding Exercise Solution
139 Python 3 – map() and filter()
140 Notebook – map() and filter()
141 Coding Exercise Solution
142 Python 3 – Iterators and Generators
143 Notebook – Iterators and Generators
144 Coding Exercise Solution
145 Python 3 – Itertools
146 Notebook – Itertools
147 Coding Exercise Solution
148 Python 3 – Decorators
149 Notebook – Decorators
150 Coding Exercise Solution
151 Python 3 – Threading Basics
152 Notebook – Threading Basics
153 Python 3 – Coding Best Practices
154 You’re Halfway There!

GENERAL RECAP: Python 3 – Cheat Sheet and 200+ Pages E-Book
155 Python 3 – Cheat Sheet
156 Python 3 – 200+ Pages E-book

PROJECT – APPLICATION: Build a Scientific Calculator with Python 3
157 Planning the Application
158 Designing and Building the User Menu
159 Implementing Addition, Subtraction, Multiplication, Division
160 Implementing Modulo, Raising to a Power, Square Root, Logarithm
161 Implementing Trigonometric Functions: sin, cos, tan
162 Testing Each Function of the Application
163 Download the Code – Interactive Scientific Calculator
164 Creating Executable Files (.exe) from Python Scripts (.py)

SUPERHERO LEVEL: Automate Excel Tasks with Python 3
165 Setting Up the Working Environment
166 Loading an Excel Workbook In Python and Creating/Removing Sheets
167 Notebook – Handling Workbooks
168 Getting General Information About a Sheet
169 Notebook – Sheet Information
170 Working with Sheet Cells Using Python
171 Notebook – Cell Information
172 Working with Cell Styles Using Python
173 Notebook – Cell Styles
174 Download the Excel-Python Cheat Sheet
175 APPLICATION – Migrating Records from a Text File to an Excel Workbook
176 Download the Code – Excel Application

SUPERHERO LEVEL: Automate Database Tasks with Python 3
177 Installing the Database Server Software
178 Downloading and Installing PostgreSQL on Windows, Linux, macOS
179 Installing the Necessary Python Module
180 Creating a New Database, Schema and User
181 Notebook – Creating a New Database, Schema and User
182 Connecting Python to the Database
183 Notebook – Connecting Python to the Database
184 Creating Database Tables with Python
185 Notebook – Creating Database Tables with Python
186 Inserting Records Into a Table with Python
187 Notebook – Inserting Records Into a Table with Python
188 Updating Records Into a Table with Python
189 Notebook – Updating Records Into a Table with Python
190 Deleting Records From a Table with Python
191 Notebook – Deleting Records From a Table with Python
192 Querying the Database with Python
193 Notebook – Querying the Database with Python
194 Fetching Information From the Database with Python
195 Notebook – Fetching Information From the Database with Python
196 Committing and Rolling Back Transactions with Python
197 Notebook – Committing and Rolling Back Transactions
198 Download the PostgreSQL Syntax Cheat Sheet
199 Download the PostgreSQL-Python Cheat Sheet
200 APPLICATION – Migrating Records from a Text File to the Database
201 Download the Code – Database Application

SUPERHERO LEVEL: Automate Network Tasks with Python 3
202 Network Setup Overview
203 Installing the Virtualization Software
204 Installing the Virtualization Software on Windows, Linux, macOS
205 Downloading & Installing the Network Device VM
206 Signing Up to the Arista Software Download Portal
207 Importing the VM & Tweaking the VM Settings
208 Connecting the Local PC to the Devices in Windows
209 Connecting the Local PC to the Devices in macOS
210 Checking the SSH Configuration and Testing the Connectivity
211 Necessary Switch/Router Configuration
212 Any Connection Issues? Check Out This Troubleshooting Checklist!
213 Planning the Application
214 Checking IP File Validity
215 Notebook – Checking IP File Validity
216 Checking IP Address Validity
217 Notebook – Checking IP Address Validity
218 Checking IP Address Reachability
219 Notebook – Checking IP Address Reachability
220 Note about pinging in Windows vs. Mac OS / Linux
221 Checking Username/Password File Validity
222 Notebook – Checking Username/Password File Validity
223 Checking Command File Validity
224 Notebook – Checking Command File Validity
225 Establishing the SSH Connection
226 Notebook – Establishing the SSH Connection
227 Enabling Simultaneous SSH Connections
228 Notebook – Enabling Simultaneous SSH Connections
229 APPLICATION – Putting Everything Together
230 Download the Code – Network Application and Modules
231 Reading Device Configuration
232 Extracting Network Parameters
233 Configuring Multiple Devices Simultaneously

SUPERHERO LEVEL: Automate Data Analysis Tasks with Python 3
234 Running Python Code – The Next Level: IPython and Jupyter Notebook
235 Notebook – IPython and Jupyter Notebook
236 Introduction to Pandas – Basic Operations
237 Notebook – Introduction to Pandas
238 Handling Files with Pandas – TXT, CSV, JSON, XLSX
239 Notebook – Handling TXT, CSV, JSON, XLSX Files with Pandas
240 Reading HTML Content from URLs and HTML Files with Pandas
241 Notebook – Reading HTML Content with Pandas
242 Indexing and Slicing Tables with Pandas
243 Notebook – Indexing and Slicing Tables with Pandas
244 Adding, Updating, Deleting Table Rows and Columns
245 Notebook – Adding, Updating, Deleting Table Rows and Columns
246 APPLICATION – Reading and Writing Data in PostgreSQL Databases Using Pandas
247 Download the Code – SQL Data Analysis Application

SUPERHERO LEVEL: Data Visualization with Bokeh and Python 3
248 Introduction to Bokeh
249 Bookmark These 3 Important Documentation Links
250 Creating a Basic Line Plot Based on Python Lists
251 Notebook – Creating a Basic Line Plot Based on Python Lists
252 Creating a Bar Plot Based on Excel Data
253 Notebook – Creating a Bar Plot Based on Excel Data
254 Creating a Pie Chart Based on CSV Data
255 Notebook – Creating a Pie Chart Based on CSV Data
256 Plotting Multiple Stock Prices Simultaneously
257 Notebook – Plotting Multiple Stock Prices Simultaneously
258 Plotting Bitcoin Prices as an Interactive Plot with a Range Tool
259 Notebook – Plotting Bitcoin Prices as an Interactive Plot with a Range Tool
260 Plotting Bitcoin Prices as an Interactive Plot with Candlesticks
261 Notebook – Plotting Bitcoin Prices as an Interactive Plot with Candlesticks

SUPERHERO LEVEL: Automate Unit Testing with Python 3
262 Installing pytest and Writing Your First Test
263 Notebook – Introduction to pytest
264 Running Multiple Tests. Test Discovery Rules in Action
265 Notebook – Running Multiple Tests
266 Testing a Basic Script – Preparing the Test Bed
267 Download the Code for Testing
268 Fixture Functions
269 Notebook – Fixture Functions
270 Sharing a Fixture Instance & Fixture Finalization
271 Notebook – Sharing a Fixture Instance & Fixture Finalization
272 Parametrizing Fixtures
273 Notebook – Parametrizing Fixtures
274 Marking Test Functions Using Attributes
275 Notebook – Marking Test Functions Using Attributes
276 Marking Test Functions Using Custom Markers
277 Notebook – Marking Test Functions Using Custom Markers

SUPERHERO LEVEL: Automate Web Scraping with Python 3
278 Installing the Necessary Modules
279 Notebook – Installing the Necessary Modules
280 Extracting and Parsing Web Content
281 Notebook – Extracting and Parsing Web Content
282 Tags, Names and Attributes
283 Notebook – Tags, Names and Attributes
284 Searching the Tree of HTML Tags: find() and find_all()
285 Notebook – Searching the Tree of HTML Tags: find() and find_all()
286 APPLICATION – Extracting the Product Names, Links and Prices. Saving to Excel
287 Download the Code – Scraping Web Data and Saving to Excel
288 APPLICATION – Handling Website Pagination When Extracting Data
289 Download the Code – Handling Website Pagination When Extracting Data

Useful Python Modules and Tools
290 Comparing File Contents (difflib)
291 Notebook – Comparing File Contents (difflib)
292 Argument Passing with sys.argv
293 Notebook – Argument Passing with sys.argv

10 Ways to Earn Money and Build a Portfolio with Your Python Skills
294 Putting Your Skills to Work – Part 1
295 Putting Your Skills to Work – Part 2
296 Download the Presentation

Final Section
297 Closing Thoughts
298 How to Get Your Certificate of Course Completion

Course Bonuses
299 Bonus Lecture – Free Python 2 Training, Discounts, Social Media