Database Analyst

Excel, Introduction

Learn how to create effective and efficient worksheets using formulas, common functions, formatting, and printing. Microsoft Excel is required for online classes.

Excel, Intermediate

Learn specialized functions, like IF, COUNTIF, and DSUM, and how to effectively analyze, sort, filter data, create outlines, subtotals, range names, and work with tables. Display data more visually in charts, Pivot tables, and charts and work with slicers and templates. Microsoft Excel is required for online classes.

Excel, Advanced

In this course, you will work with multiple worksheets, use LOOKUP functions and formula auditing, share and protect workbooks, automate workbook functionality with data validation and macros, create spark lines, and map data, and work with data tables, scenarios, goal seek, and forecasting data trends. Microsoft Excel is required for online classes.

Database Design

Is your database efficient and easy to work with? Learn the theory behind relational databases, entity relationship diagrams, and normalization of data and plan the design of a database.

Access, Introduction

Take away the mystery of database design in Access by creating, designing, and editing tables. Learn to create simple queries and filters and develop the skills to design simple forms and reports.

Access, Intermediate

Learn about database normalization, relationships, referential integrity, and analyzing tables. Explore complex queries with joins, parameters, calculated fields, and summarizing and grouping values. Work with action queries and finding unmatched or duplicate records. Learn to create advanced reports with calculated fields and enhanced control formatting and data bars.

SQL

This course prepares the novice database user to use generic SQL (Structured Query Language) to retrieve, store, and manipulate data from any relational database. The course will progress quickly through fundamental concepts and move into advanced SQL concepts such as nested queries, tables, and data manipulation as well as indexing.

Access, Advanced

Learn more advanced form design with sub-forms, tab pages, and navigation forms. Import, export, and link external data and perform a Word mail merge with Access data. Learn how to have a more turnkey database with macros, VBA programming, and switchboards. Learn about database management topics like dependencies, documenting, compacting, repairing, splitting, security, and converting into ACCDE.

Business Intelligence 1

Organizations use reporting tools to access data sources and generate customized reports. Crystal Reports® 2016 helps you build advanced reports with ease, presenting complex information in an understandable way. Crystal Reports® 2016 enhances report building and report processing techniques with a variety of features that add value to a presentation. In this course, you will create a basic report by connecting to a database and modifying the report's presentation.

Business Intelligence 2

The creation of data-backed visualizations is a key way a data scientist, or any professional, can explore, analyze, and report insights and trends from data. Tableau® software is designed for this purpose. Tableau® was built to connect to a wide range of data sources, and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. In this course, you will visualize data with Tableau.

SQL Server Database Services

Create queries to retrieve, add, update, and maintain database data. Work with data sorting, built-in functions, stored procedures, subqueries, table operators, set operators, conditional operators, views, indexes, and error handling features of SQL Server 2012.

Database Productivity Lab

Design a working database, queries, forms, and reports. This hands-on session provides the review and practical application needed to pull the courses in the Database Analyst Certificate Program together and fine-tune your new database management skills. You must successfully complete in order to receive the Database Analyst Certificate. Prerequisites: Access (Introduction, Intermediate and Advanced), Database Design, SQL (Introduction), Crystal Reports (Introduction), and SQL Server Database Services.

Agile Fundamentals

This course provides you with the Agile values and principles to incorporate Agile methodologies into your organization. To be successful in delivering software using Agile methods, you must have a strong and stable agile mindset. This course focuses on being Agile before doing Agile and provides a common foundation for making decisions about the best way to develop software using agile values and principles and introduces you to PMI's Agile Certified Practitioner (PMI-ACP)®. This course prepares you for the Professional Scrum Master 1 (PSM1) certification.