Conestoga College Logo - Home Page

Distance Learning - Part-time Courses - Technology

Click on the course code or title below for a full description of the course. If available for registration, clicking on "Details" in the Status column will open a new browser tab or window in the Student Portal.

Courses
Course # Courses Status
COMP1626 Achieving Top Search Engine Positions

Description: The vast majority of Web traffic comes from search engines. That means the most important thing you can do to increase your website's traffic is to improve its search engine ranking. To do that, you have to understand both the art and science of search engine optimization (SEO).
In this course, you'll gain the knowledge you need to boost your website's visibility. You'll discover how search engines crawl the Web, rank websites, and find previously undiscovered sites, and learn which HTML tags are key to getting sites on a search engine's radar. You'll also explore how to select keywords, why you should amass as many potential keyword choices as possible, and which keywords hold the most potential.
In addition, we'll discuss why you should complete a pre-submission analysis, how to do a post-submission analysis using tools such as Google Analytics, and how to manage the SEO cycle to maximize results. By the end of the course, you'll have mastered proven, step-by-step SEO strategies that you can implement right away.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1208 Advanced CSS3 and HTML5

Description: You've heard the buzz about CSS3 and HTML5? These latest versions of HTML and CSS have redefined how Web pages are created. So if you're going to design Web pages, you need to know how to work with CSS3 and HTML5.
This course will teach you how to take advantage of HTML5 "semantic" tags that make page design far more intuitive, faster, and easier compared to older versions of HTML. And you'll learn to use HTML5 to create basic mobile pages and apps.
In this class, you'll learn to use HTML5 to provide video that works in any environment. HTML5 makes it possible to build inviting forms that test user data without back-end coding. It also allows designers to include friendly tools like calendars, calculators, and color palettes to encourage accurate user input. You'll leave this course with the skills to create all those elements.
And you'll learn to wield new CSS3 features essential for fast-loading, exciting, interactive websites, especially mobile sites. You'll create complex gradient blend backgrounds for pages and page elements, without using image files. And you'll learn to use jQuery Mobile to create app-like mobile Web pages and themes— complex sets of styles for mobile sites.

In short, you'll leave this course with valuable skills essential to creating modern websites.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1031 Advanced PC Security

Description: When is hacking legal? When you use it to secure your own network. This new method of hacking, called ethical hacking or white-hat hacking, uses common and readily available hacking tools and techniques to audit your network so you can locate and close security holes. Whether you're running a small home network or you're an enterprise network administrator, this course will teach you how to better protect your system against those who wish to gain unauthorized access.
You'll gain an understanding of the complex method of electronic breaking and entering. You'll learn the terms and programming behind the interaction between hardware and software when communicating through a network. You'll follow packets of data from one point to another through an entire network, and find out where the flaws exist for data loss and security breaches. You'll discover the role of the seven layers of the OSI model, and the dependencies of hardware and software interaction through packet transmission. And you'll find out how private data can quickly become public knowledge.
Hackers are costing businesses around the globe several billions of dollars every year. Don't become part of that sad statistic. Sooner or later, you know that somebody is going to try and break into your network. Why not learn how hackers think so you can harden your defenses against them?
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1287 Advanced Web Pages

Description: Take your Web design skills to the next level! Whether you want to work as a freelance Web designer, join a Web development team, or build websites for your organization, this course will give you the advanced tools you need.
In these lessons, you'll learn to write HTML code for page content and CSS code for page styling. You'll master cutting-edge techniques that take advantage of HTML5 and CSS3, the latest versions of the languages used to create modern websites.
With the help of step-by-step instructions, you'll build interactive websites that collect information from visitors through email signup and feedback forms. In addition, you'll learn the latest and most effective techniques for presenting layouts and video that work in any browsing environment from a desktop computer to a mobile device. Along the way, you'll explore aesthetics, color scheming, and accessible Web page design.
And don't worry if you have only the most basic exposure to Web design! This course walks you all the way through to purchasing and uploading your site to a remote server. You won't need any special software, either—just the text editor that comes installed with your computer.
Whether you're a beginner or an experienced Web designer wanting to update and enhance your skills, this course is perfect for you. In just a few weeks, you'll be designing state-of-the-art websites that offer all the sophisticated elements that today's Web users expect to see.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1821 Basic Comp TIA A+ Certification Preparation

