Database Administrator Associate Program

Course Description:

This course covers database design and the use of database management systems for applications. It includes coverage of the relational model, and SQL. It also covers XML data including DTDs and XML Schema for validation, and the query and transformation languages XPath, XQuery, and XSLT. The course includes database design in UML, and relational design principles based on dependencies and normal forms. Many additional key database topics from the design and application-building perspective are also covered: indexes, views, transactions, authorization, integrity constraints, triggers, on-line analytical processing (OLAP), JSON, and emerging NoSQL systems.

This comprehensive course offers an in-depth exploration of fundamental database concepts and cloud-based data services, bridging the gap between the Microsoft Technology Associate (MTA) Database Fundamentals and Microsoft Azure Data Fundamentals certifications. Designed for aspiring database administrators, data analysts, and cloud enthusiasts, this course provides a solid foundation in managing data both on-premises and in the cloud.

This course prepares students for the Microsoft Azure Data Fundamentals Certification Exam DP-900.

Admission Requirements:

Interview with an Admissions Counselor

Be at least 18 years of age (applicants under the age of 18 require written consent from a parent or legal guardian to enroll)

Present proof of secondary education (high school diploma or GED) or in the event the applicant is unable to provide proof of secondary education, achieve a passing score on the Wonderlic Basic Skills Test (Verbal 200 and Quantitative 210)