- Individuals looking to establish their credibility and value in the market as experienced Typescript Practitioners
- System Administrators
- Cloud Professionals
- Solutions Architects
- Infrastructure Architects
- Site Reliability Engineers
- Technical Leads
- Software Engineers
- Freshers
1. Introduction to Visual Basic
Learning Objective:Learn how VB is used to make applications
- Topics:
- Introduction Graphics User Interface (GUI)
- Keywords and Identifiers
- Constants and Variables
- Operators and Expressions
- Strings
2. The Visual Basic Environment IDE
Learning Objective:Introduction to VB Controls
- Topics:
- Textboxes, Frames, check Boxes, Option Buttons, list box and combo box
- Designing the user Interface
- , Keyboard access
- Default & controls property
3. Functions and Sub Procedures
Learning Objective:Learn the fundamentals of functions and Procedure Oriented Programming
- Topics:
- Parameters and Return Values
- Sub Procedures
- Functions vs. Sub Procedures
4. Functions
Learning Objective:Learn about information hierarchy and how to implement it with native navigators.
Section 4 - Decision & conditions and Controls
- Topics:
- If Statement
- If then-else Statement
- Comparing Strings
- Compound conditions (and, or Not)
- Nested if Statements
- Case Structure
- Loops
- Do loop
- while
- for next loop
5. MsgBox and InputBox
Learning Objective:Learn how to manage and configure your infrastructure using Ansible Ad-Hoc commands, Playbooks, and Roles.
Section 5 -
- Topics:
- MsgBox
- VB Constants
- Style
- InputBox
- Working with InputBox
6. Objects
Section 6 - Goroutines and Channels Concurrency vs. Parallelism Goroutine Functions and Lambdas Wait Groups Channels Sending and Receiving Unbuffered and Buffered Channels Directional Channels Multiplexing with select Timers and Tickers Learning Objective:In this module, you will learn how to write your application using ES6. Also, you will learn how to Design Dashboard and perform CRUD operations.
- Topics:
- Objects
- Excel Objects
- Worksheet Object
- Workbook Object
- Cells and Ranges as objects
- Object events and properties
- Assign events to objects in Excel sheets
- User Forms
- Charts, Embedded Charts and ChartSheets
7. Packages and Testing
Learning Objective:In this module, you will learn how to secure your application by implementing API Authentication and User authentication using JSON Web Tokens (JWT).
- Topics:
- Range selection,
- Referring to Ranges in other sheets
- The Offset property, Columns and Rows to refer to Ranges
- Retrieve the address in ranges, Size and resize ranges
- Join multiple ranges
- Merge ranges
- Intersect ranges
- Format ranges
- Special cells
- Formulas in ranges and Excel objects
8. VBA Dialogs
Learning Objective:In this module, you will learn how Build Realtime Chat Application using Socket.IO.
- Topics:
- Standard Excel Dialogs
- VBA constants for dialogs
- Combining VBA constants for complex statements in dialogs
- The InputBox
9. Special functions
Learning Objective:Learn how to provision and manage infrastructure on a Cloud Platform (AWS) using Terraform Configuration Files.
- Topics:
- Excel functions in VBA functions
- Custom Excel functions, complex functions
9. Conditional Types Decorators
Learning Objective:Learn how to provision and manage infrastructure on a Cloud Platform (AWS) using Terraform Configuration Files.
- Topics:
- For..Next Loops
- Do Loops
- While..Wend loops
- Do While Loops
- Do Until Loops
- For Each loop
9. The String object and the String functions
Learning Objective:Learn how to provision and manage infrastructure on a Cloud Platform (AWS) using Terraform Configuration Files.
- Topics:
- The String object
- String functions