Azure SQL Server Developer

    SQL

• Database (Create, Alter, Drop)

• Tables (Create, Alter, Drop)

• DQL - Basics (Select, From, Where)

• DQL - Aggregate Functions (Group By, Having, Order By)

• DQL - Joins

• DQL - Set Operations

• DQL - Analytical Functions

• DML - Insert

• DML - Update

• DML - Delete

• String Functions

• Date Functions

   T-SQL

• Variables and Operators

• Conditional Statements

• Loops

• Code Blocks (Begin .. end)

• Cursors

• Exceptions

• Functions

• Procedures

• Views

• Synonyms

• Triggers

• Dynamic SQL

• Temp Tables

   Performance Tuning

• Indexes

• Partitioning

• Materialized Views

• Explain Plan

   Advanced Concepts

• System Views

• SET Parameters

• SP_ Functions / Procedure

• Working with JSON

• Working with XML

• Logger

• Job Scheduler

• System Architecture

   Client Tools

• SQLCMD

• BCP

    Assignments

• DDL Assignment

• SQL Assignments

• TSQL Invoicing Project

MS SSIS (SQL Server Integration Services)

• SSIS Introduction

• Components of SSIS

• Sources Targets Control flow

• Common Tasks Containers Data Flow

• Parameters Event Handlers Execution

• Precedence Constraint Variables Expressions

• SSIS Transformations

  • Derived column

  • Type Casting Copy Column

  • sort

  • Merge

  • Group by

  • pivot

  • multicast

  • Control Flow Tasks

    • Containers

    • Sequence

    • for loop

    • for each loop Event Handlers

• Execute Package Task

  • (Parent - Child Package)

  • Blocking

  • Non Blocking

  • Semi Blocking

• Performance Improvement

• SSIS Catalog (Deployment) SQL Server Agent (Schedule Jobs)

• FTP Site Files to SQL Server

• BLOB Files to SQL Server **

• MySQL Docker DB to SQL Server

• OLTP to FILE to OLAP