We may earn an affiliate commission when you visit our partners.
Course image
Destin Learning

This course is a survey of the critical topics of Information Systems. The material covers essential areas that drive computing and information technology today. I describe these technologies in easy-to-understand terms and use practical examples to illustrate how these concepts are used in everyday IT operations.

Read more

This course is a survey of the critical topics of Information Systems. The material covers essential areas that drive computing and information technology today. I describe these technologies in easy-to-understand terms and use practical examples to illustrate how these concepts are used in everyday IT operations.

The course contains sections that cover a survey of topics of information systems and computer science. These topics include:

  • A basic introduction to computer hardware and how a computer functions

  • An introduction to foundations concepts such as binary numbers and why they are important in computing

  • How software is built by industry today and the software development life cycle (SDLC)

  • Basics of database management systems

  • Cloud computing and the services that are offered by the leading vendors on the market today, such as Amazon AWS

  • Computer security and

  • The future of computing

I have designed this course for anyone who wants to learn more about the Information Technology field and is ideal for someone just getting started. Also included is a section for those individuals who desire to start a career in Information Technology and the jobs that are available. The course will give you a solid understanding of many of the concepts that drive one of the most important industries in today's world. I have also included several downloadable materials that you can use to help you along your way with this course.

Enroll now

What's inside

Learning objectives

  • You will also learn some of the history of computing and some of the emerging technologies.
  • By the end of the course you will have a solid understanding major information systems concepts.
  • In this course you will learn how software is developed, the basic operation of a computer and how networks function.
  • You will also lean the basics of html and how websites operate

Syllabus

In this section I will present a brief overview of the course.

In this lecture I will give you a brief overview of the material we will cover in this class.

Read more
Module 2 - Background

Information Technology is one of the most critical industries in the world today. Computers and information systems interact with most aspect of our daily lives. Understanding the basics of Information Technology will give you a better appreciation of how these systems are changing people lives. It will also help you determine if you are interested in pursuing a career in IT.   

Module 3 - Computer Hardware

In this lesson I will describe to you the basic components of a computer and how they function.

Please complete the brief quiz that is attached as a pdf file that you are to identify major components of a PC.

In this lesson I will describe the major types of computers that are in use today.

In this lesson, I will describe Moore's Law that has been used to predict the increases in computing power.

In this lecture I will present the basics of binary numbers and why they are the basis of modern computing.

Binary Numbers Quiz
Module 4 - Computer Networking
The History of Computer Networking
How Does a Local Area Network Function?
How Does the Internet Work?
Module 5 - Introduction to HTML
HTML Section Overview
Introduction to HTML
Hello World HTML
Lab - Hello World HTML
Key HTML Commands
Lab - HTML Common Tags
Lab - HTML Tables
HTML Resume Project
Lab - HTML Resume Lab
Module 6 - Software and Systems

In this video, I will describe the phases of the software development lifecycle.

This is a brief quiz about the steps of the software development lifecycle.

In this lesson I will describe the major types of eCommerce systems.

e-commerce systems quiz.

In this lesson I will describe what an enterprise application is.  I will also define the major different types of enterprise applications.

In this lesson, I will describe the software release process and how most organizations promote software from development through test, to staging, and on to production.  There are a number of things to consider in each environment and also establish successful exit criteria to move from one layer to the next. The steps are set up to ensure that the organization his shipping and delivering high-quality software.      

Module 7 - Introduction to Programming
7.1 Introduction to Programming
7.2 Introduction to the C Programming Language
7.3 Hello World in C
Lab Hello World in C
7.4 Functions in C
Lab Functions in C

In this lecture you will learn how to write loops in C.

In this lab, you will use the Destin Learning lab environment and learn to write loops in C.

Module 8 - Database Management Systems
What is a Relational Database?

This lesson is designed to be a very brief introduction to SQL and will demonstrate how to write basic queries.  I will show how to create a basic table in the MySQL database,  insert data into the table, and utilize a SQL select statement to display the results.   Attached is a pdf file that is the lab file for this lesson that will show you step by step how to write your first query.

Overview of Microsoft SQL Server
How to Install Microsoft SQL Server Express
Hello World Database
Module 9 - Cloud Computing

In this lesson I will describe the major aspects of Cloud Computing systems.

In this lesson I will describe the top 10 vendors in the Cloud Computing market today,

this quiz will summarize the main points of this section on Cloud Computing.

Introduction to Amazon AWS

I will show you how to sign up for a free account with Amazon AWS.

In this lesson I will show you how you can easily build a web site with Amazon's S3 storage service.

In this section I present the basic threats to computer systems.
Computer Security Threats
Module 11 - The Future of Computing
The Future of Computing

In this lesson, we will look t the grown in cloud computing. We will look at the growth of the market in general as well as the performance of the top cloud computing companies. We will also take a brief look at the cloud computing job market.

The Future of Computing - Short Presentation
Module 12 - IT Career Information
Top IT Jobs For 2021

In this lesson, we will look at the top IT jobs for 2018.  I will review the median salary, projected job growth, and a brief description of the responsibilities for each job.

