BANGLADESH TECHNICAL EDUCATION BOARD

SYLLABUS FOR THE SHORT COURSE ON

CERTIFICATE IN DATABASE PROGRAMMING

Total Duration: 360 hours

Course Title: CERTIFICATE IN DATABASE PROGRAMMING

Index:

Sl. no. 01 02 03 04 05 06 07 08 09 10

Subject Introduction Objectives Course out line Competencies Contents Job List Entry Qualification Employment Opportunities List of Tools Book Reference

1

Page No. 2 2 2 3 5 9 9 9 9 10

Course Name: Database Programming Introduction: Computer Short Course training on Certificate in Database Programming provides a solid foundation in the basic and intermediate skills for working with Database Management System (DBMS), Relational Database Management System (RDBMS), MS Access/ SQL Server/ Oracle and Database Connectivity with Visual Basic 6. This course is ready to extend the knowledge into some of the more specialized and advanced capabilities of software development. In this regard BTEB has approved a short course on Certificate in Database Programming. The syllabus is prepared as per present need in the job markets.

Objectives: 1. To be able to understand the basic knowledge and skills on Database. 2. To provide basic knowledge and skills on Database Programming. 3. To Develop skills on various Database connectivity. 4. To Develop/ Customize Database software.

Course Outline: Name of Course Database Programming

Duration of Course Total 360 hrs Theory= 100 hrs Practical= 200 hrs. Communicative English= 60 hrs

2

5 days per week, Per day 3 hrs Theory = 1 hr, per lesson Practice = 2 hrs. per practice Total = 3 hrs, per working day

Entry Qualification Minimum S.S.C Pass.

LIST OF COMPETENCIES: Basic Competencies: a) Receive and respond, Participate and Lead to workplace communication: 1. Work with others, Team Environment and Lead small Teams: 2. Demonstrate work values, Practice career professionalism and Develop & Practice Negotiation skills. 3. Practice housekeeping procedures. Occupational health and safety procedure and Solve problems related to work Activities: 4. Use Mathematical Concepts & Techniques and Use Relevant Technologies: 5. Personal Manner a) (ii) Efficiently communicate in English 1. Speak in English with confidence. 2. Communicate with target persons effectively. 3. Understand the speech of English users. 4. Achieve better professional performance

Common Competencies: • • • • • • • • • • • • • • • • • • • • • • • • • • •

Define Data, Record, Table/File, Database Define Database Management System (DBMS). Understand Relational Database Management System (RDBMS). Describe the System Development Life Cycle (SDLC) Understand about DDL, DML. Define Normalization Mention the Popular database software State Database components Start with a new database in MS Access Define Data type, Fields List the available data types in MS Access State the naming convention of fields Create Table, insert data into the created table, sort, index, update, delete data from table Modify table structure Define Primary key, Foreign Key, Composite Key, Candidate key Independent & Dependent Table Define Relationship, Create relations among database tables in accordance to task assigned Define Query Identify the importance of query in database Create a Cross tab query Define Form Create Forms using Wizards Run and modify Form in Design View Define Report Identify the different sections in a report State the difference between Form and Report Print Report Create a complete database of Student Information System 3

• • • • • • • •

Use, manipulate and maintain the database Describe the SQL and SELECT capabilities Execute Basic SELECT statement with mandatory clauses Understand SQL query Create Views and Sequences Create, Drop, Alter view and Sequences Fundamentals of Visual Basic Data types, sub routine in Visual Basics

Core Competencies: • • • • • •

Develop project with MS Access Understand and execute different queries using SQL Understand and work with Visual Basic Perform database connectivity with Visual Basic Develop customized database software Develop a real life project using MS Access/ SQL Server/ Oracle and Visual Basic

Contents: a) (i) Basic Competencies - 30 hours Period

Topics

