Disclaimer: I am not an SQL expert. There may be ways to make these queries run more efficiently. All code is provided “as is.”
Blackboard Learn (DDA)
- SQL: Total Number of Announcements Created Per Course
- SQL: Students Who Have Not Logged In Within 7 Days
- SQL: List Courses Containing Users With A Specific Email Domain Enrolled
- SQL: List All Merged Blackboard Courses
- SQL: List All Courses Accessed by a System Role in the Last 7 Days
- SQL: Find When a User is Created
- SQL: Find Courses with the Blackboard Collaborate Original B2 in the Course Menu