Database Management Using SQL
Most HR data lives in organized collections of tables called relational databases. Querying and aggregating data from these databases by using SQL (Structured Query Language) enable analytics to be performed on multiple data sets very quickly and efficiently. As an experienced HR professional, this course will equip you to use SQL to query data from relational databases. This course assumes no knowledge of SQL. The focus will be on hands-on learning, using HR data to work through typical examples encountered when working in the fast-growing discipline of people analytics. Topics will include running basic queries, generating statistics, and querying multiple tables.
You'll Walk Away with
- The ability to query a database using SQL to extract data for downstream analysis
- The skills to use SQL to apply functions that generate aggregate and group statistics on large data sets
- The ability to connect multiple tables by using join functions in SQL
- The skills to troubleshoot common errors associated with SQL queries
Ideal for
- Experienced human capital management professionals
- Those interested in furthering their career in the field of human resources
1 section
-
Summer 2023
-
Section
001 -
Semester
Summer 2023 -
Date
Aug 9 - Aug 23 -
Day
Wednesday -
Time
6:00PM-9:00PM -
Sessions
3 -
Faculty
TBA -
Location
Instructor Led
-
-
-
Section
2 -
Semester
Spring 2023 -
Date
Feb 23 - Mar 9 -
Day
Thursday -
Time
6:00PM-9:00PM -
Sessions
3 -
Faculty
Jahanshahi, Maryam -
Location
Instructor Led
Tuition $400 -