Tóm tắt nội dung

Contents: Introduction to databases: Databases and database user; database system concepts and architecture. Conceptual data modeling and database design: Data modeling using thê entity - relationship (ER) model; th enhanced entity - relationship (EER) model. The relational data model and SQL: The relational data model and relational database constraints; basic SQL; more SQL: Complex queries, triggers, views, and schema modification; the relational algebra and relational calculus; relational database design by ER - and EER - to - Relational mapping. Database programming techniques: Introduction to SQL programming techniques; web database programming using PHP. Object, object - relational, and XML: Concepts, models, languages, and standards: Object, object - relational databases; XML: Extensible markup language. Database design theory and normalization: Basics of functional dependencies and normalization for relational databases; relational databases design algorithms and further dependencies. File structures, hashing, indexing, and physical database design: Disk storage, basic file structures, hashing, and modern storage architectures; indexing structures for files and physical database design.Query processing and optimization: Strategies for query processing; query optimization. Transaction processing, concurrency control, and recovery: Introduction to transaction processing concepts and theory; concurrency aontrol techniques; database recovery techniques. Distributed databases, NOSQL systems, and Big Data: Distributed database concepts; NOSQL databases and Big Data storage systems; Big Data technologies based on mapreduce and hadoop. Advanced database models, systems, and applications: Enhanced data models: Introduction to active, temporal, spatial, multimedia, and deductive databases; introduction to information retrieval and web search; data mining cocepts; overview of data warehousing and OLAP. Additional database topics: Security: Database security.