Google Links
Follow the links below to find material targeted to the unit's elements, performance criteria, required skills and knowledge
Required Skills
analytical skills to design complex multilayer application model
communication skills to interact with developer to ensure proper implementation
learning skills to investigate potential new techniques to access data from various resources
read and interpret database design document
problemsolving skills to develop and refine strategies to access data sources
create code for the dataaccess layer
create structured query language SQL commands to select insert update or delete data
objectoriented design and multilayer applications
relational database management systems
Evidence Required
Range Statement
Multi-layer application may include: | business logic layer (BLL)data-access layer (DAL) user interface layer (UI). |
Data-access application programming interface may relate to: | object-oriented set of libraries used to interact with data sources:active data objects (ADO.NET)ADO.NET Entity FrameworkJava database connectivity (JDBC) language integrated query (LINQ). |
Data source may include: | databases:Microsoft SQL serverMySQLOraclePostgre Structured Query Language (Postgre SQL)fat-files databaseinternal dataobject data sourcesXML database. |
Data providers may include: | managed providersMicrosoft object linking and embedding (OLE) DBnative providersopen database connection (ODBC)SQL clientthird-party providers. |
Query data may include: | access input and output parameters and return valuesaccess stored procedurescreate command objects. |
Data integrity may include: | cascading deletescascading updatesconstraints. |
Disconnected data may include: | DataSetDataTableservice data objects (SDO). |