Visual basic training
In December 2011, Tata Institute of Social Sciences set up the School of Vocational Education (SVE) to provide immediate and definite interventions to improve the lives of the disadvantaged and marginalized youth, especially who are excluded by the formal school education system, through appropriate vocational training programmes. It has been set up with a vision of creating an ecosystem that would bring back the dignity of labour for blue collar streams of work and create sustainable sources of income. This project has been initiated under the aegis of All India Council for Technical Education (AICTE) proposed by the Ministry of HRD, Government of India.
1.1Introduction and Course Objectives:
VB.Net is a simple, modern, object-oriented computer programming language developed by Microsoft to combine the power of .NET Framework and the common language runtime with the productivity benefits that are the hallmark of Visual Basic.
Visual Basic was initially introduced in 1991 as the first programming language that directly supported programmable graphical user interfaces using language-supplied objects. From that time until 2002, there were five other versions released, each version having features that increased the power of the language. In 2001, Microsoft released the .NET (pronounced “dot net”) platform. Visual Basic .NET, or VB.NET, is an upgrade to the last version of VB (version 6.0) that conforms to the .NET platform. As you will see in subsequent chapters, the changes in VB.NET allow programmers to write Web or desk-top applications within the same language. In addition, VB.NET is fully object-oriented as opposed to prior versions that had many, but not all, of the elements of an object-oriented language. This book is based on VB.NET. In the balance of the book we will sometimes refer to Visual Basic as VB, omitting .NET. From a programming viewpoint, Visual Basic is an object-oriented language that consists of two fundamental parts: a visual part and a language part. The visual part of the language consists of a set of objects, while the language part consists of a high-level procedural programming language. These two elements of the language are used together to create applications. An application is simply a Visual Basic program that can be run under the Windows operating system
This course provides VB.NET training according to the current requirement of IT industry. The objective of this certification course is to develop VB.NET programming understanding to the students so that they will be able to make VB.NET applications on their own.
1.2. Eligibility for Admission
The candidate should pass 10+2 in any discipline
1.3. Employability/Skill enhancement
Undergoing the VB.NET Programming certificate course will give the students an upper hand in comparison to others as they will receive additional specialized training as follows:
- After completion of VB.NET training students can easily able to use object-oriented features of the VB.NET language, such as encapsulation, inheritance and polymorphism.
- Use arrays and other data collections
- Implement error-handling techniques using exception handling
- Can easily create GUI applications using Swing components: panels, buttons, and labels.
Method of Teaching:
A combination of vocational theory inputs along with relevant practical exposure that would commensurate with the guidelines provided in the Facilitator’s guide.
Method of Assessment & Weightage:
The assessment of students would be done in written and practical examination.
- Written – 40%
- Practical examination – 60%
2. Course Structure
Duration of Course – 3 Months
Credits for course – 10 Credits
Duration of Course – 210 Hours [For Theory (classroom) courses, 1 credit = 15 hours For Practical training, 1 credit = 30 hours]
|Sr. No.||Subject||Credits||Duration Hrs.|
|1.||IT Foundations & Programming Concepts||2||30|
|2.||Database Management Systems-Theory & Practice||2||30|
|3.||PROGRAMMING WITH VISUAL BASIC.NET||2||30|
IT Foundations & Programming Concepts
- To create overall generic awareness about scope of the field of IT and to impart basic personal computing skills.
- To create background knowledge for the various courses in the programme.
- To introduce the basic terminology in the field of IT
- To impart functional knowledge about PC hardware, operations and concepts
- To impart functional knowledge about networks and internet.
- To give an overview of computer application in various fields and an overall generic awareness about the scope of the field of IT
- To give an overview about problem solving steps, Develop algorithm for different problems, Draw flow chart, Analyse algorithms
Computer characteristics: Speed, storage, accuracy, diligence; Digital signals, Binary System, ASCII; Historic Evolution of Computers; Classification of computers: Microcomputer, Minicomputer, mainframes, Supercomputers; Personal computers: Desktop, Laptops, Palmtop, Tablet; Hardware & Software; Von Neumann model.
Hardware: CPU, Memory, Input devices, output devices. Memory units: RAM (SDRAM, DDR RAM, RDRAM etc. feature wise comparison only); ROM-different types: Flash memory; Auxiliary storage: Magnetic devices, Optical Devices; Floppy, Hard disk, Memory stick, CD, DVD, CD/DVD-Writer; Input devices – keyboard, mouse, scanner, speech input devices, digital camera, Touch screen Voice Input, Joystick, Optical readers, bar code reader; Output devices: Display device, size and resolution; CRT, LCD, LED; Printers: Dot-matrix, Inkjet, Laser; Plotters, Sound cards & speaker.
Software- System software, Application software; concepts of files and folders, Introduction to Operating systems, Different types of operating systems: single user, multitasking, time-sharing multi-user; Booting, POST; Basic features of two GUI operating systems: Windows & Linux (Basic desk top management); Programming Languages, Compiler, Interpreter, Databases; Application software: Generic Features of Word processors, Spread sheets and Presentation software; Generic Introduction to Latex for scientific typesetting; Utilities and their use; Computer Viruses & Protection, Free software, open source.
Computer Networks and Internet- Connecting computers, Requirements for a network: Server, Workstation, switch, router, network operating systems; Internet: brief history, World Wide Web, Websites, URL, browsers, search engines, search tips; Internet connections: ISP, Dial-up, cable modem, WLL, DSL, leased line Wireless and Wi-Fi connectivity ; email, email software features (send receive, filter, attach, forward, copy, blind copy); characteristics of web-based systems, Web pages, Web Programming Languages.
Information Technology And Society – Indian IT Act, Intellectual Property Rights, issues. Application of information Technology in Railways, Airlines, Banking, Insurance, Inventory Control, Financial systems, Hotel management, Education, Video games, Telephone exchanges, Mobile phones, Information kiosks, special effects in Movies.
Programming Concepts & Techniques – Program Concept, Characteristics of Programme, Stages in Program Development, Tips for Program Designing, Programming Aids, Algorithms, Pseudo code, Notations, Design, Flowcharts, Symbols, Rules, compiler & Interpreter. Introduction to programming techniques, Top-down & Bottom-up approach, Unstructured, & Modular programming, Cohesion, Coupling, Debugging, Syntax & Logical Errors, Linking and Loading, Testing and Debugging, Documentation.
- E. Balaguruswamy, Fundamentals of Computers, McGraw Hill, 2014
- Dennis P Curtain, Information Technology: The Breaking wave, McGrawhill, 2014
- Peter Norton, Introduction to Computers, McGrawhill, Seventh edition
Database Management Systems-Theory & Practice
- To create generic awareness about general concepts of database management systems.
- To background knowledge for the oracle and SQL & PL/SQL.
- To introduce the basics of database in programming.
- To impart functional knowledge about data models and keys.
- To impart functional knowledge about MS access.
Operational data, Purpose of database system, Views of data, Data models: Relational, Network, Hierarchical, Instances & Schemes, Data Dictionary, Types of Database languages : DDL, DML, Entity Relationship Model as a tool of conceptual design : Entities & Entity set, Relationship & Relationship set, Attributes, Mapping Constraints, Keys, Entity-Relationship diagram (E-R diagram) : Strong & weak entities, Generalization, Specialization, Aggregation, Reducing ER diagram to tables
Concepts of Keys : Candidate key, Primary Key, Alternate Key, Super Key, Foreign Key, Fundamental integrity rules : Entity integrity, Referential integrity.
Different types of joins i.e. theta join, equi join, natural join, outer join, set operations .Structured query language(SQL), Codd’s rules,
Functional Dependencies, Good & Bad Decomposition, Anomalies as a database : A consequences of bad design, Universal Relation, Normalization : First, Second, Third & BCNF Normal Forms, Multivalues Dependency, Join Dependency & forth Fifth Normal Form
Popular RDBMS available in the market, Introduction to MS Access, Creating Databases using MS Access, Creating and Using Tables in MS Access, Modifying tables in Access, Query in MS Access, Creating and using reports in MS Access, Printing Reports in MS Access, Importing and exporting in MS Access,
Oracle introduction, Client and server communication (SQL) Data Definition Language (DDL) – Creating, Altering & Dropping Tables, Oracle Data Types, Integrity Constant, Data Manipulation Language (DML) – Select Insert, Update, Delete Commands, Sorting in oracle, Joins in Oracle-Inner,Outer, Cartesian, Self-join, Non-equi joins, Transaction Control Using ,SQL – Commit, Rollback, Savepoint Command, Data Controlling Using SQL – Grant, Revoke, Set Role, SQL functions,Indexes and views
PL/SQL, SQL & PL/SQL, Differences, Blocking Code for Clarity, Using Variables, Constant and Data Types, Assigning Data Base Values to Variables, Select Into ….. Cursors using Flow Control and Loop Statements, Goto Statement. Error handling built in PL / SQL Exceptions, User – Defined Exceptions, Unhandled
Exception, the Raise – Application – Error Procedure. PL / SQL Programs Anonymous PL / SQL Blocks, Stored Procedure,
Function & Packages, Using Database Triggers.
TEXT & REFERENCE BOOKS :
- “DATABASE MANAGEMENT SYSTEM” bY Leon & Leon, Vikas Publications
- Oracle Database 12c- Hands on SQL and PL/SQL by Ashis Asnani, PHI
- “DATABASE SYSTEM CONCEPTS” by Henry F.Korth & Abraham Silberschatz
- “AN INTRODUCTION TO DATABASE SYSTEM” by Bipin C.Desai
- “Database Management and Oracle Programming” 2nd Edition By S. S. Khandare , S. Chand Publisher
- “Oracle A Beginners Guide” by Michael Abbey & Michael J. Corey TMH Publications
PROGRAMMING WITH VISUAL BASIC.NET
(THE SYLLABUS IS BASED ON THE VISUAL STUDIO 2010)
- To gain overall generic knowledge about .net framework and visual studio.
- To gain knowledge of VB.NET language programming language.
Upon successful completion of the course, the student will be able to:
- Create a new project using VB.Net language in visual studio.
- Identify the Main, Form and Toolbox
- Write Visual basic code
- Build a user interface
- Compile a Visual Basic application and build executables
- effectively develop applications with full functionality and a graphical user interface using the language Visual Basic
Introduction to .NET, .NET Framework 4.0 features & architecture, CLR, Common Type System, MSIL, Assemblies and class libraries. Introduction to Visual Studio, Project basics, types of project in .Net, IDE of VB.NET- Menu bar, Toolbar, Solution Explorer, Toolbox, Properties Window, Form Designer, Output Window, Object Browser.
Visual Studio 2010 environment: Editor tab, format tab, general tab, docking tab. visual development & event drive Programming -Methods and events.
The VB.NET Language- Variables -Declaring variables, Data Type of variables, Forcing variables declarations, Scope & lifetime of a variable, Constants, Arrays, types of array, control array, Collections, Subroutines, Functions, Passing variable Number of Argument Optional Argument, Returning value from function.
Control flow statements: conditional statement, loop statement. Msgbox & Inputbox.
UNIT – III
Working with Forms : Loading, showing and hiding forms, controlling One form within another.
GUI Programming with Windows Form: Textbox, Label, Button, Listbox, Combobox, Checkbox, PictureBox, RadioButton, Panel, scroll bar, Timer, ListView, TreeView, toolbar, StatusBar.There Properties, Methods and events. OpenFileDilog, SaveFileDialog, FontDialog, ColorDialog, PrintDialog. Link Label.
Designing menues : ContextMenu, access & shorcut keys.
Object oriented Programming: Classes & objects, fields Properties, Methods & Events, constructor, inheritance. Access Specifiers: Public Private, Projected. Overloading, My Base & My class keywords.
Overview of OLE, Accessing the WIN32 API from VB.NET & Interfacing with MS Office, COM technology, advantages of COM+, COM & .NET, Create User control, register User Control, access com components in .net application.
Error Handling in VB.Net applications
Database programming with ADO.NET – Overview of ADO, from ADO to ADO.NET, Accessing Data using Server Explorer. Creating Connection, Command, Data Adapter and Data Set with OLEDB and SQLDB. Display Data on data bound controls, display data on data grid. Using DataGridView Control. Generate Reports Using CrystalReportViwer.
TEXT & REFERENCE BOOKS :
VB.NET Programming Black Book by steven holzner –dreamtech publications
Mastering VB.NET by Evangelos petroutsos- BPB publications
Introduction to .NET framework-Worx publication
Trainer at the HUB location is suppose to guide the students for the Practical related to Database management & VB.NET programming language.