This course focuses on the role of business analytics in facilitating implementation of business process changes and how to appropriately use analytic tools.
- Teacher: Cengage Unlimited
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
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.
- Teacher: Juan Balette
Upon completion of the Master of Information Technology Degree Program, students are prepared for executive positions in the field of Information Technology Management. This Master Degree aims to provide training in cutting edge information technology for IT professionals wishing to upgrade their qualifications and/or skills. The program gives the student a global knowledge in the areas of information technology and communications for the creation, transformation and development of organizations oriented to manage an adequate knowledge and appropriation of the technological advancements to sustain their business development in a highly global, interconnected competitive world. Students will gain the knowledge and skills necessary to learn the importance of data and information in today’s digital world and the processes to protect it.