{"title":"SQL","description":null,"products":[{"product_id":"writing-sql-queries-with-sql-server-management-studio","title":"Writing SQL Queries with SQL Server Management Studio","description":"\u003cdiv\u003e\n\u003cp\u003eThis SQL Server Management Studio course will teach you to write SQL queries and learn the basics of SELECT, INSERT, UPDATE, and DELETE statements. SQL Server Management Studio helps ease the learning curve of SQL with the Query Designer and Query Window and is a good starting point for those wanting to learn SQL. Learn to leverage all it has to offer in this intensive 1-day course.SQL Server Management Studio helps ease the learning curve of SQL with the Query Designer and Query Window and is a good starting point for those wanting to learn SQL. In this training course, you learn the basics of SELECT, INSERT, UPDATE, and DELETE statements, and gain the skills to leverage SQL Server Management Studio for graphically designing SQL queries.\u003c\/p\u003e\n\u003cp\u003e\u003c\/p\u003e\n\u003cp\u003eNo formal prerequisites are required to attend this course.\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eWriting SQL Queries with SQL Server Management Studio Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eLeverage SQL Server Management Studio to graphically design SQL queries\u003c\/li\u003e\n\u003cli\u003eWrite Transact-SQL statements to collect and analyze data\u003c\/li\u003e\n\u003cli\u003eTarget data retrieval with the WHERE clause\u003c\/li\u003e\n\u003cli\u003eManipulate data with INSERT, UPDATE, and DELETE statements\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eSQL Server Management Studio Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eOutline\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eSelecting simple data sets with Transact-SQL\u003c\/li\u003e\n\u003cli\u003eJoining columns from related tables\u003c\/li\u003e\n\u003cli\u003eAnalyzing aggregated data\u003c\/li\u003e\n\u003cli\u003eChanging information in a query window\u003c\/li\u003e\n\u003cli\u003eCreating a simple stored procedure\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"268A06US \/ 2026-08-11T09:00:00 \/ Online","offer_id":47408519020763,"sku":"US-4550-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"26BA18US \/ 2026-11-20T09:00:00 \/ Online","offer_id":48050320605403,"sku":"US-4550-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"272A10US \/ 2027-02-19T09:00:00 \/ Online","offer_id":48277632123099,"sku":"US-4550-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"275A13US \/ 2027-05-19T09:00:00 \/ Online","offer_id":48783428354267,"sku":"US-4550-IL","price":716.0,"currency_code":"USD","in_stock":true}]},{"product_id":"writing-sql-queries-training","title":"Writing SQL Queries Training","description":"\u003cdiv\u003e\u003cp\u003eAttend this Writing SQL Queries course and learn the essentials of the SQL language used by all relational database products. In this course, you gain the knowledge and skills to write SELECT statements for data retrieval. This SQL query writing course is intended for users and developers who are new to the technology and interested in getting started with the SQL language.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eWriting SQL Queries Training Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eWrite SQL SELECT statements based on ANSI\/ISO standards to retrieve data from relational databases\u003c\/li\u003e\n\u003cli\u003eIdentify the fundamental database building blocks\u003c\/li\u003e\n\u003cli\u003eApply filter conditions to extract specific data\u003c\/li\u003e\n\u003cli\u003eCombine multiple tables with different types of joins\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eYou should have familiarity with basic programming and database concepts a the level of:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLearning Tree course 382, {course:382}\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eImportant Writing SQL Queries Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eTraining Modules\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eRetrieving data from tables\u003c\/li\u003e\n\u003cli\u003eApplying conditions to filter retrieved rows\u003c\/li\u003e\n\u003cli\u003eJoining multiple tables\u003c\/li\u003e\n\u003cli\u003eSorting query results\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"269A24US \/ 2026-09-16T09:00:00 \/ Online","offer_id":47597100859611,"sku":"US-4551-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"26AA31US \/ 2026-10-26T09:00:00 \/ Online","offer_id":48041972728027,"sku":"US-4551-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"271A04US \/ 2027-01-08T09:00:00 \/ Online","offer_id":48111273803995,"sku":"US-4551-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"273A01US \/ 2027-03-03T09:00:00 \/ Online","offer_id":48313106104539,"sku":"US-4551-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"274A12US \/ 2027-04-26T09:00:00 \/ Online","offer_id":48669334372571,"sku":"US-4551-IL","price":716.0,"currency_code":"USD","in_stock":true}]},{"product_id":"developing-sql-queries-for-oracle-databases","title":"Developing SQL Queries for Oracle Databases","description":"\u003cdiv\u003e\u003cp\u003eThis \u003cstrong\u003eOracle SQL Queries training\u003c\/strong\u003e course will help you increase productivity and maximize the potential of SQL to formulate intricate queries for Oracle databases. Learn to solve business problems easily, efficiently, and elegantly with only a few lines of SQL code, and gain the practical skills to choose the best query method — ensuring accuracy and avoiding common errors or pitfalls.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eDeveloping SQL Queries for Oracle Databases Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMaximize the potential of SQL to formulate complex queries.\u003c\/li\u003e\n\u003cli\u003eThoroughly test SQL queries and avoid common errors.\u003c\/li\u003e\n\u003cli\u003eSelect the most efficient solution to complex SQL problems.\u003c\/li\u003e\n\u003cli\u003eLeverage the analytical functions of Oracle.\u003c\/li\u003e\n\u003cli\u003eEmploy inner joins, outer joins, cross joins, and self joins.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eSQL and Oracle RDBMS knowledge at the level of:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCourse 925, Introduction to SQL Course\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eOracle SQL Queries Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Introduction and Overview\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eThe uses of SQL queries\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eWhy SQL can be both easy and difficult\u003c\/li\u003e\n\u003cli\u003eRecommendations for thorough testing\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eEnhancing query performance\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eQuery optimization\u003c\/li\u003e\n\u003cli\u003eChoosing the most efficient query method\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Leveraging SQL Functions to Build Queries\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eAggregate functions\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eGrouping in several levels\u003c\/li\u003e\n\u003cli\u003eGrouping and NULLs\u003c\/li\u003e\n\u003cli\u003eCUBE and ROLLUP\u003c\/li\u003e\n\u003cli\u003eBuilding crosstab reports\u003c\/li\u003e\n\u003cli\u003eUtilizing the PIVOT operator in Oracle 11\u003ci\u003eg\u003c\/i\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSingle-row functions\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eString-manipulation functions\u003c\/li\u003e\n\u003cli\u003eFunctions for date and time manipulation\u003c\/li\u003e\n\u003cli\u003eSimulating IF ... THEN ... ELSE with functions\u003c\/li\u003e\n\u003cli\u003eHandling regular expressions with Oracle 10\u003ci\u003eg\u003c\/i\u003e functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Performing Extensive Analysis with Analytical Functions\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eCalculating ranks\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eRANK and DENSE_RANK\u003c\/li\u003e\n\u003cli\u003eROW_NUMBER depending on ORDER BY\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eExtending the use of aggregates\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePartitioning in multiple levels\u003c\/li\u003e\n\u003cli\u003eComputing running totals\u003c\/li\u003e\n\u003cli\u003eComparing row and aggregate values\u003c\/li\u003e\n\u003cli\u003eDefining sliding window boundaries\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Developing Complex Joins\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eCreating inner and outer joins\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBuilding multiple table joins\u003c\/li\u003e\n\u003cli\u003eGrouping and joins\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eHow and when to use self-joins\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eImplementing recursive self-joins with CONNECT BY\u003c\/li\u003e\n\u003cli\u003eCONNECT BY and join simultaneously\u003c\/li\u003e\n\u003cli\u003eOracle 10\u003ci\u003eg\u003c\/i\u003e enhancements to CONNECT BY\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eApplying the ANSI standard join syntax\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eINNER JOIN\u003c\/li\u003e\n\u003cli\u003eCROSS JOIN\u003c\/li\u003e\n\u003cli\u003eLEFT, RIGHT and FULL OUTER JOIN\u003c\/li\u003e\n\u003cli\u003eAdding filter conditions to OUTER JOINS\u003c\/li\u003e\n\u003cli\u003eDifferences between new ANSI and old Oracle style\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eManipulating the set operators\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUNION and UNION ALL\u003c\/li\u003e\n\u003cli\u003eINTERSECT\u003c\/li\u003e\n\u003cli\u003eMINUS\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Building Subqueries\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eNoncorrelated subqueries\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSubqueries that return NULL\u003c\/li\u003e\n\u003cli\u003eMultiple row subqueries\u003c\/li\u003e\n\u003cli\u003eMultiple column subqueries\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eHandling correlated subqueries\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eFetching main query values\u003c\/li\u003e\n\u003cli\u003eThe EXISTS operator\u003c\/li\u003e\n\u003cli\u003eAvoiding accidental correlation\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSubqueries in the FROM clause\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBreaking up a complex problem into manageable pieces\u003c\/li\u003e\n\u003cli\u003eFactoring subqueries for reusability\u003c\/li\u003e\n\u003cli\u003eApplying recursive factored subqueries in Oracle 11\u003ci\u003eg\u003c\/i\u003e R2\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSubqueries as expressions\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSubqueries as parameters to functions\u003c\/li\u003e\n\u003cli\u003eCorrelated and noncorrelated subqueries in expressions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Employing Views and Temporary Tables\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eOvercoming obstacles with views\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMultiple group levels in one query\u003c\/li\u003e\n\u003cli\u003eHow views impact performance\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eTemporary tables as alternatives to views\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eAvoiding interference from other users\u003c\/li\u003e\n\u003cli\u003eTailoring temporary tables\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 7: Introducing Oracle 12c\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eLimiting the number of rows returned with FETCH\u003c\/li\u003e\n\u003cli\u003eRetrieving partly results with OFFSET\u003c\/li\u003e\n\u003cli\u003eSimulating joins with lateral views and APPLY\u003c\/li\u003e\n\u003cli\u003eDeclaring local functions in the WITH clause\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"267B67US \/ 2026-07-21T09:00:00 \/ Herndon, VA","offer_id":47534212776155,"sku":"US-234-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"269C18US \/ 2026-09-15T09:00:00 \/ Herndon, VA","offer_id":48216577638619,"sku":"US-234-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26BA43US \/ 2026-11-17T09:00:00 \/ Herndon, VA","offer_id":48216577736923,"sku":"US-234-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"271A45US \/ 2027-01-19T09:00:00 \/ Herndon, VA","offer_id":48216577769691,"sku":"US-234-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"273A37US \/ 2027-03-16T09:00:00 \/ Herndon, VA","offer_id":48377299566811,"sku":"US-234-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"275A38US \/ 2027-05-18T09:00:00 \/ Herndon, VA","offer_id":48780667388123,"sku":"US-234-IL","price":2512.0,"currency_code":"USD","in_stock":true}]},{"product_id":"advanced-sql-course","title":"Advanced SQL Course","description":"\u003cdiv\u003e\u003cp\u003eStructured Query Language (SQL) is the cornerstone of all relational database operations. In this hands-on \u003cstrong\u003eAdvanced SQL course\u003c\/strong\u003e, you will learn how to exploit the full potential of the SELECT statement to write robust queries using the best query method for your application, test your queries, and avoid common errors and pitfalls. It also teaches alternative solutions to given problems, enabling you to choose the most efficient solution in each situation.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eAdvanced SQL Course Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this Advanced SQL Course, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMaximize the potential of SQL to build powerful, complex, and robust SQL queries.\u003c\/li\u003e\n\u003cli\u003eQuery multiple tables with inner joins, outer joins, and self joins.\u003c\/li\u003e\n\u003cli\u003eConstruct recursive common table expressions.\u003c\/li\u003e\n\u003cli\u003eSummarize data using aggregation and grouping.\u003c\/li\u003e\n\u003cli\u003eExecute analytic functions to calculate ranks.\u003c\/li\u003e\n\u003cli\u003eBuild simple and correlated subqueries.\u003c\/li\u003e\n\u003cli\u003eThoroughly test SQL queries to avoid common errors.\u003c\/li\u003e\n\u003cli\u003eSelect the most efficient solution to complex SQL problems.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eAdvanced SQL Course Prerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eThis is an advanced course, and knowledge of the basics of SQL at the level of Learning Tree course 925, Introduction to SQL Course, or equivalent is assumed.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eAdvanced SQL Course Instructor-Led Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Introduction and Overview\u003c\/h4\u003e\n\u003cp\u003eSQL fundamentals \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eWhy SQL can be both easy and difficult \u003c\/li\u003e\n\u003cli\u003eRecommendations for thorough testing \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eRetrieving data with SELECT \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExpressions \u003c\/li\u003e\n\u003cli\u003eLiterals \u003c\/li\u003e\n\u003cli\u003eHandling NULLs properly \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eExecuting queries \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eAnalyzing query plans \u003c\/li\u003e\n\u003cli\u003eEnhancing query performance \u003c\/li\u003e\n\u003cli\u003eRetrieving partial results with FETCH and OFFSET \u003c\/li\u003e\n\u003cli\u003eSelecting the best alternatives \u003c\/li\u003e\n\u003cli\u003eAvoiding errors and pitfalls \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Querying Multiple Tables\u003c\/h4\u003e\n\u003cp\u003eImplementing various types of joins \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eInner joins \u003c\/li\u003e\n\u003cli\u003eCross joins \u003c\/li\u003e\n\u003cli\u003eLeft, right, and full outer joins \u003c\/li\u003e\n\u003cli\u003eEquijoins vs. theta joins \u003c\/li\u003e\n\u003cli\u003eThe performance implications of joins \u003c\/li\u003e\n\u003cli\u003eAdding filter conditions to outer joins \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eWriting self joins \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eJoining a table to itself \u003c\/li\u003e\n\u003cli\u003eChaining self joins \u003c\/li\u003e\n\u003cli\u003eSolving time-interval problems \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eCombining queries with set operators \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUNION \u003c\/li\u003e\n\u003cli\u003eUNION ALL \u003c\/li\u003e\n\u003cli\u003eINTERSECT \u003c\/li\u003e\n\u003cli\u003eEXCEPT \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Aggregate Functions\u003c\/h4\u003e\n\u003cp\u003eSummarizing data with aggregate functions \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCOUNT \u003c\/li\u003e\n\u003cli\u003eSUM \u003c\/li\u003e\n\u003cli\u003eAVG \u003c\/li\u003e\n\u003cli\u003eMIN \u003c\/li\u003e\n\u003cli\u003eMAX \u003c\/li\u003e\n\u003cli\u003eManaging NULLs \u003c\/li\u003e\n\u003cli\u003eidentifying duplicates \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eGrouping data \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eGROUP B \u003c\/li\u003e\n\u003cli\u003eApplying conditions with HAVING \u003c\/li\u003e\n\u003cli\u003eCalculating moving averages \u003c\/li\u003e\n\u003cli\u003eBuilding crosstab reports \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eExtending group queries \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eNesting grouped aggregates \u003c\/li\u003e\n\u003cli\u003eJoins and grouping \u003c\/li\u003e\n\u003cli\u003eIntroducing subtotals with CUBE and ROLLUP \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Performing Extensive Analysis with Analytic Functions\u003c\/h4\u003e\n\u003cp\u003eThe OVER clause \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSpecifying the ordering before applying the function \u003c\/li\u003e\n\u003cli\u003eSplitting the result set into logical partitions \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eCalculating ranks \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eRANK and DENSE_RANK \u003c\/li\u003e\n\u003cli\u003eROW_NUMBER with ordered sets \u003c\/li\u003e\n\u003cli\u003eCalculating percentiles \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eExtending the use of aggregates \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePartitioning in multiple levels \u003c\/li\u003e\n\u003cli\u003eComputing running totals \u003c\/li\u003e\n\u003cli\u003eComparing row and aggregate values \u003c\/li\u003e\n\u003cli\u003eTop-N queries \u003c\/li\u003e\n\u003cli\u003eDefining sliding window boundaries \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Building Subqueries\u003c\/h4\u003e\n\u003cp\u003eSelf-contained subqueries \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSubqueries in conditions and column expressions \u003c\/li\u003e\n\u003cli\u003eCreating multilevel subqueries \u003c\/li\u003e\n\u003cli\u003eAvoiding problems when subqueries return NULLs \u003c\/li\u003e\n\u003cli\u003eHandling multirow subquery results \u003c\/li\u003e\n\u003cli\u003eFinding gaps in number series \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eCorrelated subqueries \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eAccessing values from the outer query \u003c\/li\u003e\n\u003cli\u003eEXISTS vs. IN \u003c\/li\u003e\n\u003cli\u003eIdentifying duplicates \u003c\/li\u003e\n\u003cli\u003eAvoiding accidental correlation \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eCommon table expressions \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eReusable subqueries \u003c\/li\u003e\n\u003cli\u003eRecursive subqueries \u003c\/li\u003e\n\u003cli\u003eTraversing hierarchies \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Breaking Down Complex Queries\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eOvercoming SQL limitations \u003c\/li\u003e\n\u003cli\u003eReducing complexity and improving performance \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"267A15CN \/ 2026-07-22T09:00:00 \/ Online","offer_id":47534178238683,"sku":"US-929-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"268B63US \/ 2026-08-26T09:00:00 \/ New York","offer_id":47534178271451,"sku":"US-929-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269B29US \/ 2026-09-16T09:00:00 \/ Austin","offer_id":47597097910491,"sku":"US-929-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26AA20CN \/ 2026-10-21T09:00:00 \/ Toronto","offer_id":48216562467035,"sku":"US-929-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26AB14US \/ 2026-10-14T09:00:00 \/ Aurora, CO","offer_id":48216562499803,"sku":"US-929-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26AB15US \/ 2026-10-28T09:00:00 \/ Herndon, VA","offer_id":48216562532571,"sku":"US-929-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26BB14US \/ 2026-11-23T09:00:00 \/ San Francisco","offer_id":48216562565339,"sku":"US-929-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26CA32CN \/ 2026-12-16T09:00:00 \/ Ottawa","offer_id":48216562598107,"sku":"US-929-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"271B19US \/ 2027-01-20T09:00:00 \/ New York","offer_id":48216562663643,"sku":"US-929-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"272A82US \/ 2027-02-10T09:00:00 \/ Austin","offer_id":48236922503387,"sku":"US-929-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"273A36CN \/ 2027-03-23T09:00:00 \/ Toronto","offer_id":48500532740315,"sku":"US-929-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"273A96US \/ 2027-03-31T09:00:00 \/ Herndon, VA","offer_id":48525735198939,"sku":"US-929-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"274A87US \/ 2027-04-28T09:00:00 \/ Aurora, CO","offer_id":48696378228955,"sku":"US-929-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"275A32CN \/ 2027-05-19T09:00:00 \/ Ottawa","offer_id":48783409119451,"sku":"US-929-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269D51US \/ 2026-09-23T09:00:00 \/ Online","offer_id":48837147918555,"sku":"US-929-IL","price":2228.0,"currency_code":"USD","in_stock":true}]},{"product_id":"sql-server-integration-services-ssis-training-for-business-intelligence","title":"SQL Server Integration Services (SSIS) Training for Business Intelligence","description":"\u003cdiv\u003e\n\u003cp\u003eIn this \u003cstrong\u003eSQL server integration services\u003c\/strong\u003e course, you gain the skills to improve business intelligence capabilities by automating complex migration tasks and auditing the success or failure of migration processes. In addition, you will learn to transform data among heterogeneous data sources — such as text files, Oracle, Access, XML (Extensible Markup Language), ODBC (Open Database Connectivity), and OLE DB (Object Linking and Embedding Database) — and effectively and securely manage data migration across various platforms.\u003c\/p\u003e\r\n\u003cp\u003eIn this SSIS training course, you’ll gain the skills to migrate and transform data with SSIS. You learn to solve data management problems by creating dynamic packages for migrating, processing, and reporting on data for business intelligence. Specifically, you learn to deploy packages to an SSIS server, assemble tasks to perform complex data migrations, and enhance package functionality with scripting.\u003c\/p\u003e\r\n\u003cul\u003e\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eSQL Server Integration Services (SSIS) Training for Business Intelligence Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this SSIS Training for Business Intelligence course, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSolve data management problems by migrating and processing data. \u003c\/li\u003e\n\u003cli\u003ePerform nonstandard imports and exports using the Script component. \u003c\/li\u003e\n\u003cli\u003eAssemble tasks to perform complex data migrations. \u003c\/li\u003e\n\u003cli\u003eETL (Extract, Transform and Load) data. \u003c\/li\u003e\n\u003cli\u003eIncrementally migrate data from SQL (Structured Query Language) Server data sources using CDC (Change Data Capture). \u003c\/li\u003e\n\u003cli\u003eDeploy packages to an SSIS catalog. \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eSQL Server Integration Services Prerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eYou should have familiarity with relational database management systems, programming concepts, and SQL language. \u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eSSIS Training Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Introduction to Integration Services\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eDefining SQL SSIS (Server Integration Services) \u003c\/li\u003e\n\u003cli\u003eExploring the need for migrating diverse data \u003c\/li\u003e\n\u003cli\u003eThe role of BI (Business Intelligence) \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: SSIS Architecture and Tools\u003c\/h4\u003e\n\u003cp\u003eManaging heterogeneous data \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eETL (Leveraging the Extract, Transform and Load) capabilities of SSIS \u003c\/li\u003e\n\u003cli\u003eRunning wizards for basic migrations \u003c\/li\u003e\n\u003cli\u003eCreating packages for complex tasks \u003c\/li\u003e\n\u003cli\u003eExplore other supported data sources, such as Hadoop and NoSQL (not only SQL) \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eIllustrating SSIS architecture \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDistinguishing between data flow pipeline and package runtime \u003c\/li\u003e\n\u003cli\u003eExecuting packages on the client side or hosted in the SSIS service \u003c\/li\u003e\n\u003cli\u003eBulletproofing a package with package environments \u003c\/li\u003e\n\u003cli\u003ePackage restorability with checkpoint files \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSimplifying deployments\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDistinguishing between project and package deployment modes \u003c\/li\u003e\n\u003cli\u003eDeploying packages to the SSISDB (SSIS Catalog Database) \u003c\/li\u003e\n\u003cli\u003eRunning packages from SQL Server \u003c\/li\u003e\n\u003cli\u003eLeveraging package parameters \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Implementing Tasks and Containers\u003c\/h4\u003e\n\u003cp\u003eUtilizing basic SSIS objects \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eConfiguring connection managers \u003c\/li\u003e\n\u003cli\u003eAdding data flow tasks to packages \u003c\/li\u003e\n\u003cli\u003eReviewing progress with data viewers \u003c\/li\u003e\n\u003cli\u003eAssembling tasks to perform complex data migrations \u003c\/li\u003e\n\u003cli\u003eMigrating multiple files with FOREACH container \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eOperating system-level tasks \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCopying, moving, and deleting files \u003c\/li\u003e\n\u003cli\u003eTransferring files with the FTP (File Transfer Protocol) task \u003c\/li\u003e\n\u003cli\u003eCommunicating with external sources \u003c\/li\u003e\n\u003cli\u003eSending messages through mail \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eProcessing XML \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIterating XML nodes \u003c\/li\u003e\n\u003cli\u003eWriting XML files from databases \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Extending Capabilities with Scripting\u003c\/h4\u003e\n\u003cp\u003eWriting expressions\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMaking properties dynamic with variables\u003c\/li\u003e\n\u003cli\u003eUtilizing expressions in loop iterations\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eScript Task\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExtending functionality with the Script Task\u003c\/li\u003e\n\u003cli\u003eDebugging, breakpoints, and watches\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Transforming with the Data Flow Task\u003c\/h4\u003e\n\u003cp\u003ePerforming transforms on columns \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eConverting and calculating columns \u003c\/li\u003e\n\u003cli\u003eTransforming with Character Map \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eProfiling, combining, and splitting data \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMerge, Union, and Conditional Split \u003c\/li\u003e\n\u003cli\u003eMulticasting and converting data \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eManipulating row sets and BLOB data \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eAggregate, sort, audit, and look up data \u003c\/li\u003e\n\u003cli\u003eImporting and exporting BLOB data \u003c\/li\u003e\n\u003cli\u003eRedirecting error rows \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003ePerforming database operations \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExecuting a SQL task \u003c\/li\u003e\n\u003cli\u003eBulk inserting data from text files \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Error Handling, Logging and Transactions\u003c\/h4\u003e\n\u003cp\u003eOrganizing package workflow \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDefining success, failure, completion, and expression precedence constraints \u003c\/li\u003e\n\u003cli\u003eHandling events and event bubbling \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eDesigning robust packages \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eChoosing log providers \u003c\/li\u003e\n\u003cli\u003eAdapting solutions with package configurations \u003c\/li\u003e\n\u003cli\u003eAuditing package execution results \u003c\/li\u003e\n\u003cli\u003eAccessing package data with ADO.NET (ActiveX Data Object) \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"266A92US \/ 2026-06-15T09:00:00 \/ Herndon, VA","offer_id":47534218346715,"sku":"US-134-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"268A86US \/ 2026-08-11T09:00:00 \/ Herndon, VA","offer_id":47534218379483,"sku":"US-134-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"269A77CN \/ 2026-09-01T09:00:00 \/ Ottawa","offer_id":48216562106587,"sku":"US-134-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26BA20CN \/ 2026-11-03T09:00:00 \/ Ottawa","offer_id":48216562139355,"sku":"US-134-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26CB10US \/ 2026-12-01T09:00:00 \/ Herndon, VA","offer_id":48216562172123,"sku":"US-134-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"272A16CN \/ 2027-02-09T09:00:00 \/ Ottawa","offer_id":48233010233563,"sku":"US-134-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"273B22US \/ 2027-03-16T09:00:00 \/ Herndon, VA","offer_id":48377301500123,"sku":"US-134-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"275A15CN \/ 2027-05-11T09:00:00 \/ Ottawa","offer_id":48759289250011,"sku":"US-134-IL","price":2512.0,"currency_code":"USD","in_stock":true}]},{"product_id":"microsoft-sql-server-training-course","title":"Microsoft SQL Server Training Course","description":"\u003cdiv\u003e\n\u003cp\u003eIn this intro to \u003cstrong\u003eMicrosoft SQL Server® training\u003c\/strong\u003e, you gain the introductory skills to maximize SQL Server's benefits. Learn how to use the various administrative and development tools within SQL Server, including the Microsoft BI (Business Intelligence) stack of Integration Services, Analysis Services, and Reporting Services. \u003c\/p\u003e\r\n\u003cp\u003eSQL Server offers a platform for enterprise data management, robust development, and implementation of modern Business Intelligence solutions. Attend this hands-on course and learn to leverage these features.\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eMicrosoft SQL Server Training Course Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this Microsoft SQL Server training, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCreate and administer SQL Server databases.\u003c\/li\u003e\n\u003cli\u003eWrite Transact-SQL queries to retrieve and manipulate data.\u003c\/li\u003e\n\u003cli\u003eSecure, back up, and monitor databases with Management Studio.\u003c\/li\u003e\n\u003cli\u003eIntegrate SQL Server with Microsoft Office.\u003c\/li\u003e\n\u003cli\u003eTransform data into strategic information using Business Intelligence components.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eMicrosoft SQL Server Training Prerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eThis is SQL Server training for beginners, so no prior experience is needed to take this course. You will learn the basics of SQL Server and gain the introductory skills needed to maximize SQL Server’s benefits.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eMicrosoft SQL Server Introduction Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Introducing SQL Server\u003c\/h4\u003e\n\u003cdiv\u003e\n\u003cp\u003eOverview of the SQL Server suite of products\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eFundamentals of the relational database engine\u003c\/li\u003e\n\u003cli\u003eBenefits of the Business Intelligence stack\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSQL Server components and tools\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSQL Server Agent and Management Studio\u003c\/li\u003e\n\u003cli\u003eIntegration Services\u003c\/li\u003e\n\u003cli\u003eAnalysis Services\u003c\/li\u003e\n\u003cli\u003eReporting Services\u003c\/li\u003e\n\u003cli\u003eData Quality Services\u003c\/li\u003e\n\u003cli\u003eMaster Data Services\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Building the Database\u003c\/h4\u003e\n\u003cp\u003eConstructing a relational database\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eChoosing optimal file size and growth parameters\u003c\/li\u003e\n\u003cli\u003eWorking with database schemas\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eDefining tables\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSpecifying appropriate data types\u003c\/li\u003e\n\u003cli\u003eIndexing tables with Management Studio\u003c\/li\u003e\n\u003cli\u003eAdding, modifying, or removing columns\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSafeguarding data with constraints\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eEnforcing uniqueness through primary key constraints\u003c\/li\u003e\n\u003cli\u003eValidating conditions with check constraints\u003c\/li\u003e\n\u003cli\u003eProtecting relationships with foreign keys\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Leveraging Server Programmability\u003c\/h4\u003e\n\u003cp\u003eRetrieving data with Transact-SQL \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eEmploying Query Designer to construct select statements \u003c\/li\u003e\n\u003cli\u003eRetrieving subsets of data from multiple tables using joins and the WHERE clause criteria \u003c\/li\u003e\n\u003cli\u003eAnalyzing data for aggregate functions \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eModifying data with SQL commands \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eInserting new rows into tables \u003c\/li\u003e\n\u003cli\u003eUpdating targeted data \u003c\/li\u003e\n\u003cli\u003eDeleting specific rows \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eIntroduction to developing programming constructs \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCreating stored procedures for productivity \u003c\/li\u003e\n\u003cli\u003eWriting user-defined functions to simplify queries \u003c\/li\u003e\n\u003cli\u003eDeploying triggers to capture change events \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Administering SQL Server Databases\u003c\/h4\u003e\n\u003cp\u003eExecuting the Maintenance Plan Wizard\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDefragmenting data and checking database integrity\u003c\/li\u003e\n\u003cli\u003eImproving performance by rebuilding indexes\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eAutomating administrative tasks\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eScheduling repeating jobs\u003c\/li\u003e\n\u003cli\u003eImplementing a backup strategy\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eMonitoring SQL Server resources\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDisplaying current activity and expensive queries\u003c\/li\u003e\n\u003cli\u003eRunning reports with Management Studio\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSecuring the database infrastructure\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eAuthenticating SQL Server and Windows logins\u003c\/li\u003e\n\u003cli\u003eAssigning users to database and server roles\u003c\/li\u003e\n\u003cli\u003eGranting or revoking permissions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Integrating External Applications\u003c\/h4\u003e\n\u003cp\u003eConnecting to Microsoft Office\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePulling data from SQL Server into Excel\u003c\/li\u003e\n\u003cli\u003eCreating a front-end interface with Access\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eTransferring business information\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eImporting and exporting data from text files\u003c\/li\u003e\n\u003cli\u003eMigrating an Access database to SQL Server\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Implementing Business Intelligence Solutions\u003c\/h4\u003e\n\u003cp\u003eExtracting data with Integration Services\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eTransforming and cleaning data\u003c\/li\u003e\n\u003cli\u003eLoading data into a data warehouse\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eInformation delivery with Reporting Services\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDesign reports quickly with the Report Builder\u003c\/li\u003e\n\u003cli\u003eDeploying reports for centralized access\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eAggregating data with Analysis Services\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBuilding multidimensional cubes\u003c\/li\u003e\n\u003cli\u003ePredicting trends with data mining\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eDeveloping a Business Intelligence strategy\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLeveraging Excel and Power Pivot\u003c\/li\u003e\n\u003cli\u003eTransferring data into knowledge with BI functionality\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"267B58US \/ 2026-07-14T09:00:00 \/ Herndon, VA","offer_id":47534212219099,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"269B02US \/ 2026-09-15T09:00:00 \/ Herndon, VA","offer_id":47595015635163,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"268A86CN \/ 2026-08-18T09:00:00 \/ Ottawa","offer_id":48216552669403,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26BC78US \/ 2026-11-17T09:00:00 \/ Herndon, VA","offer_id":48216552702171,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26CA30CN \/ 2026-12-15T09:00:00 \/ Ottawa","offer_id":48216552734939,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"272B82US \/ 2027-02-16T09:00:00 \/ Herndon, VA","offer_id":48266084843739,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"273A34CN \/ 2027-03-16T09:00:00 \/ Ottawa","offer_id":48377302155483,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"275C56US \/ 2027-05-18T09:00:00 \/ Herndon, VA","offer_id":48780665159899,"sku":"US-2107-IL","price":2512.0,"currency_code":"USD","in_stock":true}]},{"product_id":"sql-server-reporting-services","title":"SQL Server Reporting Services","description":"\u003cdiv\u003e\u003cp\u003eGain an in-depth skillset to leverage on-premises \u003cabbr title=\"Structured Query Language\"\u003eSQL\u003c\/abbr\u003e Server Reporting Services (\u003cabbr title=\"SQL Server Reporting Services\"\u003eSSRS\u003c\/abbr\u003e) for extracting business intelligence from enterprise data. Attain the knowledge and skills to produce compelling reports with enhanced visualization features. This training course enables you to go beyond the limitations of legacy reporting to deliver and share information with others — when you want and how you want.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eSQL Server Reporting Services Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\u003cp\u003eProduce reports for extracting business intelligence through the Web Portal\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eLeverage Visual Studio and Report Designer to create paginated reports\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eBuild reports for mobile devices with SQL Server Mobile Report Publisher\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eIntegrate parameters, filters, and interactive components into reports\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eDeploy reports through Report Server\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eCreate reports on SSAS cubes with Report Builder and Report Designer\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 Reporting Services Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eSQL Server Reporting Services Course Information\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003ePrerequisites\u003c\/b\u003e\u003c\/p\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eLearning Tree \u003cspan data-cke-saved-href=\"\/courses\/2107\/\" title=\"Microsoft SQL Server® Introduction \" rel=\"follow noopener\" target=\"_blank\"\u003eMicrosoft SQL Server® Introduction \u003c\/span\u003eor equivalent experience with any relational database system\u003c\/li\u003e\n\u003cli\u003eVisual Studio knowledge and familiarity with simple scripting is recommended, but not required\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003cp\u003e\u003cb\u003eWho should attend?\u003c\/b\u003e\u003c\/p\u003e\n\u003cdiv\u003e\n\u003cp\u003eThis course is for anyone with database experience who wants to design, create, or deliver reports from relational or MDX compliant data sources.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cp\u003e\u003cb\u003eExam Information\u003c\/b\u003e\u003c\/p\u003e\n\u003cdiv\u003e\n\u003cp\u003eLearning Tree Exam provided at the end of class\u003c\/p\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Introduction to SQL Server Reporting Services\u003c\/h4\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eArchitecture and tools\u003c\/li\u003e\n\u003cli\u003eManaging web farm deployment\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Developing Reports\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eLeveraging Reporting Services tools\u003c\/b\u003e\u003c\/p\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eReport Building with Report Builder and Visual Studio\u003c\/li\u003e\n\u003cli\u003eAccessing the power of \u003cabbr title=\"Structured Query Language\"\u003eSQL\u003c\/abbr\u003e Server Mobile Report Publisher\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eDesigning fundamental reports\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eConnecting to relational and multidimensional sources\u003c\/li\u003e\n\u003cli\u003eGenerating a Tablix reporting structure\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eComposing expressions\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eComputing custom fields\u003c\/li\u003e\n\u003cli\u003eLinking expressions to properties\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eArranging and sorting data\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMultiple-level grouping and categorizing the results\u003c\/li\u003e\n\u003cli\u003eApplying aggregate functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eProducing various outputs from a Tablix\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCreating parallel dynamic group report formats\u003c\/li\u003e\n\u003cli\u003eCombining dynamic and static columns\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Integrating Parameters and Filters\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eIncorporating parameters into reports\u003c\/b\u003e\u003c\/p\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eYielding subsets of data with query parameters\u003c\/li\u003e\n\u003cli\u003eConstructing cascading report parameters\u003c\/li\u003e\n\u003cli\u003eTransmitting parameters to stored procedures\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eApplying filters to report data\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eAugmenting performance with filters\u003c\/li\u003e\n\u003cli\u003eDetermining filters vs. query parameters\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Implementing Interactive Features\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eCombining multiple data regions in one report\u003c\/b\u003e\u003c\/p\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eApplying sequential and nested regions\u003c\/li\u003e\n\u003cli\u003eCreating master\/detail reports and linking subreports\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eShowing robust data with relevant detail\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDrilling through report detail and drilling down\u003c\/li\u003e\n\u003cli\u003eNavigating reports with document maps\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Deploying and Delivering Reports\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eDeploying reports to the server\u003c\/b\u003e\u003c\/p\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003ePublishing reports and configuring project properties\u003c\/li\u003e\n\u003cli\u003eVerifying results with Report Manager\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eIdentifying delivery options\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eEnhancing performance with cached instances\u003c\/li\u003e\n\u003cli\u003eConfiguring snapshot history\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eDispatching subscription reports\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePublishing reports via e-mail and file share\u003c\/li\u003e\n\u003cli\u003eSeamlessly delivering reports by data-driven subscriptions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Safeguarding Reporting Services\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eStructuring content security\u003c\/b\u003e\u003c\/p\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eLeveraging existing Windows authentication\u003c\/li\u003e\n\u003cli\u003eEstablishing permission levels on report items\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eEnsuring the RS system\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eInstituting varying levels of administrative roles\u003c\/li\u003e\n\u003cli\u003eGranting and revoking system-level permissions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 7: Extended Reporting and Data Visualization\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eCreating reports on Analysis Services cubes\u003c\/b\u003e\u003c\/p\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eExploiting cubes as intuitive data sources for nontechnical and power users\u003c\/li\u003e\n\u003cli\u003eGenerating parameterized reports with \u003cabbr title=\"Multidimensional Expressions\"\u003eMDX\u003c\/abbr\u003e Builder Designing reports for data visualization\u003c\/li\u003e\n\u003cli\u003eImproving data visualization with sparklines, data bars, maps and indicators\u003c\/li\u003e\n\u003cli\u003eImplementing Key Performance Indicators (\u003cabbr title=\"Key Performance Indicators\"\u003eKPI\u003c\/abbr\u003es)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eDelivering reports to users\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eAccessing and controlling reports using \u003cabbr title=\"Uniform Resource Locator\"\u003eURL\u003c\/abbr\u003es\u003c\/li\u003e\n\u003cli\u003eEmbedding reports in applications with the Report Viewer\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"268B22US \/ 2026-08-18T09:00:00 \/ Herndon, VA","offer_id":47534197801179,"sku":"US-140-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"267D42US \/ 2026-07-07T09:00:00 \/ Herndon, VA","offer_id":48216573608155,"sku":"US-140-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26BC23US \/ 2026-11-17T09:00:00 \/ Herndon, VA","offer_id":48216573673691,"sku":"US-140-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"271C13US \/ 2027-01-12T09:00:00 \/ Herndon, VA","offer_id":48216573706459,"sku":"US-140-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"273B65US \/ 2027-03-16T09:00:00 \/ Herndon, VA","offer_id":48377298485467,"sku":"US-140-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"275C04US \/ 2027-05-18T09:00:00 \/ Herndon, VA","offer_id":48780665225435,"sku":"US-140-IL","price":2512.0,"currency_code":"USD","in_stock":true}]},{"product_id":"introduction-to-sql-course","title":"Introduction to SQL Course","description":"\u003cdiv\u003e\n\u003cp\u003eLearning Tree's Introduction to SQL Course is designed to provide an introduction to the SQL programming language, which is the standard language for relational database management systems. The course covers the basics of SQL, including creating tables, manipulating data, and querying databases. Students who complete the course will be equipped to write SQL queries, work with Microsoft SQL Server or \u003ca href=\"https:\/\/www.postgresql.org\/about\/\" title=\"What is PostgreSQL? | PostgreSQL\" rel=\"nofollow noopener\" target=\"_blank\"\u003ePostgreSQL\u003c\/a\u003e.\u003c\/p\u003e\r\n\u003cp\u003eThe course is suitable for beginners with no prior experience in SQL or database management, as well as professionals who want to refresh their skills. Overall, Learning Tree's Introduction to SQL Course is an excellent starting point for anyone looking to learn SQL and become proficient in database management and data engineering.\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eIntroduction to SQL Course Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eWrite SQL code based on Wrap in ANSI\/ISO standards to build database structures.\u003c\/li\u003e\n\u003cli\u003eUpdate database content with SQL and transaction handling.\u003c\/li\u003e\n\u003cli\u003eRetrieve data with filter conditions and from multiple tables using various types of joins.\u003c\/li\u003e\n\u003cli\u003eProcess data with row and aggregate functions.\u003c\/li\u003e\n\u003cli\u003eLeverage continued support with after-course one-on-one instructor coaching and computing sandbox.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eNone.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eIntroduction to SQL Instructor-Led Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: SQL Overview\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eOutlining SQL as the cornerstone of database activity\u003c\/li\u003e\n\u003cli\u003eApplying the ANSI\/ISO standards\u003c\/li\u003e\n\u003cli\u003eDescribing the fundamental building blocks: tables, columns, primary keys, and foreign keys\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Building the Database Schema\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eCreating tables and columns\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBuilding tables with CREATE TABLE\u003c\/li\u003e\n\u003cli\u003eModifying table structure with ALTER TABLE\u003c\/li\u003e\n\u003cli\u003eAdding columns to an existing table\u003c\/li\u003e\n\u003cli\u003eRemoving tables with DROP TABLE\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eProtecting data integrity with constraints\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eGuaranteeing uniqueness with primary key constraints\u003c\/li\u003e\n\u003cli\u003eEnforcing integrity with foreign key constraints\u003c\/li\u003e\n\u003cli\u003eImposing business rules with check constraints\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eImproving performance with indexes\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExpediting data retrieval with indexes\u003c\/li\u003e\n\u003cli\u003eRecommending guidelines for index creation\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Manipulating Data\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eModifying table contents\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eAdding table rows with INSERT\u003c\/li\u003e\n\u003cli\u003eChanging row content with UPDATE\u003c\/li\u003e\n\u003cli\u003eRemoving rows with DELETE\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eApplying transactions\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eControlling transactions with COMMIT and ROLLBACK\u003c\/li\u003e\n\u003cli\u003eDeploying BEGIN TRANSACTION in SQL Server\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Working with the SELECT Statement\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eWriting Single Table queries\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eRetrieving data with SELECT\u003c\/li\u003e\n\u003cli\u003eSpecifying column expressions\u003c\/li\u003e\n\u003cli\u003eSorting the result with ORDER BY\u003c\/li\u003e\n\u003cli\u003eHandling NULL values in expressions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eRestricting rows with the WHERE filter\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eTesting for equality or inequality\u003c\/li\u003e\n\u003cli\u003eApplying wildcard characters\u003c\/li\u003e\n\u003cli\u003eAvoiding NULL value pitfalls\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Querying Multiple Tables\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eApplying the ANSI\/ISO standard join syntax\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMatching related rows with INNER JOIN\u003c\/li\u003e\n\u003cli\u003eIncluding nonmatched rows with OUTER JOIN\u003c\/li\u003e\n\u003cli\u003eCreating a Cartesian product with CROSS JOIN\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eCombining results with set operators\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eStacking results with UNION\u003c\/li\u003e\n\u003cli\u003eIdentifying matching rows with INTERSECT\u003c\/li\u003e\n\u003cli\u003eUtilizing EXCEPT to find nonmatching rows\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Employing Functions in Data Retrieval\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eProcessing data with row functions\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eConditional formatting with the CASE expression\u003c\/li\u003e\n\u003cli\u003eUtilizing the CASE expression to simulate IF tests\u003c\/li\u003e\n\u003cli\u003eDealing with NULL values\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003ePerforming analysis with aggregate functions\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSummarizing data using SUM, AVG and COUNT\u003c\/li\u003e\n\u003cli\u003eFinding the highest\/lowest values with MAX and MIN\u003c\/li\u003e\n\u003cli\u003eDefining the summary level with GROUP BY\u003c\/li\u003e\n\u003cli\u003eApplying filter conditions with HAVING\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 7: Constructing Nested Queries\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eApplying subqueries in filter conditions\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCreating correlated vs. noncorrelated subqueries\u003c\/li\u003e\n\u003cli\u003eTesting the existence of rows\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eIncluding subqueries in expressions\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePlacing subqueries in the column list\u003c\/li\u003e\n\u003cli\u003eCreating complex expressions containing subqueries\u003c\/li\u003e\n\u003cli\u003eHandling subqueries that return no rows\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 8: Developing In-Line and Stored Views\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eBreaking down complex problems\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSelecting data from a query result set\u003c\/li\u003e\n\u003cli\u003eUsing subqueries in the FROM clause\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eCreating views in a database\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBuilding reusable code\u003c\/li\u003e\n\u003cli\u003eCreating updateable vs. non-updateable views\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"267C04US \/ 2026-07-29T09:00:00 \/ Austin","offer_id":47534176501979,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"268A16CN \/ 2026-08-12T09:00:00 \/ Ottawa","offer_id":47534177943771,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269B28US \/ 2026-09-02T09:00:00 \/ Herndon, VA","offer_id":47534177976539,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269A18CN \/ 2026-09-16T09:00:00 \/ Toronto","offer_id":47597097844955,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"266D28US \/ 2026-06-10T09:00:00 \/ Online","offer_id":48216541626587,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"268C76US \/ 2026-08-05T09:00:00 \/ New York","offer_id":48216541692123,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269C30US \/ 2026-09-09T09:00:00 \/ Washington, DC","offer_id":48216541724891,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26AA95US \/ 2026-10-14T09:00:00 \/ Aurora, CO","offer_id":48216541757659,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26AA96US \/ 2026-10-21T09:00:00 \/ Austin","offer_id":48216541790427,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26AA97US \/ 2026-10-28T09:00:00 \/ New York","offer_id":48216541823195,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26BA17CN \/ 2026-11-04T09:00:00 \/ Ottawa","offer_id":48216541855963,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26BA91US \/ 2026-11-18T09:00:00 \/ Bellevue, WA","offer_id":48216541888731,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26BA92US \/ 2026-11-23T09:00:00 \/ Herndon, VA","offer_id":48216541921499,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26CA13CN \/ 2026-12-09T09:00:00 \/ Toronto","offer_id":48216541954267,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26CA74US \/ 2026-12-02T09:00:00 \/ Washington, DC","offer_id":48216541987035,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"271A16CN \/ 2027-01-27T09:00:00 \/ Ottawa","offer_id":48216542019803,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"271A99US \/ 2027-01-13T09:00:00 \/ Austin","offer_id":48216542052571,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"271B00US \/ 2027-01-20T09:00:00 \/ New York","offer_id":48216542085339,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"272A59US \/ 2027-02-17T09:00:00 \/ Herndon, VA","offer_id":48270695497947,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"272A60US \/ 2027-02-24T09:00:00 \/ Washington, DC","offer_id":48294630654171,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"273A35CN \/ 2027-03-03T09:00:00 \/ Toronto","offer_id":48313105514715,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"274A71US \/ 2027-04-07T09:00:00 \/ Austin","offer_id":48570238566619,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"274A72US \/ 2027-04-14T09:00:00 \/ New York","offer_id":48591354134747,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"274A33CN \/ 2027-04-21T09:00:00 \/ Ottawa","offer_id":48619708317915,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"274A73US \/ 2027-04-28T09:00:00 \/ Aurora, CO","offer_id":48696377540827,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"275A82US \/ 2027-05-12T09:00:00 \/ Herndon, VA","offer_id":48762858340571,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"275A83US \/ 2027-05-19T09:00:00 \/ Washington, DC","offer_id":48783408660699,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"275A31CN \/ 2027-05-26T09:00:00 \/ Toronto","offer_id":48805415878875,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"276A82US \/ 2027-06-02T09:00:00 \/ San Francisco","offer_id":48825879199963,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269D25US \/ 2026-09-23T09:00:00 \/ Online","offer_id":48837148344539,"sku":"US-925-IL","price":2228.0,"currency_code":"USD","in_stock":true}]},{"product_id":"oracle®-pl-sql-training","title":"Oracle® PL\/SQL Training","description":"\u003cdiv\u003e\n\u003cp\u003eThis \u003cstrong\u003eOracle® PL\/SQL training\u003c\/strong\u003e course will teach you to increase the productivity, performance, scalability, portability, and security of your Oracle database. With this training, you will learn how to execute PL\/SQL programs in Oracle, build stored procedures, design, and execute modular applications, and increase the efficiency of data movement — essential skills for any Oracle developer.\u003c\/p\u003e\r\n\u003cp\u003e\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eOracle® PL\/SQL Training Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this Oracle PL\/SQL Programming training, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDevelop efficient PL\/SQL programs to access Oracle databases. \u003c\/li\u003e\n\u003cli\u003eCreate stored procedures and functions for reuse and maintenance. \u003c\/li\u003e\n\u003cli\u003eDesign modular applications using packages. \u003c\/li\u003e\n\u003cli\u003eManage data retrieval for front-end applications. \u003c\/li\u003e\n\u003cli\u003eInvoke native dynamic SQL to develop high-level abstract code. \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eOracle PL\/SQL Programming Training Course Prerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eStudents taking this course should have basic knowledge of SQL as taught in Learning Tree course 925, Introduction to SQL Course.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eOracle PL\/SQL Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Introduction and Overview\u003c\/h4\u003e\n\u003cp\u003ePL\/SQL fundamentals\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDeclaring and anchoring variables to database definitions\u003c\/li\u003e\n\u003cli\u003eFlow control constructs\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eOracle 11\u003ci\u003eg\u003c\/i\u003e and 12\u003ci\u003ec\u003c\/i\u003e PL\/SQL features\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePL\/Scope in Oracle 11\u003ci\u003eg\u003c\/i\u003e\n\u003c\/li\u003e\n\u003cli\u003eReturning implicit cursor results from stored procedures in Oracle 12\u003ci\u003ec\u003c\/i\u003e\n\u003c\/li\u003e\n\u003cli\u003eDeclaring local functions within SELECT statements in Oracle 12\u003ci\u003ec\u003c\/i\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Data Manipulation Techniques\u003c\/h4\u003e\n\u003cp\u003eMaintaining data with DML statements\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eEmploying the RETURNING INTO clause\u003c\/li\u003e\n\u003cli\u003eSolving the fetch-across-commit problem\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eManaging data retrieval with cursors\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eImplications of explicit and implicit cursors\u003c\/li\u003e\n\u003cli\u003eSimplifying cursor processing with cursor FOR LOOPs\u003c\/li\u003e\n\u003cli\u003eEmbedding cursor expressions in SELECT statements\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eCursor variables\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eStrong vs. weak cursor variables\u003c\/li\u003e\n\u003cli\u003ePassing cursor variables to other programs\u003c\/li\u003e\n\u003cli\u003eDefining REF CURSORS in packages\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Developing Well-Structured and Error-Free Code\u003c\/h4\u003e\n\u003cp\u003eError handling using EXCEPTIONs\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePropagation and scope\u003c\/li\u003e\n\u003cli\u003e\"Retrying\" problem transactions with EXCEPTION processing\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eDebugging PL\/SQL blocks\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSimplifying testing and debugging with conditional compilation\u003c\/li\u003e\n\u003cli\u003eInterpreting compiler messages\u003c\/li\u003e\n\u003cli\u003eApplying structured testing techniques\u003c\/li\u003e\n\u003cli\u003eBuilding and applying a test bed\u003c\/li\u003e\n\u003cli\u003eLeveraging the debugging facilities in SQL Developer\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Achieving Maximum Reusability\u003c\/h4\u003e\n\u003cp\u003eWriting stored procedures and functions\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCalling and invoking server-side logic\u003c\/li\u003e\n\u003cli\u003ePassing input and output parameters\u003c\/li\u003e\n\u003cli\u003eImplementing an autonomous transaction\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eCoding user-written functions\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCalling PL\/SQL functions from SQL\u003c\/li\u003e\n\u003cli\u003eBuilding table-valued functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eDeveloping safe triggers\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eEmploying :OLD and :NEW variables\u003c\/li\u003e\n\u003cli\u003eAvoiding unreliable trigger constructs\u003c\/li\u003e\n\u003cli\u003eExploiting schema and database triggers\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Exploiting Complex Datatypes\u003c\/h4\u003e\n\u003cp\u003eCollection types\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePL\/SQL tables, nested tables, VARRAYs\u003c\/li\u003e\n\u003cli\u003eStepping through dense and nonconsecutive collections\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eBulk binding for high performance\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMoving data into and out of PL\/SQL blocks\u003c\/li\u003e\n\u003cli\u003eBULK COLLECT INTO and FORALL\u003c\/li\u003e\n\u003cli\u003eBULK cursor attributes\u003c\/li\u003e\n\u003cli\u003eBULK EXCEPTION handling\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Invoking Native Dynamic SQL\u003c\/h4\u003e\n\u003cp\u003eFinessing the compiler\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eThe EXECUTE IMMEDIATE statement\u003c\/li\u003e\n\u003cli\u003eThe RETURNING INTO clause\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eTypes of dynamic SQL\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBuilding SQL statements during runtime\u003c\/li\u003e\n\u003cli\u003eAutogenerating standard code\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 7: Package Tips and Techniques\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003ePackage structure: SPEC and BODY\u003c\/li\u003e\n\u003cli\u003eEliminating dependency problems\u003c\/li\u003e\n\u003cli\u003eOverloading for polymorphic effects\u003c\/li\u003e\n\u003cli\u003eEvaluating application frameworks\u003c\/li\u003e\n\u003cli\u003eDeclaring and using persistent global variables\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"269B35US \/ 2026-09-14T09:00:00 \/ Herndon, VA","offer_id":47591598096603,"sku":"US-493-IL","price":2680.0,"currency_code":"USD","in_stock":true},{"title":"268C75US \/ 2026-08-10T09:00:00 \/ Herndon, VA","offer_id":48216578031835,"sku":"US-493-IL","price":2680.0,"currency_code":"USD","in_stock":true},{"title":"26BA82US \/ 2026-11-30T09:00:00 \/ Herndon, VA","offer_id":48216578064603,"sku":"US-493-IL","price":2680.0,"currency_code":"USD","in_stock":true},{"title":"272A55US \/ 2027-02-01T09:00:00 \/ Herndon, VA","offer_id":48216578097371,"sku":"US-493-IL","price":2680.0,"currency_code":"USD","in_stock":true},{"title":"274A64US \/ 2027-04-05T09:00:00 \/ Herndon, VA","offer_id":48556121293019,"sku":"US-493-IL","price":2680.0,"currency_code":"USD","in_stock":true}]},{"product_id":"writing-powerful-sql-queries-for-sql-server","title":"Writing Powerful SQL Queries for SQL Server","description":"\u003cdiv\u003e\u003cp\u003eGain the skills to maximize the potential of SQL, formulate powerful, complex queries, and avoid common errors and pitfalls. This SQL Queries training course provides an understanding of possibilities and potential risks that could affect your organization and is intended for users and developers who want to learn how to use the power of SQL queries for retrieving content from SQL Server databases.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eWriting Powerful SQL Queries for SQL Server Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this Writing Powerful SQL course, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSelect the most efficient solution to complex SQL problems.\u003c\/li\u003e\n\u003cli\u003eApply joins and subqueries.\u003c\/li\u003e\n\u003cli\u003eIdentify and avoid common error situations.\u003c\/li\u003e\n\u003cli\u003eEnsure that correct queries continue to work correctly in the future.\u003c\/li\u003e\n\u003cli\u003eProduce test data for thorough and complete testing.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eWriting Power SQL course attendees need to have familiarity with:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eRelational database theory and concepts.\u003c\/li\u003e\n\u003cli\u003eTables and columns.\u003c\/li\u003e\n\u003cli\u003ePrimary and foreign keys.\u003c\/li\u003e\n\u003cli\u003eThe basics of SELECT statements.\u003c\/li\u003e\n\u003cli\u003eUsing Management Studio to enter, edit, and execute SQL statements.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eAdvanced SQL Queries Instructor-Led Training Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eInstructor-Led Training Modules\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eDealing with NULL-value problems\u003c\/li\u003e\n\u003cli\u003eCombining tables with inner and outer joins\u003c\/li\u003e\n\u003cli\u003eHandling self-contained and correlated subqueries\u003c\/li\u003e\n\u003cli\u003eEnsuring complete and correct join conditions\u003c\/li\u003e\n\u003cli\u003eAvoiding ambiguous columns\u003c\/li\u003e\n\u003cli\u003eGuaranteeing single-row subqueries\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"269A19US \/ 2026-09-11T09:00:00 \/ Online","offer_id":47579377991899,"sku":"US-4559-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"267C90US \/ 2026-07-23T09:00:00 \/ Online","offer_id":48039761248475,"sku":"US-4559-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"26BA11US \/ 2026-11-09T09:00:00 \/ Online","offer_id":48050329452763,"sku":"US-4559-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"271A15US \/ 2027-01-22T09:00:00 \/ Online","offer_id":48172165562587,"sku":"US-4559-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"273A11US \/ 2027-03-18T09:00:00 \/ Online","offer_id":48381951901915,"sku":"US-4559-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"275A07US \/ 2027-05-12T09:00:00 \/ Online","offer_id":48762900250843,"sku":"US-4559-IL","price":716.0,"currency_code":"USD","in_stock":true}]},{"product_id":"sql-server-database-administration","title":"SQL Server Database Administration","description":"\u003cdiv\u003e\u003cp\u003eHelp protect your organization by using the knowledge gained in this course to correctly manage business databases. With this training, you learn the essential skills for administering SQL Server databases, and gain extensive experience using SQL Server tools to perform real-world administrative tasks with SQL Server Management Studio and Transact-SQL.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eSQL Server Database Administration Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\u003cp\u003eConfigure and manage SQL Server databases\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eEnsure SQL Server security with logins, roles, users, and permissions\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eDevelop backup strategies and recover from disasters\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eLeverage SQL Server Agent to automate administrative tasks\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eIsolate and repair fragmentation and database corruption\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eSQL Server Database Administration Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eImportant SQL Server Database Administration Course Information\t\u003c\/h4\u003e\n\u003cp\u003e\u003c\/p\u003e\n\u003cul class=\"accordion\"\u003e\n\u003cli\u003e\n\u003ch3\u003ePrerequisites\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003eRelational database experience\u003c\/li\u003e\n\u003cli\u003eWorking knowledge of computers and a familiarity with Microsoft Windows\u003c\/li\u003e\n\u003cli\u003eSQL programming experience is helpful, but not required\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003ch3\u003eAudience Profile\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cp\u003eThis course is helpful to those who are new to SQL Server administration and who will be responsible for administering SQL Server. A basic understanding of SQL Server or experience at the level of Microsoft SQL Server Training Course is required..\u003c\/p\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003ch3\u003eExam Information\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cp\u003eOptional Learning Tree exam is available at the end of class.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eSQL Server Database Administration Course Outline\u003c\/h4\u003e\n\u003cp\u003e\u003c\/p\u003e\n\u003cul class=\"accordion\"\u003e\n\u003cli\u003e\n\u003ch3\u003eGetting Started with SQL Server\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cp\u003eSetting up SQL Server\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSelecting installation options\u003c\/li\u003e\n\u003cli\u003eInstalling a named instance\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eLeveraging essential tools\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSQL Server Management Studio\u003c\/li\u003e\n\u003cli\u003eConfiguration Manager\u003c\/li\u003e\n\u003cli\u003eTransact-SQL\u003c\/li\u003e\n\u003cli\u003esqlcmd\u003c\/li\u003e\n\u003cli\u003ePowerShell\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003ch3\u003eConstructing and Managing Databases\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cp\u003eInspecting storage structures\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eRelating servers, databases and files\u003c\/li\u003e\n\u003cli\u003eCreating databases and transaction logs\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eDesigning file groups\u003c\/p\u003e\n\u003cp\u003eUpgrading and moving databases\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMaximizing storage utilization\u003c\/li\u003e\n\u003cli\u003ePlacing tables on file groups\n\u003cul\u003e\n\u003cli\u003eChoosing between upgrade and migration\u003c\/li\u003e\n\u003cli\u003eDetaching and attaching databases\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003ch3\u003eControlling database space\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cul\u003e\n\u003cli\u003ePermitting automatic database growth\u003c\/li\u003e\n\u003cli\u003eAdding database files to expand databases\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003ch3\u003eHandling Server and Database Security\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cp\u003eImplementing server security\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eComparing authentication modes\u003c\/li\u003e\n\u003cli\u003eDefining logins\u003c\/li\u003e\n\u003cli\u003eCreating user-defined server roles\u003c\/li\u003e\n\u003cli\u003eEnforcing password policy\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eGranting database access\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eContrasting users and logins\u003c\/li\u003e\n\u003cli\u003eAdding users\u003c\/li\u003e\n\u003cli\u003eDefining new roles\u003c\/li\u003e\n\u003cli\u003eDelegating privileges with predefined roles\u003c\/li\u003e\n\u003cli\u003eRepairing mis-mapped logins\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003ch3\u003eGranting and Revoking Permissions\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cp\u003eManaging database-scoped privileges\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePermitting object creation\u003c\/li\u003e\n\u003cli\u003eGiving blanket permissions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eDefining object-level permissions\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLimiting object access\u003c\/li\u003e\n\u003cli\u003eMeeting complex permission requirements with roles\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003ch3\u003eBackup and Recovery\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cp\u003eBacking up databases\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSelecting a recovery model\u003c\/li\u003e\n\u003cli\u003eInvestigating the transaction log\u003c\/li\u003e\n\u003cli\u003eRunning full, log and differential backups\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eRestoring databases\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePerforming a post-crash log backup\u003c\/li\u003e\n\u003cli\u003eRebuilding the master database\u003c\/li\u003e\n\u003cli\u003eRecovering user and system databases\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003ch3\u003eStreamlining Tasks with Jobs, Alerts and Database Mail\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cp\u003eConfiguring SQL Server Agent\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSetting agent properties\u003c\/li\u003e\n\u003cli\u003eImplementing database mail\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eDefining jobs to handle routine tasks\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCreating alerts and operators\u003c\/li\u003e\n\u003cli\u003eInitiating multi-step jobs\u003c\/li\u003e\n\u003cli\u003eAssociating alerts with jobs\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003ch3\u003eDatabase Maintenance and Monitoring\u003c\/h3\u003e\n\u003cdiv\u003e\n\u003cp\u003eHandling fragmentation and database corruption\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIdentifying and curing fragmentation\u003c\/li\u003e\n\u003cli\u003eRepairing database corruption\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eBuilding database maintenance plans\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eScheduling plan execution\u003c\/li\u003e\n\u003cli\u003eNotifying operators of success or failure\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eResolving contention problems\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIdentifying blocked processes\u003c\/li\u003e\n\u003cli\u003eKilling blockers\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"268D03US \/ 2026-08-04T09:00:00 \/ New York","offer_id":48216575639771,"sku":"US-2108-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"269A86CN \/ 2026-09-08T09:00:00 \/ Ottawa","offer_id":48216575672539,"sku":"US-2108-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26AC20US \/ 2026-10-13T09:00:00 \/ Herndon, VA","offer_id":48216575705307,"sku":"US-2108-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26BC29US \/ 2026-11-03T09:00:00 \/ Austin","offer_id":48216575869147,"sku":"US-2108-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26CB71US \/ 2026-12-08T09:00:00 \/ New York","offer_id":48216575901915,"sku":"US-2108-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"271A39CN \/ 2027-01-26T09:00:00 \/ Ottawa","offer_id":48216575934683,"sku":"US-2108-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"273C07US \/ 2027-03-09T09:00:00 \/ Herndon, VA","offer_id":48331763187931,"sku":"US-2108-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"274C17US \/ 2027-04-06T09:00:00 \/ Austin","offer_id":48567539728603,"sku":"US-2108-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"275C57US \/ 2027-05-11T09:00:00 \/ New York","offer_id":48759291642075,"sku":"US-2108-IL","price":2512.0,"currency_code":"USD","in_stock":true}]},{"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}]},{"product_id":"querying-data-with-microsoft-transact-sql-training-dp-080","title":"Query and modify data with Transact-SQL Training (DP-080)","description":"\u003cdiv\u003e\n\u003cp\u003eThis course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database, Azure Synapse Analytics, and Microsoft Fabric.\u003c\/p\u003e\r\n\u003cp\u003eThis course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eQuery and modify data with Transact-SQL Training (DP-080) Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUse SQL Server query tools.\u003c\/li\u003e\n\u003cli\u003eWrite SELECT statements to retrieve columns from one or more tables.\u003c\/li\u003e\n\u003cli\u003eSort and filter selected data.\u003c\/li\u003e\n\u003cli\u003eUse built-in functions to returned data values.\u003c\/li\u003e\n\u003cli\u003eCreate groups of data and aggregate the results.\u003c\/li\u003e\n\u003cli\u003eModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eNone.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eQuery and modify data with Transact-SQL Training (DP-080) Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Introduction to Transact-SQL\u003c\/h4\u003e\n\u003cp\u003eThis module provides an introduction to relational databases, the SQL language and Transact-SQL. You'll learn what kinds of statements make up the SQL language and look at the SELECT statement in detail. \u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eAfter completing this module, you'll be able to: \u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand what SQL is for \u003c\/li\u003e\n\u003cli\u003eIdentify database objects in schemas \u003c\/li\u003e\n\u003cli\u003eIdentify SQL statement types \u003c\/li\u003e\n\u003cli\u003eUse the SELECT statement \u003c\/li\u003e\n\u003cli\u003eWork with data types \u003c\/li\u003e\n\u003cli\u003eHandle NULLs \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Sort and filter results in T-SQL \u003c\/h4\u003e\n\u003cp\u003eLearn how to sort and filter query results \u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eAfter completing this module, you will be able to: \u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSort your results \u003c\/li\u003e\n\u003cli\u003eLimit the sorted results \u003c\/li\u003e\n\u003cli\u003eReturn paged results \u003c\/li\u003e\n\u003cli\u003eRemove duplicates \u003c\/li\u003e\n\u003cli\u003eFilter data with predicates \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Combine multiple tables with JOINs in T-SQL \u003c\/h4\u003e\n\u003cp\u003eExplore T-SQL queries accessing data from multiple tables with various kinds of JOIN operations. \u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eAfter completing this module, you will be able to: \u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDescribe join concepts and syntax \u003c\/li\u003e\n\u003cli\u003eWrite queries that use inner and outer joins \u003c\/li\u003e\n\u003cli\u003eWrite queries that use cross joins \u003c\/li\u003e\n\u003cli\u003eWrite queries that use self joins \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Write Subqueries in T-SQL \u003c\/h4\u003e\n\u003cp\u003eLearn how to use subqueries to combine multiple SELECT statements and compose nested queries. \u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eAfter completing this module, you will be able to: \u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand what subqueries are \u003c\/li\u003e\n\u003cli\u003eUse scalar or multi-valued subqueries \u003c\/li\u003e\n\u003cli\u003eUse self-contained or correlated subqueries \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Use built-in functions and GROUP BY in Transact-SQL \u003c\/h4\u003e\n\u003cp\u003eLearn how to use functions in Transact-SQL, and how to group aggregated results. \u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eAfter completing this module, you will be able to: \u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCategorize built-in functions \u003c\/li\u003e\n\u003cli\u003eUse scalar functions \u003c\/li\u003e\n\u003cli\u003eUse ranking and rowset functions \u003c\/li\u003e\n\u003cli\u003eUse aggregate functions \u003c\/li\u003e\n\u003cli\u003eSummarize data with GROUP BY \u003c\/li\u003e\n\u003cli\u003eFilter groups with HAVING \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Modify data with T-SQL \u003c\/h4\u003e\n\u003cp\u003eLearn how to use Transact-SQL to insert, update, and delete data in a database. \u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eAfter completing this module, you will be able to: \u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eInsert data into a table \u003c\/li\u003e\n\u003cli\u003eGenerate automatic values \u003c\/li\u003e\n\u003cli\u003eUpdate data in a table \u003c\/li\u003e\n\u003cli\u003eDelete data from a table \u003c\/li\u003e\n\u003cli\u003eMerge data based on multiple tables\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"267C44US \/ 2026-07-27T09:00:00 \/ Herndon, VA","offer_id":47534205993179,"sku":"US-8597-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"26AB35US \/ 2026-10-19T09:00:00 \/ Herndon, VA","offer_id":48216588615899,"sku":"US-8597-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"271B54US \/ 2027-01-25T09:00:00 \/ Herndon, VA","offer_id":48216588648667,"sku":"US-8597-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"274B18US \/ 2027-04-26T09:00:00 \/ Herndon, VA","offer_id":48669331718363,"sku":"US-8597-IL","price":1640.0,"currency_code":"USD","in_stock":true}]}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0691\/4143\/0491\/collections\/roezYb8lRS6W7qqGrtOd_44a18c50-815c-4692-a9e2-056c05b1c4ec.webp?v=1780655665","url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/collections\/sql.oembed","provider":"Learning Tree International","version":"1.0","type":"link"}