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.
Registering at least three weeks prior to the course start date is highly recommended.
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 2024
-
Section
001 -
Semester
Summer 2024 -
Date
Aug 7 - Aug 21 -
Day
Wednesday -
Time
6:00PM-9:00PM -
Sessions
3 -
Faculty
Vajjhala, Amarendra -
Location
Instructor Led
-
-
-
Section
2 -
Semester
Spring 2024 -
Date
Apr 3 - Apr 17 -
Day
Wednesday -
Time
6:00PM-9:00PM -
Sessions
3 -
Faculty
Vajjhala, Amarendra -
Location
Instructor Led
Tuition $400 -