This course aims to identify, assess and evaluate risk to enable the execution of the enterprise risk management strategy; develop and implement risk responses to ensure that risk factors and events are addressed in a cost-effective manner and in line with business objectives; monitor risk and communicate information to the relevant stakeholders to ensure the continued effectiveness of the enterprise’s risk management strategy; design and implement information systems controls in alignment with the organization’s risk appetite and tolerance levels to support business objectives; monitor and maintain information systems controls to ensure they function effectively and efficiently; and achieve professional qualification as Certified in Risk and Information Systems Control (CRISC).

In this class, you will explore options that range from personal desktop databases to large-scale geographically distributed database servers and classic relational databases to modern document-oriented systems and data warehouses. You will cover key terminology and concepts, such as normalization, "deadly embraces" and "dirty reads," ACID and CRUD, referential integrity, deadlocks, and rollbacks. The course also explores data modeling systematically through hands-on examples to design the best system for your data. You will learn new real time hybrid transactional/analytical professing. You will combine in-memory column store and row store capabilities in MS SQL Server 2016 for real-time operational analytics—fast analytical processing right on your transactional data. Open up new scenarios like real-time fraud detection without impacting your transactional performance.