ETI 461Database Management and Administration

3 credits · Enterprise Technology Integration · Penn State

A study of advanced topics in database management systems that are fundamental to effective administration of modern enterprise information systems. The objective of the course is to enable a student to comprehend a range of issues in modern database management and administration. The students will learn advanced SQL, database system development lifecycle topic that include: database planning, requirements and design, database selection and application design, prototyping, implementation, testing operational and maintenance; database performance tuning concepts, monitoring the system for improved performance, and DBMS performance tuning; database transaction management covering transactions and the ACID properties, concurrency control techniques, and database recovery management; query processing and optimization techniques via query decomposition and optimization options; introduction to distributed processing and distributed database concepts, components and characteristics of DDBMS, and distributed database design; web connectivity technologies and XML; introduction to Business intelligence and data warehouses; introduction to Big data, NOSQL and cloud databases; and database security and database administration.