• LOGIN
  • No products in the cart.

Login

Course Curriculum

Course Curriculum

Section 01: Getting Started
Introduction 00:03:00
How to Get Course requirements 00:02:00
Getting Started on Windows, Linux or Mac 00:02:00
How to ask a Great Questions 00:01:00
FAQ’s 00:01:00
Section 02: HTML
Introduction HTML 00:05:00
Choosing Code Editor 00:06:00
Installing Code Editor (Sublime Text) 00:04:00
Overview of a Webpage 00:05:00
Structure of a Full HTML Webpage 00:07:00
First Hello World! Webpage 00:09:00
Section 03: HTML Basic
Heading tags 00:09:00
Paragraph 00:08:00
Formatting Text 00:12:00
List Items Unordered 00:05:00
List Items Ordered 00:04:00
Classes 00:09:00
IDs 00:06:00
Comments 00:04:00
Section 04: HTML Intermediate
Images 00:12:00
Forms 00:05:00
Marquee 00:06:00
Text area 00:06:00
Tables 00:06:00
Links 00:07:00
Navbar – Menu 00:04:00
HTML Entities 00:05:00
Div tag 00:06:00
Google Maps 00:07:00
Section 05: HTML Advanced
HTML Audio 00:07:00
HTML Video 00:05:00
Canvas 00:06:00
Iframes 00:05:00
Input Types 00:04:00
Input Attributes 00:06:00
Registration Form 00:04:00
Contact Us Form 00:10:00
Coding Exercise 00:01:00
Solution for Coding Exercise 00:02:00
Section 06:Python Introduction
Introduction to Python 00:02:00
Python vs Other Languages 00:04:00
Why It’s Popular 00:04:00
Command Line Basics 00:07:00
Python Installation (Step By Step) 00:06:00
PyCharm IDE Installation 00:08:00
Getting Start PyCharm IDE 00:05:00
First Python Hello World Program 00:07:00
Section 07: Python Basic
Variables 00:16:00
Data Types 00:13:00
Type Casting 00:07:00
User Inputs 00:08:00
Comments 00:04:00
Section 08: Python Strings
Strings 00:05:00
String Indexing 00:05:00
String Slicing 00:04:00
String Built-in Functions 00:09:00
Formatting String (Dynamic Data) 00:05:00
Section 09: Python Operators
Arithmetic Operators 00:08:00
Assignment Operators 00:05:00
Comparison Operators 00:05:00
Logical Operators 00:02:00
AND Operator 00:04:00
OR Operator 00:02:00
NOT Operator 00:03:00
Booleans 00:02:00
Section 10: Python Data Structures
Arrays in Earler 00:02:00
Lists 00:06:00
Add List Items 00:03:00
Remove List Items 00:01:00
Sort Lists 00:03:00
Join Lists 00:08:00
Tuples 00:08:00
Update tuples 00:07:00
Join tuples 00:02:00
Dictionaries 00:06:00
Add Dictionary Items 00:04:00
Remove Dictionary Items 00:03:00
Nested Disctionaries 00:04:00
Sets 00:04:00
Add Set Items 00:03:00
Remove Set Items 00:01:00
Join Set Items 00:04:00
Section 11: Python Conditional Statements
If Statement 00:03:00
If-else Statement 00:04:00
If-elif-else Statement 00:04:00
If Statement Coding Excercise 00:05:00
Section 12: Python Control Flow Statements
Flow Charts 00:06:00
While Loops Statement 00:10:00
For Loops Statement 00:06:00
The range() Function 00:04:00
Nested Loops 00:04:00
2D List using Nested Loop 00:04:00
Section 13: Python Core Games
Guessing Game 00:07:00
Car Game 00:10:00
Section 14: Python Functions
Creating a Function 00:03:00
Calling a Function 00:06:00
Function with Arguments 00:05:00
Section 15: Python args, KW args for Data Science
args, Arbitary Arguments 00:04:00
kwargs, Arbitary Keyword Arguments 00:06:00
Section 16: Python Project
Project Overview 00:04:00
ATM RealTime Project 00:13:00
Section 17: MYSQL Introduction
Overview of Databases 00:10:00
MySQL Installation 00:16:00
MySQL Workbench Installation 00:09:00
Connecting to MySQL using Console 00:09:00
Section 18: MySQL Basic
Overview of Challenges 00:04:00
SQL Statement Basic 00:16:00
SELECT Statement 00:09:00
SELECT DISTINCT 00:05:00
Column AS Statement 00:12:00
COUNT function 00:11:00
Section 19: MySQL Filtering Data
SELECT WHERE Clause – One 00:05:00
SELECT WHERE Clause – Two 00:11:00
ORDER BY 00:08:00
LIMIT 00:09:00
BETWEEN 00:11:00
IN Operator 00:11:00
LIKE and ILIKE 00:11:00
Section 20: MySQL Functions
Overview of GROUP BY 00:06:00
Aggregation function SUM() 00:09:00
Aggregation MIN() and MAX() 00:06:00
GROUP BY – One 00:09:00
GROUP BY – Two 00:12:00
HAVING Clause 00:05:00
Section 21: MySQL Joins
Overview Assessment 00:02:00
Overview of JOINS 00:04:00
Introduction to JOINS 00:04:00
AS Statement table 00:03:00
INNER JOIN 00:19:00
FULL Outer Join 00:11:00
LEFT Outer JOIN 00:08:00
RIGHT JOIN 00:08:00
Union 00:07:00
Section 22: MySQL Advanced Commands
Advanced SQL Commands 00:04:00
Timestamps 00:12:00
EXTRACT from timestamp 00:10:00
Mathematical Functions 00:12:00
String Functions 00:22:00
SUBQUERY 00:13:00
Section 23: MySQL Structure Creation
Database and Tables 00:06:00
DataTypes 00:11:00
Primarykey and Foreignkey 00:06:00
Create Table in SQL Script 00:13:00
Section 24: MySQL Data Queries
Insert 00:11:00
Update 00:07:00
Delete 00:04:00
Section 25: MySQL Structure Queries
Alter Table 00:10:00
Drop Table 00:05:00
Section 26: MySQL Constraints
NOT NULL Constraint 00:08:00
UNIQUE Constraint 00:09:00
Section 27: MySQL Backup and Restore
Overview of Databases and Tables 00:05:00
Backup database using phpMyAdmin 00:12:00
Restoring a Database 00:07:00