Description: Time to roll up those sleeves and dive inside the personal computer! The Basic CompTIA A+ Certification Prep course teaches you about the hardware common to virtually every personal computer, including microprocessors, RAM, power supplies, motherboards, UEFI/BIOS, the system setup utility, the expansion bus, and input/output devices. You'll learn how things work, how to configure everything, and how to troubleshoot in real-world environments. This course gives you the knowledge upon which you'll base the rest of your CompTIA A+ certification studies for the 220-901 and 220-902 exams. Plus it helps you take that first step to becoming an excellent PC technician. So what are you waiting for?!?

Requirements

• Internet access
• Email
• One of the following browsers:
o Mozilla Firefox
o Microsoft Internet Explorer (9.0 or above)
o Google Chrome
o Safari
• Adobe PDF plug-in (a free download obtained at Adobe.com .)

A solid conceptual and practical knowledge of Windows (XP, Vista, or 7).

It's also recommended that you have a PC that you can take apart and put back together again. This can be anything from an ancient Intel 286 to a newer 486 or beyond. Because of the dangers of electro-static discharge (to the machine, not the student), we do not require you to tear apart your own primary computer. This is, however, a class that trains you to be a hardware technician - having a machine to play with greatly helps your learning.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1247 compTIA Security+ Certification Prep 1

Description: The U.S. Department of Labor forecasts that computer security and related computer-support specialties will be among the fastest-growing occupations through 2018. CompTIA's Security+ certificate is widely regarded as the entry-level certificate for this fast-growing field. Getting that certificate requires passing CompTIA's challenging SY0-301 exam.
This course covers the key terminology and concepts needed to ace the exam, all in a condensed format for rapid reading. The course provides helpful study tools including crossword puzzles, games, and practice questions to aid with learning. All of the content is geared toward helping you pass the SY0-301 exam so you can leave the test center with your Security+ certificate in hand.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1248 compTIA Security+ Certification Prep 2

Description: The U.S. Department of Labor forecasts that computer security and related computer-support specialties will be among the fastest-growing occupations through 2026. CompTIA's Security+ certificate is widely regarded as the entry-level certificate for this fast-growing field. Getting that certificate requires passing CompTIA's challenging SY0-501 exam.
This course, the second of two courses, reviews the key terminology and concepts needed to ace the exam, all in a condensed format for rapid reading. The course provides helpful study tools, including games and practice questions to aid your learning. All of the content is geared toward helping you prepare to pass the SY0-501 exam, so you can leave the test center with your Security+ passing score in hand.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1064 Designing Effective Websites

Description: These days, creating a website is so easy almost anyone can do it. But with all the competition on the Web, creating a site that's effective is more challenging than ever. To do that, you need to employ good design principles. Regardless of your current skills or level of knowledge, in this course you'll master the basics of Web design and learn how to build sites that are better and more effective. Get ready to take your Web design skills to the next level!
We'll examine the tension between form and function, explore the six major states of the website development process, and learn the basics of user-centered design. We'll also cover the five basic steps to organizing information, find out how site design themes can be used for information delivery, and review Web page design considerations. Along the way, we'll talk about effective type and graphics and explore the idea of Web 2.0.
This course is a must for Web designers, giving the tips and tools that will help them establish a solid career.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1675 How to get Started in Game Development

