SQL & Relational Database

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.