Wij slaan cookies op om onze website te verbeteren. Is dat akkoord? Ja Nee Meer over cookies »

MCSA SQL 2016 Database Developer OEM Certkit

MCSA SQL 2016 Database Developer OEM Certkit

€ 598,00 € 723,58 Excl. btw

Bestel deze unieke E-Learning cursus MCSA SQL 2016 Database Developer online, 1 jaar 24/ 7 toegang tot rijke interactieve video’s, voortgangs door rapportage en testen.

Lees meer
Beschikbaarheid:
999
Levertijd:
Bestel voor 16:00 uur en start vandaag.
Blader door onze trainingsmethoden: ICT Trainingen (en meer) , ICT E-Learning
Vergelijk
  • Bestel voor 17:00 uur en start vandaag
  • Persoonlijke service van ons deskundige team
  • Veilig betalen
  • Certificaat van deelname
  • De laagste prijs garantie

MCSA SQL 2016 Database Developer OEM Certkit E-Learning

Bestel de MCSA SQL 2016 Database Developer OEM CertKit. Een dynamisch, uniek certificeringsvoorbereidingsproduct met 1 klik. OEM CertKit biedt de student leer- en certificeringsvoorbereidingstools die volledig zijn geïntegreerd in een op maat gemaakt leerbeheersysteem (LMS).
Met de OEM CertKit heeft de gebruiker toegang tot alle volgende producten vanuit één LMS. Volledig geïntegreerde producten omvatten: uitgebreide E-Learning met 1 jaar online toegang, examen quizzen, tips en informatie, MeasureUp examensimulatie is 60 dagen beschikbaar en begint met de eerste keer dat u het oefentest gebied betreedt. Sommige OEM Cert Kit-titels bevatten 1 jaar online Mentoring en Virtuele Labs (meerprijs). *Controleer het gedeelte Algemene eigenschappen hieronder om te zien of online Mentoring en Virtuele Labs zijn inbegrepen voor deze titel.

Cursusinhoud

Querying Data with Transact-SQL exam 70-761  T-SQL Querying
25 uur

start the course
recognize features of SQL Server 2016
list SQL Server 2016 editions and components
identify SQL Server 2016 functions and capabilities
list features of SQL Server Management Studio
configure T-SQL statements in SQL Server 2016
work with T-SQL Language functions in SQL Server 2016
create T-SQL Variables in SQL Server 2016
demonstrate how to implement T-SQL expressions in SQL Server 2016
work with T-SQL control of flow, errors, and transactions in SQL Server 2016
use T-SQL comments in SQL Server 2016
work with T-SQL batch separators
describe the characteristics of sets in SQL Server 2016
describe the set theory and how it relates to SQL Server 2015
describe applying set theory to SQL server queries
define predicate logic in SQL Server 2016
recognize the elements of a SELECT statement in SQL Server 2016
define the logical order of operations
demonstrate the logical order of operations when writing SELECT statements
demonstrate querying data in SQL Server 2016

Querying and Manipulating Data

start the course
recognize elements of simple SQL Server 2016 SELECT queries
demonstrate how to write simple SELECT statements in SQL Server 2016
demonstrate how to use calculations in the SELECT clause
describe the purpose of DISTINCT in SQL Server 2016
describe how to execute a SELECT DISTINCT
demonstrate how to eliminate duplicates using DISTINCT
describe how to refer to columns using aliases
specify how to refer to tables using aliases
describe SQL Server 2016 CASE expressions
demonstrate how to use simple CASE expressions
recognize how and when to use joins in SQL Server 2016
demonstrate the proper usage of inner joins in SQL Server 2016
demonstrate the proper usages of outer joins in SQL Server 2016
demonstrate the proper usages of outer joins in SQL Server 2016
demonstrate the proper usages of cross and self joins
demonstrate the use of multiple join operators
demonstrate how to write queries with NULLs on joins
demonstrate how to query and manipulate data in SQL Server 2016

Filter and Modify Data in SQL Server 2016

start the course
describe the ORDER BY clause in SQL Server 2016
demonstrate how to sort data in SQL Server 2016 using the ORDER BY clause
recognize how to filter data in SQL Server 2016
demonstrate how to filter data in SQL Server 2016 using the WHERE clause
describe how to use predicates and operators in SQL Server 2016
describe three-valued logic in SQL Server 2016
work with NULL in Queries in SQL Server 2016
describe how to test for NULL in SQL Server 2016
describe how SQL Server 2016 uses data types
recognize when data type conversions occur in SQL Server 2016
demonstrate implicit and explicit conversions
describe different types of character data in SQL Server 2016
demonstrate how to manipulate character data in SQL Server 2016
list the benefits of using data manipulation language (DML) in SQL Server 2016
describe how to populate tables in SQL Server 2016 using the SELECT INTO statement
demonstrate how to add data using INSERT statement
describe how to use UPDATE and MERGE statements to modify data
describe how to use DELETE and TRUNCATE statements to remove data
demonstrate how to use the OUTPUT clause to monitor data in SQL Server 2016
demonstrate how to filter and modify data in SQL Server 2016

