Skilled Bharat
info.s.bharat@gmail.com |
91+ 8900713504

COURSE DETAILS

CCDBm

Certificate Course in DBMS with SQL(6m)

Contents

1) MS ACCESS

  • 1. Introduction to Database Management :- Type of Database, Examples of DBMS
  • 2. Definitions :- Table, Field, Field Name, Record, Database, Database Object
  • 3. Opening Microsoft Access :- Start button & Desktop icon
  • 4. Creating a Database file :- Designing a table - Field names, Data Types, Description
  • 5. Data Types :- Text, Number, Data/Time, Yes/No, Currency, Memo, AutoNumber, Ole Object, Lookup Wizard
  • 6. Entering Records within a table
  • 7. Editing parts of a table :- Selecting, Renaming, Inserting, Deleting, Hiding, Freezing, Resizing
  • 8. Sorting Records
  • 9. Moving to specific records :- First, Last, Previous, Next, New
  • 10. Formatting e table :- Font, Cells
  • 11. Checking Spelling , Finding and Replacing data

2) Concept of software

  • • Types of Software - System software, Application software, Utility software, Demo ware, Shareware, Freeware, Firmware, Free software.
  • • Operating System - Functions, Types - Batch Processing, Single User, Multi User, Multiprogramming, Multi- Tasking.
  • • Programming languages - Machines Assembly, High Level, 4 GL.
  • • Data representation in computers .
  • • Number System of computers - Binary, Octal, Hexa, Decimal - Representation & their conversion.
  • • Coding System - ASCII, BCD, and EBCDIC etc.
  • • Computer Viruses.
Apply Online
Skilled Bharat