Close
İletişim
logo
İletişim

SQL Server 2019 ile Veritabanı Programlama

  • Home  
  • SQL Server 2019 İle Veritabanı Programlama
Awesome Image

SQL SERVER EĞİTİMLERİ

Her Yönüyle SQL Server 2019 ile Veritabanı Programlama

  • Module 1: Introduction to Database Development

    +Introduction to the SQL Server Platform

    +Working with SQL Server Tools

    +Configuring SQL Server Services

    +Lab : Introduction to Database Development

  • Module 2: Designing and Implementing Tables

    +Designing Tables

    +Working with Schemas

    +Creating and Altering Tables

    +Lab : Designing and Implementing Tables

  • Module 3: Ensuring Data Integrity through Constraints

    +Enforcing Data Integrity

    +Implementing Domain Integrity

    +Implementing Entity and Referential Integrity

    +Lab : Ensuring Data Integrity through Constraints

  • Module 4: Introduction to Indexing

    +Core Indexing Concepts

    +Single Column and Composite Indexes

    +SQL Server Table Structures

    +Working with Clustered Indexes

    +Lab : Creating Indexes

  • Module 5: Advanced Indexing

    +Execution Plan Core Concepts

    +Common Execution Plan Elements

    +Working with Execution Plans

    +Designing Effective Non-clustered Indexes

    +Performance Monitoring

    +Lab : Planning for SQL Server 2016 Indexing

  • Module 6: Columnstore Indexes

    +Columnstore Indexes

    +Best Practices for Columnstore Indexes

    +Lab : Using In-Memory Database Capabilities

  • Module 7: Designing and Implementing Views

    +Introduction to Views

    +Creating and Managing Views

    +Performance Considerations for Views

    +Lab : Designing and Implementing Views

  • Module 8: Designing and Implementing Stored Procedures

    +Introduction to Stored Procedures

    +Working With Stored Procedures

    +Implementing Parameterized Stored Procedures

    +Controlling Execution Context

    +Lab : Designing and Implementing Stored Procedures

  • Module 9: Designing and Implementing User-Defined Functions

    +Overview of Functions

    +Designing and Implementing Scalar Functions

    +Designing and Implementing Table-Valued Functions

    +Implementation Considerations for Functions

    +Alternatives to Functions

    +Lab : Designing and Implementing User-Defined Functions

  • Module 10: Responding to Data Manipulation via Triggers

    +Designing DML Triggers

    +Implementing DML Triggers

    +Advanced Trigger Concepts

    +Lab : Responding to Data Manipulation via Triggers

  • Module 11: Using In-Memory Tables

    +Memory-Optimized Tables

    +Native Stored Procedures

    +Lab : Using In-Memory Database Capabilities

  • Module 12: Implementing Managed Code in SQL Server

    +

    +Introduction to SQL CLR Integration

    +Importing and Configuring Assemblies

    +Implementing SQL CLR Integration

    +Lab : Implementing Managed Code in SQL Server

  • Module 13: Storing and Querying XML Data in SQL Server

    +Introduction to XML and XML Schemas

    +Storing XML Data and Schemas in SQL Server

    +Implementing the XML Data Type

    +Using the T-SQL FOR XML Statement

    +Getting Started with XQuery

    +Shredding XML

    +Lab : Storing and Querying XML Data in SQL Server

  • Module 14: Working with SQL Server Spatial Data

    +Introduction to Spatial Data

    +Working with SQL Server Spatial Data Types

    +Using Spatial Data in Applications

    +Lab : Working with SQL Server Spatial Data

  • Module 15: SQL Server Database Certification Path

    +Introduction to SQL Server Database Certification

    +Choosing the Right SQL Server Database Certification Path

    +Preparing for SQL Server Certification Exams

    +Sample Tips,Questions and Answers from Certification Exams