edX courses

Querying Data with Transact-SQL

• 6 weeks long @ 4-5 hours/week

• Prerequisite: basic understanding of databases and IT systems

Content covered:

• 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