Complete SQL & Relational Database Management System

Complete SQL & Relational Database Management System

What you’ll 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

Requirements

  • Basic knowledge about computer

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

 

Telegram Group Join Now
WhatsApp Group Join Now

´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.

Who this course is for:

  • 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

We will be happy to hear your thoughts

      Leave a reply

      Freewebcart
      Logo
      Share to...