Have a question?
Message sent Close
4.18
25 reviews

Complete SQL & Relational Database Management System

Learn RDBMS and SQL - Easy and Effective explanation
Instructor
Atul Kadlag
4,437 Students enrolled
  • Description
  • Curriculum
  • FAQ
  • Reviews

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.

How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
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.18
25 reviews
Stars 5
14
Stars 4
8
Stars 3
2
Stars 2
0
Stars 1
1
41942
Course details
Video 3 hours
Lectures 3
Certificate of Completion
Full lifetime access
Access on mobile and TV

External Links May Contain Affiliate Links read more

Join our Telegram Channel To Get Latest Notification & Course Updates!
Join Our Telegram For FREE Courses & Canva PremiumJOIN NOW