VBScripting Fundamentals (Updated 2021) from Udemy

Most of the content is re-recorded using VSCode Editor
Added a module on WSH (Windows Scripting Host)
Added a module on ADO (Working with MS SQL Server)

VBScript is an Active Scripting language developed by Microsoft. VB scripting allows users to automate tasks in a Windows environment. The concepts from this course benefit regular users (wanting to experiment) and QTP/UFT professionals. VBSkills enables QA Engineers to move their efficiency to a QA Engineers, QTP/UFT engineers, System Administrators, and Network Administrators use VBScripting skills to automate simple to complex daily tasks.

We will start from the basics and walk you through a learning journey to master the skills.

The course begins with variables, arrays, operates, and error handling. After you learn these basic skills, we jump into the conditional statements and loops. We have included a module to help you master the built-in functions. These built-in functions come real handy as you don't have to code that functionality.

You will also learn to work with Files, Folders, Excel Documents, and MS SQL Server.

The projects at the end of the course help you to move to the next level by pushing you to most of the skills gained in this course.

There is no replacement for hands-on coding. You will learn to code like a professional developing reusable code.

The Sample Scripts included helps students to learn quickly and experiment by modifying them. The course is well organized with High-Quality Videos, and sample scripts.

What's inside

Learning objectives

Create vb scripts
Create conditional statements
Create loops
Create reusable vb functions.

Learn to work with drives, folders and drives using file system object (fso).
Learn to work with excel object model
Learn to work with wsh

Create vb scripts
Create conditional statements
Create loops
Create reusable vb functions.
Learn to work with drives, folders and drives using file system object (fso).
Learn to work with excel object model
Learn to work with wsh

Syllabus

Getting Started

Here is what you will learn in this course:

Variables & Constants
Message Box
Accepting User Input
Arrays - Single Dimension & Two Dimensions
Operators
Error Handling
Data Types
Conditional Statements - IF & Select
Nested Conditional Statements
Loops -
- Do...While
- Do...Until
- For
- For Each
- While...Wend
Procedures
ByVal & ByRef
FSO - File System Object
Working with Excel
WSH (Windows Scripting Host)

Here are our recommendations for this course:

Editors:
- Notepad will work just fine. However, notepad++ or VSCode might be a better choice.
- To the most part, the course lectures utilize VSCode.
Practice:
- Nothing replaces hands-on coding.
- Do not skip assignments & projects.

Here is what you will learn in this section:

Procedures
ByVal & ByRef

Career center

Learners who complete VBScripting Fundamentals (Updated 2021) will develop knowledge and skills that may be useful to these careers:

Quality Assurance Engineer

As a Quality Assurance Engineer, you play a critical role in ensuring software reliability by designing and executing tests. This often involves creating automated test scripts to ensure efficiency and repeatability. The VBScripting Fundamentals course is particularly relevant here, as it directly addresses skills vital for test automation platforms like QTP/UFT, which leverage VBScript. Learners will master creating conditional statements, loops, and reusable functions—foundational elements for robust test scripts. The ability to work with Excel Object Model and handle files and folders through the File System Object, as taught in this course, also directly applies to managing test data and reporting test results effectively. This course helps learners gain the hands-on coding experience to automate complex daily tasks in a QA environment.

See salaries and explore the career path for Quality Assurance Engineer

System Administrator

System Administrators are responsible for the upkeep, configuration, and reliable operation of computer systems, especially servers. A significant part of this role involves automating routine maintenance, troubleshooting, and deployment tasks to ensure system stability and efficiency. The VBScripting Fundamentals course directly supports this by enabling System Administrators to automate simple to complex daily tasks within a Windows environment. Skills such as working with Windows Scripting Host (WSH) for system-level operations, managing files and folders using the File System Object (FSO), and handling errors are crucial. The course's focus on conditional statements, loops, and procedures helps in developing sophisticated scripts for system monitoring, user management, and configuration adjustments.

See salaries and explore the career path for System Administrator

Automation Engineer

An Automation Engineer focuses on streamlining repetitive processes across various systems, often within a Windows environment. This role is about identifying manual tasks and developing scripts or tools to perform them automatically. The VBScripting Fundamentals course provides a strong foundation for this career path by teaching how to automate tasks using VBScript, an Active Scripting language developed by Microsoft. Learners will acquire essential skills such as working with Windows Scripting Host (WSH), manipulating files and folders via the File System Object, and interacting with Excel Documents and MS SQL Server. The emphasis on creating reusable VBScript functions, variables, arrays, and error handling helps learners develop efficient and reliable automation solutions, making them well-prepared for the challenges of an Automation Engineer.

