Search Colleges, Exams, Schools & more
Interested in this College?
Get updates on Eligibility, Admission, Placements Fees Structure
CompareGet updates on Eligibility, Admission, Placements Fees Structure
Quick Facts
| Medium Of Instructions | Mode Of Learning | Mode Of Delivery |
|---|---|---|
| English | Self Study | Video and Text Based |
Courses and Certificate Fees
| Fees Informations | Certificate Availability | Certificate Providing Authority |
|---|---|---|
| INR 5793 | yes | Stanford |
The Syllabus
- Introduction to the relational model and concepts in relational databases and relational database management systems
- Comprehensive coverage of SQL, the long-accepted standard query language for relational database management systems
- Creating indexes for increased query performance
- Using transactions for concurrency control and failure recovery
- Database constraints: key, referential integrity, and "check" constraints
- Database triggers
- How views are created, used, and updated in relational databases
- Authorization in relational databases
- Star schemas, the data cube concept, and On-Line Analytical Processing (OLAP) features in relational databases including the Cube and Rollup operators
- The SQL standard for queries over recursively-defined relations
- Relational algebra – the algebraic query language that provides the formal foundations of SQL
- Dependency theory and normal forms in relational databases as the basis of schema design
- The data-modeling component of the Unified Modeling Language (UML), how UML diagrams are translated to relations
- The XML model for semistructured and self-describing data, including DTDs and some features of XML Schema
- The JSON model for human-readable structured or semistructured data
- The XPath language for processing XML data, and many features of the more advanced XQuery language
- An introduction to the XSLT rule-based language for querying and transforming XML data
Instructors
Articles
21 Oct'23, 04:32 AM
20 Oct'23, 11:58 AM
20 Oct'23, 10:15 AM
20 Oct'23, 09:05 AM
20 Oct'23, 07:04 AM
19 Oct'23, 11:49 AM
19 Oct'23, 10:50 AM
19 Oct'23, 07:23 AM
19 Oct'23, 06:55 AM
19 Oct'23, 06:09 AM
3 Oct'23, 01:37 PM
27 Sep'23, 06:16 PM
27 Sep'23, 10:15 AM
22 Sep'23, 08:39 AM
21 Sep'23, 10:20 AM
20 Sep'23, 12:05 PM
20 Sep'23, 11:15 AM
21 Oct'23, 04:32 AM
20 Oct'23, 11:58 AM
20 Oct'23, 10:15 AM
20 Oct'23, 09:05 AM
20 Oct'23, 07:04 AM
19 Oct'23, 11:49 AM
19 Oct'23, 10:50 AM
19 Oct'23, 07:23 AM
19 Oct'23, 06:55 AM
19 Oct'23, 06:09 AM
Back to top