SQL FUNDAMENTALS

GENBUS 760

Focuses on various technologies needed to perform data analytics. Techniques of extracting structured and unstructured data from databases, applications, or social networks. Transform and combine data with other relevant information and load into targeted systems. How to use programming languages to collect data from the web and leverage libraries for other, more, advanced data analysis.

GENBUS 746

Provides an opportunity to construct advanced SQL statements (including joins, common table expressions, window functions, etc.) and build cloud data warehouses in a variety of software vendor platforms.

GENBUS 730

Introduction to fundamentals of prescriptive analytics with emphasis on business applications. Modeling and mathematical optimization using Excel and Python. Designing, building, testing, and analyzing models, including sensitivity and risk analysis. Developing and solving optimization models, including linear, integer, and nonlinear problems. Course includes some principles of model-building and fundamentals of optimization theory but emphasizes practical application, hands-on learning, and problem-driven exercises.

INFOSYS 322

Introduction to database management systems with a focus on relational databases. Covers designing, creating, populating, managing, and retrieving data from databases. SQL will be used with a focus on querying for business applications and intelligence, data retrieval for summary reports, and data visualization. Offers a brief introduction to non-relational databases for business applications.

LIS 464

Introduces the applications of databases to real-world data and information problems. Overview of the principles and practices of user-oriented database design, management, and application. Discussion and practice cover database application lifecycle, data modeling, relational database design, SQL queries, reports and other interfaces to database data, and database documentation.