Wrapping things up

Functions for Manipulating Data in SQL Server

Ana Voicu

Data Engineer

Chapter 1: Choosing the appropriate data type

Data types

  • Numeric
  • Date and time
  • Character strings

Data conversion

  • Implicit
  • Explicit
Functions for Manipulating Data in SQL Server

Chapter 2: Manipulating time in SQL Server

  • Functions returning system date and time
    • GETDATE()
  • Functions returning date parts
    • YEAR(), MONTH(), DAY()
  • Arithmetic operations on dates
    • DATEADD(), DATEDIFF()
  • Validating if an expression is a date
    • ISDATE()
Functions for Manipulating Data in SQL Server

Chapter 3: Working with strings

  • Functions for positions
    • CHARINDEX(), PATINDEX()
  • Functions for string transformation
    • UPPER(), LOWER(), LEFT(), RIGHT()
  • Functions for manipulating groups of strings
    • STRING_AGG(), STRING_SPLIT()
Functions for Manipulating Data in SQL Server

Chapter 4: Recognizing numeric data properties

  • Aggregate arithmetic functions
    • SUM(), MIN(), MAX(), AVG()
  • Analytical functions
    • FIRST_VALUE(), LAST_VALUE(), LAG(), LEAD()
  • Mathematical functions
    • ABS(), POWER()
Functions for Manipulating Data in SQL Server

Congratulations!

Functions for Manipulating Data in SQL Server

Preparing Video For Download...