| Info |
|---|
edX courses are free to join. Fees charged for certification, typically $99. |
Querying Data with Transact-SQL
...
6 weeks long @ 4-5 hours/week
Prerequisite: basic understanding of databases and IT systems
...
Create Transact-SQL SELECT queries
Work with data types and NULL
Query multiple tables with JOIN
Explore set operators
Use functions and aggregate data
Work with subqueries and APPLY
Use table expressions
Group sets and pivot data
Modify data
Program with Transact-SQL
Implement error handling and transactions
...
Analyzing and Visualizing Data with Power BI
6 weeks @ 2-4 hours/week
Connect, import, shape, and transform data for business intelligence (BI)
Visualize data, author reports, and schedule automated refresh of your reports
Create and share dashboards based on reports in Power BI desktop and Excel
Use natural language queries
Create real-time dashboards
...