Developing MS SQL Server Databases 2014 Training Course

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.

Developing MS SQL Server Databases 2014
 Training Course

Developing MS SQL Server Databases 2014 Training 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

 

 

Related Public Course Schedule and Costs

Please click on link below for our related public course/s


There are no upcoming events at this time.
There are no upcoming events at this time.

 

Book Now or Obtain Instant Quote

We also offer customized courses across the country: Anytime, Anywhere. Click on the link to get get instant proposal or book you course:

Book This Course Or Obtain Quote – Now

View Calendar for the latest Public Course Schedule

Please Phone Us Now To Speak to One of Our Friendly Consultants

Tel:011-882-8853

OR

FOR CELL PHONES CLICK TO CALL

Please Fill in the Form – We Will Get Back to You Within 15 minutes

Please Email Us Now  – We Will Get Back to You Within 15 minutes

 [email protected]

Course Enquiry

    Knowing your course will help us prepare for our consultation and phone call.

    The more people you send on our courses, the cheaper the unit cost.


    YesNo

    Input this code: captcha

    Accredited Courses

    Additional Courses

      Software & IT Courses

      Top Rated