CLOSURE: Central Library will be closed Tuesday, July 21, through Saturday, July 25, while emergency repairs are made to the building’s cooling system. We expect to reopen Monday, July 27. Click for more details on holds, program schedules, and returns during the closure. 

Notice of Public Meeting: Kalamazoo Public Library Board of Trustees | July 27 | 5:30 pm | Central Library/Van Deusen Room. The packet of information for the meeting can be found on the library’s website

Introduction to Transact-SQL

Summary

Get an introduction to Transact-SQL (T-SQL), a Microsoft-specific extension of SQL.

Relational databases and SQL servers have been a cornerstone of businesses for decades, and as data growth increases at an exponential pace, learning to work with data held in SQL Server databases is more important than ever. In this course, Jess Pomfret introduces Transact-SQL, an extension of SQL used to interact with relational databases that includes additional programming constructs and features beyond standard SQL, particularly procedural programming. Jess starts with the basics, guiding you through your first SELECT statement to help you get the data you need out of a database. She then shows how to add functionality to help filter, manipulate, and present the results you need. By the end of this course, you’ll be well equipped to write the T-SQL you need to get the job done. This course includes Code Challenges powered by CoderPad. Code Challenges are interactive coding exercises with real-time feedback, so you can get hands-on coding practice alongside the course content to advance your programming skills.

Subjects

Added Authors

linkedin.com (Firm)