Udemy APAC

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.


Get on Udemy