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 5794 | 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
9 Sep'23, 02:35 PM
9 Sep'23, 01:42 PM
9 Sep'23, 01:13 PM
9 Sep'23, 12:25 PM
9 Sep'23, 11:57 AM
9 Sep'23, 11:56 AM
9 Sep'23, 11:45 AM
7 Sep'23, 12:34 PM
7 Sep'23, 12:27 PM
5 Sep'23, 10:10 AM
21 Aug'23, 07:18 AM
18 Aug'23, 11:51 AM
21 Jun'23, 12:18 PM
13 Jun'23, 09:54 AM
4 Apr'23, 11:39 AM
27 Mar'23, 07:53 AM
22 Mar'23, 12:57 PM
9 Sep'23, 02:35 PM
9 Sep'23, 01:42 PM
9 Sep'23, 01:13 PM
9 Sep'23, 12:25 PM
9 Sep'23, 11:57 AM
9 Sep'23, 11:56 AM
9 Sep'23, 11:45 AM
Back to top