Home » Database Administration Fundamentals exam 98-364

Opleiding: Database Administration Fundamentals exam 98-364

Bij: OEM Office Elearning Menu

 

OEM Office Elearning Menu

P.J, Oudweg 4
1314 CH ALMERE
 

Inhoud van de cursus

SQL Server Database Fundamentals: Design Principles and Data Manipulation
start the course
define a database, describe how data is stored in tables containing records and fields, and describe flat, hierarchal, and relational databases
define database management systems (DBMS) and relational database management systems (RDBMS)
describe the purpose of and navigate SQL Server Management Studio (SSMS), a SQL Server instance, and its objects
describe the data types supported by SQL Server
describe the importance of data integrity to related database tables and list the methods for enforcement
define the standards used in tables for data storage such as removing duplicates, breaking down fields, and the use of primary keys in the context of SQL Server examples
define the standards used in column design and its properties such as auto increment columns, default and null values, and modifying size and format in the context of SQL Server examples
define the table and column properties such as collation, data type, size, and field properties in the context of SQL Server examples
define relationships in a database such as one-to-many, one-to-one, and many-to-many, outlining the role of primary, composite, and foreign keys in the context of SQL Server examples
describe the purpose of SQL, Data Definition LanguageDDL, and Data Manipulation LanguageDML statements in the context of SQL Server
use SELECT statements to query tables and columns
use SELECT statements with WHERE, AND, NOT, BETWEEN to filter results
use the ORDER By clause to order result sets returned from a SELECT statement
use the SQL Server aggregate functions COUNT, AVG, MIN, and MAX to return specific result sets
use INNER JOINS to retrieve data from multiple SQL Server tables
use OUTER JOINS to retrieve data from multiple SQL Server tables
use CROSS JOINS to retrieve data from multiple SQL Server tables
use the statements executed on a SQL Server database
use INTERSECT and EXCEPT to compare and extract data from result sets returned from SQL Server data
describe how data is inserted into a database and use INSERT statements to insert onemore rows into a SQL Server database
use BULK INSERT to insert data into a SQL Server database
describe how data is updated to a SQL Server database and use appropriate UPDATE statements
use DELETE to delete data from singlemultiple SQL Server tables
use transactions with SQL Server to ensure data and referential integrity
use Data Manipulation LanguageDML statements to query, update, and delete data in a SQL Server database
SQL Server Database Fundamentals: Creating, Optimizing, and Securing Databases
start the course
create a new SQL Server database with its specific syntax and parameters and review its schema by using SQL Server Management StudioSSMS and Data Definition LanguageDDL
use, alter, and drop SQL Server databases by using SQL Server Management StudioSSMS and Data Definition LanguageDDL
create SQL Server tables and define their properties by using SQL Server Management StudioSSMS and Data Definition LanguageDDL
alter and drop SQL Server tables by using SQL Server Management StudioSSMS and Data Definition LanguageDDL
compare TRUNCATE to DELETE and use the TRUNCATE command to remove data from a SQL Server table
describe the purpose and performance impact of views and create a view in a SQL Server database by using SQL Server Management StudioSSMS graphical designerby using Transact-SQLT-SQL
create and use stored procedures in SQL Server databases
compare the stored functions with stored procedures and create and use a stored function within a SQL Server database
describe the purpose of normalizing relational databases
describe the normalization guidelines for relational databases and define the first normal form1NF
describe the normalization guidelines for relational databases and define the second normal form2NF
describe the normalization guidelines for relational databases and define the third normal form3NF
describe clustered and nonclustered indexes in the context of their use in a SQL Server database
create clustered and nonclustered indexes in SQL Server databases
describe the main considerations for relational database security
identify and describe SQL Server fixed and user-defined server and database roles, the guest account, and how to revoke it by using SQL Server Management StudioSSMS
create, assign, and manage permissions to a SQL Server login
list the options available in SQL Server for database backups and restores
use SQL Server to back up databases
use SQL Server to restore databases
use the appropriate commands to create and normalize tables in a SQL Server database

Toelatingseisen: wat heb je nodig?

Er is geen specifieke voorkennis vereist.

Duur van de cursus

9 uur

Bijzonderheden

Award Winning E-learning

Plaatsen / leslocaties

Heel Nederland, E-learning, Online

Algemene informatie over de cursus

Bestel deze geweldige Elearning Training Database Administration Fundamentals exam 98-364 online cursus, 1 jaar 24/ 7 toegang tot rijke interactieve video’s, spraak, praktijkopdrachten, voortgangsbewaking door rapportages en testen per onderwerp om de kennis direct te toetsen. Na de cursus ontvangt u een certificaat van deelname.

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

Informatie aanvragen

Gegevens aangeduid met een * zijn verplicht in te vullen.
jaar
 
resterend: tekens
 
8003F Typ de code exact over: (hoofdlettergevoelig)
 
Copyright 2009-2020 Particuliereopleidingen.nl | Algemene voorwaarden | Overzicht van onze aanbieders | Adverteren