1. Receive and Respond, Participate and Lead to workplace communication: 1 a) Explain & follow routinary speaking & messages in a workplace. 2 b) Follow routinary Speaking & message. 3 c) Perform work duties following written notices. 2. Work with others, Team Environment and Lead small Teams: 3 a) Develop effective workplace relationship. 4 b) Contribute to work group activities.

Hours

1 1 1 1.5 1.5

3. Demonstrate work values, Practice career professionalism and Develop & Practice Negotiation skills 5 a) Define the purpose of works. 1 6 b) Apply work values/ethics. 1 7 c) Deal with ethical problems. 1 8 d) Maintain integrity of conduct in the workplace. 1 4. Practice housekeeping procedures, Occupational health and safety procedure and Solve problems related to work Activities: 9 a) Sort and remove unnecessary items. 1 10 b) Arrange items. 1 11 c) Maintain work areas, Tools and Equipments. 1 12 d) Follow standardizes work process and procedures. 1 13 e) perform work spontaneously. 1 14 a. Use Mathematical Concepts & Techniques and Use Relevant 3 Technologies:

6. Personal Manner: 15 a) Show good Manner. 16 b) Respect honorable person (Sir, Senior, Trainees). 17 c) Cooperate & Thinking to each and other about practical works. 18 d) Maintain sequence in practical works. 19 e) Own Responsibility & Duties of practical works. 20 f) Observation of all practical works. 4

2 2 2 2 2 2

a) (ii) Communicative English - 30 hours (Practical) a) Interpret the meaning of given words (by the teachers) - Vocabulary. b) Speaking on a specific Situation. c) Public speaking. d) Exchanging views with target persons. e) Introducing one self. f) Describing & narrating events, places, objects etc.

Communicative English - 30 hours Related Subject-10 hours and General Subject- 20 hours 1 hour/period On the completion of this course trainees will be able to: 1. Speak in English with confidence 2. Communicate with target persons effectively. 3. Understand the speech of English users. 4. Achieve better professional performance. No. of period 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

Tropics- Conversational Situation

hours

Speaking English – Getting Information & Finding one’s way Speaking English – About Tools and Equipments Speaking English – About meeting some one & participating in class. Speaking English – Daily Activities & Asking About Activities Speaking English – Evening Activities and about theoretical contents. Speaking English – Meeting at the Train station & Asking Question at the Train station. Speaking English – Meeting at the Airport & Getting information at the Airport’s Speaking English – About different type of Measuring Tools and Cutting Tools Speaking English – Getting to the Hotel & Asking direction. Speaking English – Asking about Buses & Traveling by bus. Speaking English - About Practical Class. Speaking English – Going by Taxi and Asking the time. Speaking English – Arriving early or late and Time and the calendar. Speaking English – Living in an Apartment. Speaking English – Using the Telephone. Speaking English – Getting help in stores and talking about shopping. Speaking English – Sending and Receiving Letters. Speaking English – Talking about the Weather & Trips and sight seeing. Speaking English – Talking about Eating & Dinner Conversation. Speaking English – About Machines and Materials. Speaking English – Common Health problem and Quitting & Finding Jobs. Speaking English – Office Details and Office Conversation. Speaking English – About Practical Job. Speaking English – On a specific situation & Public speaking. Speaking English – About Exchanging view with a Persons & Introducing oneself. Speaking English – Describing and Narrating events, place, Objects etc.

1 1 1 1 1 1

5

1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1

27

Speaking English – About different type of computer, operating system, system and operating software, add remove software, DBM, Email and internet .

4

Practical: 1. Speaking on a specific Situation. 2. Public Speaking. 3. Exchanging views with target persons. 4. Introducing one self. 5. Describing & Narrating events, places, objects etc. 6. Producing the meaning of given words (by the teachers)-Vocabulary. 7. Prepared speech.

a) Theoretical: Common Competencies and Core Competencies Sl. No. 01

Topics Fundamentals of Database Management System(DBMS), Relational

Hours 3

Database Management System (RDBMS)

02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

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 6

