Introduces students to foundational concepts of data, information, and data management. Learners identify and use different types of data models. Learners use Microsoft Visio to create diagrams that illustrate how entities are related. Additional topics include eliminating data redundancy, explaining structures of relational tables, and compiling a data dictionary.
Introduces the development and deployment of native mobile applications. Learners will create applications for various mobile platforms incorporating both platform specific user interfaces and shared, back-end, C#, .NET code, and will deploy them to their own mobile devices. Additional topics include mobile user interface standards, bandwidth considerations, XML, JSON and debugging.
Learners describe primary keys and how to select them. Learners explain normalization and its role in the database design process. Learners apply normalization rules to evaluate and correct table structures. Learners use SQL Server and retrieve information from data tables. Learners use to SQL queries to join tables, aggregate data, and restrict data retrieval.
Create database models and database objects using T-SQL statements. Learners use data manipulation language (DML) to modify and create data. Learners manipulate the structure of existing tables to add, modify, and remove columns and constraints. Additional topics include foreign key relationships and indexes.