Course Outline

ISTA 420 : SQL and Application Development

Preview Workflow

Viewing: ISTA 420-WW : SQL and Application Development

Last approved: Tue, 26 Jul 2016 14:01:18 GMT

Last edit: Tue, 26 Jul 2016 14:01:17 GMT

ISTA 420-WW
Campus
Worldwide
College of Business (WBUAD)
ISTA
420
SQL and Application Development
3
This course introduces the key components of SQL including tables, indexes, data integrity, managed code, XML, and functions. The SQL components are applied using APIs in order to support the development of applications that interact with SQL servers. This course is part of a set of five related ISTA courses that make up the Cloud Applications Developer specialization's technical content.

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server

2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course incorporates concepts, materials, and online labs from Microsoft Official Courses 20461, Querying Microsoft SQL Server. Required course materials include time-sensitive license vouchers that students must have to participate in the course. The course prepares students to take the associated Microsoft Certification exam, which is incorporated as the course Final Exam. Students must take this exam at a Microsoft-approved test proctor facility; see the Master Textbook List for further information. In addition, by preparing the student to succeed with the related Microsoft Certification exams, this course is an essential step on the way to earning relevant Microsoft professional certifications.

After completing this course, a student will be able to:1. Compare and contrast other programming languages and strategies with the architecture, concepts and approach when using SQL and Transact-SQL with databases.2. Plan the development, test and validation, and operational use and support of apps using T-SQL that meet business or organizational objectives.3. Develop applications using T-SQL to perform basic database transactions, such as select, query, sort, filter, group and aggregate, input and modify data.4. Group and aggregate data.5. Use subqueries, table expressions, pivoting and grouping, set operators, built-in functions, and stored procedures.6. Implement data validation, consistency checking, and error handling strategies.

Located on the Daytona Beach Campus, the Jack R. Hunt Library is the primary library for all students of the Worldwide Campus. The Chief Academic Officer strongly recommends that every faculty member, where appropriate, require all students in his or her classes to access the Hunt Library or a comparable college-level local library for research. The results of this research can be used for class projects such as research papers, group discussion, or individual presentations. Students should feel comfortable with using the resources of the library. 


Web & Chat: http://huntlibrary.erau.edu
Email:  library@erau.edu
Text: (386) 968-8843
Library Phone:  (386) 226-7656 or (800) 678-9428
Hourshttp://huntlibrary.erau.edu/about/hours.html
 

Written assignments must be formatted in accordance with the current edition of the Publication Manual of the American Psychological Association (APA) unless otherwise instructed in individual assignments.

ActivityPercent of Grade
Input Grading Item100

Undergraduate Grade Scale

90 - 100% A
80 - 89% B
70 - 79% C
60 - 69% D
0 - 60% F

Graduate Grade Scale

90 - 100% A
80 - 89% B
70 - 79% C
0 - 69% F
Key: 443