Windows Store Applications and Databases

Individuals interested in the Microsoft Technology Associate (MTA) certification track; programmers and developers who want to better understand software development; individuals interested in learning the fundamental skills needed in software development

Prerequisite
None

Expected Duration
134 minutes

Description
Creating applications for multiple types of devices is now commonplace and most applications today require access to a datastore for saving, modifying, and retrieving information. In this course, you will learn the fundamentals of Windows Store applications for creating apps for multiple devices. Focus is centered on planning and designing the app, as well as how gestures operate in Windows Store apps. In addition, this course also covers the basics of console-based applications and Windows Services, and the benefits of these types of applications. Finally, you will learn database fundamentals including various types of databases available, basics of RDBM systems, entity relationship diagrams, normalization, structured query language, and stored procedures. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft certification exam Software Development Fundamentals (Exam 98-361), part of the Microsoft Technology Associate (MTA) certification track.

Objective

Console Applications and Windows Services

  • start the course
  • identify the characteristics of a console-based application and the situations when console applications are beneficial
  • create a console application in Microsoft Visual Studio
  • describe the characteristics of a Windows Services application and how they differ from other applications created using Visual Studio
  • create a Windows Service in Microsoft Visual Studio
  • perform the install and uninstall procedures when working with Windows Services

Windows Store Apps

  • describe what Windows Store apps are and on which devices they can run
  • identify the key stages in the design process when planning a Windows Store app
  • identify the key elements to consider when creating the UI for a Windows Store app
  • identify the types of gestures available to a Windows Store app
  • explain considerations for creating Windows Store apps
  • Create a Windows Store app in Microsoft Visual Studio

Database Fundamentals

  • describe the characteristics and capabilities of various types of databases, including table structure
  • identify the core concepts of RDBMS, including primary, foreign and unique keys, and relationship types
  • recognize the purpose of entity relationship diagrams and their associated components
  • recognize basic entity relationship diagrams to demonstrate the relationships existing in a database
  • describe what normalization is and identify the benefits it provides
  • describe the different levels of normal forms and the advantages and disadvantages of each

Database Query Methods and Connections

  • describe the purpose of SQL and how it can be used to access data in a database
  • identify and write basic SQL statements for reading, writing, and editing data in a database
  • create a new SQL database, import SQL data and use SQL commands to access a database
  • describe the different types of stored procedures and the benefits stored procedures provide
  • create and access a stored procedure
  • describe various types of data stores such as flat files and XML files
  • connect to an XML data store programmatically

Practice: Windows Store Apps and Databases

  • identify the fundamental concepts associated with Windows Store Apps and databases, including stored procedures and normalization

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.