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.