Apr 28, 2024  
College Catalog 2022-2023 
    
College Catalog 2022-2023 [ARCHIVED CATALOG]

CSIS 291 - SQL Server for Manufacturing - Part 1


5 Credits
This course is for managing manufacturing database. The student will learn how to create batches and scripts, declare and use variables, data type conversions, and operators. Next, the student will learn the built-in T-SQL functions, work with numbers and string manipulation, as well as learning how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. The student will learn how to use the Transact-SQL programming language for error handling and hierarchical queries in SQL Server.