Working with Local Data in Xamarin.Forms 4 from Pluralsight

At the core of high quality mobile app development with Xamarin.Forms is an understanding of how to store data locally. In this course, you'll learn about different local data storage options, and how they can improve your app's performance.

Mobile apps that don't leverage local data storage for caching and offline access often present a less polished experience to the end user. In this course, Working with Local Data in Xamarin.Forms, you’ll learn how to use a variety of local data storage options to enhance your app’s performance and flexibility. First, you’ll explore the different storage options that are available, so you can make the best decision about which type of local storage to use. Next, you’ll discover how to create SQLite databases, the most robust option available. Then, you’ll learn how to create a model to map the database, with a code first/ORM style experience. Finally, you’ll get a better understanding on how to set up and access data in the SQLite database using the models you’ve created, enabling things like caching and offline access. When you’re finished with this course, you’ll have a foundational knowledge of local data storage in Xamarin.Forms that will help you as you move forward to high quality Xamarin.Forms app development.

What's inside

Syllabus

Course Overview

Introduction

Local Storage Options in Xamarin.Forms

Setting up SQLite Databases

Accessing Data in SQLite Databases

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Explores data storage, which is standard in app development

Taught by John Kuefler, who is a recognized expert in Xamarin.Forms

Develops advanced SQLite knowledge for robust local data storage

Covers setting up and accessing SQLite databases, which are highly relevant in mobile app development

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Working with Local Data in Xamarin.Forms 4 with these activities:

Join a SQLite Study Group or Discussion Forum

Show steps

Facilitates knowledge sharing and helps you connect with other learners interested in SQLite.

Browse courses on Local Data Storage

Show steps

Search for online SQLite study groups or discussion forums
Join a group and actively participate in discussions
Ask questions, share your knowledge, and collaborate with others

Review mobile development concepts

Show steps

Review foundational concepts of mobile development to strengthen your understanding before diving into local data storage.

Browse courses on Xamarin.Forms

Show steps

Go over notes from previous mobile development courses
Read articles and tutorials on essential mobile development principles
Complete practice exercises or coding challenges to test your understanding

Xamarin.Forms Local Data Storage Tutorial

Show steps

This tutorial will provide you with a comprehensive overview of local data storage options in Xamarin.Forms.

Browse courses on Local Data Storage

Show steps

Visit the official Xamarin documentation.
Find the tutorial on local data storage.
Follow the steps in the tutorial.

Ten other activities

Expand to see all activities and additional details

Show all 13 activities

Review Apps Using SQLite

Show steps

Reinforces knowledge of local data storage options and gets you comfortable using SQLite.

Browse courses on SQLite

Show steps

Find a beginner-friendly tutorial that focuses on SQLite for Xamarin.Forms
Follow the steps in the tutorial to create a basic SQLite database and populate it with data
Query the database and display the results

SQLite Database Creation

Show steps

Creating and modifying SQLite databases will solidify your understanding of local storage in Xamarin.Forms.

Show steps

Create a new Xamarin.Forms project.
Install the SQLite.Net NuGet package.
Create a new SQLiteConnection.
Create a new SQLiteCommand.
Execute the SQLiteCommand to create the database.

Study Group Discussion

Show steps

Discussing local data storage concepts with peers will reinforce your understanding and help you identify areas where you need additional support.

Browse courses on Discussion

Show steps

Find a study group or create your own.
Choose a topic related to local data storage in Xamarin.Forms.
Prepare for the discussion by reviewing the course materials.
Participate in the discussion and share your insights.

Explore SQLite tutorials

Show steps

Seek out tutorials to gain a deeper understanding of SQLite, its features, and how it can enhance your Xamarin.Forms app performance.

Browse courses on SQLite

Show steps

Identify reputable online resources or video courses
Follow tutorials on SQLite concepts such as database creation, data manipulation, and query optimization
Practice writing SQLite queries and executing them in a sample project

ORM Tutorial

Show steps

Implementing an ORM with SQLite will help you understand how to interact with data in a type-safe and efficient manner.

Browse courses on ORM

Show steps

