SQL and RDBMS
Database management systems
4.55 (41 reviews)
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
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
Rating
Enrollment distribution
Related Topics
2268302
udemy ID
3/12/2019
course created date
11/22/2019
course indexed date
Bot
course submited by