Module 13 - Summary

In this lesson I will wrap up this class.  Thank you for your interest in this class!

Bonus Lecture

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Introduces computer hardware, foundational computer science concepts, and software development, which are all core to an IT education
Gives a solid foundation in future-proofing knowledge and technology skills in the IT field
Provides a general introduction to computer networking, HTML, software, programming, database management systems, and cloud computing
Teaches fundamental principles in the IT field, which are helpful for more in-depth study
Covers topics that are highly relevant to both industry and academia
Offers numerous downloadable materials, such as quizzes and activity sheets, to enhance comprehension and practice

Save this course

Save Information Technology Essentials to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Information Technology Essentials with these activities:
Organize Your Course Notes
Organize your course notes to improve your ability to review and retrieve information effectively.
Browse courses on Organization
Show steps
  • Gather all of your course notes, handouts, and assignments.
  • Sort your notes by topic or module.
  • Create a system for easy referencing, such as using color-coded tabs or a table of contents.
  • Review your notes regularly to reinforce your learning.
Practice SQL Queries
Practice writing SQL queries to reinforce your understanding of data retrieval and manipulation.
Browse courses on SQL
Show steps
  • Find a website or online platform that provides interactive SQL tutorials.
  • Start with basic queries and gradually increase the complexity.
  • Test your queries on sample datasets or create your own.
  • Experiment with different SQL commands and functions.
  • Review the execution plans of your queries to understand their efficiency.
Build a Simple HTML Website
Build a static HTML website to practice the concepts of web page structure and content display.
Browse courses on HTML
Show steps
  • Choose a topic for your website.
  • Write the HTML code for the website structure.
  • Add content to the website, including text, images, and links.
  • Validate your HTML code for errors.
  • Preview your website in a browser.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Practice Binary Number Conversion
Practice converting between binary and decimal numbers to solidify your understanding of computer architecture.
Browse courses on Binary Numbers
Show steps
  • Review the basics of binary numbers.
  • Set up a practice table with binary and decimal numbers.
  • Convert the binary numbers to decimal.
  • Convert the decimal numbers to binary.
  • Check your answers for accuracy.
Host a Study Group
Host a study group with classmates to review course material, discuss concepts, and work on assignments together.
Browse courses on Information Systems
Show steps
  • Gather a group of classmates who are interested in forming a study group.
  • Establish a regular meeting time and place.
  • Create a study schedule and stick to it.
  • Develop a collaborative learning environment where everyone contributes.
  • Use a variety of study methods, such as discussing lecture notes, working through practice problems, and taking quizzes.
Design a Database Schema
Design a database schema for a specific problem or business need to reinforce your understanding of data modeling.
Browse courses on Database Design
Show steps
  • Identify the entities and relationships involved in the problem.
  • Create a conceptual data model.
  • Translate the conceptual model into a physical database schema.
  • Validate the database schema for correctness and efficiency.
  • Document the database schema for future reference.
Attend a Cloud Computing Workshop
Attend a cloud computing workshop to learn about the latest technologies and best practices in cloud computing.
Browse courses on Cloud Computing
Show steps
  • Research and choose a reputable cloud computing workshop.
  • Register for the workshop.
  • Attend the workshop and actively participate in the activities.
  • Take notes and engage with the instructors and other participants.
  • Follow up after the workshop by reviewing your notes and applying what you learned.
  • Consider sharing your experiences and insights with others.
Build a Cloud-Based Application
Develop a cloud-based application to demonstrate your understanding of cloud computing concepts and technologies.
Browse courses on Cloud Computing
Show steps
  • Define the purpose and requirements of your application.
  • Choose a suitable cloud platform and services.
  • Design and implement the application's architecture.
  • Test and debug the application.
  • Deploy the application to the cloud.
  • Monitor and maintain the application.

Career center

