Skip to content
UdemySQLPaid courseAll LevelsCertificate

Complete SQL & Relational Database Management System (Udemy.com)

Learn RDBMS and SQL - Practical hands-on with Theory concepts

Created by: Atul Kadlag

Last updated January 2023

icon
What you will 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

How it compares

Against the other 388 rated Udemy courses in SQL on CourseDuck:

  • Rating4.4 out of 5higher than 34% of them
  • Reviews202#295 of 389 by number of reviews
  • Length3.3 hoursshorter than 72% of them
  • Last updatedJanuary 2023earlier than 54% of them

icon
Course 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

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


icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Atul Kadlag

With over 16+ years of enriching experience in the IT industry, I have carved a niche for myself at the forefront of technological innovation, working on a multitude of projects for a global clientele within a leading multinational company. My journey began in the realm of Java technologies, where I honed my skills in enterprise development before diving into the dynamic world of Business Intelligence (BI) and ETL technologies. My expertise spans a wide array of tools and platforms, including:

SAP Business Objects Reporting, SAP Design Studio, SAP Lumira Designer, SAP Analytics Cloud, and Microsoft Power BI Desktop/Pro, Data Fabric, Data Modelling. Python for Data Analysis( Jupyter Notebook, Pandas, Numpy, Matplotlib, Seaborn)

SQL - Microsoft SQL Server, Oracle.

ETL - Microsoft SQL Server Integration Service (SSIS), SAP BusinessObjects Data Services (BODS), and Pentaho,Microsoft Fabric.

In an industry characterized by rapid technological evolution, my ability to swiftly adapt and master new technologies has been a cornerstone of my professional growth. This adaptability, coupled with a deep-seated passion for technology, has propelled me to not only excel in my field but also to share my wealth of knowledge with others.


icon
More courses by Atul Kadlag

$10.99

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

icon
Reviews

4.4

202 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Ashish Patel on 12/25/2024

Wow.. Thanks for such wonderful course. Although been in computer science students many of the things were new to me practically.. It was just best utilization of my time. ✨

By Sakshi Dilip Raut on 7/11/2024

The course is amazing, the mentor also explain the topics in detail. It was great to learn from udemy

By Sachith T. Ananda on 7/7/2024

Good Content. But I think some examples are to be added. Learners should have a basic understanding of SQL theories. This is not suitable for beginners. Good Effort! Keep Doing! Happy Learning With You!!!

By Jimoh Yusuf Bolaji on 3/24/2024

I believe the tutor master should share a csv file to be used for the classes so that the students too can have hands-on practical experiences. thanks

By Adejumo Victor on 11/24/2023

the instructor teaches from scratch. I could get along with every section of the course. in short perfect for me in all ways ↕️

By Akash A on 11/12/2023

The course was good that it made me clear about the topic i was confused. The basic topics are well taught.The only thing is you can add some more subqueuries to make it understandable and some assignments that can make people think and practice .

By Ștefan George Alexandru on 11/7/2023

Really useful and well explained. You can add homework sections to each chapter to make the course more interactive. Congratulations.

By Ashish Sonkar on 10/31/2023

It was nice journey and also i like the way you explained i.e. firstly theory and then hands-on experience that actually how queries execeute.

By Manisha Bandala on 10/24/2023

yeah, It's good. But expecting in detail.

By Muhammad Ahmed on 9/17/2023

It was a great learning course for the beginner. It clear my giant concepts in the blink of an eye

Showing all 10 reviews on CourseDuck

Read all 202 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 88 / 100