Information Systems &Technologies Applications (ISTA)

Courses

ISTA 210  Database Fundamentals  3 Credits

This course introduces database concepts and programming using SQL. Students are introduced to SQL server and data warehouse fundamental principles. Key topics include an introduction to relational databases, SQL syntax, and DML. This course is part of a set of five related ISTA courses that make up the Data Base and Business Intelligence Administrator specialization's technical content.

ISTA 220  Programming in C#  3 Credits

An introduction to applications programming in C# including a coverage of the Visual Studio development environment. Key topics including C# syntax, variables, types, expressions, classes, and interfaces are introduced leading to a final application project. This course is part of a set of five related ISTA courses that make up the Cloud Applications Developer specialization's technical content.

ISTA 230  Networking and Server Fundamentals  3 Credits

This course introduces the fundamentals of network server architectures using the installation and configuration processes of Windows Server as a framework. It provides an in-depth examination of server architectures, performance tuning, and resource access and allocation controls. Using online labs, projects and other activities derived from Microsoft Official Course 70-410, Installing and Configuring Windows Server course, the student conducts a variety of server installation and configuration activities, while building the conceptual and practical knowledge and skills necessary for server and cloud administration. Required course materials include time-sensitive license vouchers that students must have to participate in the course. The course prepares students to take the associated Microsoft Certification exam, which is incorporated as the course Final Exam. Students must take this exam at a Microsoft-approved test proctor facility; see the Master Textbook List for further information.Prerequisites: Passing score on Microsoft Technology Associate (MTA) Network Fundamentals exam.

ISTA 310  SQL Server Administration and T-SQL  3 Credits

This course is building upon fundamental database concepts and focuses on methods for inputting, retrieving and updating database information using T-SQL and DML. This course is part of a set of five related ISTA courses that make up the Data Base and Business Intelligence Administrator specialization's technical content.

ISTA 312  Implementing Data Warehouses and Databases  3 Credits

This course provides an introduction to practical techniques for building and using a data warehouse using SQL server. Topics include dimensioning a warehouse, extracting, transforming and controlling the flow of data as well as the use of SSIS. This course is part of a set of five related ISTA courses that make up the Data Base and Business Intelligence Administrator specialization's technical content.

ISTA 320  Advanced Web Apps Development  3 Credits

In this course the students will learn the more advanced programming skills and techniques that they can use to optimize their Windows Store app and differentiate their app from other apps in the Windows Store. These advanced skills and techniques include a combination of both design and development skills. The students will also learn about supporting the apps that they have published to the Windows Store. This course is part of a set of five related ISTA courses that make up the Cloud Applications Developer specialization's technical content. Prerequisite: ISTA 220, or the approval of the Program Chair.

ISTA 322  Developing ASP.NET Web Applications  3 Credits

This course prepares students to develop dynamic Web applications using the .NET framework. Students are introduced to Web architecture and the MVC (Model-View-Controller) model and employ the Microsoft Web Technologies stack within the course project in order to develop a dynamic Web application. This course is part of a set of five related ISTA courses that make up the Cloud Applications Developer specialization's technical content. Prerequisite: ISTA 320, or the approval of the Program Chair.

ISTA 330  Windows Server Configuration and Management  3 Credits

This course is part two of a three part series that provides the skills and knowledge necessary to implement a core Windows Server infrastructure in an existing enterprise IT environment. Building on the concepts and technologies covered in ISTA 230, this course provides a deeper, more detailed focus on the provisioning and systems administration tasks necessary to maintain a Windows Server infrastructure such as configuring and troubleshooting name resolution, user and group management, and implementing remote access solutions in the context of establishing and maintaining network access protection and data security. Deployment and maintenance of server images, as well as update management and monitoring of Windows Server environments, complete the course. This course incorporates materials from Microsoft Official Course 70-411, Administering Windows Server; required course materials include time-sensitive license vouchers that students must have to participate in the course. The course prepares students to take the associated Microsoft Certification exam, which is incorporated as the course Final Exam. Students must take this exam at a Microsoft-approved test proctor facility; see the Master Textbook List for further information.Prerequisites: ISTA 230.

ISTA 332  Configuring Advanced Windows Server Services  3 Credits

