MySQL: A Practical Approach
- Scholarship Details
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.
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
- You should have a Basic working knowledge of computer operations.
- You should have basic logic building skills, problem solving skills.
- You should have a sound knowledge of any of the procedural programming language
Registration is required for course enrollment and scholarship request. You will get an activation link in the mail. Click on it and follow the instructions to complete your registration. Login with your username and password. You will be redirected to your dashboard. 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 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: Scholarship Eligibility: 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.
Click on 'Register' link on the menu bar
Click on activation link in the email
Click on 'Login' link on the menu bar
Click on 'Courses' link on the menu bar
Click on 'Scholarship Enrollment' in the course
1. Click on 'login' link and enter your username and password. or
2. Click on 'Register' link for registering on our website.
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. :
Click on 'Direct Enrollment ' in the course
Registration is required for course enrollment and scholarship request.
You will get an activation link in the mail. Click on it and follow the instructions to complete your registration.
Login with your username and password. You will be redirected to your dashboard.
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
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.
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.
*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%
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 email@example.com
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.
What is a Database
Using MySQL Queries
Datatypes in MySQL
Setting up XAMPP
Introduction to phpmyadmin
Designing Databases Using MySQL
Principles and Normalization
Importing data in MySQL database
Show Use and Describe
Select Single Column
Select Multiple Column
DISTINCT and LIMIT
WHERE and BETWEEN
AND and OR
IN, NOT IN and LIKE
AND (&&) and OR (||) again
UPDATE and DELETE
ALTER, RENAME and DROP
Concat and Count
Using the IN clause
Math and SubQueries
Using Group By
MySQL Performance Management