Sep 20, 2019  
2018-2019 Course Catalog 
    
2018-2019 Course Catalog [ARCHIVED CATALOG]

[Add to Portfolio]

MDT 320 - Mobile Data Storage Management

Credits: 3
Lecture Hours: 3
Lab Hours: 0
Practicum Hours: 0
Work Experience: 0
Course Type: Voc/Tech
This course examines how to build apps that persist and use data effectively on mobile devices. Explore how to create an efficient data model to represent data and learn how to work with data objects to refine result sets. Introduce techniques developers use in data-driven apps to store and retrieve data utilizing the device’s native database. Discuss the opportunities for using the cloud environment to store and stream data.
Prerequisite OR Corequisite: MDT 210   orMDT 220  
Competencies
  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.



[Add to Portfolio]