课程

Functions for Manipulating Data in SQL Server

中级技能水平

更新时间 2026年3月

Learn the most important functions for manipulating, processing, and transforming data in SQL Server.

免费开始课程

SQLData Manipulation

4小时

14 视频

54 道练习

4,600 XP

24,282

成就证明

深受数千家公司学习者的喜爱

需要团队培训？

企业版试用

课程描述

In this course, you will learn how to make use of the most important functions for manipulating data provided by SQL Server. You can use these functions for processing and transforming data to get the results you want.

先决条件

Time Series Analysis in SQL Server

1

Choosing the appropriate data type

In this chapter, you will learn what are the most used data types in SQL Server. You will understand the differences between implicit and explicit conversion and how each type of conversion manifests. You will also get familiar with the functions used for explicitly converting data: CAST() and CONVERT().

Welcome to this course!

Working with different types of data

Storing dates in a database

Types of character strings

Implicit conversion

Implicit conversion between data types

Data type precedence

Explicit conversion

CASTing data

CONVERTing data

Working with the correct data types

2

Manipulating time

Date and time functions are an important topic for databases. In this chapter, you will get familiar with the most common functions for date and time manipulation. You will learn how to retrieve the current date, only parts from a date, to assemble a date from pieces and to check if an expression is a valid date or not.

Functions that return system date and time

Get the know the system date and time functions

Selecting parts of the system's date and time

Functions returning date and time parts

Extracting parts from a date

Generating descriptive date parts

Presenting parts of a date

Creating a date from parts

Performing arithmetic operations on dates

Arithmetic operations with dates

Modifying the value of a date

Calculating the difference between dates

Validating if an expression is a date

Changing the date format

Changing the default language

Correctly applying different date functions

3

Working With Strings

Strings are one of the most commonly used data types in databases. It's important to know what you can do with them. In this chapter, you will learn how to manipulate strings, to get the results you want.

Functions for positions

Calculating the length of a string

Looking for a string within a string

Looking for a pattern within a string

Functions for string transformation

Changing to lowercase and uppercase

Using the beginning or end of a string

Extracting a substring

Replacing parts of a string

Functions manipulating groups of strings

Concatenating data

Aggregating strings

Splitting a string into pieces

Applying various string functions on data

4

Recognizing Numeric Data Properties

In this chapter, you will work with functions applied to numeric data. You will use aggregate functions for calculating the minimum, maximum or the sum of values from a set. You will learn how to raise a number to a power or to calculate its square root.

Aggregate arithmetic functions

Learning how to count and add

MINimizing and MAXimizing some results

Analytic functions

Accessing values from the next row

Accessing values from the previous row

Getting the first and last value

Mathematical functions

Extracting the sign and the absolute value

Rounding numbers

Working with exponential functions

Manipulating numeric data

Wrapping things up

Functions for Manipulating Data in SQL Server

课程完成

获得成就证明

将此证书添加到您的 LinkedIn 档案、简历或履历中
在社交媒体和绩效评估中分享立即注册

加入超过19百万学习者，今天就开始Functions for Manipulating Data in SQL Server！

通过 DataCamp for Mobile 提升您的数据技能

随时随地通过我们的移动课程和每日 5 分钟编程挑战提升技能。