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 Development. (4 Credits)

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

Prerequisites: (156-102 with a minimum grade of C and 156-110 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-108 (may be taken concurrently) with a minimum grade of C

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.

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 and 156-109 (may be taken concurrently) with a minimum grade of C

See sections of this course

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

Learn to draw business insights from data. Explore descriptive and diagnostic data analytics. Identify trends and patterns within data using Power BI. Perform statistical analysis with Excel to determine causes and correlations.

Prerequisites: 804-189 (may be taken concurrently) with a minimum grade of C and 156-110 with a minimum grade of C

See sections of this course

156-112. Predictive Analytics. (2 Credits)

Gain an introduction to predictive analytics. Learn how to use standard Python libraries to prepare and load data for predictive models, create basic visualizations, and run machine learning algorithms to predict outcomes.

Prerequisites: 156-111 (may be taken concurrently) with a minimum grade of C and 152-101 (may be taken concurrently) with a minimum grade of C

See sections of this course

156-113. Python Data Manipulation. (2 Credits)

Learn techniques to manipulate a variety of sources of data using standard Python libraries, including Pandas. Parse text and CSV files, extract data from a database, and clean and manipulate the data. Data will be output to either files or a database.

Prerequisites: 152-101 with a minimum grade of C

See sections of this course