Certkit Developing Microsoft SQL Server 2012 Databases

Niveau
Tijdsduur
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

Er zijn nog geen startdata bekend voor dit product.

@The Academy biedt haar producten standaard aan in de volgende regio's: 's-Hertogenbosch, Alphen aan den Rijn, Amersfoort, Antwerpen, Arnhem, Breda, Dordrecht, Ede, Eindhoven, Hilversum, Maastricht, Middelburg, Nijmegen, Roermond, Rotterdam, Tilburg, Utrecht, Veenendaal, Venlo

Beschrijving

<div class="domino-par--indent" style="padding-left: 0pt"><font size="2" color="#000080" face="Verdana">In-depth e-learning content, exam quizzes, practice test, tips and information on the exam,and even online coaching from certified professionals that know how to pass the exam. This comprehensive product saves time and money by enabling you to access all your learning tools…with one login!</font> <ul type="disc" class="domino-par-list" style="padding-left: 18pt"> <li><font size="2" color="#000080" face="Verdana"><b>Customized e-Learning</b></font><font size="2" color="#000080" face="Verdana"> – focused on the specific certification</font></li> <li><font size="2" color="#000080" face="…

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" color="#000080" face="Verdana">In-depth e-learning content, exam quizzes, practice test, tips and information on the exam,and even online coaching from certified professionals that know how to pass the exam. This comprehensive product saves time and money by enabling you to access all your learning tools…with one login!</font> <ul type="disc" class="domino-par-list" style="padding-left: 18pt"> <li><font size="2" color="#000080" face="Verdana"><b>Customized e-Learning</b></font><font size="2" color="#000080" face="Verdana"> – focused on the specific certification</font></li> <li><font size="2" color="#000080" face="Verdana"><b>Exam Quizzes</b></font><font size="2" color="#000080" face="Verdana"> – an easy way to test your knowledge</font></li> <li><font size="2" color="#000080" face="Verdana"><b>Online Mentor</b></font><font size="2" color="#000080" face="Verdana"> – chat or mail with a technical specialist with the same certification*</font></li> <li><font size="2" color="#000080" face="Verdana"><b>MeasureUp Exam Simulation</b></font><font size="2" color="#000080" face="Verdana"> – so you can test your readiness for the exam*</font></li> <li><font size="2" color="#000080" face="Verdana"><b>Tips &amp; Tricks</b></font><font size="2" color="#000080" face="Verdana"> – portal of notes, tips, articles, links to communities, etc.</font></li> </ul> <br /> <font size="2" color="#000080" face="Verdana"><b>Samenvatting</b></font><br /> <font size="2" color="#000080" face="Verdana">This 4-day instructor-led course introduces SQL Server 2012 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, concurrency, error handling, triggers, and SQL CLR are also covered in this course. Also this course helps you prepare for the </font><a href="http://www.microsoft.com/learning/en/us/exam.aspx?id=70-464&locale=en-us"><font size="2" color="#000080" face="Verdana">Exam 70-464</font></a><br /> <br /> <font size="2" color="#000080" face="Verdana"><b>At Course Completion</b></font><font size="2" color="#000080" face="Verdana"> </font><br /> <font size="2" color="#000080" 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" color="#000080" 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" color="#000080" 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" color="#000080" 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" color="#000080" face="Verdana">Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE constraints, and investigate cascading FOREIGN KEY constraints.</font></li> <li><font size="2" color="#000080" face="Verdana">Determine appropriate single column and composite indexes strategies.</font></li> <li><font size="2" color="#000080" 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" color="#000080" face="Verdana">Read and interpret details of common elements from execution plans.</font></li> <li><font size="2" color="#000080" face="Verdana">Design effective non-clustered indexes.</font></li> <li><font size="2" color="#000080" face="Verdana">Design and implement views</font></li> <li><font size="2" color="#000080" face="Verdana">Design and implement stored procedures.</font></li> <li><font size="2" color="#000080" 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" color="#000080" 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" color="#000080" face="Verdana">Perform basic investigation of a deadlock situation and learn how transaction isolation levels affect application concurrency.</font></li> <li><font size="2" color="#000080" face="Verdana">Use both traditional T-SQL error handling code and structured exception handling.</font></li> <li><font size="2" color="#000080" face="Verdana">Design and implement DML triggers</font></li> <li><font size="2" color="#000080" face="Verdana">Learn appropriate uses for SQL CLR integration and implement an existing .NET assembly within SQL Server.</font></li> <li><font size="2" color="#000080" face="Verdana">Store XML data and schemas in SQL Server.</font></li> <li><font size="2" color="#000080" face="Verdana">Perform basic queries on XML data in SQL Server.</font></li> <li><font size="2" color="#000080" face="Verdana">Work with the GEOGRAPHY and GEOMETRY data types</font></li> <li><font size="2" color="#000080" 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)

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.