Mar 29, 2024  
Loyola Marymount University Bulletin 2022-2023 
    
Loyola Marymount University Bulletin 2022-2023 [ARCHIVED CATALOG]

AIMS 4715 Developing Business Applications Using SQL


4 semester hours

Students looking to work with data must know how to extract data from databases using SQL (Structures Query Language). Students will gain hand-on SQL experience to create databases, construct complex relational queries, develop database programs (views, transactions, triggers, functions, and stored procedures), and write Python code to issue SQL queries for analytics and application development purposes. The SQL syntax covered is supported by many popular databases, such as Oracle, MySQL, Microsoft SQL Server, and PostgreSQL. The course will cover SQL usage for common roles such as a software developer, data scientist, and a business analytics manager.

Prerequisites: ACCT 3140  or BCOR 2710 ; and AIMS 3710 , all with a grade of C- (1.7) or higher.