{"product_id":"sql-server-transact-sql-programming","title":"SQL Server Transact-SQL Programming","description":"\u003cdiv\u003e\u003cp\u003e\u003cspan\u003eTransact-SQL is integral to the power of SQL Server as its features allow developers to create scalable, distributed applications for meeting the demanding requirements of modern organizations. In addition to comprehensive coverage of Microsoft SQL Server, this training course provides you with the skills to create stored procedures and triggers and develop T-SQL that utilizes SQL Server to the fullest.\u003c\/span\u003e\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eSQL Server Transact-SQL Programming Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\u003cp\u003e\u003cspan\u003eDevelop scalable, distributed applications with Transact-SQL to meet organizational requirements\u003c\/span\u003e\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003e\u003cspan\u003eCreate modular code with stored procedures and formulate triggers\u003c\/span\u003e\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003e\u003cspan\u003eDevelop reusable code with scalar- and table-valued functions\u003c\/span\u003e\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003e\u003cspan\u003eHandle Transact-SQL runtime errors to create robust software\u003c\/span\u003e\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003e\u003cspan\u003eAudit data changes using AFTER triggers\u003c\/span\u003e\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eLeverage continued support with after-course one-on-one instructor coaching and computing sandbox\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eSQL Server Transact-SQL Programming Instructor-Led Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eImportant Course Information\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003ePrerequisites\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLearning Tree Learning Tree Course 2107: Microsoft SQL Server Training Course\u003c\/li\u003e\n\u003cli\u003eExperience with the Windows user interface\u003c\/li\u003e\n\u003cli\u003eFamiliarity with the base features of SQL Server or DBMS\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eWho Should Attend?\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eThis course benefits database developers, administrators, and analysts who want to expand their knowledge of SQL Server. Attendees should have experience with SQL Server at the level of Learning Tree Course 2107: Microsoft SQL Server Training Course\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eExam Information\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eLearning Tree Exam provided at the end of class\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: SQL Server Architecture\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eSQL Server edition overview\u003c\/li\u003e\n\u003cli\u003eSQL Server Management Studio\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Managing Tables with DDL\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eCreating schemas\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eReferencing schemas versus using the default schema\u003c\/li\u003e\n\u003cli\u003eHiding schemas with synonyms\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eBuilding tables\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSelecting appropriate SQL Server data types\u003c\/li\u003e\n\u003cli\u003eConstructing tables with CREATE TABLE\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eAdding constraints\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eEnforcing uniqueness using PRIMARY KEY and UNIQUE constraints\u003c\/li\u003e\n\u003cli\u003eValidating relationships using FOREIGN KEY\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Retrieving Data with Transact-SQL Stored Procedures\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eBatch and stored procedure processing\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMinimizing network traffic using batches and procedures\u003c\/li\u003e\n\u003cli\u003eStored procedure compilation and execution\u003c\/li\u003e\n\u003cli\u003eUsing scalar functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eSelecting data\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDeveloping stored procedures that extract data from multiple servers\u003c\/li\u003e\n\u003cli\u003eExecuting dynamic queries using OPENROWSET and OPENQUERY\u003c\/li\u003e\n\u003cli\u003eExecuting remote procedures\u003c\/li\u003e\n\u003cli\u003eCapturing RETURN values from stored procedures\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eDeclaring variables and parameters\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCreating and utilizing local variables\u003c\/li\u003e\n\u003cli\u003ePassing input and output parameters\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eCalling built-in scalar functions\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eConverting data using CAST and CONVERT\u003c\/li\u003e\n\u003cli\u003eOrdering data with ranking functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Maintaining Data\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eModifying data\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eEnsuring data consistency with transactions and distributed transactions\u003c\/li\u003e\n\u003cli\u003eManaging concurrency with isolation levels\u003c\/li\u003e\n\u003cli\u003eSQL Server locking fundamentals\u003c\/li\u003e\n\u003cli\u003eAvoiding blocking problems with read-committed snapshot isolation\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eProgramming procedural statements\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eImplementing conditions with IF...ELSE\u003c\/li\u003e\n\u003cli\u003eLooping with WHILE and GOTO\u003c\/li\u003e\n\u003cli\u003eCreating code blocks with BEGIN...END\u003c\/li\u003e\n\u003cli\u003eDebugging T-SQL in Management Studio\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eHandling errors\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCommunicating problems to the client with RAISERROR\u003c\/li\u003e\n\u003cli\u003eIntercepting errors with TRY ... CATCH\u003c\/li\u003e\n\u003cli\u003eDealing with open transactions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eProducing server-side result sets\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBuilding and using temporary tables\u003c\/li\u003e\n\u003cli\u003eProcessing rows on the server with a cursor\u003c\/li\u003e\n\u003cli\u003eTaking advantage of table variables\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Developing Views, Functions, and Triggers\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eStoring queries on the server\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eConcealing complexity with views\u003c\/li\u003e\n\u003cli\u003eSolving business problems using multi-statement table-valued functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eCreating user-defined functions\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCalculating values with scalar functions\u003c\/li\u003e\n\u003cli\u003eTaking advantage of schema binding\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eFormulating triggers\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eINSTEAD OF vs. AFTER triggers\u003c\/li\u003e\n\u003cli\u003eDetecting row changes using the inserted\/deleted tables\u003c\/li\u003e\n\u003cli\u003eTracing metadata changes with DDL triggers\u003c\/li\u003e\n\u003cli\u003eAuditing user access using a LOGON trigger\u003c\/li\u003e\n\u003cli\u003eTracking data changes with the OUTPUT clause\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"267C22US \/ 2026-07-28T09:00:00 \/ Herndon, VA","offer_id":47534213431515,"sku":"US-532-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26AB07US \/ 2026-10-27T09:00:00 \/ Herndon, VA","offer_id":48216587862235,"sku":"US-532-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"271B14US \/ 2027-01-26T09:00:00 \/ Herndon, VA","offer_id":48216587895003,"sku":"US-532-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"274A83US \/ 2027-04-27T09:00:00 \/ Herndon, VA","offer_id":48682050552027,"sku":"US-532-IL","price":2512.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/products\/sql-server-transact-sql-programming","provider":"Learning Tree International","version":"1.0","type":"link"}