Introduction: Developing MS SQL Server Databases 2014 Training Course
This course deals with SQL Server 2014 and deals with design of logical table, query plans and indexing. It also emphasis the production of database objects including stored procedures, views functions and parameters. Procedure coding, such as indexes, error handling, concurrency, and triggers are also included in this course.
Outline: Developing MS SQL Server Databases 2014 Training Course
Johannesburg (Sandton), Cape Town, Durban, Port Elizabeth, Pretoria – South Africa
Key outcomes of the course include:
The major tools of the SQL Server platform i.e. editions, versions, network listeners, and an understanding of services and service accounts.
Interpret details from execution plans of common elements.
Craft effective non-clustered indexes.
Design and implement views, stored procedures.
Work with table types, and utilize the MERGE statement to produce procedures (stored) that update information warehouses.
Scalar and table-valued functions
Utilizing appropriate data types when producing tables. Data conversions and production of alias data types.
Understand deadlock situation and impact of isolation levels and application concurrency.
Understand T-SQL error handling code, DML trigger, SQL CLR integration, .NET assembly, storing XML data and schemas in SQL Server.
Undertake XML data queries.
GEOGRAPHY and GEOMETRY data types
Full-text index queries
Principles of good design and practices for SQL Server tables. Using T-SQL to create tables. (NB: partitioned tables are not dealt with).
Utilize the constraints: PRIMARY AND FOREIGN KEY, DEFAULT, CHECK and UNIQUE constraints, and interrogate cascading FOREIGN KEY constraints.
Deciding on composite indexes strategies and appropriate single column.
Heaps and tables with clustered indexes.
Considering the structure of a table.
Course duration and fees: Developing MS SQL Server Databases 2014 Training Course
Our two day training course is designed so that the knowledge acquired is applied practically, so that the business environment can be enhanced.
Please consult schedule for course costs or contact BOTI for a quote.
Recommended Prior Experience and Knowledge: Developing MS SQL Server Databases 2014 Training Course
The course (Developing MS SQL Server Databases 2014
Training Course) is designed for the following attendees:
IT Professionals who wish to become proficient on SQL Server 2014 product features and technologies for the purpose of database implementation.
For the Developing MS SQL Server Databases 2014 Training Course it is advisable that you have the following experience/knowledge:
Skills in writing T-SQL queries and basic relational database concepts experience
View Calendar for the latest course