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.
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)
Data Warehouse / Mining and Database Administration (11.0802)
Eligible Certification Exam
Microsoft MTA Database Exam #364