Description: There's never been a better time to start a career in the game development industry. Games can be found on computers, the Web, gaming consoles, and virtually every mobile tablet and phone. Industry forecasts indicate that gaming will be worth close to $100 billion dollars in the next two years. Talented, creative, and enthusiastic people are in great demand in this industry.
Whether you want to start your own indie game project in your basement or work with a small creative team or for a large game development studio, this course will prepare you to start developing your own games.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1073 Intermediate C# Programming

Description: Build upon your current knowledge of programming logic by writing Graphical User Interface (GUI) applications in the C# programming language. This course will show you how to write professional looking applications with many of the common GUI controls, such as buttons, labels, text boxes, check boxes, and radio buttons. You'll also learn how to put menus and toolbars into your program to make them easier to use. And later in the course, you'll find out how to make your program interact with sequential files, random access files, and databases.
This six-week course will walk you through computer application design and implementation by giving you real examples that you can enter as you learn. Since practicing is the best way to learn programming, most lessons have more than one example, and each provides a programming problem you can solve to demonstrate your new knowledge.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1212 Intermediate CSS3 and HTML5

Description: In this course, you'll take your CSS and HTML skills to the next level and learn how to create professional-quality websites. You'll find out the methods the pros use to quickly build effective sites that are easy to maintain and modify. You'll discover the secrets to ensuring you keep total creative control over every aspect of a site. You'll master specific techniques for using background images and controlling opacity, visibility, and scrollbars. You'll create picture thumbnail galleries, cool hover (mouseover) effects, drop-down menus and flyout menus, and animation effects that work on hover as well as touchscreens like the iPhone and iPad. You'll also discover wonderful easy-to-code methods for creating responsive layouts that scale well to all screen sizes and devices.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1856 Intermediate Dreamweaver CS6

Description: Take your Adobe Dreamweaver skills to the next level with more advanced techniques under the tutelage of a proven Web development expert. In this new intermediate-level Dreamweaver course, you'll learn to harness the power of this industry-standard Web design tool.
You'll examine pure CSS layout and discover how to get the most out of Dreamweaver's templates. The course also shows you how to incorporate multimedia elements such as video and manipulate data using XML data and XSL. Throughout the course, you'll get hands-on experience with Dreamweaver as you develop a sample site using your new skills.
Whether you're planning a career in Web design, designing a website for your business, or developing sites as a hobby, this course will give you the tools you need to work like a pro. By the end of this course, you'll have a solid, in-depth understanding of traditional layout and how it translates to the Web so you can make your sites clearer, cleaner, and more accessible.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Closed
PROG1064 Intermediate Java Programming

Description: Deepen your understanding of the Java programming language, and start writing programs that are more sophisticated and professional. Learn how to save data permanently on a disk by writing it to a sequential data file. See how to read the file to get the data back and process it. Organize information using multiple classes in Java's class hierarchy and inheritance. Explore some of the hundreds of classes that are built into the Java language. Find out how to create GUI applications in Java using tools like windows, menus, buttons, text boxes, check boxes, scroll bars, and other GUI tools.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1115 Intermediate Microsoft Access 2010

Description: Do you have experience building Microsoft Access 2010 databases, but want to take your skills to the next level? In this course, you'll build an entire database project from scratch. By the time you've completed the course, you'll have a fully functional database that tracks customer and order information.
You'll start by learning how to create your new database by importing information from Excel spreadsheets into tables. Using action queries, you'll add and update key fields that allow you to build relationships among the tables. Then you'll master the steps for building complex yet easy-to-use forms to manage table data.
The course offers you tips and techniques for optimizing your database, including ways to build crosstab and summary queries so you can access information quickly and easily. You'll also learn about outer table joins that can make you queries more effective.
Once you've built your database, you'll examine how to build reports using conditional formatting to highlight key data points, and explore Visual Basic, a powerful programming language that allows you to automate simple and complex tasks. Finally, you'll put the finishing touches on your database as you build a navigation form to make it easy for your users to find what they need.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1069 Intermediate Networking

