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.