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
- 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
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.
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.
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.
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 email@example.com
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.
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 of Rs. 12,500(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.
What is a Database
Datatypes in MySQL
Setting up XAMPP
Introduction to phpmyadmin
Setting up MySQL Workbench
Designing Databases Using MySQL
Principal and Normalization
Basic SQL Queries
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
Configuring MySQL server
MySQL Performance Tuning
MySQL Performance Management
Setting Up MySQL Replication
Backup And Restoring Database
Managing User And Privileges
Advanced MySQL Concepts 1
Advanced MySQL Concepts 2
Importing Data From A CSV File
MySQL Option Files