TRAINING SYLLABUS

• The concept of databases, tables, records and fields.Functions of databases, tables, records and fields.
• Terms - conditions for writing database names, tables, records and fields.
• Create a Field Name by using the data types.
• Creating Databases, Tables, Records and Fields
• Creating the Index Primary Key
• Entering data into database with standard method
• Entering data into the database with the import file method
• The concept of database normalization with its advantages and disadvantages.
• Master table concept and transaction
• Master and transaction table functions
• Requirements in making Relational Data Table.
• Database normalization process
• Create master tables and transactions using SQL – Distinct
• Create and design standard queries with certain criteria
• Run a standard query with certain criteria
• Create and design updated queries using arithmetic functions
• Running an updated query using arithmetic functions
• Create and design updated queries using logical functions
• Menjalankan updated query dengan menggunakan fungsi logika
• Running an updated query using logical functions
• Create and Design Form data
• Create and design Report data