Euro-training Center
 Advanced Microsoft SQL B1769 QR Code
Share   Like Download Brochure (PDF) Dates and locations

Advanced Microsoft SQL

Overview:

Introduction

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network.

Course Objectives

At the end of this course the participants will be able to:

  • Explain MS SQL storage engines

  • Explain database transactions

  • Obtain database metadata

  • Describe MS SQL GUI tools

  • Monitor database performance

  • Perform database backup and recovery

  • Export and import database data

  • Describe the features and benefits of MS SQL

  • Explain the basics of relational databases

  • Design an effective database

  • Build a database and tables by using SQL Modify or delete database entities

  • Join data from multiple tables

  • Use built-in MS SQL functions

Targeted Audience

  • Team leaders seeking professional development in MS SQL
  • IT Team Leader.
  • MS SQL developer
  • IT manager
  • IT department managers.
  • Project managers.
  • Systems designers.

Course Outline

Unit 1: 

  • Basic SELECT Statement Practice Problems

  • Microsoft SQL Server and T-SQL (Microsoft SQL) variant language

  • Differences between MS SQL and Python

Unit 2: 

  • Structured Query Language (SQL)

  • Nested Queries in MS SQL

  • Operation Vs Nested query in DBMS

Unit 3: 

  • Database Objects in DBMS

  • Nested Queries in MS SQL

  • Indexing in Databases 

  • SQL elevator pitch technical message.

Unit 4: 

  • MS SQL Server Keys, Constraints, and Indexes

  • MS SQL Server Database Administration

  • SQL Server Programming

Unit 5: 

  • Auditing the execution of Code Template Mappings

  • SQL Server Comparison Operators

  • SQL Server Joins

Unit 6:

  • SSMS and MySQL Workbench

  • Creating SQL loader mappings to Extract Data from Flat Files.

  • Creating SAP extraction mappings

Unit 7:

  • Retrieving data from the SAP System

  • Creating Code Template (CT) mappings

  • Setting options for Code Templates in Code Template Mappings

Select training course venue