3.97 out of 5
3.97
127 reviews on Udemy

Complete SQL & Relational Database Management System

Learn RDBMS and SQL - Easy and Effective explanation
Instructor:
Atul Kadlag
14,540 students enrolled
English [Auto]
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

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.

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4
4 out of 5
127 Ratings

Detailed Rating

Stars 5
48
Stars 4
48
Stars 3
24
Stars 2
4
Stars 1
3
1ba0c177c5717723905457949b59ce4b

Includes

3 hours on-demand video
3 articles
Certificate of Completion