See salaries and explore the career path for Automation Engineer

Network Administrator

Network Administrators manage the infrastructure that enables communication between computers and devices. This includes monitoring network performance, configuring devices, and ensuring security, often requiring repetitive checks and commands. The VBScripting Fundamentals course enhances the capabilities of a Network Administrator by providing the skills to automate many of these tasks within a Windows environment. Learning to work with Windows Scripting Host (WSH) can be particularly beneficial for executing scripts across multiple machines or integrating with network tools. The ability to manage files and folders via the File System Object (FSO), coupled with skills in error handling and conditional logic, helps streamline network diagnostics, log analysis, and configuration deployment, thereby boosting efficiency in daily operations.

See salaries and explore the career path for Network Administrator

Desktop Automation Developer

A Desktop Automation Developer focuses on creating scripts and tools to automate repetitive tasks performed directly on a user's desktop or within a Windows operating system. This role streamlines workflows and improves personal or team productivity. The VBScripting Fundamentals course is ideal for an aspiring Desktop Automation Developer, providing comprehensive training in automating tasks in a Windows environment using VBScript. Learners will gain proficiency in working with the Windows Scripting Host (WSH) to interact with the operating system, and the File System Object (FSO) for managing files and folders. The course also teaches how to automate interactions with Excel Documents. Mastering variables, conditional statements, and loops helps in building intelligent and robust scripts that execute tasks seamlessly on any Windows desktop.

See salaries and explore the career path for Desktop Automation Developer

Legacy Systems Support Engineer

A Legacy Systems Support Engineer specializes in maintaining, troubleshooting, and occasionally enhancing older software systems that are still critical to an organization's operations. Many legacy systems, particularly in Windows environments, may utilize VBScript for automation or internal logic. The VBScripting Fundamentals course is highly relevant for a Legacy Systems Support Engineer, providing the core skills needed to understand, debug, and modify existing VBScript codebases. Learners will gain proficiency in VBScript syntax, error handling, file system operations, and database interactions (ADO with MS SQL Server), which are common components in older automated processes. This course helps in effectively supporting and extending the lifespan of essential legacy applications.

See salaries and explore the career path for Legacy Systems Support Engineer

Business Process Automation Specialist

Business Process Automation Specialists analyze existing workflows to identify inefficiencies and implement automated solutions, often using scripting to connect systems or automate data handling. The VBScripting Fundamentals course provides highly relevant skills for an aspiring Business Process Automation Specialist, especially in Windows-centric organizations. Learners gain proficiency in automating tasks in a Windows environment, which is fundamental to this role. The ability to work extensively with Excel Documents and MS SQL Server for data processing, coupled with mastering File System Object (FSO) for file management, are invaluable for designing scripts that streamline common business operations, from data entry to report generation. The focus on reusable code helps in building adaptable automation solutions.

See salaries and explore the career path for Business Process Automation Specialist

Report Automation Developer

A Report Automation Developer specializes in creating and deploying automated systems for generating reports from various data sources, ensuring timely and accurate information delivery. This often involves intricate data extraction, transformation, and presentation. The VBScripting Fundamentals course is highly relevant for this career path, particularly for reports generated within a Windows ecosystem. Learners will gain expertise in working with MS SQL Server (ADO) for data retrieval and processing, and critically, automating Excel Documents for report formatting and delivery via the Excel Object Model. The course's focus on loops, conditional statements, and reusable functions helps in building flexible and dynamic reporting scripts, reducing manual effort and potential errors in data presentation.

See salaries and explore the career path for Report Automation Developer

Information Technology Operations Analyst

An Information Technology Operations Analyst assesses IT processes and systems to identify areas for improvement and automation, aiming to enhance efficiency and reliability of IT operations. This often involves understanding how to script solutions for recurring operational challenges. The VBScripting Fundamentals course helps an Information Technology Operations Analyst by providing the practical skills to implement automation strategies within a Windows environment. Learners will become proficient in automating tasks, working with Files, Folders, and leveraging the Windows Scripting Host (WSH). The ability to develop reusable VBScript functions, manage errors, and utilize conditional logic allows for the creation of robust scripts that can streamline IT processes, from system checks to data synchronization, ultimately improving operational effectiveness.

