Table Design: Functions & Strings

SQL Server 2014
  • 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.

YOU MIGHT ALSO LIKE

Likes 226 Likes 226  
CHANNEL NoSQL
Likes 24 Likes 24  
Likes 70 Likes 70  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 141 Likes 141  
Likes 71 Likes 71  
Likes 64 Likes 64