Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

RDBMS-SQL course

person icon Blismos Academy

4.5

RDBMS-SQL course

SQL, MySQL

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Blismos Academy

category icon MySQL,Big Data

Lectures -143

Duration -13 hours

4.5

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Database development with MySQL is one of the most fundamental skills that a technology professional needs to thrive in today's workplace. This course gives you that skill. You'll start with the absolute basics of installing and creating databases to resolving the complex queries.

In this course you can learn the fundamental basics of RDBMS and Data Management with SQL. Learn everything that you will need to construct queries with the most popular data manipulating programming language - SQL. The course is a self-paced and you can work through it at your own pace. The course is a right blend of concepts and hands-on to take a step towards making you a pro in SQL.

  • 10+ hours of on demand videos

  • Clarifications through community

  • Right blend of concepts and hands-on

  • Built in Assessment to test your knowledge

In this course, you will:

  • The difference between Data and Information

  • Why do we need Data?

  • Learn the ins and outs of SQL syntax

  • What is RDBMS and its History?

  • Database Objects and Database Design

  • Learning about the Keys and Constraints

  • Explaining the Normalization and its types

  • Understanding the Transactions and its types

  • How to write SQL queries to Manipulate data

  • How to write SQL queries to insert, update and delete data into database

  • Analyze data using Aggregate Functions

  • Run complex queries using MySQL logical operators

  • How to handle the NULL values in the SQL

  • Write all the common SQL joins

  • Querying the data using Set Operators

  • Executing the complex queries with String Functions

  • And more!!!!


Who this course is for:

  • Beginners who want to learn RDBMS and SQL
  • Database developers and database administrators.
  • Students who wish to learn a new skill to develop their career.
  • Professional who wish to learn a new skill to develop their career.


Goals

What will you learn in this course:

  • Understand the basic and Intermediate concepts of databases and MySQL

  • How to write SQL queries to manipulate data.

  • Learn how to create database tables using SQL commands.

  • Learn how to perform different types of join operations.

  • Learn SQL operators to write complex SQL queries.

  • Learn how to perform different types of Set Operators.

  • Learn about different SQL functions and constrains including NULL values.

  • How to write SQL queries to insert, update and delete data into database.

Prerequisites

What are the prerequisites for this course?

  • Passion and curiosity to learn something new technology

  • No technical knowledge required.

  • A computer with internet connection.

RDBMS-SQL course

Curriculum

Check out the detailed breakdown of what’s inside the course

Welcome to course
2 Lectures
  • play icon Introduction to RDBMS 02:08 02:08
  • play icon RDBMS SQL(youtube) 02:01 02:01
Installation Video
3 Lectures
Tutorialspoint
RDBMS
49 Lectures
Tutorialspoint
SQL
89 Lectures
Tutorialspoint

Instructor Details

Blismos Academy

Blismos Academy

e


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515