| |
May 06, 2024
|
|
|
|
|
2022-2023 Catalog [ARCHIVED CATALOG]
|
DBMS 230 - Microsoft T-SQL Development
PREREQUISITES: DBMS 130 - Data Management using Structured Query Language
PROGRAM: Data Analytics
CREDIT HOURS MIN: 3
LECTURE HOURS MIN: 2
LAB HOURS MIN: 2
DATE OF LAST REVISION: Fall, 2020
Students will focus on developing applications in a Microsoft SQL Server environment. Students will build and test applications using the functionality of tools in Microsoft SQL Server. Students will develop and test application functionality across multiple platforms and environments, deploy to production code, and build and validate enterprise-ready solutions.
MAJOR COURSE LEARNING OBJECTIVES: Upon successful completion of this course the student will be expected to:
- Identify the components and specifications of SQL Server.
- Perform an installation and configuration of Microsoft SQL Server.
- Design and modify file groups, tables, views, and indexes.
- Create and alter stored procedures and user-defined functions (UDFs).
- Create and alter DML and DDL triggers.
- Create and deploy CLR-based objects and error handling.
- Perform transaction management and track data changes.
- Use Query Builder and SQL Workshop to create, run, and save SQL queries.
- Construct an application using developer tools.
- Generate data definition language (DDL) statements.
- Create, manipulate and customize interactive reports manually and using wizards.
- Design and modify multiple types of forms manually or with themes and templates.
- Implement subqueries and joins.
- Demonstrate mastery of T-SQL through integration with queries and triggers and to automate database tasks such as backup.
- Integrate Database Mail.
- Utilize appropriate scripting with environment appropriate tools to automate database administration tasks, such as Windows PowerShell, SQL Server Management Objects (SMOs) and Service Broker.
- Utilize XML to retrieve, transform and manage data.
- Analyze performance information using SHOWPLAN, Profiler, Tuning Advisor and Dynamic Management View.
- Implement Security measures including authentication, authorization, access controls and session state protection and debugging.
- Verify, Deploy, manage and maintain a completed application using development tools.
COURSE CONTENT: Topical areas of study include -
- File Groups
- Transaction Management
- Query Builder
- Aggregate Queries
- Application Creation
- Subqueries and Joins
- Report and Form Creation
- Database Mail
- Tables, Views, Indexes, and Constraints
- Full-Text Search
- Partitioning
- Windows PowerShell
- Access Control
- SQL Server Management Objects (SMOs)
- Session State and Debugging
- Service Broker Solutions
- Data Validation and Data Processing
- XML
- Data Definition Language (DDL)
- SHOWPLAN
- Stored Procedures
- SQL Server Profiler
- CLR Objects
- Database Engine Tuning Advisor
- User Defined Functions (UDFs)
- Dynamic Management Views (DMVs)
- Catalog Views
- Error Handling
Course Addendum - Syllabus (Click to expand)
|
|
