About this Program
Business intelligence is a discipline that relies on ready access to a huge volume of stored data in well-structured databases. In this three-course certificate program, you’ll learn how to build and manage the databases and infrastructure for your organization’s business intelligence operations.
We’ll explore the entire life cycle of database development, from defining business requirements to analytical reporting. You’ll learn how to create, program and manage traditional relational and the newer non-relational databases, and we'll cover data migration techniques, or the ETL process — how to extract, transform and load data from one database to another. You’ll also learn how to build effective internal administrative dashboards and manage both on-site and cloud databases. All the material will come together in a comprehensive final project that you can add to your professional portfolio.
DESIGNED FOR
Those with some SQL and database experience who want to develop and expand their skills in the design and implementation of databases and BI infrastructure.
See Requirements
ADMISSION REQUIREMENTS
To apply, you must have ONE of the following:
Basic SQL and database skills, including the ability to:
Understand and use various SQL commands such as SELECT, WHERE, JOIN (INNER and OUTER), GROUP BY, HAVING and ORDER BY
Create tables and define relationships between them
Insert, update and delete data in a database using SQL commands
Understand how to create and use basic SQL views, stored procedures and functions
Successfully completed the Foundations of Databases & SQL Programming course
To help determine if you have the required SQL knowledge, consider taking this SQL self-assessment .
Time Commitment
Including time in class, you should expect to spend about 10 to 12 hours each week on coursework.
English Proficiency
If English is not your native language, you should have at least intermediate English skills to enroll. To see if you qualify, make sure you are at the B2 level on the CEFR self-assessment grid . To learn more, see English Language Proficiency Requirements – Noncredit Programs .
International Students
Because this offering is 100% online, no visa is required and international students are welcome to apply. For more information, see Admission Requirements for International Students .
Technology Requirements
Access to a Windows or Mac computer with:
A recent operating system and web browser
At least 4GB of RAM (8GB recommended)
At least 64GB hard drive space
High-speed internet connection
Headset and webcam (recommended)
Earning the Certificate
You earn a certificate of completion by successfully completing all required courses. For more information, see Earning the Certificate .
▸ Explore More : Interested in BI data analysis? Check out our Certificate in Data Analytics: Techniques for Decision Making — or find the right data program for you .
Video Overview
Randal Root, an instructor for the Certificate in Business Intelligence & Database Development, discusses the skills students will gain from this certificate for this in-demand field.
Duration: 02:43
Play
WHAT YOU’LL LEARN
Best practices for developing, testing and deploying data migration
How to identify and choose between advanced analytical data architectures
Key terms and concepts of analytical data architectures (snowflake and star schemas, OLAP, dimension and measures, data lakes and more)
Best practices in utilizing data extraction, transformation and loading techniques and technologies
GET HANDS-ON EXPERIENCE
Architect, build, deploy and manage end-to-end BI solutions using a variety of technologies (SQL, NoSQL, on-site and cloud)
Create and refine data warehouses, ETL processes and reporting infrastructure
Implement BI projects that involve the construction of various data structures
Perform ETL with SQL, Python, Integration Services and Azure Data Factory
Create dashboard reports with Excel, Power BI, Tableau and Jupyter Notebook
APPLY FOR A SCHOLARSHIP
You may be eligible to apply for a UW Certificate Scholarship or Rotary Scholarship to cover most of the costs of this program. Scholarships are awarded based on financial need and the potential of the program to positively impact your career. For more information, see the Scholarships page.
EARN DIGITAL BADGES
You can earn a digital achievement badge for successfully completing this certificate program, as well as a separate badge for each course. These badges can be shared on LinkedIn and other social media sites. Learn more about digital badges .
Career Stats
25%
Projected job growth for database architects in Washington state (2020–2030)
$134,870
Average salary for database architects in the U.S. (2022)
OUR ENROLLMENT COACHES ARE HERE TO HELP
Connect with an enrollment coach to learn more about this offering. Or if you need help finding the right certificate, specialization or course for you, reach out to explore your options .