Vskills has developed a new strategic framework for Skill Development for early school leavers and existing workers, especially in the unorganized sector to improve their employability called Trade Employable Skills (TES).
Trade Employable Skills does effective assessment and certification of candidates in different trade disciplines like Electrical, Electronics, Agriculture, Chemical, Automobile, IT, etc to make them job ready.
Why should one take this certification?
To demonstrate clear understanding and practical aspects and to get a visible recognition for this knowledge.
Table of Content
https://www.vskills.in/certification/Vskills-Certified-Database-Processing-Operator-Table-of-Content
Practice Test
https://www.vskills.in/test/
Companies that hire Database Processing Operator
All small and medium companies need certified employees who have the requisite skills. There are more jobs opening up in the economy on a regular basis with the fast growth of the country.
Apply for Certification
By Net banking / Credit Card/Debit Card
We accept Visa/Master/Amex cards and all Indian Banks Debit Cards. There is no need to fill application form in case you are paying online.
Please click buy now to proceed for online payments.
|
TABLE OF CONTENT
Basic structure of Computer & its essential parts
- HISTORY
- The Abacus
- Algorithm
- Boolean algebra
- Babbage’s engines
- Turing’s Universal Machine
- Vacuum tube
- ENIAC
- Transistors
- Integrated circuits
- Micro computers
- Mini computers
- Mainframes
- Super computers
- BASIC OF COMPUTER
- Types of Computers
- The system unit (CPU)
- Input devices
- Multimedia Keyboard
- Optical mice
- Output devices
- TFT monitor
- Printer
- Other Input and Output devices
- Optical Scanner
- Digital Audio Tape (DAT)
- Zip drive
- USB Flash drive
- Modem
- UPS (Un-interrupted Power Supply)
- Familiarizing with disk drives
- Secondary memory devices
- Floppy Disk
- Floppy Diskette Drive
- Tips for removing the Floppy diskette drive
- Floppy Drive Troubleshooting
- Hard disk Trouble shooting
- CD ROM
- Advantages of Secondary Storage Devices
- Limitations of Secondary Storage Device
- CD ROM Drive
- CD drive troubleshooting
- Video Compact Disc (VCD)
- VCD Hardware and Software Requirements
- Digital Video Disc (DVD)
Motherboard, Cables and Connectors of a PC system
- Basic Computer
- Cables and connectors
- Connector/converters
- Basics of Mother Board
- Processor Sockets
- Memory packaging
- Need for expansion slots
- Types of IO buses
- AGP Accelerated Graphic Port
- Bus speeds
- Interrupts
- Chip sets
- BIOS
- POST
- Cooling system in a PC
- Memory
- Dynamic RAM (DRAM)
- Static RAM (SRAM)
- Main memory
- Cache Memory
Computers and Operating system
- Introduction to PC Family
- PC
- PC / XT
- PC / AT
- LAPTOP
- PALMTOP
- DESKTOP
- Introduction to Operating Systems
- DOS
- The command interpreter (COMMAND. COM)
- The Basic input/output System (BIOS)
- The DOS utilities
- WINDOWS
- Introduction
- Windows XP Professional
- BOOTING PROCESS
- Booting sequence
- Booting from A Floppy Disk
- Booting from A Hard Disk
- Warm and Cold Boot
- System Date and Time
- COMMAND
- Syntax
- DOS Command, Syntax, switches and examples
- Important Notes
- 2 TIME
- Important notes
- 3 CLS
- 4 PROMPT
- Meta-string
Creating Subdirectories, changing directories, listing & searching files
- Hierarchical Directory System
- ROOT
- Path
- DOS COMMANDS
Methods to display the contents of a text file
- TYPE
- Renaming of file(S)
- Copying files
- Switches
- Copy concatenating
File operations using DOS Commands
- Creating a new file using copy con command
- Comparing Files: FC
- Search Specific Lines in a File
- Graphically Display Structure of a directory
- Copy Group of Directories and Sub-Directories
- Remove Directory
I/O operations
- I / O re-direction
- Print screen
- Character echoing
- File printing
- FORMAT message
- Safe Formatting
- Using one drive for copying
Attrib and simple batch file
Invoking \ Closing Application(s) from Window XP desktop
- Starting window XP
- Components of windows DESKTOP
Creating and working with folder and text file
- Creating a new folder
- Working with folder shortcuts and customizing icons
- Create and Edit ASC II Text files using Notepad
- Creating a new document
- Editing an Existing Text Document
- Moving around the text
- Selecting text
- Cut, Copy and Paste
- Deleting the text
Working with files, folders and drives
- Viewing contents of My Computer
- Understanding contents of My Computer
- Invoking windows explorer application
- Changing the working folder
- Changing the working drive
- Scrolling the window
- Changing the icon viewing arrangement
- Tiles
- Icon
- List
- Details
- Thumbnails
- Filmstrip
- Show in Groups
- Copy files \ folders to floppy diskette
- Format Floppy Diskette
- Format options
Working with system setting (control panel ) -1
- Accessibility options
- Display
- Fonts
- Keyboard
- Modems
- Multimedia
- Networks
- Ports
- Printers
- Regional setting
- SCSI Adapters
- Server
- Service
- Sounds
- System
- Tape Devices
- Telephony
- UPS
- Date and Time properties
- Changing the wall paper and screen savers
- Screen saver setting
- Appearance of window
- Working with keyboard
- Working with mouse
- Selecting Cursors and pointers
- Controlling the motion of the mouse
- Regional setting
An Introduction to MS – ACCESS
- What is Microsoft Access?
- Access XP vs. Access 2000
- What are tables?
- Getting stared
- Blank Access database
- Open an existing database
- Database window
- Create a table in design view
- Field properties
- Primary key
Datasheet Records - I
- Adding records
- Moving Around in a Table
- Editing records
- Deleting records
Datasheet Records – II
- Resizing Rows and Columns
- Hiding Columns
- Freeing Columns
- Finding data in a table
- Replace
- Check spelling and AutoCorrect
- Print Data sheet
- Creating table & table wizard
- Access offers 2 methods for creating a table
- Sorting
Data validation
- Indexes
- Validation Rules
- Validation Rules for field
- Validation Rules for table
- When to use validation rules
- Field’s validation rule
- Table’s validation rule
- Limitations
- Input Masks
Filters
Forms
- Views in the Form window
- Creating new forms
- Form Wizards
- Creating forms from scratch
- The Toolbox
- Reviewing controls
- The controls most often used in Access are
- The properties window
- Form window
- The field list
- Form selections
- Form controls
- What are controls?
- Basic types of controls
- The Toolbox
- The properties Window
- Individual controls
- Text Boxes and Labels
- Yes \ No options
- Drop – Down Boxes
- Graphics objects and Sub forms
- Layout Enhancement Controls
- The field list
- Selecting, Moving, and Sizing Controls
- Aligning Controls
- On-The-Fly Control Switching
Reports
- The report wizards
- WORKING WITH REPORTS
- Sections
- Controls
- The Toolbox
- The Properties window
- Types of control
- Combo box
- Selecting, moving and sizing controls
Query
- What is query?
- Common types of queries
- Select query
- Parameter query
- Action query
- Crosstab query
- View in query window
- Query wizard
- The bob villa method
- To create a query without query wizards
- Avoid the Cartesian product
- Using the query design window
- Query by example grid
- Adding fields to the QBE grid
- Rearranging, inserting and deleting fields
- To move a field or fields
- To insert a field
- To delete a field
- Renaming a field
- Specifying criteria
- Entering expressions
- Using the expressions builder
- Common types of expressions
- Using” Or”
- Using “And”
- Using wildcards
- Blank field searches
- Ranges of records
- Creating calculated fields
- Using the totals button
- Query properties
- Parameter Queries
- To create a parameter query
- Viewing a dynast
Relationship
- Creating a relationship
- Referential integrity
- Cascading update \ delete operations
- Types of relationships
- Join types
Integrated Development Environment
- Menu bar
- Tool bar
- Project Explorer
- Properties window
- Object Browser
- Object naming conversions of controls
- Modules
- Data types in visual basic
- Numeric
- String
- Date
- Boolean
- Variant
- New project window
- Toolbar
- Visual basic-Definitions
- Tool box
- ADODS
- ADD-INS
- Visual Data Manager
- Dynaset
- Record source
- Microsoft jet database engine
- Importing and linking
Data base backup and Recovery
- Database Backup
- Database Backup and recovery needs
- Backup and recovery and database failure
- Backup and recovery and disaster
Shine.com
