| Title | Winter | Spring | Summer | Fall |
| Data Management |
Designing Relational Databases (3 units)
I&C SCI X426.81
If you need to learn more about the design of relational database systems, this course is for you. You'll explore how the relational database approach is used in both open and closed systems and on both mainframe and client/server platforms, and learn about the design of systems of all sizes including standalone, workgroup, departmental, and enterprise-wide applications. You'll also learn how to incorporate data from legacy systems as well as how to develop entirely new systems. You'll have the opportunity to design a rational database model in class and refine it for a real-world system or case study. Topics include an overview of database systems, defining business entities, entity relationship modeling (ERM) for top-down analysis, defining relational database tables and attributes, conversion of logical design to physical design, normalization of tables, and using structured query language (SQL) to process data and generate reports.
|
|
Online
|
|
to be scheduled
|
Data Modeling (2.5 units)
I&C SCI X425.32
In this course you will learn how to develop data models which are used to publish the information that organizations rely on for their day-to-day decision making processes. Basic data modeling techniques will be explored including capturing data requirements, analyzing data elements, identifying entities and attributes, and determining relationships between entities. Data models will be developed using the entity/relationship graphical model. Once a basic data model has been developed, students will be instructed on how to enhance the data model to manage and enhance the value of the data it contains. This will directly affect the quality of the information produced from the data, and provide an organization with the knowledge necessary to optimally perform its business functions. The emphasis of this course is on analysis and design rather than on the actual implementation of a database.
|
to be scheduled
|
|
Online
|
|
Data Management (2.5 units)
I&C SCI X425.35
Data may be an organization's most underrated asset. Organizations often invest a very small percentage of their budget on maintaining the health of their data, which may over time lead to decreasing competitiveness, loss of market share, and even violations of regulatory requirements. This course presents data management from an organizational perspective with the goal of using data management methodologies as a foundation for enterprise data architecture. The course concentrates on data definition and specification, data quality, data organization, data integration, and data equilibrium.
|
|
Online
|
|
to be scheduled
|
| Data Analysis |
Introduction to Big Data (2 units)
I&C SCI X425.80
Web 2.0 has changed the way we conduct business. It affects consumer interactions, information sharing, success measurement in terms of business revenue and customer wallet share, and brand management. Most importantly, it has created a revenue channel like none other. Personalization of products and services by enterprises have increased data volumes and the velocity of data production while creating a variety of data formats. We are now well and truly in the world of Big Data. The key value of this data is the vast amount of intelligence that can be found when data is modeled with geographic and demographic information. This introductory course will help students navigate through the complex layers of Big Data and Data Warehousing while providing information on how to effectively think about using these technologies and architectures to design the next-generation data warehouse. Concepts covered include an introduction to Big Data, discussion of Big Data Processing Architectures, explanation of the integration of Big Data and Data Warehouses, and fundamentals of Big Data Analytics. Examples will be used to step students through an implementation of a Big Data solution.
|
|
Online
|
|
to be scheduled
|
Big Data Analytics (2 units)
I&C SCI X425.70
“Big Data” is a reality in many industries. Very large databases of more than 100 petabytes are becoming more common with data storage and reporting technology becoming faster and easier. Successful users of big data, like Wal*Mart, Amazon, Google and others harness data in ways simply impossible 15 years ago. This course will begin with a review of some case histories of big data use. Basic elements of successful big data implementation will be covered as well as a review of commercially available tools and technology. A focus will be placed on value opportunities in online marketing, search optimization and site performance modeling. Other topics covered in the course will include database architecture as related to knowledge discovery and evaluation of the relative merits of normalized relational databases, report-oriented dimensional designs, and unstructured SQL-free systems. All students across the business, technical, and analytic spectrum are welcome.
|
|
Online
|
|
to be scheduled
|
R Programming (2 units)
I&C SCI X425.20
R is a scripting language for statistical data manipulation and analysis. R is an open source package available under GNU license at no cost. R competes with SPSS, another very well-known statistical package used heavily in many industries. Statistics is used in every part of business data processing and prediction. Data captured by web analytics services need statistics. Statistics is also the foundation of predictive analytics. R business applications include correlation, regression, hypothesis testing, and all inference testing. This course will focus on R programming which is used for solving business problems related to basic math and statistics. First, all relevant math concepts will be reviewed. This will include functions, regression, descriptive and inferential statistics, and matrix operations. All these basic math problems will be solved using R. The programmatic interface and graphic capabilities of R will also be explored. In the end, several real-world business problems will be solved using R.
|
to be scheduled
|
Online
|
Online
|
to be scheduled
|
Hadoop: In Theory and Practice (3 units)
I&C SCI X425.18
Today, organizations in every industry are being showered with imposing quantities of new information. Along with traditional sources, many more data channels and categories now exist. Collectively, these vastly larger information volumes and new assets are known as Big Data. Enterprises are using technologies such as MapReduce and Hadoop to extract value from Big Data. This course provides an in-depth overview of Hadoop and MapReduce, the cornerstones of big data processing. To crystalize the concepts behind Hadoop and MapReduce, you will work through a series of short/ focused exercises; you will configure and install a Hadoop cluster, write basic MapReduce programs, gain familiarity with advanced MapReduce programming practices, and utilize interfaces such as Pig and Hive to interact with Hadoop. You will also learn about real-world situations were MapReduce techniques can be used.
|
to be scheduled
|
Online
|
Online
|
|
| Oracle Database |
Oracle Database 12c: Introduction to SQL - Part 1 (1.5 units)
I&C SCI X442.2
Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises. This course covers creating indexes and constraints, and altering existing schema objects. Students also learn how to create and query external tables. Students learn to use the advanced features of SQL in order to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Students also learn some of the date-time functions available in the Oracle Database. This course also discusses how to use the regular expression support in SQL.
|
|
|
|
|
Oracle Database 12c: Introduction to SQL - Part 2 (1.5 units)
I&C SCI X442.3
Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises. This course covers creating indexes and constraints, and altering existing schema objects. Students also learn how to create and query external tables. Students learn to use the advanced features of SQL in order to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Students also learn some of the date-time functions available in the Oracle Database. This course also discusses how to use the regular expression support in SQL.
|
|
|
|
|
Oracle Database 12c: Administration Workshop - Part 1 (1.5 units)
I&C SCI X442.4
The Oracle Database 12c Administration Workshop will teach you about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance. Benefits to you: Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.
Hands-on demonstrations will provide you with real world experience. By engaging in hands-on exercises to reinforce your learning, you'll develop in demand skills to effectively manage an Oracle Database.
|
|
|
|
|
Oracle Database 12c: Administration Workshop - Part 2 (1.5 units)
I&C SCI X442.5
The Oracle Database 12c Administration Workshop will teach you about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance. Benefits to you: Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.
Hands-on demonstrations will provide you with real world experience. By engaging in hands-on exercises to reinforce your learning, you'll develop in demand skills to effectively manage an Oracle Database.
|
|
|
|
|
Oracle Database 12c: Backup & Recovery Workshop - Part 1 (1.5 units)
I&C SCI X442.6
This Oracle Database 12c: Backup and Recovery Workshop will teach you how to evaluate your own recovery requirements. You'll develop appropriate strategies for backup, restore and recovery procedures from provided scenarios. This course will teach you about Recovery Manager (RMAN) command line and graphical interfaces for various backup, failure, restore and recovery. Participating in extensive hands-on practices and workshops will help you gain experience in a realistic technical environment. Interactive workshops give you the opportunity to diagnose and recover from numerous failure scenarios, based on backup and recovery case studies.
|
|
|
|
|
Oracle Database 12c: Backup & Recovery Workshop - Part 2 (1.5 units)
I&C SCI X442.7
This Oracle Database 12c: Backup and Recovery Workshop will teach you how to evaluate your own recovery requirements. You'll develop appropriate strategies for backup, restore and recovery procedures from provided scenarios. This course will teach you about Recovery Manager (RMAN) command line and graphical interfaces for various backup, failure, restore and recovery. Participating in extensive hands-on practices and workshops will help you gain experience in a realistic technical environment. Interactive workshops give you the opportunity to diagnose and recover from numerous failure scenarios, based on backup and recovery case studies.
|
|
|
|
|
| Microsoft SQL Server Database |
Writing Queries Using Microsoft SQL Server (2.5 units)
I&C SCI X450.72
In this course students learn the concepts of relational databases. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Students learn to control privileges at the object and system level. This course covers creating indexes and constraints, and altering existing schema objects. Students learn to use the advanced features of SQL in order to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Students also learn some of the date-time functions available in the Oracle Database.
|
to be scheduled
|
to be scheduled
|
|
to be scheduled
|
Implementing a Microsoft SQL Server Database (2.5 units)
I&C SCI X450.79
In this course students learn how to implement a Microsoft SQL Server database. This course demonstrates how to create, populate, and use SQL Server databases to meet an organization’s needs.This course provides an overview of SQL Server databases and instructs students in how to create and secure databases, database objects, and programming components. Students will learn to create databases, tables, indexes, and views. Students will also learn to use Structured Query Language (SQL) to query, insert, update, and delete data in a SQL Server database, and to use Transact-SQL (T-SQL) to program SQL Server by writing stored procedures and user-defined functions. Finally, students will explore the use of columnstore indexes for data warehouse environments, store XML and JSON documents, store spatial and temporal data, and use full-text search in a SQL Server database.
|
to be scheduled
|
|
Online
|
|
Implementing and Maintaining SQL Server Reporting Services (2.5 units)
I&C SCI X450.77
In this course students learn how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create simple reports to very complex reports, and how to use the Report Services management and administrative tools to manage a reporting Services solution. This course covers Reporting Services architecture, reporting authoring tools to dynamically modify the data set underlying a data region by allowing parameters to be sent to the underlying query, as well as will learn to use best practices to implement static and dynamic parameter lists when interacting with queries and stored procedures.
|
to be scheduled
|
Online
|
to be scheduled
|
|
Implementing and Maintaining SQL Server Integration Services (2.5 units)
I&C SCI X450.78
In this course students learn how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages. This course covers the role that Integration Services plays in extracting, transforming, and loading data.The students will also be introduced to the tools that are used to build and manage Integration Services solutions.
|
|
|
|
|