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.
After this class, students will be able to demonstrate and have the ability to manage fast-growing online transaction processing (OLTP) databases cost-effectively, keep historical data online and available, and have cold data quickly accessible with optimal performance. Be able to write effective and efficient queries with Microsoft SQL 2014/2016.- Teacher: Vincent Marshburn
- Teacher: Dawn Piper
- Teacher: Inty Saez