SQL and RDBMS

Database management systems

4.55 (41 reviews)
Udemy
platform
English
language
Other
category
instructor
2,917
students
3.5 hours
content
Apr 2019
last update
$54.99
regular price

What you will learn

DBMS,SQL syntaxes, PL/SQL, theory of DBMS,FUNCTIONS,PACKAGES, Stored Procedures,JOINS

Description

Basics of DBMS and SQL queries, how to write select, insert and update queries , how to write PL/SQL blocks , procedures , functions and triggers, basics of ER diagram and designing the table structure from it. Apart from these you will learn about Codd rules and why it is important. Difference between DBMS and RDBMS. Hands on explanations along with assignments forms the course content.

Content

RDBMS and SQL an introduction

Relational databases and Codd rules

ER diagram with an example

Database Design using ER diagram
Demo on creating tables, constraints, alter table
Handling cardinality ratios in ER diagram

Normalization of tables

Normal Forms

Table joins

Various joins with examples

Relational algebra basics

Relational algebraic operations, SELECT,PROJECT and JOINS
Test your knowledge on relational algebra
Grouping in relational algebra

Structured Query Language (SQL)

Demo on select query, joining tables
Update explained
Deleting data
Querying dates
Test your understanding

PL/SQL

Basic Structure of a PL/SQL block
Creating stored procedures
Stored procedures to handle exceptions
Creating Functions
Creating Triggers
Creating packages
Practice test

Screenshots

SQL and RDBMS - Screenshot_01SQL and RDBMS - Screenshot_02SQL and RDBMS - Screenshot_03SQL and RDBMS - Screenshot_04

Reviews

Parameshwaran
December 4, 2021
Absolutely great topic for learners who does not have any idea of basics of Data analysis ......BUT, I felt that instructor could have made this course bit more neat in terms of explanation. I felt instructor was switching screens numerous times (back & forth) as the presentation was not organized. Also need more clarity in terms of educational/training quality as the language sometimes put you in doubt, especially when you run through a live example and land up in an error. The last section was absolute bouncer for me hence I am rethinking if I would even need to go through a special course to understand the programming language (section 7 PL/SQL). Thank you very much for the first 6 section which went on smooth for me.

Charts

Price

SQL and RDBMS - Price chart

Rating

SQL and RDBMS - Ratings chart

Enrollment distribution

SQL and RDBMS - Distribution chart
2268302
udemy ID
3/12/2019
course created date
11/22/2019
course indexed date
Bot
course submited by