SQL Server and T-SQL

Associate of Applied Science in Information Technology – Software Development

Course ID
Course Credits

About SQL Server and T-SQL

This course provides an in-depth look at Microsoft’s relational database management system, SQL Server, as well as Microsoft’s proprietary flavor of SQL technology, T-SQL. The course material builds upon prior coursework with SQL, and explores topics including T-SQL queries, query tuning, multi-table queries, grouping, pivots, windowing, T-SQL for Microsoft BI, objects, OLTP, graphs, and recursive queries. Upon completion of the course, students will be confident performing detailed and complex SQL and RDBMS operations in a Microsoft environment.


Students must have completed ASD225 with a satisfactory grade.

Talk to an Advisor

Reach out today and one of our knowledgeable Admissions Representative will be happy to answer any questions you have about CIAT.

  • We’d like to make it easy for you to connect with us! When you request an inquiry, you will be immediately introduced to your personal Admissions Representative who will help you coordinate an appointment time that best works with your schedule.

    By submitting this form, you are giving your express written consent for California Institute of Arts & Technology to contact you regarding our educational programs and services using email, telephone or text – including our use of automated technology for calls and periodic texts to any wireless number you provide. Message and data rates may apply. This consent is not required to purchase goods or services and you may always call us directly at 877-559-3621. You can opt-out at any time by calling us or responding STOP to any text message.