MDT 320 - Mobile Data Storage Management

1. Discuss the fundamentals of local data storage on mobile devices.
   1. Discuss the built-in storage features of mobile devices.
   2. Explain the advantages and disadvantages of storing data on mobile devices.
   3. Introduce the device’s file system and native database.
2. Analyze the mobile platform’s development environment.
   1. Identify the required software.
   2. Review the download and installation steps.
   3. Discuss the essential configuration settings.
3. Point out the storage capabilities of the device’s file system.
   1. Identify internal and external storage mechanisms.
   2. Describe common use cases for storing limited amounts of data.
   3. Explore the framework to store and retrieve key/value pairs within an app.
   4. Explain app-to-app data sharing features.
   5. Discuss the device sensor inputs available to an app.
4. Assess using the native database as a local back-end for applications.
   1. Explain the benefits of local database storage.
   2. Describe key concepts of database processing.
   3. Introduce database schemas.
   4. Explore schemas containing multiple interdependent tables.
5. Create a basic data-driven app utilizing the native database.
   1. Develop and instantiate a database schema.
   2. Demonstrate how to obtain a database object.
   3. Explore inserting, updating and removing rows from database tables.
   4. Demonstrate how to insert/retrieve rows into/from a table.
6. Analyze the fundamentals of database queries.
   1. Discuss the benefits of optimizing queries on mobile devices with limited memory.
   2. Differentiate between parsing/filtering data within an app versus parsing/filtering data utilizing database commands.
   3. Describe the purpose of a SELECT statement
   4. Examine the structure and clauses of a SELECT statement.
   5. Explore the result sets from SELECT statements using various combinations of clauses.
7. Demonstrate insert, update and delete techniques.
   1. Explain basic concepts for maintaining database content.
   2. Describe the purpose of the INSERT, UPDATE and DELETE statements.
   3. Examine the structure and clauses of the INSERT, UPDATE and DELETE statements.
   4. Explore the results of executing INSERT, UPDATE and DELETE statements.
8. Analyze a user interface (UI) components’ database capabilities.
   1. Discuss creating an intuitive interface to interact with a local database.
   2. Explain binding data to UI components.
   3. Describe techniques for displaying local database content.
   4. Describe techniques for storing and updating local database content.
9. Develop a full featured data-centric mobile application.
   1. Define and implement a data model.
   2. Identify the data objects available to the application.
   3. Write code to manipulate local database content.
   4. Demonstrate the use of result sets from database operations.
10. Explore Web Services.
    1. Describe the fundamentals of Web Services including the roles of SOAP and WSDL in component-based services and XML and HTTP in the REST Architecture.
    2. Understand how to manipulate XML packages received from Web Service components or pushed to Web Service components.
    3. Explian how to pull data remotely via Web Services.
    4. Understand how to push data from the mobile app to a remote server via Web Services.
11. Outline mobile database common practices.
    1. Identify use cases for local databases within mobile apps.
    2. Discuss exposing database content to other applications on the mobile device.
    3. Identify use cases for external databases as primary data storage.
    4. Explore using local database caches with external databases.