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

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.

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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 internet speed is required to attend the LIVE classes?

Ans. 1Mbps of internet speed is recommended to attend the LIVE classes. 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 in the form of a complete set of previous class recordings, PPTs, PDFs, assignments and access to our 24x7-support team. You can start learning right away.

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.

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 of Rs. 12,500(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.

Lessons

  1. What is a Database

  2. MySQL overview

  3. Datatypes in MySQL

  4. Installation

    1. Setting up XAMPP

    2. Introduction to phpmyadmin

    3. Setting up MySQL Workbench

  5. Designing Databases Using MySQL

    1. Principal and Normalization

    2. Creating Database

  6. SQL Queries

    1. Basic SQL Queries

    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

  7. Database Structure

  8. MySQL Functions

  9. Configuring MySQL server

  10. MySQL Performance Tuning

  11. MySQL Performance Management

  12. Setting Up MySQL Replication

  13. Backup And Restoring Database

  14. Managing User And Privileges

  15. Advanced MySQL Concepts 1

  16. Advanced MySQL Concepts 2

  17. Importing Data From A CSV File

  18. MySQL Option Files