Faculties from U.P., Haryana, Punjab, Chandigarh and Delhi can apply for scholarship. LEARN MORE

Select Your Style

Choose your layout

Color scheme

MySQL: A Practical Approach

MySQL: A Practical Approach

MySQL: A Practical Approach

  • Timeline
  • Overview
  • Curriculum
  • Prerequisite
  • Enrollment
  • Scholarship Details
  • Certification
  • FAQ's

About the course

MySQL is a very popular, fast and easy to use relational database management system (RDBMS) which was released under an open source license also known as GNU GPL (GNU General Public License) and is free of cost. MySQL is the name which is formed by the combination of "My", the name of the daughter of co-founder Michael Widenius and "SQL", the abbreviation for Structured Query Language. This database is most widely used in big and small businesses. MySQL was developed by a Swedish company named MYSQL AB which only launched this product including its marketing and support services. The reason why this is most popular is due to its compatibility with different web applications. It is compatible with different programming languages like PERL, C, C++, Java and it is very friendly with PHP as well. It also supports a large database of more than 50 million rows in a table where the default size of the table is 4GB which can be further extended to a theoretical limit of 8 million TB (terabytes).

MySQL is an open source web application known as LAMP which is known as "Linux, Apache, MySQL, Perl/PHP/Python". There are applications which uses MySQL database such as TYPO3, MODx, Joomla, WordPress, phpBB, MyBB, and Drupal. MYSQL is also extensively used in some of the large-scale and high profile websites such as Google, Youtube, Facebook, Twitter etc.

1. What is a Database

Learning Objectives: This chapter we will talk about what a database actually is. When people talk about a database, they mean many things. So we will define what a database really is.

2. MySQL overview

Learning Objectives: This chapter we re going to focus on the features of MySQL.

3. Datatypes in MySQL

Learning Objectives: This chapter we will talk about datatypes in MySQL. Any data that is added to the database table has to have a certain datatype.

4. Installation

Learning Objectives:This chapter we will cover Setting up XAMPP, Introduction to phpmyadmin, Setting up MySQL Workbench.

5. Designing Database using MySQL

Learning Objectives: This chapter covers the introduction to MySQL. MySQL is a very popular and robust relational database management system. This database is most widely used in big and small businesses. MySQL was developed by a Swedish company named MYSQL AB. You’ll also learn about the concepts of database, a database is an organized collection of data and information which can be easily accessed and maintained. The chapter also covers the details of datatypes in MySQL. A datatype is defined as the type of data which a variable can hold. In MySQL, the datatypes can be numeric, strings, date and time, bit, Boolean and enumeration. Apart from this the chapter also attempts to cover the installation instructions of MySQL including XAMPP configuring and setting up of MySQL workbench, PHPMYADMIN, normalization and principles.

6. SQL queries

Learning Objectives:This chapter covers the details of SQL Joins. A SQL Join clause combines the columns from two or more tables in a relational database. This creates a set which can be used as a table or as it is. There are various types of joins in MySQL, such as Inner Join, Left Join, Right Join, Full Join, Self-Join etc. The chapter also includes the aggregate functions which are there in MySQL.

7. Database Structure

Learning Objectives:The chapter covers the details of the database structure which includes some important terms such as Applications, End user, Data Definition Language, DDL compiler, DML Compiler, Query Optimizer, Stored data manager, Data files, Compiled DML and Data Dictionary.

8. MySQL Functions

Learning Objectives:This chapter attempts to cover the functions used in MySQL. A function is a procedure or a routine which is created to perform specific tasks in a program. Once the function is created, it can be used multiple times. MySQL includes different built-in functions which are categorized and aggregate functions and string functions, control flow functions. Aggregate functions such as like COUNT, MAX, MIN, AVG, SUM etc. String functions like CONCAT, LENGTH, CHAR_LENGTH etc. and Control functions like IFNULL, NULLIF, CASE etc. The functions will be covered in detail in this chapter along with their implementation.

