-
Module 1: Using Common Data Types Effectively
21 Lessons-
StartExact Numeric Types
-
StartApproximate Numeric Types
-
StartCharacter Types
-
StartUnicode
-
StartCollations
-
StartSC Collations
-
StartUTF-8
-
StartEmbedding Unicode with Unistr
-
StartSplitting Strings
-
StartSplitting Strings
-
StartAggregating Strings
-
StartANSI String Concatenation
-
StartLTRIM, RTRIM, and TRIM Extensions
-
StartDate and Time Data Types
-
StartDate and Time String Formats
-
StartDate and Time Functions
-
StartGetting the CURRENT_DATE
-
StartDate Truncation and Date Bucket
-
StartQuiz 1
-
StartLab 1
-
StartLab 1 Solution
-
-
Module 2: Using Special Data Types
16 Lessons-
StartHierarchyID
-
StartRowversion
-
StartXML
-
StartUniqueIdentifier
-
StartGraph Data Types
-
StartOther Data Types
-
StartSparse Data and Column Sets
-
StartImplicit and Explicit Data Type Casts
-
StartConcat
-
StartConcat with Separator
-
StartGenerate Series
-
StartIs Distinct From
-
StartWorking with Bits
-
StartQuiz 2
-
StartLab 2
-
StartLab 2 Solution
-
-
Module 3: Working with SQL Server Spatial Data
19 Lessons-
StartTarget Applications
-
StartTypes of Spatial Data
-
StartFlat Earth vs Round Earth
-
StartOpen Geographic Consortium
-
StartSpatial Reference Systems
-
StartSQL Server Spatial Data Types
-
StartSystem CLR Types
-
StartData Formats
-
StartSources of Spatial Data
-
StartOGC Methods and Collections
-
StartMicrosoft Extension Methods and Formats
-
StartSpatial Indexes
-
StartSpatial Index Restrictions
-
StartCircular Arc Support
-
StartSpatial Aggregates
-
StartFull Globe Support
-
StartQuiz 3
-
StartLab 3
-
StartLab 3 Solution
-
-
Module 4: Using Joins and Set Operations
17 Lessons-
StartCross Join
-
StartUsing Cross Join to Simplify Queries
-
StartInner Join
-
StartOuter Joins
-
StartSelf Join
-
StartNon-Equi Join
-
StartMulti-Table Join
-
StartForcing Join Order
-
StartJoin Strategies
-
StartForcing Join Strategy
-
StartUnion
-
StartExcept
-
StartIntersect
-
StartAdaptive Joins
-
StartQuiz 4
-
StartLab 4
-
StartLab 4 Solution
-
-
Module 5: Using Subqueries and Common Table Expressions
16 Lessons-
StartScalar Subqueries
-
StartTable Subqueries
-
StartCorrelated Subqueries
-
StartExists
-
StartNull Logic
-
StartIssues with Not In
-
StartDerived Tables
-
StartRow Constructors
-
StartCommon Table Expressions
-
StartRecursive Common Table Expressions
-
StartOpenRowSet and OpenQuery
-
StartTableSample
-
StartRandom Ordering and Sampling
-
StartQuiz 5
-
StartLab 5
-
StartLab 5 Solution
-
-
Module 6: Modifying Data
15 Lessons -
Module 7: Ranking, Pivoting, and Grouping Data
23 Lessons-
StartRanking Functions
-
StartRow Number
-
StartRank
-
StartDense Rank
-
StartNtile
-
StartPartition By
-
StartCumulative Distribution
-
StartPercent Rank
-
StartPercentile
-
StartApproximate Percentile
-
StartOther Uses for Over
-
StartPivoting Data
-
StartPivot
-
StartUnpivot
-
StartRollup
-
StartCube
-
StartGrouping
-
StartGrouping ID
-
StartGrouping Sets
-
StartGreatest and Least
-
StartQuiz 7
-
StartLab 7
-
StartLab 7 Solution
-
-
Module 8: Using TOP, APPLY and Window Functions
14 Lessons -
Module 10: Working with JSON Data
17 Lessons-
StartWhy JSON Data in SQL Server?
-
StartStoring JSON Data in SQL Server
-
StartFOR JSON
-
StartINCLUDE_NULL_VALUES
-
StartRoot and Array Options
-
StartOPENJSON
-
StartOPENJSON
-
StartJSON_VALUE
-
StartJSON_QUERY
-
StartJSON_MODIFY
-
StartISJSON
-
StartJSON_PATH_EXISTS
-
StartJSON Constructors
-
StartJSON Aggregates
-
StartQuiz 10
-
StartLab 10
-
StartLab 10 Solution
-
-
Module 11: Using Full Text Indexing
16 Lessons-
StartWhat End Users Want
-
StartLimitations of Like
-
StartFull Text Terminology
-
StartWordbreakers
-
StartFull Text Index Implementation
-
StartFull Text Internal Architecture
-
StartStoplists
-
StartIndexing Performance
-
StartUpgrade Options
-
StartProperty Scoped Searching
-
StartCustomizable Proximity
-
StartStatistical Semantic Search
-
StartFileTable
-
StartQuiz 11
-
StartLab 11
-
StartLab 11 Solution
-
-
Module 13: Creating Code Objects
18 Lessons-
StartViews
-
StartStored Procedures
-
StartInput and Output Parameters
-
StartReturn Values
-
StartInline Scalar Functions
-
StartMulti-Statement Scalar Functions
-
StartTable-Valued Functions
-
StartT-SQL Function Performance
-
StartTypes of Triggers
-
StartDML Triggers
-
StartDDL Triggers
-
StartLogon Triggers
-
StartTable Types
-
StartTable-Valued Parameters
-
StartMetadata Discovery
-
StartQuiz 13
-
StartLab 13
-
StartLab 13 Solution
-
-
Module 14: Using Error and Exception Handling
15 Lessons-
StartHow T-SQL Code Executes
-
StartT-SQL and Errors
-
StartError Levels
-
StartAvailable Error Information
-
StartError Severities
-
Start@@Error
-
StartRaiserror
-
StartThrow
-
StartTry and Catch
-
StartError Handling Functions
-
StartTransactions
-
StartErrors and Transactions
-
StartNesting Transactions
-
StartErrors and Clients
-
StartQuiz 14
-
Advanced T-SQL for Developers and DBAs
Take your T-SQL skills to the next level
Course Summary
Have you been working with T-SQL for a while but not sure you're using it well?
Do you think there are probably simpler ways to write your T-SQL queries?
Do your queries look awkward and not have the elegance that other people's queries seem to have?
Do you know the basics but think it's time to extend your knowledge?
Do you want to learn from an expert
If any of these apply to you, this course is for you! And as well as detailed instruction, the course also offers optional practical exercises and quizzes to reinforce your learning.
Course Curriculum
Greg Low
