Complete SQL & Relational Database Management System

Complete SQL & Relational Database Management System, Learn RDBMS and SQL – Easy and Effective explanation.

Course Description

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 SQL Server Management studio
• How to create a table in a Microsoft SQL server with CREATE TABLE command
• How to insert data in a table in a Microsoft SQL server with INSERT INTO statement
• How to retrieve data from a table  with a SELECT statement

Advanced DDL & DML statements :

• How to use string pattern, range of values and set in the SELECT statement
• how to sort data with ORDER BY statement
• how to group by data with GROUP BY clause
• how to use GROUP BY HAVING clause

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 SQL statements in Microsoft SQL server studio
• learn to work with any database tool.