mysql installation on windows 10
How to install mysql

How to install MySQL in Windows 10 | Download and Install MYSQL Server

In this video, you will understand how to download and install MYSQL server. For step – by step guide, watch the video, completely.

To download MYSQL server, click on the following link :
https://dev.mysql.com/downloads/file/?id=495321
and follow the complete steps.
————————————————————————————————————————————-
To uninstall MYSQL:
Open control panel —- Select MySQL and then click uninstall option….
Also, delete the MySQL folder from hidden files and folders also.. and then do the fresh installation..

For hidden folders, Open Windows Explorer… View menu —- options —- change Folder and Search options —– Click on View tab—- And select show hidden files and folders..
C:Program Data | Mysql
This is the default location…check here and delete the mysql folder
After uninstallation, check in C:Program files (086) also..if it’s not deleted..delete from there also..

After this reinstall mysql and follow the steps given in the video…
—————————————————————————————————————————————–
Interface Python with MYSQL (Part – 1)
https://www.youtube.com/watch?v=HZU0JRwv6AE

FETCHALL( ) , FETCHONE( ) , FETCHMANY() , ROWCOUNT
https://www.youtube.com/watch?v=s8ZspjEzAd4

Parameterized Queries
https://www.youtube.com/watch?v=tv1ZGOCs8mA

Performing Insert, Update and Delete Operations, while connecting Python with MYSQL
https://www.youtube.com/watch?v=Agt8ClOF7EA

Create database , Table and insert multiple rows (Taking input from users)
https://www.youtube.com/watch?v=QbOFI1s0IXc

Introduction of Data File handling , Types of Files , Access Modes..
https://www.youtube.com/watch?v=SEpL1QA0uNo

How to read data from a text file using read( ), readline( ) and readlines ( )
https://www.youtube.com/watch?v=AjA3DVeKRsg

How to write data in a file using write and writelines( ) ? How to append data ?
https://www.youtube.com/watch?v=k5js3EH4oe8

Most Important Questions Based On Text File (Part – 1)
https://www.youtube.com/watch?v=c6nQqd-7On0

Most Important Questions Based On Text File (Part – 2)
https://www.youtube.com/watch?v=-IIM5cOcfJo
Program to read data from the text file “Story.txt” and display those words ,
which are ending with ‘e’ and Program to read data from a text file “Story.txt” and calculate and display the sum of all the even digits present in a text file.
https://www.youtube.com/watch?v=gLnArNsb16Y

Program to read data from a text file “PythonSpace.txt” and remove the multiple spaces with a single space and then write the data in a file.
https://www.youtube.com/watch?v=ZL1z3E6zCKc

Introduction of Binary Files, Pickle module , load( ) and dump( )
https://www.youtube.com/watch?v=H0rVCBU8A6U

How to write and read multiple records from a binary file? Taking input from user.
https://www.youtube.com/watch?v=Um6lQM1JY98

How to append data in a Binary File?
https://www.youtube.com/watch?v=pvoreKkD53M

How to search record in a Binary File?
https://www.youtube.com/watch?v=5hgmwVLku_E

seek( ) and tell ( ) in File handling
https://www.youtube.com/watch?v=ozjOoal52Dw

How to update a record in a Binary File?
https://www.youtube.com/watch?v=fMzVPXzwPlc

Most Important Questions based on Binary Files
https://www.youtube.com/watch?v=zap3-ZnRhN8

Introduction of CSV Files … How to write data in a CSV File using writerow( ) and writerows( ) functions?
https://www.youtube.com/watch?v=WmKxew1hJK8

How to read data from a csv file?
https://www.youtube.com/watch?v=jULarC_9rnU

Introduction of Recursion
https://www.youtube.com/watch?v=qEXeOtOok3Q

Program in Python to find factorial of a Number using Recursion.
https://www.youtube.com/watch?v=O2gSmRfQgfY

Program in Python to print Fibonacci series using Recursion.
https://www.youtube.com/watch?v=5abrmh2hSf8

Program in Python to print sum of first N natural numbers using Recursion.
https://www.youtube.com/watch?v=2mrMiN0lyVU

Program to search an element using Binary Search recursively
https://www.youtube.com/watch?v=mHb3mfxGYs8

Solving Output – based Questions of Recursion
https://www.youtube.com/watch?v=Pnk018gzBT8

Idea of Algorithmic Efficiency (Introduction)
https://www.youtube.com/watch?v=iHieYtgtlYU
Calculating Complexity of an algorithm
https://www.youtube.com/watch?v=DJC5733DO2I