{"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}],"url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/products\/advanced-sql-course","provider":"Learning Tree International","version":"1.0","type":"link"}