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.