This course examines how to achieve a variety of IT systems performance, continuity of operations and disaster recovery capabilities in the context of Windows Server infrastructures. As the third of a three-course sequence, it combines fundamental concepts and skills used to deploy, provision and manage server systems and infrastructures with a hands-on approach to information risk management. This course focuses extensively on advanced networking services, Active Directory Domain Services (AD DS), Active Directory Rights Management Services (AD RMS), Active Directory Federation Services (AD FS), as part of implementing strategies to achieve network load balancing, failover clustering, business continuity, and disaster-recovery services. This course also covers access and information provisioning, and protection technologies such as Dynamic Access Control (DAC), and Web Application Proxy integration with ADFS and Workplace Join. This course incorporates materials from Microsoft Official Course 70-412, Configuring Advanced Windows Server Services; required course materials include time-sensitive license vouchers that students must have to participate in the course. The course prepares students to take the associated Microsoft Certification exam, which is incorporated as the course Final Exam. Students must take this exam at a Microsoft-approved test proctor facility; see the Master Textbook List for further information.Prerequisite: ISTA 330.

ISTA 410  Data Modeling and Reporting  3 Credits

An introduction to multidimensional and tabular data models including customization, maintenance, reporting, and data delivery. This course is part of a set of five related ISTA courses that make up the Data Base and Business Intelligence Administrator specialization's technical content.

ISTA 412  Designing Business Intelligence Solutions  3 Credits

This course introduces the design process for developing a BI solution from planning and designing the infrastructure to creating an ETL (Extract, Transform, and Load) solution complete with reporting services. This course is part of a set of five related ISTA courses that make up the Data Base and Business Intelligence Administrator specialization's technical content.

ISTA 420  SQL and Application Development  3 Credits

This course introduces the key components of SQL including tables, indexes, data integrity, managed code, XML, and functions. The SQL components are applied using APIs in order to support the development of applications that interact with SQL servers. This course is part of a set of five related ISTA courses that make up the Cloud Applications Developer specialization's technical content. Prerequisite: ISTA 322, or the approval of the Program Chair.

ISTA 422  Azure Application Development  3 Credits

A practical introduction to the Microsoft's cloud computing technologies. The course includes practical techniques for coding, testing and deploying Visual Studio and Microsoft Azure to Azure itself and the SQL Azure storage services. This course is part of a set of five related ISTA courses that make up the Cloud Applications Developer specialization's technical content.

ISTA 430  Configuring and Deploying Private Cloud Systems  3 Credits

This course focuses on the deployment, configuration and operation of private cloud systems using Windows Systems Center technologies. Students will learn how to plan and implement private clouds; to monitor, manage and administer cloud environments; while also monitoring and managing key infrastructure elements and applications that run within cloud environments. Students will also learn how to operate and extend Service Management in cloud environments, achieve high availability, protection and recovery services, and use service level agreements (SLAs) to manage and optimize private cloud systems. Students produce high-level cloud systems designs, configure and deploy cloud systems to meet requirements, and use a variety of virtualization technologies and tools to deliver applications services, configure and publish service catalogs, and use Data Protection Manager to provide information security. This course encompasses the learning objectives, labs, projects and other materials derived from two Microsoft courses: 70-246, Monitoring and Operating a Private Cloud, and 70-247, Configuring and Deploying a Private Cloud; as such, required course materials include time-sensitive license vouchers that students must have to participate in the course. The course prepares students to take the associated Microsoft Certification exams, which are incorporated into ISTA 430. Students must take these exams at a Microsoft-approved test proctor facility; see the Master Textbook List for further information.Prerequisites: ISTA 330 or the approval of the Program Chair.

ISTA 432  Building Azure Infrastructures  3 Credits

This course completes our study of the deployment, configuration and operation of private cloud systems and infrastructures using Windows Systems Center and Azure technologies. Building on previous ISTA courses, students will learn how to use and manage virtual networking, virtual machines and related technologies to plan, configure, control, optimize and support private cloud infrastructures, systems and applications. Hands-on exercises will also investigate how to plan for, deploy and support SQL database applications and services, web site deployment and configuration, as well as a variety of monitoring, incident analysis and problem-solving techniques.This course encompasses the learning objectives, labs, projects and other materials derived from Microsoft Official Course 70-533, Implementing Microsoft Azure Infrastructure Solutions course; as such, required course materials include time-sensitive license vouchers that students must have to participate in the course. The course prepares students to take the associated Microsoft Certification exam, which is incorporated as the course Final Exam. Students must take this exam at a Microsoft-approved test proctor facility; see the Master Textbook List for further information.Prerequisites: ISTA 430 or the approval of the Program Chair.