9. Configuring MySQL Server

Learning Objectives: This chapter covers in detail, how to configure MySQL server in order to enhance its performance. The chapter includes performance tuning, monitoring performance, increasing memory allocations and table cache.

10. MySQL Performance Management

Learning Objectives:This Chapter we will learn about the performance related issues in MySQL. We will learn about monitoring the server and the system variables and viewing the logs. Then we will learn about performance tuning and denormalization.

11. Setting Up MySQL Replication

Learning Objectives:This chapter covers the details of What replication is and how it works,Different ways that replication can occur, How MySQL handles replication, The difference between slaves and the master, The importance of the Binary Log, How to configure MySQL to enable replication, How to troubleshoot replication.

12. Backup and Restoring Database

Learning Objectives:This chapter covers the details of creating a backup and restoring the data from the database with the help of SQL queries.

13. Managing User and privileges

Learning Objectives: This chapter covers the details of how to create and manage users in MySQL database, understanding users and privileges.

14. Advanced MySQL concepts 1

Learning Objectives: This chapter covers an introduction to CSV files, how to insert data into the tables using INSERT query, how to update a table using UPDATE query and how to delete a record from the table of complete table using DELETE query. The chapter also includes how to import data from a CSV file and exporting the data to a CSV file with the help of SQL query.

15. Advanced MySQL concepts 2

Learning Objectives: This chapter covers the details of advanced queries with clauses like ORDER BY, LIMIT etc. SELECT query helps to select the data from the tables in the form of rows and columns. In order to filter the data, the ORDER BY clause is used with SELECT statement. The chapter covers operators which are used with the SELECT statement. Also, the clauses like DISTINCT, LIMIT, COUNT are also covered in this chapter, how to change the tables with the help of ALTER statement.

16. MySQL Option files

Learning Objectives: This chapter is all about option files. Option files in MySQL are also known as configuration files and are read by most MySQL programs for startup options.

Pre-requisites for MySQL: A Practical Approach

  1. You should have a Basic working knowledge of computer operations.
  2. You should have basic logic building skills, problem solving skills.
  3. You should have a sound knowledge of any of the procedural programming language

Create Your Account

Click on 'Register' link on the menu bar

Registration is required for course enrollment and scholarship request.

Check Your Email Inbox

Click on activation link in the email

You will get an activation link in the mail. Click on it and follow the instructions to complete your registration.

Login to Your Account

Click on 'Login' link on the menu bar

Login with your username and password. You will be redirected to your dashboard.

Browse Courses

Click on 'Courses' link on the menu bar

You can browse available courses from Home Page or by clicking Courses link on menu bar. Navigating to a course will give you two options: 1.Direct Enrollment 2. Scholarship Enrollment

Scholarship Enrollment

Click on 'Scholarship Enrollment' in the course

Logged in user can fill their details in the 'Scholarship Application' available in each course.

We will mail you further details after processing your application based on your academic and professional record.

Note:
1. Click on 'login' link and enter your username and password. or
2. Click on 'Register' link for registering on our website.