Create a new class that represents your database model.
Add properties to the class for each column in your database table.
Create a new SQLiteConnection.
Create a new SQLiteCommand to create the table.
Execute the SQLiteCommand.

Data Retrieval and Update Exercises

Show steps

Practicing data retrieval and update operations will improve your ability to manipulate data in your SQLite database.

Browse courses on Data Retrieval

Show steps

Create a new Xamarin.Forms project.
Install the SQLite.Net NuGet package.
Create a new SQLiteConnection.
Create a new SQLiteCommand to retrieve data.
Execute the SQLiteCommand and iterate through the results.

Solve SQLite query challenges

Show steps

Engage in practice drills to enhance your ability to write efficient and optimized SQLite queries.

Browse courses on SQLite

Show steps

Find online resources or platforms that offer SQLite query challenges
Attempt to solve the challenges within a time constraint
Review and analyze your solutions against optimal solutions provided

Create a simple SQLite database app

Show steps

Build a small project to apply your knowledge of SQLite and local data storage in a practical setting.

Browse courses on SQLite

Show steps

Define the purpose and scope of your app
Create a database schema and design data models
Implement data access and manipulation functionality
Test the app and iterate based on feedback

Contribute to a SQLite Library or Tool

Show steps

Provides practical experience working with SQLite and contributes to the open source community.

Browse courses on SQLite

Show steps

Find an open source SQLite library or tool that interests you
Review the documentation and identify an area where you can contribute
Make changes to the codebase and submit a pull request
Respond to feedback and iterate on your contributions

Develop a Real-World App Using SQLite

Show steps

Challenges you to apply your SQLite skills to solve a real-world problem and create a fully functional app.

Browse courses on SQLite

Show steps

Brainstorm an idea for an app that requires local data storage
Design the app's data model and schema
Implement the SQLite database and integrate it into your app's functionality
Test and debug your app to ensure it meets the requirements
Deploy your app and share it with others

Career center

Learners who complete Working with Local Data in Xamarin.Forms 4 will develop knowledge and skills that may be useful to these careers:

Data Privacy Analyst

Data Privacy Analysts develop and implement data privacy policies and procedures to ensure that data is collected, used, and disclosed in a compliant manner. They use their knowledge of data privacy laws and regulations to create data privacy programs that meet the needs of organizations. The Working with Local Data in Xamarin.Forms 4 course may be useful for Data Privacy Analysts, as it provides a foundation in local data storage options and techniques, which are essential for managing and protecting data.

See salaries and explore the career path for Data Privacy Analyst

Software Architect

Software Architects design and implement software architectures. They use their knowledge of software architecture principles and best practices to create software architectures that meet the needs of organizations. The Working with Local Data in Xamarin.Forms 4 course may be useful for Software Architects, as it provides a foundation in local data storage options and techniques, which are essential for designing and implementing software architectures.

See salaries and explore the career path for Software Architect

Information Architect

Information Architects design and organize information systems to make them easy to use and find. They use their knowledge of information architecture principles and best practices to create information systems that meet the needs of users. The Working with Local Data in Xamarin.Forms 4 course may be useful for Information Architects, as it provides a foundation in local data storage options and techniques, which are essential for designing and organizing information systems.

See salaries and explore the career path for Information Architect

Data Warehouse Architect

Data Warehouse Architects design and implement data warehouses. They use their knowledge of data warehousing principles and best practices to create data warehouses that meet the needs of users. The Working with Local Data in Xamarin.Forms 4 course may be useful for Data Warehouse Architects, as it provides a foundation in local data storage options and techniques, which are essential for designing and implementing data warehouses.

See salaries and explore the career path for Data Warehouse Architect

Data Governance Analyst

Data Governance Analysts develop and implement data governance policies and procedures to ensure that data is managed and used in a consistent and ethical manner. They use their knowledge of data governance principles and best practices to create data governance programs that meet the needs of organizations. The Working with Local Data in Xamarin.Forms 4 course may be useful for Data Governance Analysts, as it provides a foundation in local data storage options and techniques, which are essential for managing and governing data.

See salaries and explore the career path for Data Governance Analyst

Data Security Analyst

