50-156-701Introductory SQL
Course Information
Description
The introductory SQL course prepares apprentices to leverage a relational database management system to retrieve data. They will create and execute queries using SQL statements. They will read an Entity-Relationship Diagram to direct the creation of the correct query.
Total Credits
2
Course Competencies
  1. Use a SQL-based development toolset
    Assessment Strategies
    Oral, Written and/or Skill Assessment
    Criteria
    apprentice creates database objects using a SQL IDE (integrated development environment)
    apprentice scripts objects using a SQL IDE
    apprentice locates components within a SQL IDE
    apprentice runs scripts within a SQL IDE
    apprentice successfully debugs scripts within a SQL IDE

  2. Use data terminology, concepts and data types
    Assessment Strategies
    Oral, Written and/or Skill Assessment
    Criteria
    apprentice lists common data types
    apprentice defines the components of a relational database
    apprentice assigns appropriate data types to data elements
    apprentice associates database terms with corresponding definitions
    apprentice explains the value and typical use of a database

  3. Analyze an Entity Relationship (ER) Diagram
    Assessment Strategies
    Oral, Written and/or Skill Assessment
    Criteria
    apprentice identifies entities
    apprentice explains relationships
    apprentice builds SQL statements based on the ER Diagram

  4. Create SQL statements
    Criteria
    apprentice writes “Select” statements
    apprentice uses the “Order by” command
    apprentice uses the “Where” clause
    apprentice joins tables

This Outline is under development.