Note: 

   

If you guys are getting coupon expired or course is not free after opening the link, then it is due to the fact that course instructors provide only few hundreds or thousands of slots which get exhausted. So, try to enroll in the course as soon as it is posted in the channel. The Coupons may expire any time for instant notification follow telegram channel

New customer offer! Top courses from $13.99 when you first visit Udemy
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