Data Security Analysts develop and implement data security policies and procedures to ensure that data is protected from unauthorized access, use, disclosure, disruption, modification, or destruction. They use their knowledge of data security principles and best practices to create data security programs that meet the needs of organizations. The Working with Local Data in Xamarin.Forms 4 course may be useful for Data Security Analysts, as it provides a foundation in local data storage options and techniques, which are essential for protecting data.

See salaries and explore the career path for Data Security Analyst

Database Administrator

Database Administrators design, implement, and maintain databases. They use their knowledge of database management systems and data storage technologies to ensure that data is stored and managed efficiently and securely. The Working with Local Data in Xamarin.Forms 4 course may be useful for Database Administrators, as it provides a foundation in local data storage options and techniques, which are essential for managing and maintaining databases.

See salaries and explore the career path for Database Administrator

Cloud Architect

Cloud Architects design and implement cloud computing solutions. They use their knowledge of cloud computing principles and best practices to create cloud solutions that meet the needs of organizations. The Working with Local Data in Xamarin.Forms 4 course may be useful for Cloud Architects, as it provides a foundation in local data storage options and techniques, which are essential for designing and implementing cloud solutions.

See salaries and explore the career path for Cloud Architect

Business Intelligence Analyst

Business Intelligence Analysts use their knowledge of business intelligence tools and techniques to help businesses make informed decisions. They collect, analyze, and interpret data to identify trends, patterns, and insights that can be used to improve business outcomes. The Working with Local Data in Xamarin.Forms 4 course may be useful for Business Intelligence Analysts, as it provides a foundation in local data storage options and techniques, which are essential for managing and analyzing data.

See salaries and explore the career path for Business Intelligence Analyst

DevOps Engineer

DevOps Engineers design and implement DevOps pipelines. They use their knowledge of DevOps principles and best practices to create DevOps pipelines that meet the needs of organizations. The Working with Local Data in Xamarin.Forms 4 course may be useful for DevOps Engineers, as it provides a foundation in local data storage options and techniques, which are essential for managing and automating data pipelines.

See salaries and explore the career path for DevOps Engineer

Mobile App Developer

Mobile App Developers design, develop, and maintain mobile applications. They use their knowledge of mobile operating systems and programming languages to create apps that meet the needs of users. The Working with Local Data in Xamarin.Forms 4 course may be useful for Mobile App Developers, as it provides a foundation in local data storage options and techniques, which are essential for building and maintaining mobile applications.

See salaries and explore the career path for Mobile App Developer

Software Engineer

Software Engineers design, develop, and maintain software applications. They use their knowledge of programming languages and software development methodologies to create software that meets the needs of users. The Working with Local Data in Xamarin.Forms 4 course may be useful for Software Engineers, as it provides a foundation in local data storage options and techniques, which are essential for building and maintaining software applications.

See salaries and explore the career path for Software Engineer

Data Analyst

Data Analysts use their skills in data analysis and interpretation to help businesses make informed decisions. They collect, clean, and analyze data to identify trends, patterns, and insights that can be used to improve business outcomes. The Working with Local Data in Xamarin.Forms 4 course may be useful for Data Analysts, as it provides a foundation in local data storage options and techniques, which are essential for managing and analyzing data.

See salaries and explore the career path for Data Analyst

Data Engineer

Data Engineers use their knowledge of data storage and management to build and maintain data pipelines, data warehouses, and other data infrastructure. Their work involves designing and implementing data storage solutions, ensuring data quality, and developing tools and processes to improve data access and analysis. The Working with Local Data in Xamarin.Forms 4 course may be useful for Data Engineers, as it provides a foundation in local data storage options and techniques, which are essential for building and managing data systems.

See salaries and explore the career path for Data Engineer

Data Scientist

Data Scientists use their knowledge of data science and machine learning to build and deploy models that can predict future outcomes and provide insights into complex data. Their work involves developing and implementing machine learning algorithms, designing and conducting experiments, and interpreting and communicating results. The Working with Local Data in Xamarin.Forms 4 course may be useful for Data Scientists, as it provides a foundation in local data storage options and techniques, which are essential for managing and analyzing data.

See salaries and explore the career path for Data Scientist