1
PERSONNEL SERVICES
RIALTO UNIFIED SCHOOL DISTRICT Name
182 E. Walnut
Avenue
Rialto, CA
92376
Date
JUNIOR DATABASE ANALYST
QUALIFICATIONS
QUESTIONNAIRE
INSTRUCTIONS
TO APPLICANT: Please complete this questionnaire by typing or clearly
printing your answer
to
each question. This information will be used as part of the testing
process for Junior Database Analyst
.
NOTE: Please review the vacancy announcement carefully before completing this
Qualifications Questionnaire
.
1) Describe how you meet the requirement of six months of paid experience
programming in SQL database or web-based client/server, software development
environment, and database systems developer.
2
2) Please describe and give examples for all of the following questions:
a) Your knowledge and ability in database development and implementation as it
pertains to your experience in SQL databases and web-based relational
database systems’ design and programming techniques.
b) Your knowledge of structured query language, relational databases and their
structures, and Job Control Language.
c) Your ability to conduct, research, analyze and track problems to final solution.
3
3) Given the following tables, you have been tasked to generate a list of students, one
record per student, which meets the listed required fields and conditions. Describe or
list specific queries you would use and your processing steps.
Required fields & Conditions:
Fields: Student ID, Student Last and First Name, Student Grade Level, Student Gender,
Student Ethnicity
Conditions: Additionally list any Math course marks (Display fields: Course ID, Course
Name, Course Teacher, Course Term and Course Mark) for semesters 1 and 2 and their
CAASPP Math scores and performance levels (Display fields: Test Name, Test Version, Test
Type, Test Scale Score, Test Performance Level) during the last two years. The list should
only include a student if the student had a Math mark of an A or B in either semester or the
CAASPP Math Performance Level was met or exceeded in any of the last two years.
Students:
Courses:
Tests:
4
Grades:
Test Performance Levels:
Test Scores: