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-134 with a minimum grade of C or 152-112 with a minimum grade of C or 152-138 with a minimum grade of C) and (152-115 with a minimum grade of C or 156-109 with a minimum grade of C)

See sections of this course

156-102. Advanced SQL. (3 Credits)

Learn various advanced SQL topics for 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, implement windowing functions, perform data integration using triggers and merge statements, and create and parse JSON and XML.

Prerequisites: 156-109 with a minimum grade of C or 152-115 with a minimum grade of C

See sections of this course

156-103. Database Administration. (3 Credits)

Learn to install, configure and secure Microsoft SQL Server. Discuss recurring maintenance needs and perform common maintenance tasks. Plan server configurations for various database environments and implement high availability/disaster recovery configurations. Explore methods for monitoring server performance and identify and resolve common security and performance issues.

Prerequisites: 150-136 with a minimum grade of C or 150-137 (may be taken concurrently) 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 and 152-115 with a minimum grade of C and 107-119 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-107 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: 156-109 with a minimum grade of C

Credit for prior learning available

See sections of this course

156-108. Intro to Databases & Reporting. (1 Credit)

Gain an introduction to relational databases, queries and reports. Use Microsoft Access to build queries and reports. Gain an understanding of SELECT queries, joins, reporting and the basics of relational database design.

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

See sections of this course

156-109. Intro to SQL. (2 Credits)

Gain an introduction to Structured Query Language (SQL) through real-world scenarios. Learn SQL, including joins, aggregate functions, subqueries and the basics of security and permissions. Revisit database design and use table creation/data management commands.

Prerequisites: 156-108 (may be taken concurrently) with a minimum grade of C

See sections of this course

156-110. Data Visualization & Reporting. (2 Credits)

Learn to create and manage reports in a variety of reporting tools, and explore the uses of data visualizations. Learn to implement self-service BI solutions and query a variety of data sources. Tools used include SQL Server Reporting Services, Power BI and Excel.

Prerequisites: 156-107 with a minimum grade of C

See sections of this course

156-111. Intro to Data Analysis. (2 Credits)

Learn to draw business insights from data through analysis. Identify patterns in data, perform basic statistical data analysis and evaluate data for accuracy and objectivity. Tools include Excel and Tableau.

Prerequisites: 804-189 with a minimum grade of C and 156-110 with a minimum grade of C

See sections of this course

156-112. Advanced Topics in Data. (2 Credits)

Research current trends in data, including big data, machine learning, NoSQL databases and other emerging data technologies and trends. Work with a team to develop a project proposal and proof-of-concept. Learn to present proposals and project outcomes.

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

See sections of this course