LearnSQL

Learn basic things about Sql for develop basic Data Management skills.

Topics

• mysqlServer Install
• MYSQL python connector
• Queriying data from a table
• Inserting data into a table
• Updating data in a Table
• Store Procedures
• Retrieving & updating BLOB in MYSQL database

Sample Data Base For Learning

Basic Definitions

SQL commands

• SQL commands are instructions. It is used to communicate with data base. It is also used to perform specific task, functions and queries of data.
• SQL can perform specific task like create a table, add data to tables, drop the tables, modify the table, set permisions for users

Type of SQL commands

There are five type of SQL commands: