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