Certificate Authentication

SQL DATABASE MANAGEMENT AND DESIGN Certificate for Mary Grace Maclang

Add to LinkedIn

Certificate ID: 
714279
Authentication Code: 
3789e
Certified Person Name: 
Mary Grace Maclang
Trainer Name: 
Rey Norbert Besmonte
Duration Days: 
2
Duration Hours: 
14
Course Name: 
SQL DATABASE MANAGEMENT AND DESIGN
Course Date: 
30 March 2023 09:00 to 31 March 2023 17:00
Venue: 
Mandaluyong City CHUBB Business Services Philippines
Course Outline: 
  • Module 1: Introduction
    • SQL Definition
    • SQL Capabilities
    • Standards of SQL
    • SQL uses

 

  • Module 2: SQL Query Commands
    • Table Create [ Data Type, Table Format, Key Format]
    • Insert Data [ Single record to multiple records]
    • Insert Into [ Single record to multiple records]
    • Select Statement
    • Select Statements with Conditions
    • Select Statements with Sub Query

 

  • Module 3 - Querying with Unions
    • Rule and application of Union
    • Rule and application of Union all

 

  • Module 4 – Calculate and compute
    • Using special query such as:
      • SUM
      • AVE
      • MIN
      • MAX
      • Other computation procedures to extract data

 

  • Module 5 – Entity Relationship diagram
    • Table Relationship
    • How to properly breakdown a single table to multiple table
    • Create tables with relationship
    • How to improve performance of selecting data by using ERD

 

  • Module 6 - Table Joins with 2
    • Full Join Tables
    • Inner Join Tables
    • Left Join Tables
    • Right Join Tables

 

  • Module 7 – Combination of Joins
    • Using 3 or more table with mix joins (left, right, full, inner)
    • Guidelines to follow when joining multiple tables

 

  • Module 8 - SQL Transactions
    • What is an SQL Transaction?
    • Uses of SQL Transaction
      • SQL Transaction when selecting data
      • SQL Transaction, roll back and commit
    • SQL Transaction ACID property
Course Name Eng: 
SQL DATABASE MANAGEMENT AND DESIGN