Developing Microsoft SQL Server Databases

Developing Microsoft SQL Server Databases
(MOC 20464C)
SQL Server 2012
&
`
r
Max. Teilnehmerzahl
Die Teilnehmerzahl beträgt
maximal 8 Personen.
Dauer
5 Tage
e
Die nächsten Termine
08.05.2017 - 12.05.2017
-----
Preis
2.390,00 Euro (exkl. MwSt)
2.868,00 Euro (inkl. MwSt)
12.06.2017 - 16.06.2017
-----
r
Ansprechpartner
WBS Beraterteam
Tel: 0800 6011-29
Fax: 0720 1159-32
[email protected]
07.08.2017 - 11.08.2017
-----
j
Kursbeschreibung
This 5-day instructor-led course introduces SQL Server 2014 and describes logical table design, indexing
and query plans. It also focusses on the creation of database objects including views, stored procedures,
along with parameters, and functions. Other common aspects of procedure coding, such as transactions,
error handling, triggers, and SQL CLR are also covered in this course. This course helps people prepare for
exam 70-461: Writing Queries Using Microsoft SQL Server 2014 Transact-SQL.
j
Aktuelle
Kursinformationen
Bitte beachten Sie, dass die Kursunterlagen ausschließlich in englischer Sprache verfügbar sind.
j
Lernziele
After completing this course you will be able to:
- Describe the concepts of database development
- Design and implement tables
- Use constraints to ensure data integrity
- Describe indexes
- Implement advanced indexes
- Deploy in-memory database capabilities
- Design and implement views
- Design and implement stored procedures
- Design and implement user-defined functions
- Implement triggers to respond to data manipulation
- Deploy in-memory tables
- Implement managed code in SQL Server
- Store and query XML data in SQL Server
- Work with spatial data in SQL Server
- Incorporate data files into databases
Erstellt am 07.04.2017
Seite 1 von 2
j
Zielgruppe
The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2012
product features and technologies for implementing a database.
j
Teilnahmevoraussetzung
This course requires that you meet the following prerequisites:
In addition to their professional experience, students who attend this training should already have the
following technical knowledge:
- Knowledge of writing T-SQL queries
- Knowledge of basic relational database concepts
j
Inhalte
- An Introduction to Database Development
- Designing and Implementing Tables
- Ensuring Data Integrity through Constraints
- Introduction to Indexes
- Advanced Indexing
- In-Memory Database Capabilities
- Designing and Implementing Views
- Designing and Implementing Stored Procedures
- Designing and Implementing User-Defined Functions
- Responding to Data Manipulation via Triggers
- Using In-Memory Tables
- Implementing Managed Code in SQL Server
- Storing and Querying XML Data in SQL Server
- Working with Spatial Data in SQL Server
- Incorporating Data Files into Databases
j
Webseite
Link zum Kurs
j
Weiterführende
Themen
IT - Informationstechnologie
Erstellt am 07.04.2017
Microsoft-Zertifizierungen
Seite 2 von 2