ISBA 4715

Course Description

This course introduces the use of SQL for creating and interacting with relational databases as well as for developing applications using application program interfaces and query programming languages. Students will gain hands-on experience in server level database installation, use of query languages for database creation, manipulation and information retrievals, and web-based applications that would interact with back-end databases for data and information management.

Prerequisites

BCOR 2710 and ISBA 3710 with a grade of C- or higher

Course Learning Outcomes

• Become a data analyst: use SQL for data exploration and analysis
• Become a data engineer: use modern technologies to extract, transform, and load data
• Become a data professional: communicate data findings to both technical and non-technical audiences

ISBA Major Learning Outcomes

• Utilize competencies gained from hands-on experience in core information technologies including programming languages, database management systems and other software used to create and store data, interact with databases in a SQL environment and develop database applications through web and mobile interfaces
• Apply critical thinking and problem-solving skills when analyzing business problems
• Identify problems, structure problems, propose an IT solution, and solve the problem
• Develop proficiency in one or more mainstream programming language, such as SQL, PHP, JavaScript, and Python
• Effectively communicate complex technological concepts including oral communications and written communications

Required Materials

No textbook required. Optional references available through the library's O'Reilly subscription:

• "Learning SQL" 3rd Edition by Beaulieu
• "Fundamentals of Data Engineering" by Reis & Housley

Software and Tools:

• DBeaver Community Edition (database client)
• Microsoft Teams
• Cursor IDE
• Claude Code
• MySQL
• PostgreSQL
• AWS RDS
• Airbyte
• GitHub
• dbt
• Visualization tools: Looker / Tableau / Power BI / Streamlit

Work Load Expectations

Per LMU's Credit Hour Policy, one credit hour requires a minimum of 3 hours of work per week. For this 4-credit course, expect approximately 12 hours of total weekly effort. With 200 minutes of class time per week, plan for 8-9 hours of outside work.

Grade Breakdown

Grading Scale

AI Policy

AI tools like ChatGPT and GitHub Copilot are permitted in this course as learning aids. However, you must understand and be able to explain any AI-assisted work you submit.

Attendance & Participation

If you feel ill, please stay home to keep others safe and recover. If an unexpected obligation arises that prevents you from attending class, please let me know before class or within 12 hours after the class start time.

I get there are emergencies or things that come up. Do your best to tell me in advance (at least a day before, if possible). I'm most concerned about you communicating and keeping me in the loop.

Each undocumented absence is -2% of your total class grade.

Assignment Submission

All assignments must be submitted through the designated platform (Brightspace) by the specified deadline. Late submissions will be penalized 10% per day unless prior arrangements have been made with the instructor. Technical issues are not valid excuses for late submissions. Plan ahead and submit early. Extensions may be granted in cases of documented emergencies.

Academic Honesty

Academic integrity is fundamental to the mission of Loyola Marymount University. All students are expected to adhere to the LMU Academic Honesty Policy. Violations include but are not limited to: plagiarism, cheating on exams, unauthorized collaboration, and fabrication of sources. Any violation will result in disciplinary action, which may include failure of the assignment, failure of the course, and/or referral to the Dean of Students.

Accommodations

Students with disabilities who require accommodations should contact Disability Support Services (DSS) to establish eligibility and coordinate appropriate accommodations. Please provide the instructor with your accommodation letter as early as possible so we can work together to support your learning. All discussions will remain confidential.

Syllabus Changes

This syllabus is subject to change based on the needs of the class. Any changes will be announced in class and posted on Brightspace. Students are responsible for staying informed of any modifications to the course schedule, assignments, or policies.

Exams & Quizzes

There are no make-up exams or quizzes. If you miss an exam or quiz due to a documented emergency, contact the instructor as soon as possible to discuss options.

Electronic Devices

Laptops and tablets are permitted for note-taking and class activities. Please silence your phone and avoid non-class-related browsing during class time. If device use becomes disruptive, the instructor reserves the right to restrict their use.

Title IX & Reporting

LMU is committed to creating a safe and supportive environment for all students. If you experience or witness sexual harassment, sexual assault, domestic violence, dating violence, or stalking, please know that help is available. You can report incidents and find resources through LMU Cares. Faculty members are required to report incidents to the Title IX office.

Emergency Preparedness

In case of emergency, follow the instructions of your instructor and building emergency personnel. Familiarize yourself with the nearest exits and emergency procedures. For campus emergency information, visit lmu.edu/emergency. Sign up for LMU Alerts to receive emergency notifications.