Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Python Programming, MySQL, Database Concepts & Management
Rating: 3.9 out of 5(24 ratings)
93 students

Python Programming, MySQL, Database Concepts & Management

Python, mySQL, python-SQL Connection, be able to code with Python and defining relations (databases, etc.)
Created byS Hasan Ali
Last updated 6/2024
English
English [Auto],

What you'll learn

  • Able to write Python V3 code
  • Work with all data types in Python — Strings, Lists, Tuples and Dictionary
  • Work with functions, defining them, and implementing them with knowledge of Python's standard library of modules
  • Basics of mySQL—creating databases & tables
  • Work with mySQL: Data Definition Language & Data Manipulation Language
  • Finally, connection of mySQL with Python to create a front and backend system

Course content

7 sections • 24 lectures • 4h 43m total length
  • Introduction: installing & basics of Python2:58
    • 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

  • Fundamentals of Python - Identifiers, Keywords, Variables, Comments, and Object-6:54

    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

  • Datatypes of Python8:49

    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

  • Operators of Python9:32

    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

  • Essentials: Precedence, Input Handling, Conversions, Debugging, and Error Types8:30

    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

  • Segment 1 Quiz

Requirements

  • Computer (Mac/Windows)

Description

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

Who this course is for:

  • Anyone who wants to learn Python
  • Students with no prior knowledge of Python or mySQL
  • Anyone who wants to learn mySQL
  • Python-mySQL Connectivity