Using Functions in SQL Server 2016

start the course
list the built-in function types used in SQL Server 2016
work with scalar functions in SQL Server 2016
describe aggregate functions in SQL Server 2016
list Windows functions in SQL Server 2016
describe rowset functions in SQL Server 2016
work with implicit and explicit data type conversions in SQL Server 2016
demonstrate how to convert a value using the CAST function
demonstrate how to convert a value using the CONVERT function
describe how to convert a value using the PARSE function
demonstrate how to convert a value using the TRY_Parse function
describe how to convert a value using the TRY_Convert function
demonstrate how to validate data types using the ISNUMERIC function
work the IIF logical function in SQL Server
work with the CHOOSE function in SQL Server 2016
describe the NULL value in SQL Server 2016
demonstrate how to use ISNULL to replace NULL
work with the COALESCE function in SQL Server 2016
describe how to use the NULLIF function in SQL Server 2016
use functions in SQL Server 2016

Aggregating Data in SQL Server 2016

start the course
recognize the aggregate functions available using Transact-SQL
describe the built-in aggregate function SUM in SQL Server 2016
describe the built-in aggregate function AVG in SQL Server 2016
list the built-in aggregate function in MIN Server 2016
list the built-in aggregate function MAX in SQL Server 2016
list the built-in aggregate function COUNT in SQL Server 2016
describe how to aggregate distinct values using DISTINCT
demonstrate how to use aggregate functions with NULL
recognize when and where to use the GROUP BY clause
demonstrate how to group and rank the results of a query using the windowing functions in SQL Server 2016
describe how to process queries using the logical order of operations
describe the GROUP BY workflow process
describe how to use GROUP BY with aggregate functions in SQL Server 2016
demonstrate using complex GROUP BY clauses using GROUPING sets
recognize how to filter groups using the HAVING clause
recognize how to use PIVOT and UNPIVOT relational operators in SQL Server 2016
demonstrate how to use PIVOT in SQL Server 2016
demonstrate how to use UNPIVOT in SQL Server 2016
describe how to determine the impact on NULL values in PIVOT and UNPIVOT queries
use aggregate functions in SQL Server 2016

Subqueries and Predicate

start the course
recognize when and where to use subqueries in SQL Server 2016
describe the benefits of using scalar subqueries
demonstrate how to write scalar subqueries in SQL Server 2016
recognize how to write multi-valued subqueries in SQL Server 2016
work with correlated subqueries in SQL Server 2016
describe how to write correlated subqueries
recognize how to write correlated subqueries with aliases
describe how to write correlated subqueries with aliases
describe how to write correlated subqueries in a HAVING clause
describe how the EXISTS predicate evaluates data in SQL Server 2016
describe how to write queries using EXISTS with subqueries
demonstrate how to use EXISTS and NULLs in SQL Server 2016
describe how to use EXISTS and INNER JOINS in SQL Server 2016
demonstrate how to use NOT EXISTS with OUTER JOINs
use subqueries in SQL Server 2016

Operators and Expressions in SQL Server 2016

start the course
distinguish when to use the UNION and UNION All operators in SQL Server 2016
demonstrate how to write SQL Server 2016 queries that use the UNION operator
demonstrate how to write SQL Server 2016 queries that use the UNION ALL operator
demonstrate how to use the UNION and UNION ALL operators together
recognize when to use the EXCEPT operator in SQL Server 2016
demonstrate how to use the EXCEPT and INTERSECT operators in SQL Server 2016
determine the results of reversing the order of input with the EXCEPT operator
determine the effect of NULL values on the INTERSECT operator
recognize when to use the APPLY operator in SQL Server 2016
use APPLY statements that return given data based on supplied data in SQL Server 2016
use CROSS APPLY operators in SQL Server 2016
use OUTER APPLY operators in SQL Server 2016
recognize the basic components of table expressions in SQL Server 2016
describe the difference between table expressions and temporary tables
create recursive table expressions in SQL Server 2016
use operators in SQL Server 2016

Database Programmability Objects and Non-Relational Data

start the course
describe stored procedures in SQL Server 2016
use and create stored procedures in SQL Server 2016
demonstrate how to input parameters in SQL Server 2016
demonstrate how to output parameters in SQL Server 2016
recognize table-valued functions in SQL Server 2016
describe scalar-valued user-defined functions in SQL Server 2016
demonstrate TRY…CATCH error handling
demonstrate how to use RAISERROR in SQL 2016
describe temporal data types in SQL Server 2016
work with temporal tables in SQL Server 2016
describe XML data
describe JSON data
demonstrate how to query and output JSON data in SQL Server 2016
demonstrate how to query and output XML data in SQL Server 2016
use database programmability objects in SQL Server 2016

TestPrep 70-761 Querying Data with Transact SQL Test your knowledge on the skills and competencies measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.

Developing SQL Databases exam 70-762 :30 uur SQL Server 2016 Database Objects

