Complete SQL & Relational Database Management System

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.