Description: Learn real-world applications for the concepts you learned in Introduction to Networking. Continue to build your knowledge of networks and networking, with detailed treatments of TCP/IP, how switches and routers operate, DNS, and more. You'll gain a full understanding of almost every aspect of networking technology, including hot topics such as virtual private networks, security, Internet connectivity, and cloud computing. Completion of this course and its prerequisite should serve as a springboard for a career in computer networking or training for CCNA Certification.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1066 Intermediate Oracle

Description: Gain hands-on experience with Oracle's PL/SQL programming language, with expert assistance from an IT veteran. PL/SQL is Oracle's procedural language extension to Structured Query Language (SQL). This course will give you the skills you need to write powerful and flexible programs using that language. You'll learn the building blocks and core features of PL/SQL, including expressions, various iterations, and built-in functions. Then, you'll begin building fully functional PL/SQL programs with procedures, packages, debugging routines, database structures, triggers, and cursor processing. By the time you finish this course, you will be able to store PL/SQL programs in a database and execute them.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1047 Intermediate PHP and MySQL

Description: Learn how to create an interactive online store complete with an online catalog of products, allowing customers to browse the catalog to select items, place them in a shopping cart, and complete an order. In this six-week online course, you'll see how to create a commercial online store using the PHP programming language and the MySQL database server.
We'll walk through the steps for developing a complete online store Web application. During the course, you'll see step-by-step how to create all of the software and database objects used in the application. The application consists of two parts, an administrative Web application allowing a store manager to post new products, alter product information, and process customer orders, and a customer Web application allowing customers to browse the catalog of products, select products for purchase, and check out using a shopping cart. At the end of the course, you'll be able to use these code templates to create your own online store application.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1066 Intermediate SQL

Description: Expand your knowledge of Structured Query Language (SQL), the industry standard database programming language.
In this course, you'll learn techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data. First, you'll explore how to write and implement complex queries on multiple tables simultaneously and how to apply advanced filtering techniques. You'll learn to create union queries that combine records from multiple queries, and you'll discover how to use union queries to exclude or include duplicate records. In addition, you'll find out how to use text strings within union queries.
Next, you'll master advanced techniques for updating various types of data stored in your tables. You'll learn how to update a single field, multiple fields, multiple records, date fields, and calculated fields. And you'll see how to update and set NULL values using an update statement.
In addition, you'll use advanced insertion techniques to add data to your tables and learn how to create, query, and modify temporary tables. You'll also see how to implement techniques to handle duplicate values stored in a table and how to limit the results of a result set. And finally, you'll discover how to use string functions to perform complicated searches on strings, how to implement date and time functions to insert and extract portions of a date, and how to create queries that accept input from users.
By the end of this course, you'll be able to use a wide range of advanced SQL techniques with confidence. Your new skills with databases will enhance your competitiveness in the technical fields of software development and database administration.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1093 Intermediate Visual Basic

Description: Why is Visual Basic the most widely used programming language for creating Windows applications? Because it's easier to learn and faster to use than most other programming languages.
If you're a VB programmer who wants to go beyond the introductory level to create the sophisticated and powerful programs business users need, this course is for you. As we focus on database applications, you'll learn the in-demand programming skills you need to get new work in the business world.
We'll begin by discussing how to enrich the graphical user interface with custom menus and toolbars. Next, we'llC87:C88 explore multiple form applications, starting with built-in dialog controls, and then turning to helper forms and Multiple Document Interface applications.
After that, we'll deepen your understanding of databases. You'll find out how to access and modify data with data-bound controls, ADO .NET, and Structured Query Language (SQL). And we'll finish up with a survey of other areas you might be interested in studying, including information on additional SQL functionality, Web applications, and XML.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1113 Introduction to C# Programming