Learners who complete Information Technology Essentials will develop knowledge and skills that may be useful to these careers:
Computer Support Specialist
For those wishing to enter the field of Computer Support, this course can help train foundational knowledge in the installation and maintenance of computer systems, basic networking, operating systems, and security concepts. The section on HTML may help future Computer Support Specialists troubleshoot issues on websites, while the lecture on cloud computing might expose someone to concepts that they may see in an enterprise setting.
IT Project Manager
Those interested in a career as an IT Project Manager may find this course helpful as a primer for the field. It introduces the major phases of the software development lifecycle, one of the major processes an IT Project Manager may be responsible for. It also teaches basics of networking, concepts of cloud computing, and high-level overview of different types of enterprise systems, which IT Project Managers need a working knowledge of.
Information Technology Manager
This course may provide some value to those interested in an Information Technology Manager position. It provides a survey of many major concepts in IT, including networking, databases, cloud computing, and hardware, which an IT Manager will need to have a foundational knowledge of. The course also explores emerging technologies, which an IT Manager could use to stay up-to-date with trends in the field.
Network Administrator
Someone interested in a career as a Network Administrator may find this course helpful, as it introduces major concepts in networking including network architectures, cabling and hardware components. While the course does not dive into specific network protocols, it may provide a helpful foundation before diving into advanced coursework in networking.
Data Analyst
Those interested in a career as a Data Analyst may find concepts in this course helpful to get their foot in the door. While this course does not go into specific programming languages for data analysis such as Python or R, it does introduce basic database concepts, the phases of the software development lifecycle, and an overview of how enterprise systems work. This broad strokes approach may help someone grasp the larger processes they may be a part of as a Data Analyst.
Database Administrator
This course may be helpful for those considering the role of Database Administrator, as it helps build a foundation for working with relational databases. The SQL Server exercises, while brief, may prepare someone to write basic queries, which is a common task for database administrators. While the course does not cover more advanced concepts like database design or optimization, it does provide a taste of what one may encounter in the field.
Web Developer
For those considering a career as a Web Developer, this course may be a helpful starting point. It includes a section that introduces HTML and basic tags, and also helps explain how the internet works. While it does not go into advanced topics like CSS, JavaScript, or specific web frameworks, it may help one starting out with web development learn some basic concepts and decide if it's the right path for them.
Software Developer
Someone interested in a career as a Software Developer may find this course helpful to grasp major concepts they'll need to study in depth later. It explains binary numbers, the building blocks of programming, and an introduction to programming basics using C. While it does not delve into specific programming languages or frameworks, it can help one considering the field test their interest by learning basic programming commands.
Database Manager
This course includes basic concepts that may be helpful for a future Database Manager, such as an introduction to relational databases and an overview of SQL Server. Database Managers who choose to specialize in MySQL could benefit a bit more from taking this course, due to the lesson dedicated to writing basic SQL queries in MySQL. While the course does not cover more advanced topics in database management, it may provide a foundational jumping-off point for someone considering the field.
Quality Assurance Analyst
This course may be helpful for those considering a job as a Quality Assurance Analyst. It helps build a foundation in the software development lifecycle and principles of testing. It also provides an overview of how to write basic queries, which could be helpful when analyzing test data. While the course does not include advanced testing concepts like test automation, it provides a very general foundation in the field.
Systems Analyst
This course may be useful for a future Systems Analyst, who typically will analyze IT requirements and develop business solutions. This course helps build a foundation in many aspects of IT, including hardware, networking, software, and security. While it does not go in-depth into the specific techniques used during systems analysis, it may help a potential Systems Analyst gain foundational knowledge before studying specialized skills in their degree.
IT Auditor
This course may be a useful foundation for those considering a job as an IT Auditor. It helps build a foundation in essential areas that drive computing and information technology today. While the course does not go into detail about auditing, risk management, or industry regulation, the broad look at major concepts may help one determine if IT auditing is a good fit, while teaching foundational concepts that will make later, specialized coursework more accessible.
Computer Science Teacher
For future Computer Science Teachers seeking to instruct at the high school or college level, this course may help build a foundation in the basics of computer hardware, the development lifecycle of software, and even the basics of HTML and basic syntax of C. While not an expert-level look into any of these domains, the survey of so many major concepts may give someone a better idea if the profession is right for them, while giving them a foundation before they dive into more specialized coursework in their degree.
Technical Writer
An individual interested in becoming a Technical Writer may find this course useful. The section covering HTML will introduce major concepts of how websites are built, a common medium that Technical Writers often create documentation for. While the course does not cover more advanced concepts like API documentation or user requirements writing, it may provide a helpful foundation for someone to gauge their interest in technical writing.
Information Security Analyst
This course may be helpful for someone considering a career as an Information Security Analyst. While not going into technical detail about security methods, threat vectors, or recovery processes, it does provide a foundation in concepts that underpin the field, and may help someone starting out grasp the scope of the field and some basic vocabulary.

Reading list

We've selected 14 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Information Technology Essentials.
A classic textbook that provides a deep dive into operating system principles and concepts. Useful as a reference or for additional reading.
A comprehensive textbook that covers computer networking fundamentals and protocols. Useful as a reference or for additional reading.
A comprehensive textbook that covers computer security principles and practices. Useful as a reference or for additional reading.
A classic business book that discusses the challenges of innovation and disruption in the technology industry. Useful for understanding the context of the IT industry.
A popular business book that promotes the use of lean principles in technology startups. Useful for understanding the principles of agile development and product management.
A classic software engineering book that provides guidance on software design, coding, and testing. Useful as a reference for software developers.
A classic book that describes common design patterns used in object-oriented software development. Useful as a reference for software developers.
A beginner-friendly introduction to Java programming. Useful for those who are new to programming or want to learn Java.
A challenging but effective way to learn Python programming. Useful for those who are serious about learning Python for practical purposes.
A thrilling true story about a computer hacker who tracked down a group of international spies. Provides an interesting perspective on computer security and the early days of the internet.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Information Technology Essentials.
Introduction to Computer Security
406: Information Securi
IT Fundamentals for Business Professionals: Hardware
IT Fundamentals for Business Professionals: Software...
IT Fundamentals for Business Professionals: Enterprise...
Technical Support Fundamentals
S303: Strategic Information Technolo
Careers in IT: How to Get Your First Job
Health Informatics for better and safer healthcare
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser