Developing Microsoft SQL Server Databases 2012-2014

Niveau
Tijdsduur
Startdatum en plaats
Logo van @The Academy
Opleiderscore: starstarstarstarstar_border 8,1 @The Academy heeft een gemiddelde beoordeling van 8,1 (uit 161 ervaringen)

Tip: meer info over het programma, startdatum, prijs, en inschrijven? Download de brochure!

Startdata en plaatsen

Eindhoven
1 mei. 2019 tot 9 mei. 2019
Eindhoven
19 jun. 2019 tot 27 jun. 2019

Beschrijving

<div class="domino-par--indent" style="padding-left: 0pt"><font size="2" face="Verdana"><b>Course Description</b></font><br /> <font size="2" face="Verdana">This 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 indexes, concurrency, error handling, and triggers are also covered in this course. Also this course helps you prepare for the Exam 70-464.</font><br /> <font size="2" face="Verdana"><b>Note: </b></font><font size="2" face="Verdana">This course is designed for cu…

Lees de volledige beschrijving

Veelgestelde vragen

Heb je een vraag? Onze adviseurs helpen je graag. Bel ons op 085 7440830 of e-mail naar info@springest.nl.

<div class="domino-par--indent" style="padding-left: 0pt"><font size="2" face="Verdana"><b>Course Description</b></font><br /> <font size="2" face="Verdana">This 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 indexes, concurrency, error handling, and triggers are also covered in this course. Also this course helps you prepare for the Exam 70-464.</font><br /> <font size="2" face="Verdana"><b>Note: </b></font><font size="2" face="Verdana">This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform. </font><br /> <br /> <font size="2" face="Verdana"><b>At Course Completion </b></font><br /> <font size="2" face="Verdana">After completing this course, students will be able to:</font> <ul type="disc" class="domino-par-list" style="padding-left: 18pt"> <li><font size="2" face="Verdana">Introduce the entire SQL Server platform and its major tools. It will cover editions, versions, basics of network listeners, and concepts of services and service accounts.</font></li> <li><font size="2" face="Verdana">Determine appropriate data types to be used when designing tables, convert data between data types, and create alias data types.</font></li> <li><font size="2" face="Verdana">Be aware of good design practices regarding SQL Server tables and be able to create tables using T-SQL. (Note: partitioned tables are not covered).</font></li> <li><font size="2" face="Verdana">Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE constraints, and investigate cascading FOREIGN KEY constraints.</font></li> <li><font size="2" face="Verdana">Determine appropriate single column and composite indexes strategies.</font></li> <li><font size="2" face="Verdana">Create tables as heaps and tables with clustered indexes. Also consider the design of a table and suggest an appropriate structure.</font></li> <li><font size="2" face="Verdana">Read and interpret details of common elements from execution plans.</font></li> <li><font size="2" face="Verdana">Design effective non-clustered indexes.</font></li> <li><font size="2" face="Verdana">Design and implement views</font></li> <li><font size="2" face="Verdana">Design and implement stored procedures.</font></li> <li><font size="2" face="Verdana">Work with table types, table valued parameters and use the MERGE statement to create stored procedures that update data warehouses.</font></li> <li><font size="2" face="Verdana">Design and implement functions, both scalar and table-valued. (Also describe where they can lead to performance issues).</font></li> <li><font size="2" face="Verdana">Perform basic investigation of a deadlock situation and learn how transaction isolation levels affect application concurrency.</font></li> <li><font size="2" face="Verdana">Use both traditional T-SQL error handling code and structured exception handling.</font></li> <li><font size="2" face="Verdana">Design and implement DML triggers</font></li> <li><font size="2" face="Verdana">Learn appropriate uses for SQL CLR integration and implement an existing .NET assembly within SQL Server.</font></li> <li><font size="2" face="Verdana">Store XML data and schemas in SQL Server.</font></li> <li><font size="2" face="Verdana">Perform basic queries on XML data in SQL Server.</font></li> <li><font size="2" face="Verdana">Work with the GEOGRAPHY and GEOMETRY data types</font></li> <li><font size="2" face="Verdana">Implement and query a full-text index.</font></li> </ul> </div>

Efficient, kostenbewust, innovatief, met hoogste slagingspercentage opleiden bij @The Academy! 

Blijf op de hoogte van nieuwe ervaringen

Er zijn nog geen ervaringen.

Deel je ervaring

Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.

Heb je een vraag? Onze adviseurs helpen je graag. Bel ons op 085 7440830 of e-mail naar info@springest.nl.

Download gratis en vrijblijvend de informatiebrochure

Aanhef
(optioneel)
(optioneel)
(optioneel)
(optioneel)
infoEr is een telefoonnummer vereist om deze informatieaanvraag in behandeling te nemen. (optioneel)
(optioneel)
(optioneel)
(optioneel)

Heeft u nog vragen?

(optioneel)
We slaan je gegevens op om je via e-mail en evt. telefoon verder te helpen.
Meer info vind je in ons privacybeleid.