Logo

Course Content : Database Programming

  • Basic Competencies - English
    • Receive and Respond, Participate and Lead to workplace communication
    • Work with others, Team Environment and Lead small Teams
    • Demonstrate work values, Practice career professionalism and Develop & Practice Negotiation skills
    • Practice housekeeping procedures, Occupational health and safety procedure and Solve problems related to work Activities
    • Personal Manner
  • Common & Core Competencies (Computer fundamentals)
    • Fundamentals of Database Management System(DBMS), Relational Database Management System (RDBMS)
    • Normalization, System Development Life Cycle (SDLC) and ODBC
    • Fundamental Terms and Components of Database.
    • Fundamental on ERD, Entity, Attribute, Relationship
    • Create Database
    • Data type, Operators, Field Properties
    • Create Table, insert data into the created table, sort, index, update, delete data from table
    • Modify table structure
    • Define Primary & Foreign Key, Independent & Dependent Table
    • Fundamentals of SQL
    • Define Relationship. Mention the types of relations
    • Create relations among database tables in accordance to task assigned
    • Work with Query, Differentiate between a Data Table and Query Returned Table
    • Use Relational operators in query. Create a Cross tab query
    • Define Forms, Create Forms using Wizards/ Manually
    • Run and Modify Form in Design View
    • Add Controls on Forms
    • Define Report, Identify the different sections in a report
    • State the difference between Form and Report
    • Create Reports using Wizards/ Manually in various orientations
    • Display and modify Reports in design view in accordance to task assigned
    • Add Fields, page number, total number of records in the reports
    • Print a report
    • Understand and work with Visual Basic
    • Create Complete Database of Student Information System/Billing System/Inventory System etc. using MS Access/ SQL Server/ Oracle
    • Write hardcopy report on created database, use database, manipulate and maintain database
    • Use Set and Remove Passwords to maintain database security
    • Repair Database Utility in accordance to task assigned
    • Export data to and Import data from other compatible Application Programs as per requirements
    • Database Connectivity with Visual Basic
    • Develop a real life project using MS Access/SQL Server/Oracle and Visual Basic
Filter Branch wise Batch :

Batch : DB-02

Start Date: 4 Nov 2017
Days : Saturday,Monday,Wednesday
Schedule : 4:0:AM To 6:0:AM
Duration : 6 Months
Course Fee : 20000 /=
Apply Now