Home » Course Layouts » Free Course Layout Udemy
Database Management System (ArsDigita University). Instructor: Ravi Jasuja.
0
2
English
English [CC]
- Learn basic syntax that can apply to any language.
- Learn what is a programming language and the basic concepts for beginners.
- Understand what is Javascript in it's truest form.
- Know the basic syntax of Javascript.
- Know some hidden quirks in Javascript.
Description
A more formal approach to Relational Database Management Systems, compared the way they were covered during Web Applications. Database systems are discussed from the physical layer of B-trees and file servers to the abstract layer of relational design. Also includes alternative and generic approaches to database design and database management system including relational, object-relational, and object-oriented systems, SQL standards, algebraic query languages, integrity constraints, triggers, functional dependencies, and normal forms. Other topics include tuning database transactions, security from the application perspective, and data warehousing. (from ADUni.org)
Course content
- Lecture 01 – Overview, Query Processing, Embedded SQL, Cursors, Triggers Unlimited
- Lecture 02 – Relational Algebra, Relational Calculus Unlimited
- Lecture 03 – Entity Relationship Diagrams Unlimited
- Lecture 04 – RDBMS Memory and Disk Storage, RAID, Buffer Management Unlimited
- Lecture 05 – Unordered/Sorted/Hashed Files, Indexes Unlimited
- Lecture 06 – Index Sequential Access Method, B+ Trees Unlimited
- Lecture 07 – Static and Dynamic Hashing Indexing Unlimited
- Lecture 08 – External Sorting, Merge Sort, Double Buffering, Replacement Sort Unlimited
- Lecture 09 – Query Optimizers, Query Evaluation Unlimited
- Lecture 10 – Normal Forms Unlimited
- Lecture 11 – Query Analysis and Optimizing in Oracle Unlimited
Instructor
