MySQL -A Practical Approach offered by IIT Kanpur
- Public/Government Institute
- Estd. 1959
MySQL -A Practical Approach at IIT Kanpur Overview
Duration | 6 weeks |
Total fee | ₹4,237 |
Mode of learning | Online |
Credential | Certificate |
MySQL -A Practical Approach at IIT Kanpur Highlights
- Earn a certificate of completion from E & ICT Academy, IIT Kanpur
- Learn from online lectures with high-quality videos
- Hands on training for practical exposure
MySQL -A Practical Approach at IIT Kanpur Course details
- For students who are pursuing professional graduate/post-graduate courses related to computer science or Information Technology
- For computer science and engineering teachers/faculties
- For IT professionals, who wish to acquire new skills or improve their existing skills
- Understand basic concepts of how a database stores information via tables
- Understand SQL syntax used with MySQL
- Learn how to retrieve and manipulate data from one or more tables
- Learn how to filter data based upon multiple conditions
- Update and insert data into the existing tables
- Understand how the relationships between tables will affect the SQL
- Understand the advantages of stored procedures along with storing data using variables and functions
- Boost your hireability through innovative and independent learning
- This course helps you in learning MySQL, which is one of the most widely used databases in the industry
- In this course, you will learn to deal with databases which are the backbone of any personal or commercial software
- This course covers the fundamental concepts of a relational database management system along with the steps to create database and database tables
- Then it introduces queries to insert data, update, delete and fetch the data from the tables
- Merging of tables, using aggregate functions, clauses to filter and sort the data, has been covered in detail
MySQL -A Practical Approach at IIT Kanpur Curriculum
What is a Database
MySQL overview
Learning Objectives: This chapter we re going to focus on the features of MySQL
Using MySQL Queries
Datatypes in MySQL
This chapter we will talk about datatypes in MySQL. Any data that is added to the database table has to have a certain datatype
Designing Databases Using MySQL
Principles and Normalization
Creating Database
Installation
Setting up XAMPP
Introduction to phpmyadmin
SQL Queries
Show Use and Describe
Importing data in MySQL database
Select Single Column
Select Multiple Column
DISTINCT and LIMIT
ORDER BY
WHERE and BETWEEN
AND and OR
IN, NOT IN and LIKE
AND (&&) and OR (
) again
Regular Expressions
String Functions
Database Structure
Managing Users and Privileges
Other courses offered by IIT Kanpur
4.74 years
Student Forum
Anything you would want to ask experts?
MySQL -A Practical Approach at IIT Kanpur News & Updates
MySQL -A Practical Approach at IIT Kanpur Contact Information
Indian Institute of Technology, Kalyanpur
Kanpur ( Uttar Pradesh)
(For general query)
(For admission query)
(For general query)
(For admission query)
Useful Links
Know more about IIT Kanpur
- All About IIT Kanpur
- Courses 2025
- Fees 2025
- Reviews on Placements, Faculty & Facilities
- Admission 2025 - Cutoffs, Eligibility & Dates
- Placement - Highest & Average Salary Package
- Cut off & Merit List 2025
- IIT Kanpur Rankings
- Infrastructure Details & Reviews
- IIT Kanpur Faculty
- Compare IIT Kanpur
- IIT Kanpur Q&A
- Scholarships
- IIT Kanpur News & Articles