Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

VB Scripting for Windows Administrators

( Duration: 4 Days )

In VB Scripting for Windows Administrators training course, you will learn the basics of using scripts to manipulate an object based environment. The course will then use VBScript to access and manipulate the WSH objects, the FileSystemObject, the Excel object model and the ADO objects for accessing databases. You will learn to write scripts that automate applications, parse log files for specific information, map network drives, and install printers and applications, amongst others things. Due to the practical nature of scripting, there will be a large element of hands on lab work with an emphasis on creating reusable, useful sample scripts that can be employed in the work place.

By attending VB Scripting for Windows Administrators workshop, delegates will learn to:

  • Understand the thought processes of a programmer
  • Build basic specifications and flowcharts
  • Understand VBScript programming syntax
  • Understand the benefits of procedural programming
  • Understand objects
  • Identify the benefits of scripting tasks and use scripts to automate repetitive tasks
  • Write scripts that manage a users network printers and drives
  • Automate the running of various programs such as disk defragmenter
  • Edit the registry with scripts
  • Gather network information using scripts
  • Read, and write to log files
  • Write scripts that can be launched remotely
  • Identify the mechanisms used to access spreadsheets and databases
  • Use scripts to read and write information to spreadsheets and databases

This VB Scripting for Windows Administrators class is meant for administrators/IT professionals who have and would like to use VB Script to ease their administrative burden by automating repetitive tasks. The typical attendees will be an administrator/IT professional who is interested in examining how scripts can benefit and enhance their day-to-day environment.

COURSE AGENDA

1

An Introduction To Programming

  • Explanation of what a program is: How to design a program
  • Understanding the Specification
  • Use Cases
  • Flowcharts and Psuedo Code
  • Logical layers
  • Development LifeCycle
  • Other Issues
2

VBScript Fundamentals

  • What is scripting?
  • Writing VBScript code
  • Variables and constants
  • Operators
  • Boolean Logic
  • Logical decision making
  • Looping statements
3

Procedural Programming

  • What is procedural programming
  • Subroutines and Functions
  • Writing and calling procedures
  • Scope
  • MsgBox and InputBox
4

Object Fundamentals

  • What is an object
  • Type libraries and classes
  • How to create and use objects
  • What are properties and methods
  • How to access properties and methods
  • How to identify the available objects in a library
  • How to identify the available properties and methods
5

Automating Applications and command line tools

  • Using the WSH Shell object to launch applications
  • Control them and manipulate their output
  • Creating a ping function to check machine availability
6

User Input through WSH

  • Getting user input through arguments and the standard input streams
7

The Registry

  • Reading information from the registry
  • Deleting registry values and keys
  • Creating and modifying the registry
8

Shortcuts

  • Creating shortcuts
  • Accessing the paths to special folders via script
9

The Network Object

  • Mapping network drives
  • Enumerating mapped drives and installed printers
  • Installing printers via script
10

Folders

  • Enumerating folders
  • Creating and deleting folders
  • Reading and modifying folder properties
  • Retrieving drive information
11

Files

  • Enumerating files
  • Creating and deleting files
  • Reading and writing to files
  • Sending emails via the FileSystemObject
12

Spreadsheets

  • Using the Excel objects to read from and write to spreadsheets
13

Databases

  • Using the ActiveX Data Object model to access databases
  • System DSNs
  • Reading and Writing to SQL databases
14

VBScript Functions Reference

  • Functions provided in VBScript
  • String, date and numeric functions
  • Conversion Functions
  • Is Functions
15

WMI

  • Using simple scripts to utilise Windows Management Instrumentation (WMI)
  • The WMI scriptomatic tool
16

ADSI

  • Using simple scripts to utilise Active Directory Services Interface (ADSI)
  • The ADSI scriptomatic tool

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X