Description: Learn the fundamentals of computer programming with C#, the in-demand and incredibly useful programming language that incorporates the best features of Visual Basic, C++, and Java.
You'll first develop your understanding of programming fundamentals: input/output operations, decision making, and looping. Then, we'll explore the many benefits of object oriented programming, with plenty of vivid, real-life examples.
Then, you'll gain hands-on experience with sequential data files, and you'll be able to build a professional-looking and intuitive Graphical User Interface (GUI) application on your very own computer.
Because there is no better way to learn programming than hands-on practice, almost every lesson includes practical examples and assignments you can use to develop your knowledge of programming.
Learn to program the right way: by using a state-of-the-art language to build impressive applications on your schedule and on your very own computer.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1307 Introduction to C++ Programming

Description: Learn how to program in C++ from a master programming instructor and published author. In this project-oriented course, you'll skip all the gobbledygook and get right to programming--even if you have no prior programming experience! Before you know it, you'll be putting together programs that have their own windows and controls, and you'll see how easy programming really is.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1205 Introduction to CSS3 and HTML5

Description: Learn how to create state-of-the-art Web sites using modern CSS3 and HTML5 techniques. Take your existing HTML skills to the next level and start building sites like the pros. If you want to survive and excel in the fast-paced world of Web publishing, you're going to need to keep up with ever-evolving standards. The new standard for Web developers is to use CSS3 and HTML5.

CSS3 and HTML5 not only make it easier for you to build and manage large Web sites, these powerful languages can also give you more precise control over the appearance of every page you build. Almost every Web development tool--including Dreamweaver, Microsoft Expressions Web, and Visual Web Developer--offer support for CSS3 and HTML5.

This course will provide you with the foundation you'll need to master two critical and fast-growing new Web languages. If you're a Web developer, why not begin your transition to CSS3 and HTML5 today?
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1058 Introduction to Database Development

Description: A number of powerful tools are available to help you build databases and database applications. However, if you do not apply a systematic, structured approach to the use of those tools, you will probably produce systems that fail to meet user needs. Many projects bog down or are never completed for lack of a disciplined approach to development. This course will guide you step-by-step through all the phases of a system development project to guarantee that the resulting product will not only work as it was designed to work, but also that the design truly responds to user needs.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1062 Introduction to Java Programming

Description: If you want to learn computer programming but don't have any prior experience, you'll enjoy a tour of Java, one of the most widely used computer languages in the world. It's a breeze to learn in a friendly and supportive environment. Start with the basics of programming and go on to write your own programs and integrate input and output, calculations, decision making, and loops. Build your knowledge and confidence with easy-to-understand examples and plenty of skill-building exercises. So whether you just want to try it out to see if you like it or plan on doing more with Java, this is a great place to start!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1072 Introduction to JavaScript

Description: You may already know how to use HTML and CSS to create websites. If so, you're ready to add more power to your programming with JavaScript. This programming language lets you add interactivity to your pages by creating features such as buttons, picture carousels, and collapsible panels to your Web pages.

The course begins with the basics of JavaScript code and then moves on to more advanced topics. You'll learn how to define what happens when a user clicks a button or presses a key on your pages, and see how JavaScript enables your pages to make "if . . . then . . . else" decisions about what to do based on circumstances. You'll also get a chance to try out loops and timers to create animation effects. Throughout the course, you'll get plenty of hands-on practice to give you the experience you need to really understand how JavaScript works.
And since no JavaScript course would be complete without a discussion of jQuery, we cover it as well. This free "write less, do more" JavaScript library has become virtually synonymous with modern Web and mobile app development. By the end of the course, you'll understand how to use jQuery to catapult your basic JavaScript knowledge to incredible new heights.
This course assumes students already know HTML and CSS. JavaScript is always used with these two programming languages, not as an alternative to them.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1068 Introduction to Networking

Description: Introduction to Networking explains computer networking basics in terms that you can easily understand, using concepts common to everyday, non-computing experience. A brief introduction to networking history provides context, explaining how networks have become so important to businesses and individuals. The course emphasizes networking fundamentals, explaining the software and hardware that makes networking possible. The course stresses understanding how and why networks work, rather than focusing on memorization of terms or numbers.
Upon completion of the course, you will be capable of performing basic computer networking tasks, such as DSL connectivity or configuring connections to an Internet Service Provider. This course will give you the foundation you need to begin training for CCNA Certification or employment in a computer networking career.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1065 Introduction to Oracle

