Software, Programming, and Database Basics

About

Maintaining and updating software is an important activity for a Technical Support role. There are many types of software, and understanding software can be overpowering. This course introduces the fundamentals of software and how to manage software from an information technology (IT) perspective. You'll be introduced to various types of software, ranging from the operating system running on your mobile phone to the applications that run databases on your computer at work. You'll also learn about cloud computing, web browsers, software development, programming languages, and database fundamentals.

After completing this course, you will better understand software processes and gain confidence in using and securing software applications. You will also review installing and managing web browsers, extensions, and plug-ins and keeping web browsers secure and updated.

Additionally, you'll discover how cloud-based technologies help businesses create and deploy applications faster. This course provides several real-world inspired hands-on labs and activities to demonstrate your skills in programming with Python and working with a database.

What you will learn

• Classify, install, configure and manage software including mobile platforms.
• Discuss cloud computing and web browser concepts.
• Explain software development models, techniques, and concepts.
• Describe fundamental database management concepts.

Skills you learn

• Cloud Computing
• Application Deployment
• Python (Programming Language)
• Information Technology
• Operating Systems
• Web Browsers
• Technical Support
• Software Development

Syllabus

Module 1: Computing Platforms and Software Applications

• Computing Platforms and Compatibility
• Commercial and Open Source Software
• Software Licenses
• Software Installation Management
• Software Versions
• Productivity, Business, and Collaboration Software
• Hands-on Lab: Getting Started with Excel Online
• Types of File Formats
• Activity: Recognizing File Formats

Module 2: Fundamentals of Web Browsers, Applications, and Cloud Computing

• Common Web Browsers
• Browser Installs and Updates
• Browser Plug-ins and Extensions
• Basic Browser Security Settings
• Browser Security Certificates and Pop-ups Settings
• Private Browsing and Client-side Scripting Settings
• Activity: Managing Browser Plug-ins and Extensions
• Introduction to Cloud Computing and Cloud
• Deployment and Service Models
• Application Architecture and Delivery Methods
• Software Development Life Cycle

Module 3: Basics of Programming

• Interpreted and Compiled Programming Languages
• Comparing Compiled and Interpreted Programming Languages
• Query and Assembly Programming Languages
• Understanding Code Organization Methods
• Branching and Looping Programming Logic
• Activity: Programming Logic and Organizational methods
• Introduction to Programming Concepts Part 1
• Introduction to programming Concepts Part 2
• Hands-on lab: Programming Fundamentals with Python

Module 4: Database Fundamentals

• Types of Data, Sources, and uses
• Database Fundamentals and Constructs
• Database Roles and Permissions
• Database types
• Interfacing with Databases
• Database Management
• Backing Up Databases
• Hands-on Lab: Basic Database Operations

Module: Final Quiz

Auto Summary

Discover the essential foundations of IT and Computer Science with the "Software, Programming, and Database Basics" course offered by edX. Designed for beginners, this comprehensive 14-week program delves into the core concepts of software development, programming languages, web browsers, cloud computing, and database management. Gain a solid understanding of these crucial topics through a structured curriculum that caters to foundational knowledge. Flexible subscription options, including Starter and Professional plans, ensure that you can learn at your own pace and according to your needs. Ideal for aspiring IT professionals and computer science enthusiasts, this course equips you with the critical skills needed to navigate the rapidly evolving tech landscape. Join today and start building your expertise from the ground up!