edX courses

By Timothy Hitchcock

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

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

Related content