start the course
create tables in SQL Server 2016
use the DROP TABLE statement to drop a table from a
database
use the ALTER TABLE statement to modify a table
add and removing columns from a table
duplicate a table
rename a table
use constraints to ensure integrity of data
describe the best practices to follow when selecting a naming
convention
describe the numeric data type category in SQL Server 2016
describe the date and time data type category in SQL Server
2016
describe the character and unicode data type category in SQL
Server 2016
describe the binary strings data type category in SQL Server
2016
describe the special data types category in SQL Server
2016
recognize the process of normalization in SQL Server 2016
describe the first normal form level of normalization
describe the second normal form level of normalization
describe the third normal form level of normalization
discuss when to denormalize a database
demonstrate how to create a SQL Table

SQL Server 2016 Indexes and Views

SQL Server 2016 uses indexes to speed up the performance of
queries and improve overall database performance. This course
covers how to design and implement the various index types
available in SQL Server 2016. In addition, this course covers
enhancing usability in SQL Server 2016 by using views. This course
is one of a series of courses that cover the objectives for 70-762:
Developing SQL Databases exam.

Columnstore Indexes

start the course
recognize when to use columnstore indexes
determine when to implement a columnstore index
create a clustered columnstore index
describe columnstore index data loading
describe columnstore versioned feature summary
improve columnstore index query performance
implement real-time operational analytics
describe columnstore index data warehousing
implement columnstore index defragmentation
differentiate between clustered and nonclustered columnstore
indexes in SQL Server 2016
create a nonclustered columnstore index
change data in a nonclustered columnstore index
describe in-memory nonclustered hash indexes
create tables with nonclustered hash indexes
describe in-memory index performance considerations
describe XML indexes
describe secondary XML indexes
describe XML index performance considerations
implement and configure columnstore indexes

Programmability Objects

Constraints can be used in SQL Server 2016 to ensure data
integrity. This covers how to design and implement constraints for
tables and columns. This course also covers stored procedures, a
SQL Server feature that allows you to reuse the code over and over,
providing advantages such as performance, productivity, and ease of
use. This course is one of a series of courses that cover the
objectives for 70-762: Developing SQL Databases exam.

Triggers and Functions

Triggers in SQL Server 2016 are sets of statements that execute
automatically when a specific event occurs in a database. This
course covers the design and implementation of the various types of
triggers found in SQL Server 2016. In addition, this course cover
functions, including scalar-valued, table-valued, deterministic,
and nondeterministic. This course is one of a series of courses
that cover the objectives for 70-762: Developing SQL Databases
exam.

Transactions and Isolation Levels

SQL Server transactions allow you to group together a number of
statements to form a single logical unit of work. This course
covers the various types of transactions, and explains how to
implement them in SQL Server 2016. This course also covers
isolation levels, a SQL Server 2016 feature that helps control the
way locking works between transactions. This course is one of a
series of courses that cover the objectives for 70-762: Developing
SQL Databases exam.

Managing Database Concurrency

Locking is a feature in SQL Server 2016 that helps ensure the
physical integrity of each transaction. This course covers how to
implement and troubleshoot locking, as well as how to minimize,
handle, and remediate deadlocks. This course also covers
memory-optimized tables, which are used to improve the performance
of transaction processing, as well as native stored procedures - a
feature used to enable efficient execution of the queries. This
course is one of a series of courses that cover the objectives for
70-762: Developing SQL Databases exam.

Optimize SQL Database Objects and Infrastructure

Optimizing statistics helps ensure the most efficient means of
executing statements in SQL Server 2016. This course covers how to
create, modify, and troubleshoot statistics and indexes in SQL
Server 2016. This course also covers how to analyze and
troubleshoot query plans in SQL Server 2016. This course is one of
a series of courses that cover the objectives for 70-762:
Developing SQL Databases exam.

Database Instances SQL Server Resource Governor is a feature Performance Tuning

SQL Server 2016 provides a comprehensive set of tools for
monitoring and tuning to ensure optimal performance for an
environment. This course covers performance metrics and monitoring,
as well as the various logging tools available with SQL Server,
such as perfmon and dynamic management objects. In addition, this
course covers Extended Events, and the event-handling system used
for monitoring SQL Server instances. This course is one of a series
of courses that cover the objectives for 70-762: Developing SQL
Databases exam.

En dat alles voor een fractie van de kosten van een klassikale training
Wilt U meer informatie over OEM Cert Kit? Neem contact op.

Duur 55 uur
Taal Engels
Certificaat van deelname Ja
Online toegang 365 dagen
Voortgangsbewaking Ja
Award Winning E-learning Ja
Geschikt voor mobiel Ja

Er zijn nog geen reviews geschreven over dit product.

Beoordelingen

Er zijn nog geen reviews geschreven over dit product.

Nieuwsbrief

Lees hier de wettelijke beperkingen

Goud Gecertificeerde Bekroonde E-Learning

MOS Gecertificeerde Docenten

Gemiddelde beoordeling

8.7

20 jaar Ervaring

Microsoft Office 365 Incompany Trainingen

Met MOS gecertificeerde docenten, nulmetingen met deskundig advies, maatwerk, huren van laptops, naslagwerk, hand-outs, evaluaties en certificaten van deelname.

Bekijk Incompany trainingen

Van onze blog

Lees onze meest recente artikelen

View blog