See salaries and explore the career path for Information Technology Operations Analyst

Technical Support Engineer

A Technical Support Engineer assists users with technical issues, often diagnosing problems and providing solutions for software or hardware. In this role, efficiency is key, and automating common troubleshooting steps or information gathering can save significant time. The VBScripting Fundamentals course helps a Technical Support Engineer by equipping them with the ability to create simple scripts for automating diagnostic procedures or common fixes in a Windows environment. Understanding Windows Scripting Host (WSH) assists in managing local system settings, while File System Object (FSO) skills allow for automated log collection or configuration file manipulation. The course’s emphasis on error handling and conditional statements ensures that scripts are robust and can respond intelligently to various system states.

See salaries and explore the career path for Technical Support Engineer

Application Support Engineer

Application Support Engineers are crucial in maintaining the functionality and availability of software applications, often troubleshooting issues and performing routine maintenance. This role frequently involves interacting with the application's environment, logs, and databases. The VBScripting Fundamentals course is helpful for an Application Support Engineer, as it equips them with the ability to automate diagnostic and maintenance tasks for applications running in a Windows environment. Skills in working with the File System Object (FSO) are vital for automating log file analysis or configuration management. Interacting with MS SQL Server (ADO) helps in scripting database checks or data fixes. The course’s emphasis on error handling and creating reusable VBScript functions allows for the development of robust tools that enhance application stability and support efficiency.

See salaries and explore the career path for Application Support Engineer

Database Operations Specialist

A Database Operations Specialist is responsible for the routine management, maintenance, and scripting tasks related to databases, ensuring their performance, security, and availability. This often involves scripting administrative tasks. The VBScripting Fundamentals course is particularly beneficial for a Database Operations Specialist, especially when working with Microsoft SQL Server. The course includes a dedicated module on ADO (ActiveX Data Objects) for working with MS SQL Server, which directly enables the automation of database queries, data manipulation, and routine administrative scripts. Skills in error handling, conditional statements, and creating reusable VBScript functions help in building reliable scripts for tasks like data backups, integrity checks, and automated reporting, greatly enhancing database management efficiency.

See salaries and explore the career path for Database Operations Specialist

Data Analyst

Data Analysts collect, process, and perform statistical analyses on data to help organizations make informed decisions. A significant portion of this work involves repetitive data preparation, extraction, and transformation from various sources. The VBScripting Fundamentals course supports a Data Analyst by building skills to automate these crucial data handling tasks. The course's modules on working with MS SQL Server (ADO) and the Excel Object Model are particularly beneficial for automating data extraction, cleaning, and reporting directly within common business tools. Learning to use variables, arrays, loops, and conditional statements enables the creation of efficient scripts to manipulate data and generate customized reports, saving significant manual effort and ensuring data consistency.

See salaries and explore the career path for Data Analyst

Information Technology Support Specialist

An Information Technology Support Specialist is often the first point of contact for technical issues, performing basic troubleshooting and maintaining IT assets. Automating routine tasks can significantly enhance productivity and response times. The VBScripting Fundamentals course can be very helpful for an Information Technology Support Specialist by providing practical scripting skills to automate common administrative and support tasks in a Windows environment. Learners will acquire knowledge of Windows Scripting Host (WSH) to interact with the operating system and File System Object (FSO) to manage user files or system configurations. The ability to create conditional statements and loops also aids in developing scripts for rapid diagnostics or system checks, improving the speed and accuracy of support operations.

See salaries and explore the career path for Information Technology Support Specialist

Office Efficiency Specialist

An Office Efficiency Specialist focuses on optimizing daily administrative and data management tasks within an office setting, often identifying opportunities for automation. This role aims to reduce manual effort and improve overall productivity. The VBScripting Fundamentals course directly supports an Office Efficiency Specialist by providing the skills to automate numerous tasks in a Windows environment, especially those involving common office applications. Proficiency in working with Files, Folders, and the Excel Object Model enables the creation of scripts to manage documents, process spreadsheets, and automate data workflows. The ability to create reusable VBScript functions and handle user input means tailored solutions can be developed to streamline repetitive clerical or data-intensive processes, significantly boosting workplace efficiency.

See salaries and explore the career path for Office Efficiency Specialist