This course is a comprehensive introduction to database concepts. The interaction between software applications and databases will be discussed. Database terminology will be introduced. Students will learn how to manage, design, and construct relational databases. The first eight weeks will focus on using Microsoft Access. The second eight weeks will work with Microsoft SQL Server learning how to work with the SQL language to create tables, join tables, query data, write summary queries, insert, update, and delete data.
Pre-Requisites
There are no Pre-Requisites
Classes
-
Database Concepts and SQL (21703)
Online
Online
1/23/2023 - 3/17/2023
Days & Times:
Mon, Tues, Wed, Thurs, Fri: 7:00 AM - 7:30 AM
Facility:
ONLINE
Instructor:
Andrew Bangsberg
Tuition:
$469.95
Status:
Closed
Seats Available:
N/A
-
Linux Operating Systems
Undergraduate | 3 Credits
CATALOG #10154103
In this course the Linux operating system is examined in-depth with emphasis on features, capabilities, tools, and configurations including an introduction to network configurations. PREREQUISITE: 10154149 Windows Operating Systems
Offered Collegewide
Spring 2023
-
Web Design and Development
Undergraduate | 3 Credits
CATALOG #10152101
Students plan and develop well-designed websites that combine effective navigation and a balanced use of text, images, and color. Emphasis is on understanding HTML5, Cascading Style Sheets (CSS), accessibility, and responsive Web design. Students use media queries, CSS Flexbox and CSS Grid to create responsive websites that are easily viewable across a wide range of devices.
Online
Spring 2023
-
Java Programming - Beginning
Undergraduate | 3 Credits
CATALOG #10152106
This Java course familiarizes the student with the fundamentals of the Java language including data types, operators, expressions, and conditional statements. Students learn how to set up an environment for developing Java programs, define classes and utilize class objects. Students explore object-oriented programming concepts including encapsulation and abstraction. Other topics include string manipulation, Collections, Array Lists, Exception Handling, and creating professional looking end-user interfaces. This course covers software architectural patterns, such as model-view-controller (MVC). Students learn to communicate with a database. PREREQUISITE: 10152135 Program Logic and COREQUISITE: 10152101 Web Design and Development
New Richmond, Online
Spring 2023
-
Programming in SQL
Undergraduate | 3 Credits
CATALOG #10152110
This course covers using Microsoft SQL Server and SQL Server Management Studio to design and create databases, tables, view, functions and stored procedures. Students will learn to script all creation and modification of tables, views, and stored procedures. Students will also explore how to encrypt data and best practices working with SQL Server. PREREQUISITE: 10152100 Database Concepts and SQL.
New Richmond, Online
Spring 2023
-
Advanced Website Development
Undergraduate | 3 Credits
CATALOG #10152102
Students gain hands-on experience with the design and implementation of dynamic websites. Topics include JavaScript, jQuery, Ajax, and APIs with which students thoroughly explore event-driven techniques, data storage, accessing the DOM, and JSON. Students use media queries, CSS Flexbox and CSS Grid to create responsive websites that are easily viewable across a wide range of devices. Students deploy a website to a web server using FTP. PREREQUISITE: 10152101 Web Design and Development and 10152135 Program Logic.
New Richmond, Online
Spring 2023
-
Applications Development
Undergraduate | 3 Credits
CATALOG #10152113
The purpose of this capstone course is to provide the student with experience developing applications in a business environment. Students apply analysis, design, database, and programming techniques to develop a fully functional software application. The project progresses through all the stages of the development process including planning, analysis, design, construction, testing, and deployment. Students estimate their development effort and track actual time spent within each development phase. PREREQUISITES: 10152107 Java Programming - Advanced and 10152111 Systems Analysis and Design and COREQUISITE: 10152118 Enterprise Programming in .NET.
New Richmond, Online
Spring 2023
-
Enterprise Java Programming
Undergraduate | 3 Credits
CATALOG #10152108
The third course in the Java sequence continues exploring advanced Java topics within a Java web development platform. Students hone their skills in JSPs, Servlets, session management, Expression Language (EL), JSP Standard Tag Library (JSTL), and JavaBeans. New concepts include, working with form-based security, listeners, filters, encryption, as well as, working with HTTP requests and responses headers. Students develop applications that communicate with a database. PREREQUISITE: 10152107 Java Programming - Advanced.
New Richmond, Online
Spring 2023
-
Server Administration 1
Undergraduate | 3 Credits
CATALOG #10150117
This course provides students with the fundamental technologies needed to administer a Windows domain. Students will learn how to manage domain resources including users, workstations, servers and shared folders using Active Directory, role management, Server Manager and RSAT. Students will learn how to secure these domain resources using Group Policy, NTFS and file share permissions. Students will also learn how to use the Domain Naming System (DNS), an integral part of Windows domain environments. PREREQUISITE: 10154149 Windows Operating Systems.
Offered Collegewide
Spring 2023
-
Cisco CCNA 2 Routing and Switching Essentials
Undergraduate | 3 Credits
CATALOG #10150113
Cisco CCNA 2 Routing and Switching Essentials (RSE) covers the architecture, components, and operations of routers and switches in a small network. Students learn how to configure, device management, switch ports, security, VLANs, Static and Dynamic routing, DHCP (v4 and v6), NAT and ACLs on routers and switches. At the completion of this course student may achieve a discount voucher for the CCENT certification exam. PREREQUISITE: 10150111 Cisco CCNA 1 Introduction to Networks.
Offered Collegewide
Spring 2023
-
Program Logic
Undergraduate | 3 Credits
CATALOG #10152135
In Program Logic, students learn to develop clear consistent strategies to create computer-programming solutions. Students analyze problems, review requirements, develop test plans, and then create solutions. Students learn to focus on understanding the logic behind each solution. Students also learn the proper use data types, variables and variable scope, as well as, methods, decision structures and repetition structures. Although this course emphasizes programming logic, students develop working computer programs.
Online
Spring 2023
-
Web Tools of the Trade
Undergraduate | 2 Credits
CATALOG #10152116
In Web Tools of the Trade, students explore ways to make use of third-party web tools, libraries, and APIs. Besides working with web tools, students will also explore current events and hot topics in technology. PREREQUISITE: 10152102 Advanced Website Development
New Richmond, Online
Spring 2023
-
Beginning .NET Programming
Undergraduate | 3 Credits
CATALOG #10152115
Introduction to the concepts and techniques of programming in the .NET environment using the C# language. Topics covered include requirement analysis, program design, coding, and debugging. The majority of projects will be Windows form applications. COREQUISITE: 10152135 Program Logic.
Online
Spring 2023
-
Advanced .NET Programming
Undergraduate | 3 Credits
CATALOG #10152117
This course provides the student with an object-oriented view of the .NET development environment using C#. Topics include Lists, Classes, Debugging, Error Handling, Data Access connecting to an SQL server, and designing clean readable code. Windows Forms will be used for the majority of applications. PREREQUISITE: 10152115 Beginning .NET Programming and 10152135 Program Logic.
New Richmond, Online
Spring 2023
-
Enterprise Programming in .NET
Undergraduate | 3 Credits
CATALOG #10152118
This course is designed to provide students with an enterprise view of the .NET development environment. The course will use Visual Studio development environment to create fully functional websites using ASP.NET and C#. Multiple techniques will be used for database access. Students will start with web forms and move into the MVC model for development. PREREQUISITE: 10152117 Advanced .NET Programming.
New Richmond, Online
Spring 2023
-
Ethical Hacking
Undergraduate | 3 Credits
CATALOG #10154144
Ethical hacking students will scan, test and secure their own systems. Students in the lab environment will apply practical experience to implement essential security for systems. Studies will include how perimeter defenses are applied to their own networks. The processes of escalating privileges, Intrusion Detection, Policy Creation, Social Engineering, DDoS Attacks, Buffer Overflows and Virus will be studied from an ethical and defense point of view to help secure resources in the information technology. PREREQUISITES: 10150117 Server Administration 1 and 10154103 Linux Operating Systems.
Offered Collegewide
Spring 2023
-
Database Administration
Undergraduate | 3 Credits
CATALOG #10154145
This course covers basic concepts of database administration including setting up and securing users, tuning operations, database security, and backups. This course also covers web server administration and web site deployment as well as basics of SharePoint administration. PREREQUISITES: 10150118 Server Administration 2 and 10152100 Database Concepts and SQL.
Ashland, Online, Rice Lake
Spring 2023
-
Cloud Computing
Undergraduate | 3 Credits
CATALOG #10154146
This course will examine how storage and virtualization technologies are making possible the enormous rise of cloud computing. The course will look at the impact that cloud computing is having on traditional datacenters. It will also discuss security and disaster recovery from a cloud computing perspective. PREREQUISITE: 10154141 VMware Certified Professional.
Offered Collegewide
Spring 2023
-
Capstone Project
Undergraduate | 2 Credits
CATALOG #10154147
This course is the capstone work-based experience for the IT - Systems Administration Specialist program. Learners will design, develop, and perform a project either in an actual work experience or a simulated project. The project will be designed to utilize skills typical of a graduate in the field. Weekly simulated timesheets, job progress reports, and oral reports to management will be used to track project progress. Successful completion will require project documentation. COREQUISITE: 10154144 Ethical Hacking.
Ashland, Online, Rice Lake
Spring 2023
-
IT Field Experience
Undergraduate | 1 Credit
CATALOG #10154148
Provides work experience in IT Field related to course work within the program. The experience should complement program courses to implement practical application of skills students obtain. By consent of instructor, a special project(s) may be substituted for the field experience. COREQUISITE: 10154144 Ethical Hacking.
Ashland, Online, Rice Lake
Spring 2023
-
Network and Security Case Studies
Undergraduate | 1 Credit
CATALOG #10150161
The primary focus of this course is to have the students receive exposure and experience with a business information system. To accomplish this goal, students will get involved with industry or complete a business lab simulation by designing and implementing a small business project. PREREQUISITE: 10150102 Information Security.
New Richmond, Rice Lake, Superior
Spring 2023
-
Broadband Fiber Service 201
Undergraduate | 3 Credits
CATALOG #32451370
This course will introduce the students to fiber optic communication systems. Topics covered include fiber optic design, installation, test and maintenance for multimode and singlemode networks. This class will benefit those with little or no fiber experience.
Rice Lake
Spring 2023
-
Coding with Python
Undergraduate | 2 Credits
CATALOG #10150170
This course introduces Python for network engineering. It begins with basic programming topics such as variables, lists, decisions, loops and I/O. Using this knowledge the course teaches students how to automate the configuration of networking equipment. This course also introduces the “Internet of Things” (IoT) and how to use Python to program IoT devices.
Offered Collegewide
Spring 2023
-
Penetration Testing
Undergraduate | 3 Credits
CATALOG #10151103
This course will provide an overview of the tools and techniques commonly used for exposing the vulnerabilities of an organization's IT systems. Hands-on labs are used to introduce the proper selection and application of a given tool, with a focus on security techniques to prevent or mitigate such attacks. Along with this, students will explore options for documenting and reporting on the outcome of the tests to stakeholders. PREREQUISITE 10150102 Information Security
New Richmond, Rice Lake, Superior
Spring 2023
-
Intrusion Detection and Prevention
Undergraduate | 3 Credits
CATALOG #10151104
Description: This course provides a broad overview of the tools and techniques commonly used for detecting network sourced attacks. In depth hands-on exercises are used to instruct the student in the proper selection and application of a given tool for the intended task. Also included are basic strategies for documenting and reporting on detected events. The student must demonstrate the ability to plan, design, and implement a network IDS/IPS that fulfills the security needs of a common business or organization. Tools used may include: Security Onion, firepower, Palo Alto, tcpdump, snort, barnyard, etc… PREREQUISITE 10150102 Information Security
New Richmond, Rice Lake, Superior
Spring 2023
-
Logging and Analysis
Undergraduate | 3 Credits
CATALOG #10151105
Description: This course will examine different types of logs to identify issues and threats. Students will become familiar with policies, procedures, event correlation and continuous monitoring programs to help identify incidents. Network traffic will be monitored for anomalies. Tools used may include: Security Onion, SIEM OSSEC, ELK, OSSIM, solar wins, Prelude, splunk. PREREQUISITE 10150102 Information Security
New Richmond, Rice Lake, Superior
Spring 2023
-
Networking Security Capstone
Undergraduate | 2 Credits
CATALOG #10151106
This capture the flag type course will focus and developing a complete network setup and the defending it. This course integrates all the skills students learn in the program and assesses their ability to put into practice their mastery of program outcomes. The students will also be attacking other student setups. Rouge devices may be introduced and topics such as social engineering will be acceptable. Attacks and defense will be the goals of the course! COREQUISITES: 10151104 Intrusion Detection and Prevention, 10151105 Logging and Analysis
New Richmond, Rice Lake, Superior
Spring 2023
-
Broadband Telco Service 101
Continuing Education
CATALOG #47451451
This course is an introduction to the evolution of POTS (Plain Old Telephone Service) and Public Switch Telephone Networks. Students will be introduced to the physical and electrical design of cables, basic installation, troubleshooting, industry color codes, print reading, system maps and telco service procedures.
Online
Spring 2023
-
Broadband Internet Service 101
Continuing Education
CATALOG #47451452
This course is an introduction to the evolution of Internet services. Students will be introduced to the different types of broadband Internet delivery methods, installation and troubleshooting methods, Internet transmission types, safety issues, government regulatory services, the "Internet of Things" (IoT) and future trends.
Online
Spring 2023
-
Broadband Television Serv 101
Continuing Education
CATALOG #47451453
This course is an introduction to the evolution of hybrid fiber coaxial and IPTV systems within the broadband industry. Students will be introduced to RF & IPTV networks, basic installation, print reading and set-top box administration. Students will address the importance of proper installation of customer equipment, troubleshooting and customer service.
Online
Spring 2023
-
Broadband Fiber Service 101
Continuing Education
CATALOG #47451454
This course is an introduction to the evolution of fiber optics. Students will be introduced to the physical characteristics of cable and the transmission of light through fiber optic cable. Students will view basic installation and troubleshooting methods while being introduced to industry color codes, print reading, system maps and a variety of fiber optic services.
Online
Spring 2023
-
Broadband Fiber Service 201
Continuing Education
CATALOG #47451456
This course will introduce the students to fiber optic communication systems. Topics covered include fiber optic design, installation, test and maintenance for multimode and singlemode networks. This class will benefit those with little or no fiber experience.
Online
Spring 2023
-
Broadband Cable Installation 201
Continuing Education
CATALOG #47451457
The student will design and install network cabling. The focus will be to understand voice and data networking. The basic cable installer will be able to build and administrate the physical layer of network infrastructure and gain a deeper understanding of the networking devices that this layer interconnects.
Online
Spring 2023