Pennsylvania State University 3 credits ETI
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.
Our subject experts help with essays, research papers, case studies, discussion posts, and capstone projects for these programs β written from scratch to your course requirements.
Program and course information is reproduced from each university's published academic catalog for informational purposes and may change. Always confirm current requirements with your university. We are an independent academic support service and are not affiliated with or endorsed by the universities listed.
Expert guides on essay writing, citation styles, study skills, and academic success.
View All Articles
Learn how to write a good research question for a paper. Narrow your topic, identify a research problem, and create a focused question with practical examples.
Learn how to choose a research topic you can actually research. Discover how to narrow broad ideas, find reliable sources, and develop a focused research question.
Learn how to cite sources in a research paper using APA, MLA, and Chicago styles, with in-text citation examples and reference-list tips.