Description: Learn how to use the Oracle database management system to plan, organize, and manage your data. Introduction to Oracle will provide you with a practical hands-on approach to relational databases concepts and Oracle's database management system. This course will introduce you to the Structured Query Language (SQL), Oracle's SQL*Plus, and other valuable tools used to develop, manage, and reference an Oracle database.
In this six-week online course, you will learn how to create an Oracle database, build various database objects for the database, and write simple SQL statements that access the data from the database. This course will teach you how to write Data Definition Language statements to create, update, and delete database objects. You will learn how to execute Data Control Language statements to give or delete access rights to database objects. You will write Data Manipulation Language statements to insert, update, and delete records from a database. Finally, you will learn how to query the data and create finished reports.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1880 Introduction to PC Security

Description: What you don't know about PC security really can hurt you! Learn why you're at risk and what you can do to protect your precious personal and business data from the outside world. This course, taught by a security expert, will quickly bring you up to speed on the fundamentals of PC and network security.
You'll understand and explore the many vulnerabilities of operating systems, software, and networks. Then, you'll get into the minds of hackers and crackers, developing an understanding of the exploits they use to access your computer without your knowledge. You'll find out why, where, and how viruses, worms, and blended threats are created. You'll be able to identify and work to prevent DoS, SYN flooding, and other network attacks. You'll learn a safe way to share files and data across the Internet through a virtual private network. And you'll be able to install and configure a firewall to build an impenetrable moat around your computer or network.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1032 Introduction to PC Troubleshooting

Description: Don't spend your hard-earned cash on expensive PC repairs! The vast majority of the problems people experience with their computers are completely avoidable, and most can be solved with nothing more than a few minutes of your time. Intro to PC Troubleshooting takes you step by step through the typical hardware and operating system problems encountered by technicians, teaching troubleshooting techniques to decipher any problem, and giving you the skills you need to solve them. Once you've mastered the basics, the course launches into some of the more advanced and nasty problems that crop up in the PC, teaching you how to diagnose and fix those problems as well! Finally, Intro to PC Troubleshooting shows you how to maintain and optimize a Windows PC. So what are you waiting for? Let's troubleshoot - and fix - some PCs!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1045 Introduction to PHP and MySQL

Description: Learn how to create an interactive Web site, allowing visitors to post and retrieve information provided by you or your site's visitors. In this six-week online course, you'll see how to create dynamic Web pages using the PHP programming language and the MySQL database server.
During the course, you'll walk through the development of a complete content management system Web application. You'll receive clear, step-by-step, instructions demonstrating how to create a complete Web site capable of dynamically displaying data from a MySQL database.
You'll discover how you can allow your site's visitors to add new information to an online database, search through posted data, and create meaningful printed reports. By the end of this course, you'll have plenty of useful code templates that will help you create your very own dynamic, Web-based, content management system.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1094 Introduction to SQL

Description: Learn the key concepts of Structured Query Language (SQL), and gain a solid working knowledge of this powerful and universal database programming language.
In this course, you'll learn about the basic structure of relational databases and how to read and write simple and complex SQL statements and advanced data manipulation techniques. First, you'll learn about the traditional database structure, the structure and history of the relational database, and what structured query language (SQL) is and how it relates to the relational-database structure.
Next, you'll discover how to use SQL to filter retrieved data and how to use SQL to sort and retrieve data from tables. You'll learn how to reformat retrieved data with calculated fields and how to merge columns and create alternate names for columns. You'll also learn how to gather significant statistics from data using aggregate functions, and you'll see how to extract data from multiple tables simultaneously using joins and subqueries. In addition, you'll learn how to manipulate data using the INSERT, UPDATE, and DELETE statements.
We'll also cover how to use SQL to create and maintain tables, and you'll learn how to create and use views to simplify complex queries, summarize data, and manipulate data stored in tables. You'll discover how transaction processing, constraints, and indexes are implemented in SQL. And finally, you'll discover how stored procedures, triggers, and cursors are implemented in SQL.
By the end of this course, you'll have a solid working knowledge of structured query language. You'll feel confident in your ability to write SQL queries to create tables; retrieve data from single or multiple tables; delete, insert, and update data in a database; and gather significant statistics from data stored in a database.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1043 Introduction to Visual Basic

