BAN5501
DATA MGMT & SQL FOR ANALYTICS
- Department
- Business Analytics
- Terms offered
- 13
- Data refreshed
- Jun 30, 2026
Description
This course serves as an introduction and overview of the database management body of knowledge (DMBOK) from a managerial perspective. The learning objectives will be to acquire a comprehensive understanding of the basic concepts of database design and usage, as well as develop practical skills for utilizing databases to their fullest extent. Correct database design will be emphasized both as a theoretical foundation and a practical necessity. The following topics are the focus of the course: High-level, general database concepts and design Design, create and manipulate an individual relational database including the utilization of SQL as a fundamental tool Interpret and apply client database needs Discuss and apply best practices of User Interface Design to database applications Identify and discuss new developments and trends in databases including the use of data warehouses, data lakes and hubs, and X analytics.
Syllabi
Sign in to view syllabi.
Offerings and forecast 2020–2026
| Year | Fall | Spring | Summer | Intersession |
|---|---|---|---|---|
| 2030 | 2030 Fall: 66% chance, medium confidence. Offered in every fall term since 2020. Department course count rising about 10% per year. | 2030 Spring: 52% chance, medium confidence. Offered in every spring term since 2021. Department faculty is about 22% below its recent average. | 2030 Summer: 7% chance, medium confidence. Offered in 0 of 9 summer terms since 2018. | 2030 Intersession: 8% chance, medium confidence. Offered in 0 of 6 intersession terms since 2020. |
| 2029 | 2029 Fall: 69% chance, medium confidence. Offered in every fall term since 2020. Department course count rising about 8% per year. | 2029 Spring: 62% chance, medium confidence. Offered in every spring term since 2021. Section count rising about 1% per year over 2 terms. Department course count rising about 5% per year. Department faculty is about 19% below its recent average. | 2029 Summer: 6% chance, medium confidence. Offered in 0 of 10 summer terms since 2017. | 2029 Intersession: 7% chance, medium confidence. Offered in 0 of 7 intersession terms since 2017. |
| 2028 | 2028 Fall: 73% chance, medium confidence. Offered in every fall term since 2020. Department course count rising about 7% per year. | 2028 Spring: 65% chance, medium confidence. Offered in every spring term since 2021. Section count rising about 1% per year over 3 terms. Department course count rising about 5% per year. Department faculty is about 19% below its recent average. | 2028 Summer: 5% chance, medium confidence. Offered in 0 of 11 summer terms since 2016. | 2028 Intersession: 7% chance, medium confidence. Offered in 0 of 7 intersession terms since 2017. |
| 2027 | 2027 Fall: 76% chance, medium confidence. Offered in every fall term since 2020. Department course count rising about 7% per year. | 2027 Spring: 69% chance, medium confidence. Offered in every spring term since 2021. Section count rising about 1% per year over 4 terms. Department course count rising about 5% per year. Department faculty is about 19% below its recent average. | 2027 Summer: 5% chance, high confidence. Offered in 0 of 12 summer terms since 2015. | 2027 Intersession: 6% chance, medium confidence. Offered in 0 of 7 intersession terms since 2017. |
| 2026 | 2 sections | 1 section | Not offered | No data |
| 2025 | 2 sections | 2 sections | Not offered | Not offered |
| 2024 | 2 sections | 2 sections | Not offered | Not offered |
| 2023 | 2 sections | 2 sections | Not offered | Not offered |
| 2022 | 2 sections | 2 sections | Not offered | Not offered |
| 2021 | 1 section | 1 section | Not offered | Not offered |
| 2020 | 1 section | Not offered | Not offered | Not offered |
Meeting times
Recent first- Wed, 6:00 PM–9:00 PM ASEC303 20262025-1
- Thu, 6:00 PM–9:00 PM Carlson Hall CH231 20262025-12024
- Thu, 2:50 PM–5:50 PM MACD002 2025-2
- Fri, 9:00 AM–11:50 AM Carlson Hall CH128 2025-22023
- Tue, 6:00 PM–9:00 PM ONLINE 20222021
| Term | Professor | Type | Credits | Enrollment | CRN |
|---|---|---|---|---|---|
| Fall 2026 | Abdullah Asilkalkan | Seminar/Proseminar | 1 | 5 of 20 enrolled | 22022 |
| Fall 2026 | Abdullah Asilkalkan | Seminar/Proseminar | 1 | 10 of 25 enrolled | 21053 |
| Spring 2026 | Abdullah Asilkalkan | Seminar/Proseminar | 1 | 29 of 30 enrolled | 31267 |
| Fall 2025 | Abdullah Asilkalkan | Seminar/Proseminar | 1 | 29 of 30 enrolled | 21053 |
| Fall 2025 | Abdullah Asilkalkan | Seminar/Proseminar | 1 | 16 of 30 enrolled | 22022 |
| Spring 2025 | Abdullah Asilkalkan | Seminar/Proseminar | 1 | 24 of 30 enrolled | 31267 |
| Spring 2025 | Abdullah Asilkalkan | Seminar/Proseminar | 1 | 16 of 30 enrolled | 32044 |
| Fall 2024 | Abdullah Asilkalkan | Seminar/Proseminar | 1 | 28 of 30 enrolled | 21053 |
| Fall 2024 | Abdullah Asilkalkan | Seminar/Proseminar | 1 | 19 of 30 enrolled | 22022 |
| Spring 2024 | Theyab Alhwiti | Online | 1 | 35 of 40 enrolled | 32044 |
| Spring 2024 | Abdullah Asilkalkan | Seminar/Proseminar | 1 | 40 of 40 enrolled | 31267 |
| Fall 2023 | Abdullah Asilkalkan | Seminar/Proseminar | 1 | 26 of 30 enrolled | 21053 |
| Fall 2023 | Hari C. Krishna | Seminar/Proseminar | 1 | 27 of 30 enrolled | 22022 |
| Spring 2023 | Kathy S. Fogel | Seminar/Proseminar | 1 | 31 of 40 enrolled | 31267 |
| Spring 2023 | Theyab Alhwiti | Seminar/Proseminar | 1 | 40 of 40 enrolled | 32044 |
| Fall 2022 | Hari C. Krishna | Seminar/Proseminar | 1 | 23 of 30 enrolled | 21053 |
| Fall 2022 | Kathy S. Fogel | Seminar/Proseminar | 1 | 20 of 30 enrolled | 22022 |
| Spring 2022 | Becky L. Frieden | Online | 1 | 18 of 30 enrolled | 32044 |
| Spring 2022 | Becky L. Frieden | Online | 1 | 40 of 40 enrolled | 31267 |
| Fall 2021 | Becky L. Frieden | Online | 1 | 31 of 30 enrolled | 28162 |
| Spring 2021 | Becky L. Frieden | Seminar/Proseminar | 1 | 26 of 40 enrolled | 38650 |
| Fall 2020 | Becky L. Frieden | Seminar/Proseminar | 1 | 15 of 30 enrolled | 28162 |