Back to Course Catalog > Microsoft Certification > Microsoft Certified IT Professional MCITP The new Microsoft Certified IT Professional (MCITP) credential lets you highlight your specific area of expertise. An individual can distinguish themselves as an expert in database administration, database development, or data intelligence. MCITP: Database Developer Database developers design and implement relational database models (logical and physical) and database storage objects. They also program servers by using user-defined functions, triggers, stored procedures, Transact-SQL, or the CLR. They retrieve or modify data using SQL queries or tune and optimize queries. MCITP: Business Intelligence Developer Business intelligence developers design and implement multi-dimensional database models (logical and physical), data marts, data warehousing, data transforms, data analytics, and reporting solutions. MCITP: Database Administrator Database administrators install or configure Microsoft SQL Server and manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting. They also design or implement security or server automation and monitor and troubleshoot SQL Server activity. |