Description: Visual Basic is the most widely used programming language for creating Windows applications. Why? Because it's easy to learn, and doesn't require you to memorize difficult commands like other programming languages. In this course, you'll learn how to write Windows applications and programs using the Visual Basic programming language and the Visual Basic development environment.
Creating a Windows application ordinarily requires you to write lengthy and complex code. But, as you'll see, the Visual Basic development environment relieves you of this task. Instead, it enables you to create the application program and its components literally with the click of a button or menu item. It even writes all of the necessary code to get the application started for you, which you can then view and fine-tune.
Over the course of 12 lessons, you'll learn the building blocks of programming, including using variables to store data, control structures, and loops. You'll find out how to use the large function library built into Visual Basic, including the .NET Framework, as well as how to write and use your own functions. You'll also see how to use Windows' large and varied library of controls and how to access files and handle errors. And since Windows applications are event-driven and everything in Visual Basic is treated as a programmable object, you'll learn about event-driven and object-oriented programming—concepts that are important not just in Visual Basic, but in other programming languages as well.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1740 Understanding the Cloud

Description: What is the cloud? If you have trouble answering this question, you're not alone. In this course, we'll explore how the cloud works, what drives its incredible growth, and how you can use cloud services. And don't worry if you're not tech-savvy! We'll relate the cloud to things you encounter every day, using practical, non-technical language.
We'll start by looking at the building blocks of the cloud, where it started, and how it transitioned from an experiment into an unstoppable force. You'll also gain a clear understanding of IaaS, SaaS, and PaaS, and see why each may be attractive to some businesses, but not others. And you'll learn about the different kinds of clouds (public, private, and hybrid).
We'll also take an inside look at the engine rooms of the cloud: data centers. You'll examine the concept of big data¯the overwhelmingly huge amounts of data that make analysis so challenging—and how the cloud infrastructure enables data to zip across the globe at lightning speed.
Social networking has also played an incredibly important role in the growth of the cloud. We'll examine how Facebook and Twitter contribute to the cloud, and how apps go from idea to app store. You'll gain an understanding of how mobile devices and major mobile ecosystems¯like Apple, Android, and Windows¯continue to shape the cloud, and how start-ups can use social media to shake things up like never before.
So come see how the how the cloud can work for you! Whatever your technical background, by the end of this course, you'll be thoroughly cloud-savvy.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1592 Wireless Networking

Description: Wireless networking is one of the fastest growing segments of the computer industry. Every electronic device seems capable of wireless connections these days: computers, handhelds, cell phones , and even digital cameras are all capable of transmitting without a tether. To many people, those wireless connections are nothing short of technical wizardry. This course will remove the mystery and give you a thorough understanding of this fascinating and lucrative technology.
You'll learn how wireless works, how wireless devices connect to networks, and how to build and connect to your own wireless network. We'll also explore wireless standards, wireless security, satellite Internet and cellular phone technology, as well as the future of wireless.
Becoming knowledgeable about wireless networking is easier than ever. With a helpful instructor who is also a working industry expert, a practical and thoughtful approach to teaching, and an emphasis on giving you a practical, hands-on understanding how wireless works, this course will teach you everything you want to know about the world of wireless connectivity.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details

Program contacts for Technology.

Back To Top