My SQL Basics
Enrolling in this beginners course will help you develop functional knowledge of one of the Relational Database Management Systems, MySQL, and its usefulness with practicality which will eventually improve your career prospects.
![learner icon](https://d1vwxdpzbgdqj.cloudfront.net/assets/corporate-pass/icons/learner_icon_black-dd8828367c8ba9e99e2d141f059d91d53a87d6042dd8c07bd81a79bdbea43d7e.webp)
What you learn in My SQL Basics ?
About this Free Certificate Course
This course will first introduce you to Database Management System (DBMS) with a few examples. Next, you will learn its various types and advantages, followed by the Relational Database Management System (RDBMS), wherein you will comprehend the differences between DBMS and RDBMS. Later, you will get familiar with different Keys and Normalization techniques with examples. Moving ahead, you will be introduced to MySQL and its various concepts like Commands, Filter Records, Operators, Pattern Matching, and Null Values. In addition, you will learn to implement all these concepts through hands-on demonstrations. Once you finish this free course, take the quiz and earn a completion certificate.
Are you ready to upskill further than MySQL? Look no further! Our professional Software Engineering courses cover every skill you need to become an accomplished expert in the domain.
Course Outline
This section begins by defining a database, gives you an overview of the database management system, and briefly explains how to manage and manipulate data in a database.
This chapter will cover various types of DBMS, including Hierarchical, Network, Relational, and Object-Oriented Databases. You will also be familiarized with several advantages of DBMS.
This chapter will familiarize you with the RDBMS concepts and a few critical differences between File System, DBMS, and RDBMS.
This module starts by explaining the concept of keys in RDBMS. You learn about its types and learn them in detail. You will go through the comparison between a super key and a candidate key.
This module discusses Normalization and the role it plays in DBMS. In detail, you will learn about its various types like 1NF, 2NF, 3NF, and BCNF(Boyce and Codd Normal Form).
With this course, you get
![clock icon](https://d1vwxdpzbgdqj.cloudfront.net/assets/corporate-pass/icons/clock-9218c2ae1a00e7c569a4fe92a883bb65926bd5a1f2bae97106b435eb539bc966.webp)
Free lifetime access
Learn anytime, anywhere
![medal icon](https://d1vwxdpzbgdqj.cloudfront.net/assets/corporate-pass/icons/medal-fd6655a3e1418d9b471f03b4dc3318a9f3021810e8e416ea2542aff3b1592dcb.webp)
Completion Certificate
Stand out to your professional network
![medal icon](png/timer-2eeb3d901142498651d0bd14c1fb756700416be8a56d9f270920a11f1cdb7460.png)
4.5 Hours
of self-paced video lectures
Frequently Asked Questions
What are the prerequisites required to learn this MySQL Basics course?
There are no prerequisites required to learn this course. Any enthusiast can enroll in this course and develop a functional knowledge of Databases and MySQL.
How long does it take to complete this free MySQL Basics course?
This course contains 2 hours of video content which you can study at your own pace.
Will I have lifetime access to the free course?
Yes, this course is self-paced, where you can access it and learn at any time at your convenience.
What are my next learning options after this MySQL Basics course?
Once you finish this free course, you can opt for the professional Full Stack Developer course from IIT Roorkee that will help advance your career growth in Front-end, Back-end, and Database Management. In addition, this course offers specializations in Cloud Computing and Python for Data Science.
Is it worth learning MySQL?
MySQL is a powerful Database Management System used by many large-scale websites and applications. Suppose you are looking to work with or develop websites or applications requiring a database. In that case, learning MySQL will be highly beneficial since it is relatively easy to learn compared to other Database Management Systems.
Stories of success
Can Great Learning Academy courses help your career? Our learners tell us how.And thousands more such stories of success..
Related IT & Software Courses
Relevant Career Paths >
Other IT & Software tutorials for you
Basics of MySQL
MySQL is generally an RDMS (Relational Database Management System) which is based on SQL (Structured Query Language), which is the popular language for accessing, manipulating and managing the data. This is a free and open-source software under the terms of the GNU (General Public License), which is also available under a variety of proprietary licenses. This software is ideal for both small and large applications. It is very swift, reliable and also easy to use and it is free to download and access. It was developed, distributed and supported by Oracle Corporation. In this MySQL free course, you will understand the topics of MySQL database that provides information about how to manage the database and also how to manipulate data of the database with the assistance of SQL queries. These queries can be used for inserting data, updating them, deleting the records, selecting them, creating tables, truncating the records or dropping the tables.
This RDBMS software provides the following:
- It describes the relationship of a database in the form of the tables which are also known as relations.
- It also permits us to carry through the database operations on tables, rows, columns and also indexes.
- It also brings forth the Referential Integrity between the rows or columns of various database tables.
- We can avail multiple tables for the end-users with the help of many SQL queries and combined useful information.
Since we know MySQL is used to store the data in the form of tables. These databases are benefiting us by storing the information categorically. The XYZ Company may have a database that would require the tables for their employees, their products, the customers and also about the orders.
In prior to starting with MySQL basics, let us see a few definitions correlated to the database:
- Database: The collection of tables with relevant data is known as a Database.
- Table: It consists of rows and columns, a matrix with data. The cols are used to specify the type of data considering that the rows contain the actual data itself.
- Row: Also known as tuple or record.
- Column: Also known as attribute or field.
- Primary key: Primary key is a unique key constraint. This key value cannot occur twice in the table. Since it is a combination of unique + not null.
- Foreign key: Foreign key is used to establish the relation or the connection between two tables.
- Index: Just like an index which we have at the back of the book, here we have an index in the database which works as the same.
- Referential Integrity: To make sure that the foreign key value is always pointing to an existing one, we need Referential Integrity.
Let’s know about few data manipulation statements:
- Select: This clause is used to SELECT the data you require from the respective table.
- From: This clause is used to define the name of the table FROM which data is selected.
- Where: This clause is used to filter out the data according to the conditions provided.
- Order By: This clause is used to sort the data according to our requirements. Be it sorting in ascending or in descending order.
- And: This operator is used for the filtering process with the Boolean logic.
- Or: This operator is similarly used for the filtering process and for comparison purpose.
- In: This operator is used with the WHERE clause to find out if the value matches any values in the list or the subquery.
- Not In: This operator works the other way round of the IN operator. This is used to identify that none of the value matches with the values in the list or the subquery.
- Between: This is operator is used when we have a range of values to be selected.
- Like: This operator is used to select a value by describing a certain pattern for it.
- Not Like: This operator is the opposite of the LIKE operator.
- Inner Joins: Joins are basically used to obtain data from two or more table simultaneously. So this join is used to get valid or matched outputs from the table.
- Left Outer Join: This join is used to obtain all the valid as well as the invalid outputs from the left table.
- Right Outer Join: This join is used to obtain all the valid as well as the invalid outputs from the right table.
- Full Outer Join: This join is the combination of the LEFT and RIGHT outer joins. Here, we get the valid as well as the invalid data from all the tables.
- Cartesian Join: This is used to obtain both the matched as well as unmatched outputs from the tables. But the number of unmatched data is more as compared to matched data. Hence, this join is not widely used.
- Natural join: We can use this join when we do not know the primary key and foreign key relation between the tables. If there is a primary key foreign key relation then this join gives the output as an INNER join, but if there is no relation between the tables then we get the outputs as CARTESIAN join.
- Group By: This clause is used to group the record based on the conditions provided.
- Having: This clause is used to filter conditions having group by clause.
- Subquery: It is a query (inner query) written inside another query (outer query). The output of the inner query is given to the outer query as the input. Taking this input from the inner query the outer query executes completely and generates the result. It is also used to establish a connection between the tables.
- Union and Union All: These operators are used to combine two or more results sets of multiple queries into a single result set.
- Insert: This statement is used to INSERT data into the table or database.
- Insert Multiple Rows: It is also used to INSERT multiple rows into the table.
- Update: This statement is used to UPDATE the data which is existing inside the table or the database.
- Delete: This statement is used to DELETE rows from a single table or multiple tables, we can restore the records using the FLASHBACK command.
- Rename: This statement is used to RENAME the existing table name from the database.
- Create: This statement is used to CREATE the table inside the database.
- Alter: This statement is used to ALTER the table name, modify any column name, add or remove rows and columns, etc.
- Truncate: This statement is used to TRUNCATE the rows, when we truncate all the rows get deleted and cannot be restored back.
- Drop: This statement is used to Drop the table, here the records along with the table structure gets deleted. But we can restore it with the ROLLBACK command.
- Rollback: This statement is used to restore back the records along with the table structure as it is with the help of this ROLLBACK statement.
- Commit: This command is used to COMMIT the record, which is we save the last record into the database so that it can be restored if deleted.
After the completion of this course, you will get a better knowledge of MySQL basic commands which will be helpful for further knowledge on an intermediate level.
A MySQL Developer, an IT professional is responsible for all phases of Database Administration on all environments with significance on performance troubleshooting, analytical problem solving and also on business customer support.
Advantages:
SQL has many merits which makes it popular and highly in demand. It is a well-grounded and well-organized language that is used to communicate with the database.
- Faster Query Language.
- No coding skills.
- Standardised Language.
- Interactive Language.
- Portable.
Disadvantages:
Although SQL has various advantages, it still has a few disadvantages.
- Complex Interface.
- Cost.
- Partial Control.