Windows Store Applications and Databases


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/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.

Target Audience
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

Prerequisites
None

Expected Duration (hours)
2.2

Lesson Objectives

Windows Store Applications and Databases

  • 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
  • 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
  • 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
  • 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
  • identify the fundamental concepts associated with Windows Store Apps and databases, including stored procedures and normalization
  • Course Number:
    sd_sdfn_a05_it_enus

    Expertise Level
    Beginner