Microsoft MTA 98-364: Database Fundamentals | 24/7 live Help and Live Labs included | 365 Days Access

Type de cours
Logo DiviTrain
Note du fournisseur: starstarstarstarstar_half 9,2 DiviTrain a une moyenne de 9,2 (basée sur 9 avis)

Astuce: besoin de plus d'informations sur la formation? Téléchargez la brochure!

Description

DiviTrain is originally a Dutch education company with a proven track record of 19 years providing the latest award-winning IT courses thru innovative video-based e-learning complete with live labs for practicing, our unique 24/7 live help, and 365 days access per course! These days DiviTrain provides her courses all over Europe and Africa.

Candidates for this exam are seeking to prove introductory knowledge of and skills with databases, including relational databases, such as Microsoft SQL Server. It is recommended that candidates be familiar with the concepts of and have hands-on experience with the technologies described here, either by taking relevant training courses or by working with tutorials and samples available on MSDN and in Microsoft Visual Studio. Although minimal hands-on experience with the technologies is recommended, job experience is not assumed for these exams.

Description

MTA Database Fundamentals is designed to provide students with an explanation and understanding of fundamental security concepts. This …

Lisez la description complète ici

Foire aux questions (FAQ)

Il n'y a pour le moment aucune question fréquente sur ce produit. Si vous avez besoin d'aide ou une question, contactez notre équipe support.

Vous n'avez pas trouvé ce que vous cherchiez ? Voir aussi : Microsoft Access, Data privacy, Data management, IoT et Sécurité informatique.

DiviTrain is originally a Dutch education company with a proven track record of 19 years providing the latest award-winning IT courses thru innovative video-based e-learning complete with live labs for practicing, our unique 24/7 live help, and 365 days access per course! These days DiviTrain provides her courses all over Europe and Africa.

Candidates for this exam are seeking to prove introductory knowledge of and skills with databases, including relational databases, such as Microsoft SQL Server. It is recommended that candidates be familiar with the concepts of and have hands-on experience with the technologies described here, either by taking relevant training courses or by working with tutorials and samples available on MSDN and in Microsoft Visual Studio. Although minimal hands-on experience with the technologies is recommended, job experience is not assumed for these exams.

Description

MTA Database Fundamentals is designed to provide students with an explanation and understanding of fundamental security concepts. This training course prepares students for Microsoft exam 98-364.

This course provides you with interactive videos that meet the needs of multiple styles of learning from auditory to visual, and it includes a pre-test and post-test that accurately identifies your skill gap.

MTA is an entry-level credential from Microsoft that validates the foundational knowledge needed to take the first step toward building a successful career in technology. The MTA certification programs cover the baseline knowledge of building and managing Microsoft Windows Servers, Windows-based network operating systems, Active Directory, account management, and system recovery tools.

Session 1

  • Database Tables
  • Database Relationships
  • Understanding DML
  • Database Data Types
  • Creating and Manipulating Tables
  • Selecting Data
  • Filtering Data using Comparisons

Session 2

  • Filtering Data using Lists and Ranges
  • Filtering Data using Pattern Matching
  • Filtering Data with NULLs
  • Selecting Data using Functions
  • Sorting Data
  • Working with Duplicates
  • Joining Data
  • OUTER and CROSS JOINs
  • Combining and Limiting Result Sets

Session 3

  • Adding Data
  • Updating and Deleting Data
  • Working with Views
  • Stored Procedures and Functions
  • Data Normalization
  • First Normal Form
  • Second and Third Normal Forms
  • Fourth and Fifth Normal Forms

Session 4

  • Primary, Foreign, and Composite Keys
  • Clustered Indexes
  • Non-Clustered Indexes
  • Database Security Concepts
  • Database Backup and Restore
  • Incremental Backups

A more detailed list of topics can be found here.

Aims

  • Understand core database concepts like relationships, tables, and SQL (Structured Query Language)
  • Learn to filter, sort, and update data
  • Become familiar with data normalization and the common levels of normalization

Format

Online videos

  • 24/7 Live Help included
    • Live Practice Labs included 

Rester à jour sur les nouveaux avi

Pas encore d'avis.

Partagez vos avis

Avez-vous participé à Programme? Partagez votre expérience et aider d'autres personnes à faire le bon choix. Pour vous remercier, nous donnerons 1,00 € à la fondation Stichting Edukans.

Il n'y a pour le moment aucune question fréquente sur ce produit. Si vous avez besoin d'aide ou une question, contactez notre équipe support.

Recevoir une brochure d'information (gratuit)

Sexe:
(optionnel)
(optionnel)
(optionnel)
(optionnel)
(optionnel)

Vous avez des questions?

(optionnel)
Nous conservons vos données personnelles dans le but de vous accompagner par email ou téléphone.
Vous pouvez trouver plus d'informations sur : Politique de confidentialité.