SQL DATABASE MANAGEMENT AND DESIGN - Bespoke Training Course

Last updated

Course Code

bespokesql2

Duration

14 hours (usually 2 days including breaks)

Requirements

SQL: Fundamentals of Querying or equivalent knowledge.

Overview

Format of the Course

  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.

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: 
  1. SUM
  2. AVE
  3. MIN
  4. MAX
  5. 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
  1. SQL Transaction when selecting data
  2. SQL Transaction, roll back and commit
  • SQL Transaction ACID property

NOTE:

 

  • There will be hands on exercises for every module that will be completed to test the

understanding of the proponents on the topics.

  • Power Point Slides will be given after the end of the Training
  • SQL Queries from the lesson will be given after the end of the Training
  • An unanswered and answered version of the exercise will be given after the end of the training.

Testimonials

★★★★★
★★★★★

Related Categories

Related Courses

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

This site in other countries/regions