Table Design: Functions & Strings

SQL Server 2014    |    Beginner
  • 8 videos | 40m 1s
  • Earns a Badge
Rating 4.5 of 116 users Rating 4.5 of 116 users (116)
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

  • 3m 45s
    Upon completion of this video, you will be able to describe the SUBSTRING() function in SQL. FREE ACCESS
  • 3m 31s
    In this video, find out how to use the LENGTH function in SQL. FREE ACCESS
  • Locked
    3.  REVERSE() Function
    3m 11s
    Learn how to use the REVERSE function in SQL. FREE ACCESS
  • Locked
    4.  TRIM() Function
    3m 40s
    In this video, learn how to use the TRIM() function in SQL. FREE ACCESS
  • Locked
    5.  Date Functions
    7m 32s
    To find out how to use date functions in SQL, consult a database reference or tutorial. FREE ACCESS
  • Locked
    6.  SOUNDEX() and DIFFERENCE() Functions
    5m 11s
    In this video, you will use the SOUNDEX() and DIFFERENCE() functions in SQL. FREE ACCESS
  • Locked
    7.  Putting String Functions Together
    7m 45s
    In this video, you will learn how to use SQL string functions to create a query. FREE ACCESS
  • Locked
    8.  Exercise: Recognizing SQL Data Processes
    5m 28s
    In this video, learn how to use SQL functions to manage data. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Audiobook Learning SQL: Generate, Manipulate, and Retrieve Data, 3rd Edition
Course Using tables & SmartArt in PowerPoint 365
Rating 4.6 of 50 users Rating 4.6 of 50 users (50)
Book Querying MySQL: Make your MySQL Database Analytics Accessible with SQL Operations, Data extraction, and Custom Queries

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Table Design: Tables, Columns, & Numbers
Rating 4.6 of 186 users Rating 4.6 of 186 users (186)
Course Data Literacy for All Bootcamp: Session 1 Replay (October/November 2023)
Rating 5.0 of 3 users Rating 5.0 of 3 users (3)
Course Database Fundamentals: Getting Started with SQL
Rating 4.5 of 272 users Rating 4.5 of 272 users (272)