3 3 3 3 3 6 3 4 3 3 3 3 3 3 3 1.5 3 3 3 3 3 1.5 3 6

26 27 28 29 30 31

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 Total

3 3 3 3 3 6 100

b) Practical: Common Competencies and Core Competencies Sl. No. 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Tropics/Jobs Installation Database Software ( MS Access/ SQL Server/ Oracle) In MS Access Create various simple Database Create, Drop Table and Modify Table structure. Insert data into Table, Update & Delete data from Table Sort data in Table. Create index in the Table Set Primary & Foreign Key in Table Create relations among MS Access database Tables Identify the importance of query in database Use Relational operators in query Design a Form and Run the Form Modify the design Form, add controls, tabs, image etc. in the Form Design Report using wizards, display and modify Add fields, page number, Total number of records etc. and print specific record in the Report. Create a complete database system. Write hardcopy report on database. Use, manipulate, and maintain database. Maintain security purpose by setting and removing passwords. Repair Database Utility in accordance to task assigned Export data and Import data from application programs In SQL Server/ Oracle Create, Truncate, Drop Table and Modify Table structure. Insert data into Table, Update & Delete data from Table Sort data in Table. Create index in the Table Distinguish between SQL and PL/SQL Restrict rows while selecting and Arrange record Execute Basic SELECT statement with mandatory clauses Write SQL query to limit the selected rows using WHERE and HAVING clause Execute commands of various types of Function for Character, number and Date function, group function, group by clause, etc. Selecting record using different types of function Creating, Renaming, Altering and truncating tables in SQL Server/ Oracle Creating, Renaming, Altering Views, Sequences, Index Basic about Programming Language Visual Basic 7

Hours 12 12 12 12 12 6 6 6 6 6 9 9 9 12 3 9 9 9 12 12 12 9 12 9 9 12 12 12 12 12 8

32 33 34 35

36 37 38 39

Creating Forms in Visual Basic Connect with ODBC and Visual Basic Set and Remove Passwords to maintain database security Develop a real life project such as Student Information System/Billing System/Inventory System etc using MS Access/ SQL Server/ Oracle and Visual Basic Handling and debugging the errors Testing and Delivery Projects Creating Exe file Creating Setup files Total

12 9 6 30

3 3 3 3 =200

Job List : Sl. No. 01 02 03 04 05 06

Topics/Jobs Installing new Database in MS Access/ SQL Server/ Oracle Describe all the part of Tables Describe all the part of Queries Create necessary Forms Create necessary Reports

Create a complete database system for student information system with entry form and generate needed report on it (Sample) Steps ¾ Create a database ¾ Create entry form ¾ Insert data ¾ Generate report

Entry Qualification: Minimum Class Eight Pass.

Employment opportunities: 1. Government Services, 2. Semi Government Services, 3. Corporation, 4. Private sectors, 5. NGO’s 6. Abroad, 7. Self employment.

8

Hours

List of Tools: Sl. No. 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18

Name of Tools and Tackles Personal Computer System and Accessories Server PC Scanner Printer Projector (Optional) UPS Modem NIC Card RJ 45 Connector Twisted pair (UTP Cable) Switch (16 port) DVD Writer MS Office CD Windows XP CD Type Tutor CD Bijoy 2003 CD Internet Connection First Aid Kit

Qty 10 01 01 01 01 05 01 12 50 10 01 05 01 01 01 01 01( Broadband/Dial up) 01

Book Reference: 1. Database

- By Suzukitownship Date: on 27 Feb, 2008

2. Database

- By Tyneymo Date: on 18 Sep, 2008

3. Database Programming

- By Santy Date: on 23 Jul, 2007

4. Access Database Design & Programming 3e

- By Ritayan Date: on 02 Sep, 2007

5. Beginning Visual Basic 6 Database Programming

- By Servisi Date: on 01 Oct, 2008

6. Visual Basic 2005 Database Programming (2006) - By Ajbar Date: on 09 Feb, 2008

9