BDA102B — Introduction to Databases – Part 2

Topics Covered in Course

• Describe the role of database design as the foundation of a successful information system
• Describe the five phases in the Systems Development Life Cycle (SDLC)
• Design databases using the six phases in the Database Life Cycle (DBLC) framework

• Conduct evaluation and revision within the SDLC and DBLC frameworks
• Distinguish between top-down and bottom-up approaches in database design
• Distinguish between centralized and decentralized conceptual database design
• Describe the database transaction management process
• Identify the four properties of a database transaction
• Explain concurrency control and its role in maintaining database integrity
• Describe how locking methods are used for concurrency control
• Describe how stamping methods are used for concurrency control
• Describe how optimistic methods are used for concurrency control
• List and explain the ANSI levels of transaction isolation
• Describe the role of database recovery management in maintaining database integrity
• Identify the procedures involved in database performance tuning
• Describe how a DBMS processes SQL queries in each of its three phases
• Explain the role of indexes in speeding up data access
• Differentiate between a rule-based optimizer and a cost-based optimizer
• Describe some common practices used to write efficient SQL code
• Explain how to formulate queries and tune the DBMS for optimal performance
• Explain the purpose and function of distributed database management systems (DDBMSs)
• Summarize the advantages and disadvantages of DDBMSs 12-3 Describe the characteristics and components of DDBMSs
• Explain how database implementation is affected by different levels of data and process distribution
• Describe how transactions are managed in a distributed database environment
• Describe how distributed database design balances performance, scalability, and availability
• Explain the trade-offs of implementing a distributed data system
• Describe the role of business intelligence in providing comprehensive business decision support
• Describe the architecture, reporting styles, evolution, and benefits of business intelligence
• Differentiate between operational data and decision support data
• Identify the purpose, characteristics, and components of a data warehouse
• Develop star and snowflake schemas for decision-making purposes
• Describe the characteristics and capabilities of online analytical processing (OLAP)
• Describe the role and functions of data analytics and data mining
• Explain how SQL analytic functions are used to support data analytics
• Define data visualization and explain how it supports business intelligence
• Define a data lake
• Explain the role of Big Data in modern business
• Describe how the primary characteristics of Big Data go beyond the traditional “3 Vs”
• Explain how the core components of the Hadoop framework operate
• Identify the major components of the Hadoop ecosystem
• Summarize the four major approaches of the NoSQL data model
• Describe how NoSQL data models differ from the relational model
• Describe the characteristics of NewSQL databases
• Explain how a document database such as MongoDB stores and manipulates data
• Explain how a graph database such as Neo4j stores and manipulates data
• Explain the purpose of standard database connectivity interfaces
• Describe the functionality and features of various database connectivity technologies: ODBC, OLE, ADO.NET, and JDBC
• Describe how web-to-database middleware is used to integrate databases with the Internet
• Identify the services provided by web application servers
• Explain how Extensible Markup Language (XML) is used for web database development
• Describe the advantages and disadvantages of using cloud computing for the database-as-a-service model
• Describe the impact of data quality on a company’s assets and competitive position
• Describe the role of the database in supporting operational, tactical, and strategic decision making
• Describe the impact that the introduction of a DBMS has on technological, managerial, and cultural aspects of an organization
• Describe the managerial and technical roles of the database administrator
• Describe the processes and systems in the information security framework that support the three database security goals
• Identify the standards, strategies, and tools used in database administration
• Describe the impact that cloud-based data services have on the role of the DBA
• Perform various technical tasks of database administration with Oracle