考试代码：201 数据库 考试大纲

ITS认证考试考什么？考试内容？

ITS认证考试是分科目的，现在我们要看得就是Certiport给出的ITS考试代码：201 考试名称：数据库的大纲，如果你通过了这科考试之后，将会获得数据库的ITS证书

本ITS考试的考生将展示如何设计和查询关系数据库（例如 MySQL、Microsoft SQL Server 或 Oracle）的基础知识。

Database Design

  1. Given a scenario, design tables for storing data
    • Identify entities, rows/records, columns/fields
  2. Given a scenario, identify the appropriate primary key
    • Primary key, composite/compound key
  3. Given a scenario, choose data types to meet requirements
    • Definition and importance of data types; how data types affect storage requirements; data types for storing text, numbers, dates and times, and Boolean values
  4. Given a scenario, design relationships between tables
    • How to establish relationships using primary and foreign keys, entityrelationship diagrams (ERDs), referential integrity
  5. Normalize a database
    • Reasons for normalization, how to normalize a database to third normal form (3NF)
  6. Given a scenario, identify data protection measures
    • Backups, restore, principle of least privilege , GRANT, WITH GRANT OPTION, REVOKE, purpose of roles

Database Object Management using DDL

  1. Construct and analyze queries that create, alter, and drop tables
    • Create, alter, and drop tables by using proper ANSI SQL syntax; NULL and NOT NULL
  2. Construct and analyze queries that create, alter, and drop views
    • Create, alter, and drop views by using proper ANSI SQL syntax; purpose of views
  3. Construct and analyze stored procedures and functions
    • Input and output parameters, return values, purpose of stored procedures
  4. Given a scenario, choose between clustered and non-clustered indexes
    • When to use clustered vs. non-clustered indexes, syntax for creating indexes

Data Retrieval

  1. Construct and analyze queries that select data
    • INNER JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN (Cartesian product), and FULL OUTER JOIN; self joins; combine result sets by using UNION and INTERSECT; DISTINCT; column alias; computed columns
  2. Construct and analyze queries that sort and filter data
    • ORDER BY, WHERE, LIKE, BETWEEN, AND, OR, NOT, TOP (LIMIT), IN, NOT IN, ANY, ALL, NULL, NOT NULL, comparison operators
  3. Construct and analyze queries that aggregate data
    • GROUP BY, HAVING, MIN, MAX, COUNT, AVG (AVERAGE), SUM

Data Manipulation using DML

  1. Construct and analyze INSERT statements
    • INSERT INTO SELECT, INSERT INTO VALUES
  2. Construct and analyze UPDATE statements
    • Update data in a single table
  3. Construct and analyze DELETE statements
    • Delete data from a single table

Troubleshooting

  1. Troubleshoot data object management query failures
    • Syntax and runtime errors
  2. Troubleshoot data retrieval query failures
    • Syntax and runtime errors
  3. Troubleshoot data manipulation query failures
    • Syntax and runtime errors

©重庆睿一网络科技有限公司