Complete SQL & Relational Database Management System

Learn RDBMS and SQL - Easy and Effective explanation

Ratings: 4.18 / 5.00




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.


What You Will Learn!

  • Get an understanding of Relational Database Management System (RDBMS)
  • Understand Different terminology of RDBMS
  • Learn about SQL statements and its types(DDL and DML statements)
  • Learn to CREATE Table in Microsoft SQL Server
  • Understand how to INSERT data in a table
  • How to use SELECT statement to retrieve data and making use of its effectively
  • Understand how to UPDATE and DELETE data in a table

Who Should Attend!

  • Beginner who want to understand Relational database and wanted to become expert in SQL
  • Anyone who want to excel the skills in SQL
  • Anyone who want to do the career in Database technologies