Database & Advanced SQL

Onsite

Course Outlines:

Database Introduction

  • Database
  • Relational Database
  • Database Management Systems (DBMSs)
  • Relational Database Management Systems (RDBMSs)
  • Database Keys
  • Table Relationships
  • Integrity Constraints
  • Database System
  • Lifecycle of Database Design

Relational Database Important Concepts

  • SQL
  • Data Type
  • Index
  • View
  • Stored Procedure
  • Trigger

Advanced SQL

  • Select Statement
  • SQL Functions
  • Aggregating Data Using Group Functions
  • SQL Joins
  • SQL Subquery
  • CTE (Common Table Expression)
  • Create Objects in MS SQL SEVER
  • Change Table Contents

Business Intelligence Technology

  • Business Intelligence (BI)
  • Data Warehouse
  • OLTP vs. OLAP
  • Data Warehouse Architecture
  • ETL (Extract, Transform and Load)
  • CDC & SCD
Join Now
报名方式
在线购买或联系:

负责人:Kevin Wang
联系方式:416-665-1888 Ext:1
微信号:mariasunvic12 mariasunvic12