Short-Term Course in RDBMS and SQL

Self-Paced

Fee:

₹1,999

Dr. Pooja Bijlani | Trainer (Subject Matter Expert) Future Skill Academy

₹1,999

Dr. Pooja Bijlani

6 weeks

20

2 Yes

AISECT Learn

N/A

English

1 Year Access

Yes

This course helps you in learning MySQL, which is one of the most widely used databases in the industry. In this course, you will learn to deal with databases which are the backbone of any personal or commercial software. This course covers the fundamental concepts of a relational database management system along with the steps to create database and database tables. Then it introduces queries to insert data, update, delete and fetch the data from the tables. Merging of tables, using aggregate functions, clauses to filter and sort the data, has been covered in detail. The course mainly focuses on the practical approach and expects you to try hands-on with the exercises to get completely proficient in working with.

Objectives

Learn how to retrieve and manipulate data from one or more tables. Learn how to filter data based upon multiple conditions. Update and insert data into the existing tables. Understand how the relationships between tables will affect the SQL. Understand the advantages of stored procedures along with storing data using variables and functions.

Understand basic concepts of how a database stores information via tables.

Understand SQL syntax used with MySQL.

Learn how to retrieve and manipulate data from one or more tables.

Learn how to filter data based upon multiple conditions.

Update and insert data into the existing tables.

What Will You Learn

You will learn how to retrieve and manipulate data from one or more tables. Learn how to filter data based upon multiple conditions. Update and insert data into the existing tables. Understand how the relationships between tables will affect the SQL. Understand the advantages of stored procedures along with storing data using variables and functions.

Understand the advantages of stored procedures along with storing data using variables and functions.

SKILLS YOU WILL GAIN

Understand the advantages of stored procedures along with storing data using variables and functions.

Want to know more about our courses?

Prepare for your career path

MySQL Developer is an IT professional responsible for all phases of database administration on all environments, with emphasis on performance troubleshooting, analytical problem solving and business customer support.

Key Skills To Learn

"Learn how to retrieve and manipulate data from one or more tables. Learn how to filter data based upon multiple conditions. Update and insert data into the existing tables. Understand how the relationships between tables will affect the SQL. Understand the advantages of stored procedures along with storing data using variables and functions."

Jobs in India

4.4 Lakhs

Average Salary

8.5 Lakhs

Job Growth

35.20%

Jobs in India

4.4 Lakhs

Average Salary

8.5 Lakhs

Job Growth

35.20%

Learn from the industry experts and stay ahead of the curve

Companies Looking For Software Developer

and many more

Curriculum

What is RDBMS and SQL?

Installation SQL and Workbench

MySQL command line client and workbench

Data Types in MySQL

Operators in MySQL

MySQL Database

MySQL tables and constraints

Table operations

Inserting data into tables

MySQL "SELECT" Query

MySQL clause "WHERE"

Query using operators in MySQL

Aggregate functions

"UPDATE" query

"DELETE" query with "WHERE" clause

Pattern matching operator "LIKE"

"ORDER BY" Command

"GROUP BY" Command

Clause "HAVING"

Practical Question

Instructor

Dr. Pooja Bijlani

Trainer (Subject Matter Expert) Future Skill Academy

AI ML, Data science, Full Stack Web Development, Full Stack Java Development

Presently she is working as an IT Trainer (Subject Matter Expert) at Future Skill Academy, AISECT, Bhopal. She is having over 15 years of academic and research experience. Expert in Programming Languages C,C++,Python, Java, React Spring Boot, Artificial Intelligence, Machine Learning and Data Science. Students accoladed her programming language teaching skills. Having experience in number of End to End projects in Natural language Processing, Computer Vision and Python Desktop Application GUI. Web Designing.

4.9 968

1087 Learners

Still have queries? Talk to our counselors who are available to guide you

Shareable Certificate

Other Details