
Covers installation of Python and IDE
Covers execution modes of Python
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
By the end of this lecture, you will be able to define variables and declare comments with knowledge of keywords and Python's way of treating everything as an object.
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
By the end of this lecture, you will be able to use data-types in Python with the knowledge of the best usage of datatypes according to the situation.
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
By the end of this lecture, you will be able to use operators in Python.
Arithmetic
Relational operators
Assignment operators
Logical operators
Identity operators
Membership operators
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
By the end of this lecture, you will be able to:
solve precedence-based questions & predict how Python solves algebraic problems
use the input() function
explicitly convert data types in Python
have knowledge of different errors in Python.
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
After this lecture, you will be able to traverse through a string while performing multiple string operations with knowledge of the built-in functions.
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
After this lecture, you will be able to access elements in a list, whilst performing multiple list operations & knowledge of built-in functions. You will also be able to copy lists efficiently.
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
After this lecture, you will be able to access items in a dictionary — adding & modifying existing items while performing dictionary operations with knowledge of built-in functions.
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
By the end of this lecture, you will be able to:
Use the if statement
Know the usage of operators in the if statement
Use the else statement & know it's usage
Use the elif statement & know it's usage
Examples will be covered
Code a simple calculator program.
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
By the end of this lecture, you will be able to:
Use loops & know their usage
Use for and while loops.
Examples will be covered.
Use the range() function.
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
By the end of this lecture, you will be able to:
Use the break and continue statement.
Know that loops can be nested.
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
By the end of this lecture, you'll know what to expect during coding Python with these questions and scenarios. This lecture will help you build a practice towards programming.
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
By the end of this lecture, you will be able to :
use functions & know their advantages
use the define statement
examples will be covered!
use arguments & parameters with the knowledge of default parameters
use functions with return statement
have knowledge of the flow of execution when a function is present
have knowledge of scope of variables—global & local
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
By the end of this lecture, you will be able to use:
maths module
random module
statistics module
the from statement
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
By the end of this lecture, you'll know what to expect during coding Python - functions and modules with these questions and scenarios. This lecture will help you build a practice towards programming.
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
In this lecture, we'll be covering the installation process of MySQL & how to successfully set it up for your computer.
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
Starting of with database concepts, you'll be well-acquainted with the keywords used in database systems.
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
By the end of this lecture, you will be able to name all the data-types of MySQL with its constraints and commonly used constraints.
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
By the end of this lecture, you will be able to perform data definition operations in MySQL.
USE
CREATE
ALTER
DROP
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
By the end of this lecture, you will be able to perform data manipulation operations in MySQL along with the use of aggregate functions.
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
In this lecture, you will learn how to connect 2 tables together & extract data from them.
- Cartesian product
- Equi-join
- Natural join
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
In this lecture, you will create tables together with me & perform queries to build a practice towards MySQL.
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
By the end of this lecture, you will be able to:
establish a connection between Python & MySQL
use Python to perform queries in MySQL
create a back & front-end system.
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
We'll cover the practical examples of connecting MySQL & Python together.
Thank you for being till the end! Goodbye
Any form of donation is appreciated! Donate at https://www.paypal.com/donate/?hosted_button_id=KA8QKFF7JYNAY
Learn 2 programming skills at the price of 1
! Use code SEP2023 for getting the course for 13.99 $ ONLY
Learn fundamentals of Python & mySQL with creating a front and backend system using your learning! You will gain a solid foundation in Python programming, master the essentials of mySQL and learn how to establish a connection between the two.
Starting from the basics, you will learn Python's syntax, data types, control structures, and much more. Building up the base, you will be able to write clean & efficient code and automate tasks!
After that, you will dive into mySQL, understanding how to define databases and tables, manipulating them to be able to extract valuable insights and handle complex data efficiently.
The course will then guide you through the process of connecting Python and mySQL. You'll discover how to establish a connection, execute SQL queries from Python, fetch and modify data, and handle errors seamlessly. By combining the power of both languages, you'll be able to create dynamic applications that leverage the strength of Python and the reliability of mySQL.
This course will cover the basics of everything, and you do not need any experience or need to be well-versed with Python or SQL.
Join this course and unlock a world of possibilities as you gain the skills to code with Python, define relational databases, and harness the power of Python-mySQL connections. Get ready to embark on an exciting learning journey that will enable you to build innovative applications and take your coding skills to new heights!
Keywords: python, mysql, course, database, data science, discount, 2 for 1