Database Specialist (156)

156-101. .Net Database Programming. (3 Credits)

Learn basic C# methodologies, including classes, objects, types and the difference between value and reference. Apply object-oriented methodologies and utilize constructors, and inheritance and class hierarchies. Also become familiar with Common Language Runtime (CLR) techniques for using .Net code natively in MS SQL Server.

Prerequisites: (152-107 with a minimum grade of C or 152-138 with a minimum grade of C or 152-134 with a minimum grade of C) and 804-133 (may be taken concurrently) with a minimum grade of C and 152-115 (may be taken concurrently) with a minimum grade of C and (107-102 (may be taken concurrently) with a minimum grade of C or 154-135 (may be taken concurrently) with a minimum grade of C)

See sections of this course

156-102. Advanced SQL. (3 Credits)

Learn various advanced SQL topics for MS SQL Server, including temporary tables, triggers, advanced stored procedures and user-defined functions. Develop skills in optimization, indexing and other performance-tuning tools and techniques. Explore advanced database design by researching differences between OLTP and OLAP; expand knowledge of DML statements including MERGE; implement windowing functions; and use XML queries and schemas. Additionally, get an introduction to Extract-Transform-Load (ETL) concepts.

Prerequisites: 152-115 with a minimum grade of C and 156-107 with a minimum grade of C

See sections of this course

156-103. Database Administration. (3 Credits)

Learn to configure SQL Server, security for users and data, and backup and recovery options. Implement high availability and disaster recovery configurations as well as appropriate hardware configuration for various database environments. Research import and export options for data; review performance monitoring tools and how to apply them; identify and resolve common performance and security issues; and discuss common maintenance needs and how to perform them.

Prerequisites: (150-136 with a minimum grade of C or 150-137 with a minimum grade of C) and 150-150 with a minimum grade of C and (150-154 with a minimum grade of C or 152-107 with a minimum grade of C)

See sections of this course

156-104. Data Analysis and Reporting. (3 Credits)

Learn to create and manage reports in a variety of reporting tools, explore the uses of data visualizations, implement self-service BI solutions, and query a variety of data sources, including data cubes. Draw business insights from data analysis, and evaluate data for accuracy and objectivity.

Prerequisites: (152-115 with a minimum grade of C and 804-189 with a minimum grade of C)

See sections of this course

156-105. Advanced Topics in Database. (3 Credits)

Research current database trends in the industry. Topics covered may include big data, cloud solutions such as Azure or AWS, in-memory databases, mobile databases, or other emerging database technologies.

Prerequisites: (156-103 with a minimum grade of C)

See sections of this course

156-106. Data Warehouse Design. (4 Credits)

Discuss data cleansing, ETL & data synchronization strategies, data warehouse design/implementation, including star and snowflake schemas, and the creation of business intelligence (BI) solutions. Students will work together to implement a functional data warehouse start to finish, including design implementation, ETL, and a self-service BI solution.

Prerequisites: (156-102 with a minimum grade of C and 156-104 with a minimum grade of C)

See sections of this course

156-107. Data Modeling. (2 Credits)

Discover concepts of relational databases through data modeling. Learn about entities, attributes, relationships and the different types of keys in a database, and create conceptual, logical and physical data models for a variety of data types. Get an in-depth explanation of relational and dimensional models, and use Microsoft Access to query data.

Prerequisites: (Computer Skills Assessment 070 or College Profi - Comp Skills or Work Experience - Comp Skills or 860-702 with a minimum grade of S)

See sections of this course