Advanced Microsoft SQL

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

  • 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

 

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

 

  • Microsoft SQL Server and T-SQL (Microsoft SQL) variant language
  • Differences between MS SQL and Python

 

  • Nested Queries in MS SQL
  • Operation Vs Nested query in DBMS

 

  • Nested Queries in MS SQL
  • Indexing in Databases

  • MS SQL Server Database Administration
  • SQL Server Programming

 

  • SQL Server Comparison Operators
  • SQL Server Joins

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


 

 

  • Creating Code Template (CT) mappings
  • Setting options for Code Templates in Code Template Mappings

 

Related Courses