Complete SQL & Relational Database Management System

Learn RDBMS and SQL - Practical hands-on with Theory concepts

What you'll learn:

• Get an understanding of Relational Database Management System (RDBMS)
• Understand Different terminology of RDBMS
• Learn about SQL statements and its types(DDL and DML statements)
• Learn to CREATE Table in Microsoft SQL Server
• Understand how to INSERT data in a table
• How to use SELECT statement to retrieve data and making use of its effectively
• Understand how to UPDATE and DELETE data in a table

In this course, you will learn about Relational Database Management systems and Structured Query Language (SQL)

You will learn about the Relational Database Management system:

• Introduction to Relational Databases

• Information and Data Models

• Types of Relationships

• Mapping Entities to tables

• Advanced relational model constraints

• What is Primary Key

• What is Foreign key

• What is Entity, Attributes

´Data Definition Language(DDL) & Data Manipulation Language (DML)

• Types of SQL statements

• What is DDL (Data Definition Language)

• What is DML(Data Manipulation Language)

• How to get started with Database - install and set up Microsoft SQLServer Management studio

• How to create a table ina Microsoft SQLserver with CREATETABLEcommand

• How to insert data in a table in a Microsoft SQLserver with INSERTINTO statement

• How to retrieve data from a table with a SELECTstatement

Advanced DDL&DMLstatements :

• How to use string pattern, range of values and set in the SELECTstatement

• how to sort data with ORDERBY statement

• how to group by data with GROUPBYclause

• how to use GROUPBYHAVINGclause

Working with multiple tables

• How to use different tables

• understand the use of Primary key and foreign key

• understand Different types of Joins:

  • Inner Joins

  • Left Outer Join

  • Right Outer join

  • Full outer join

All these topics you will learn with theoretical concepts along with hands-on practices.

By end of the course, you gain :

• Understand RDBMS concepts

• learn to execute different SQLstatements in Microsoft SQLserver studio

• learn to work with any database tool.