SQL & Relational Database

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

In this course you will learn:

• Introduction to Relational Databases.

• Information and Data Models.

• Types of Relationships.

• Mapping Entities to tables.

• Advanced relational model constraints.

• What is the Primary Key?

• What is a Foreign key?

• What are 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 the 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 the 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.