Orient ITM


Sql Server

  • John Smith

    ·         Understanding the Foundations of T-SQL

    ·         Understanding Logical Query Processing

    ·         Using the FROM and SELECT Clauses

    ·         Working with Data Types and  Built-in Functions

    ·         CASE Expression and Related Functions

    ·         Reviewing the Use of Functions

    ·         Analyze the Data Types in the Sample Database

    ·         Filtering and sorting Data

    ·         Using the ORDER BY Clause to Sort Data

    ·         Filtering Data with TOP and OFFSET-FETCH

    ·         Filtering and Sorting Performance Recommendations

    ·         Using Joins. Cross Joins, Inner Joins, Outer Joins, Multi-Join Queries

    ·         Using Subqueries, Table Expressions and the APPLY Operator Subqueries

    ·         Using Set Operators

    ·         UNION and UNION ALL, INTERSECT, EXCEPT

    ·         Grouping and Windowing

    ·         Writing Grouped Queries

    ·         Working with a Single Grouping Set

    ·         Working with Multiple Grouping Sets

    ·         Pivoting and Unpivoting

    ·         Using Window Functions, Aggregate Functions, Ranking Functions, Offset Functions

    ·         Improving Data Analysis Operations

    ·         Querying full-text Data

    ·         Creating Full-Text Catalogs and Indexes

    ·         Full-Text Search Components 

    ·         Creating and Managing Full-Text Catalogs and Indexes

    ·         Using the CONTAINS and FREETEXT Predicates

    ·         Using the Full-Text and Semantic Search  Table-Valued Functions

    ·         Using the Full-Text Search Functions

    ·         Check the FTS Dynamic Management Views and Backup and Restore of a Full-Text Catalog and Indexes

    ·         Querying and Managing XML Data

    ·         Returning Results As XML with FOR XML

    ·         Querying XML Data with XQuery, XQuery Basics, FLWOR Expressions

    ·         Using the XML Data Type

    ·         Using the XML Data Type for Dynamic Schema

    ·         Creating tables and enforcing Data integrity

    ·         Creating and Altering Tables

    ·         Choosing Table Indexes

    ·         Using Constraints, Primary Key, Unique, Foreign Key, Check Constraints, Default

    ·         Working with Table Constraints

    ·         Designing and creating views, inline functions and synonyms

    ·         Designing and Implementing Views and Inline Functions

    ·         Creating a Synonym

    ·         Comparing Views, Inline Functions, and Synonyms

    ·         Inserting, updating, and Deleting Data

    ·         Inserting Data (INSERT VALUES), (INSERT SELECT), (INSERT EXEC), (SELECT INTO)

    ·         Updating Data, UPDATE Statement

    ·         UPDATE Based on Join

    ·         Deleting Data DELETE Statement,

    ·         TRUNCATE Statement

    ·         DELETE Based on a Join, DELETE Using Table Expressions

    ·         Other Data Modification Aspects

    ·         Using the Sequence Object and IDENTITY Column Property

    ·         Using the IDENTITY Column Property

    ·         Merging Data, Using the MERGE Statement

    ·         Using the OUTPUT Option

    ·         Working with the OUTPUT Clause

    ·         INSERT with OUTPUT

    ·         DELETE with OUTPUT

    ·         UPDATE with OUTPUT

    ·         MERGE with OUTPUT P

    ·         Providing an Improved Solution for Generating Keys

    ·         Implementing transactions, error handling, and Dynamic SQL

    ·         Managing Transactions and Concurrency, Types of Transactions

    ·         Basic Locking

    ·         Transaction Isolation Levels

    ·         Implementing Error Handling

    ·         Detecting and Raising Errors

    ·         Using Dynamic SQL, using sp_executesql

    ·         Designing and implementing T-SQL routines

    ·         Designing and Implementing Stored Procedures

    ·         Executing Stored Procedures, Developing Stored Procedures

    ·         Implementing Triggers, DML Triggers, AFTER Triggers, INSTEAD OF Triggers

    ·         Implementing User-Defined Functions

    ·         Table-Valued UDFs

    ·         Using tools to analyze Query performance

    ·         Getting Started with Query Optimization

    ·         Query Optimization Problems and the Query Optimizer

    ·         SQL Server Extended Events, SQL Trace, and SQL Server Profiler

    ·         Using SET Session Options and  Analyzing Query Plans, Execution Plans

    ·         Using Dynamic Management Objects

    ·         Implementing indexes and statistics

    ·         Heaps and Balanced Trees

    ·         Implementing Non Clustered Indexes

    ·         Implementing Indexed Views

    ·         Using Search Arguments

    ·         Supporting Queries with Indexes

    ·         Understanding Statistics

    ·         Auto-Created Statistics

    ·         Understanding cursors, sets, and temporary tables

    ·         Evaluating the Use of Cursor/Iterative Solutions

    ·         Iterations for Operations That Must Be Done Per Row

    ·         Using Temporary Tables vs. Table Variables

    ·         Performance Improvement  Recommendations for Cursors and Temporary Objects

    ·         Understanding further Optimization aspects

    ·         Using Parameterized Queries and Batch Operations

    ·         Optimizer Hints

    ·         Query Optimization

    ·         Analyze Execution Plans and Force Plans



Korporativ müştərilərimiz