Python Programming from Scratch with My SQL Database

0( 0 REVIEWS )
1 STUDENTS
Duration: 16.83 Hours
$34.75
  • Course Highlights

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This Python Programming from Scratch with My SQL Database has been specially designed to help learners gain a good command of Python Programming from Scratch with My SQL Database, providing them with a solid foundation of knowledge to become a qualified professional.

Through this Python Programming from Scratch with My SQL Database, you will gain both practical and theoretical understanding of Python Programming from Scratch with My SQL Database that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.

Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals.

  • Learning outcome
  • Get a deep understanding of the Python Programming from Scratch with My SQL Database just in hours not years
  • Familiar yourself with the recent development and updates of the relevant industry
  • Know how to use your theoretical and practical knowledge to adapt in any working environment
  • Get help from our expert tutors anytime you need
  • Access to course contents that are designed and prepared by industry professionals
  • Study at your convenient time and from wherever you want
  • Requirements
  • No formal qualifications required, anyone from any academic background can take this course.
  • Access to any internet-enabled smart device.
  • Why should I take this course?
  • Affordable premium-quality E-learning content, you can learn at your own pace.
  • You will receive a completion certificate upon completing the course.
  • Internationally recognized Accredited Qualification will boost up your resume.
  • You will learn the researched and proven approach adopted by successful people to transform their careers.
  • You will be able to incorporate various practical techniques successfully and understand your customers better.

Testimonial

Hear what our happy students want to say

Setup Menus in Admin Panel

Select your currency
0
    0
    Your Cart
    Your cart is emptyReturn to Shop

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only$68.11 / year

    ADD OFFER TO CART

    No more than 50 active courses at any one time. Membership renews after 12 months. Cancel anytime from your account. Certain courses are not included. Can't be used in conjunction with any other offer.

      Apply Coupon