free mysql course

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.

4.46
average rating

Ratings

Beginner

Level

6.75 Hrs

Learning hours

2.6L+
local_fire_department

Learners

Skills you’ll Learn

About this 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.

Why upskill with us?

check circle outline
700+ free courses
In-demand skills & tools
access time
Free life time Access

Course Outline

Introduction to Database Management System

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. 

Types of Database Management System

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.

What is a Relational Database Management System?

This chapter will familiarize you with the RDBMS concepts and a few critical differences between File System, DBMS, and RDBMS.

Key Concepts in Relational Database Management System

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.

Normalization Technique

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).

What is SQL and getting started with MySQL

This chapter will brief you on the introduction to SQL and how to install it on your system.

Types of commands in MYSQL

In this chapter, you will learn how to implement various types of Commands in MySQL, such as DDL, DQL, DML, DCL, and TCL, with hands-on demos.
 

Filter records in MySQL

In this chapter, you will learn how to filter the records using the WHERE clause in MySQL.
 

Operators in MYSQL

Now, you will learn how to implement various Operators like AND, OR, and NOT with the help of hands-on demos.
 

Pattern matching in MYSQL

Here, you will learn to find patterns using the LIKE operator with the WHERE clause.

Null values in MySQL

In the final chapter, you will learn to insert a new record or update a record to an optional field without adding a value with the help of a Null value.

Trusted by 1 Crore+ Learners globally

What our learners say about the course

Find out how our platform helped our learners to upskill in their career.

4.46
Course Rating
64%
27%
6%
1%
2%

What our learners enjoyed the most

My SQL Basics

6.75 Learning Hours . Beginner

Why upskill with us?

check circle outline
700+ free courses
In-demand skills & tools
access time
Free life time Access

Refer & Win >

Premium course worth ₹15,000/-