Scholarship Eligibility:
1. Faculties from the states of Haryana, Punjab and U.P. and U.T.s of Chandigarh and Delhi are eligible for partial or full scholarship.
2. Also the candidates belonging to SC / ST category can also avail full scholarship (You need to submit SC / ST certificate in a format prescribed by the Central Govt. :
https://www.iitk.ac.in/doaa/admissions/sc-st.pdf).

Direct Enrollment

Click on 'Direct Enrollment ' in the course

After processing your scholarship request, we will send you the necessary details.

You can directly enroll for the course by clicking on ‘Direct Enrollment’, if you do not require scholarship.

Please Login or Register to fill the Scholarship form.

Scholarship Application

Under Graduate

Post Graduate

Ph.D.

Category

Other Information

+

*CGPA to percentage conversion formula:

Equivalent Percentage = CGPA obtained X 9.5 X (10/CGPA Scale)
Example: If CGPA obtained is 8.00 on the scale of 10, then Equivalent
percentage will be 8.00 X 9.5 X (10/10) = 76%,
or If CGPA is 3.7 out of 4, then Equivalent percentage will be 3.7 X 9.5 X (10/4) = 87.88%

Disclaimer:

We urge you to provide correct information to your best knowledge. Certificates will be withheld if found that you have misrepresented any data / information.

Q1. Who is our Instructor?

Ans. All our instructors are domain experts from the Industry or are from world-renowned academic Institutes and have at least 10-12 yrs of relevant experience in their domains. They are subject matter experts and are trained by Electronics & ICT Academy for providing online training so that participants get a great learning experience.

Q2. What are the payment options?

Ans. You can pay by Credit Card, Debit Card or Net Banking from all the leading banks. We use a SBI Payment Gateway. Additionally, you may send us a cheque with appropriate details or use wire transfer.

Q3. How to get my queries resolved?

Ans. You can email us at ict@iitk.ac.in

Q4. What is the internet speed required to watch the video?

Ans. 1Mbps of internet speed is recommended to watch the videos. However, we have seen people attending the classes from a much slower internet.

Q5. How soon after signing up would I get access to the learning content?

Ans. As soon as your payment is verified, you will immediately get access to our course content.

Q6. What are the system requirements?

Ans. Your system should have a 4GB RAM, a processor better than core 2 duo and operating system can be of 32bit or 64 bit.

Q7. When can I watch the videos?

Ans. You can watch the courses as per your convenience.

Q8. What is the process that needs to be followed for getting the scholarship?

Ans. Following is the process for availing the scholarship:

a) Applicants should carry out the one-time registration on the website.

b) After registration, you browse to the course(s) of your interest and fill the scholarship application.

c) We will process the scholarship application and send the amount of scholarship qualified for and details of next steps that need to be followed.

Q9. Can we avail scholarship for only one course?

Ans. Scholarship application for a particular course is independent of your scholarship application for other courses. And it is recommended that you apply for scholarship in all the courses that is of your interest.

Q10. I cannot see the courses in my account?

Ans. Course will be available to you, once after you pay the fees(if any) as determined by the governing body of the E & ICT Academy.

Q11. I am a faculty, but your registration form only has one option of registering as a “student”?

Ans. Student are those who are registering with the purpose of learning at our website. While there is also a role of Faculty for those who wants to contribute in the courses being offered by the Academy. Since the courses are being offered to faculty for learning, their role is that of a student and therefore you are being registered as a student.

Q12. Is it okay for me to take a course?

Ans. Please check the prerequisite section of the course you are interested in.

Q13. I’m a working professional, what should I fill in the college name and HOD Email address?

Ans. You can fill the college you have graduated from and leave the HOD Email address blank.

Lessons

  1. What is a Database

  2. MySQL overview

  3. Using MySQL Queries

  4. Datatypes in MySQL

  5. Installation

    1. Setting up XAMPP

    2. Introduction to phpmyadmin

  6. Designing Databases Using MySQL

    1. Principles and Normalization

    2. Creating Database

  7. SQL Queries

    1. Importing data in MySQL database

    2. Show Use and Describe

    3. Select Single Column

    4. Select Multiple Column

    5. DISTINCT and LIMIT

    6. ORDER BY

    7. WHERE and BETWEEN

    8. AND and OR

    9. IN, NOT IN and LIKE

    10. AND (&&) and OR (||) again

    11. Regular Expressions

    12. String Functions

    13. Aggregate Functions

    14. GROUP BY

    15. SUB Queries

    16. JOINS

    17. Full Text

    18. INSERT INTO

    19. UPDATE and DELETE

    20. ALTER, RENAME and DROP

    21. VIEWS

    22. Concat and Count

    23. Using the IN clause

    24. Math and SubQueries

    25. Using Group By

  8. Database Structure

  9. MySQL Performance Management