Table Design: Functions & Strings

SQL Server 2014    |    Beginner
  • 8 Videos | 41m 31s
  • Earns a Badge
Likes 69 Likes 69
Master the core functions of SQL strings. Strings are a key component to any database, and you can work magic using fundamental SQL commands. Explore string functions like LENGTH, REVERSE, and TRIM, as well as how to put them together.

WHAT YOU WILL LEARN

  • describe the SUBSTRING() functioning in SQL
    using the LENGTH function in SQL
    use the REVERSE() function in SQL
    use the TRIM() function in SQL
  • use date functions in SQL
    Use SOUNDEX() and DIFFERENCE() functions in SQL
    use SQL string functions to create a query
    manage data using SQL functions

IN THIS COURSE

  • Playable
    1. 
    Introduction to SUBSTRING() Function
    3m 45s
    UP NEXT
  • Playable
    2. 
    LENGTH() Function
    3m 31s
  • Locked
    3. 
    REVERSE() Function
    3m 11s
  • Locked
    4. 
    TRIM() Function
    3m 40s
  • Locked
    5. 
    Date Functions
    7m 32s
  • Locked
    6. 
    SOUNDEX() and DIFFERENCE() Functions
    5m 11s
  • Locked
    7. 
    Putting String Functions Together
    7m 45s
  • Locked
    8. 
    Exercise: Recognizing SQL Data Processes
    5m 28s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 141 Likes 141  
Likes 109 Likes 109  
Likes 103 Likes 103