CCE0527 — Database & Analytics Fundament
Course discusses SQL Service Management Studio; database structure and objects in SQL Server, including versions, instances, services, system and user databases, file types, tables, views, stored procedures. Students will learn about data types and their uses, relational database design, recovery models, SQL agent. Learners will gain an understanding of indexes, execution plans, query optimizer, maintenance and best practices.