Table Design: Functions & Strings
SQL Server 2014
| Beginner
- 8 videos | 40m 1s
- Earns a Badge
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 45sUpon completion of this video, you will be able to describe the SUBSTRING() function in SQL. FREE ACCESS
-
3m 31sIn this video, find out how to use the LENGTH function in SQL. FREE ACCESS
-
3. REVERSE() Function3m 11sLearn how to use the REVERSE function in SQL. FREE ACCESS
-
4. TRIM() Function3m 40sIn this video, learn how to use the TRIM() function in SQL. FREE ACCESS
-
5. Date Functions7m 32sTo find out how to use date functions in SQL, consult a database reference or tutorial. FREE ACCESS
-
6. SOUNDEX() and DIFFERENCE() Functions5m 11sIn this video, you will use the SOUNDEX() and DIFFERENCE() functions in SQL. FREE ACCESS
-
7. Putting String Functions Together7m 45sIn this video, you will learn how to use SQL string functions to create a query. FREE ACCESS
-
8. Exercise: Recognizing SQL Data Processes5m 28sIn 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.
