Hello and Welcome to This Course on Sequel Server Functions for Manipulating Data

My name is Anna Vega and I will guide you on your path to learning how to make use of the most important functions for data manipulation using the built-in capabilities of sequel server. Proves to be a lot more useful in terms of efficiency and performance than writing complex code from scratch. You can use these functions for processing and transforming data to get the results you want, depending on the type of data you want to manipulate. You can use a different set of functions we will discuss the most commonly used ones in this course first.

You will learn what are the most important data types you can use then you will take a more in-depth look but the functions for each category date and time character and functions working with numeric data so let's get started in a database system. Each column local variable expression and parameter has a data type sequel server provides a set of data types you can use to define exact numeric approximate numeric date and time characters unicode strings binary data and other types.

An Exact Numeric Data Type Stores the Literal Representation of Numbers Value

Exact numeric data type stores the literal representation of the numbers value. They are split in whole numbers, small int, tiny int, integer begins and decimals. These are some of the most commonly used types because they are efficient from a storage perspective. As a best practice you should use the smallest data type that can reliably contain all possible values of your data. Decimals are numeric types, the find by precision and scale precision is an integer representing the total number of digits a number can have, the scale represents the number of decimal digits that will be stored to the right of the decimal point.

You should keep in mind that your numeric data will occupy more or less storage on disk depending on the precision you set. The flow Tyrael are known as approximate data types they do not store the exact values specified for numbers instead they store an extremely close approximation of that value. You should use these types carefully and avoid using them in the where clause with an equality operator because you may not get the expected results for storing date and time information.

Date and Time Information

You can use several types to store date and time information. The difference between them is in regards to the range of possible values and accuracy. Date has the smallest accuracy while daytime to is the most exact. Character Types Store Strings They Vary in Length and Storage Characteristics

Character types store strings, they vary in length and storage characteristics, and are split in ASCII and Unicode types. The ASCII types are char, varchar, text, the unicode ones are nchar,nvarchar, text, ASCII and Unicode are standards for representing characters in a computer. ASCII types are used to store strings with English characters with unicode types you can store characters from all languages around the world like Japanese.

Sequel Server Has Other Data Types That Are Not Included in the Previous Categories

Sequel server has other data types that are not included in the previous categories, these are not so commonly used and are outside the scope of this course. If you wanted to take a more in-depth look at them, take a look at the MSDN documentation which provides extensive information about each of these types.

Testing Your Knowledge

Now that you've learned which are the most important data types in sequel server and what purpose each of them serves, let's test your knowledge by answering.

"WEBVTTKind: captionsLanguage: enhello and welcome to this course on sequel server functions for manipulating data my name is Anna Vega and I will guide you on your path to learning how to make use of the most important functions for data manipulation using the built-in capabilities of sequel server proves to be a lot more useful in terms of efficiency and performance than writing complex code from scratch you can use these functions for processing and transforming data to get the results you want depending on the type of data you want to manipulate you can use a different set of functions we will discuss the most commonly used ones in this course first you will learn what are the most important data types you can use then you will take a more in-depth look but the functions for each category date and time character and functions working with numeric data so let's get started in a database system each column local variable expression and parameter has a data type sequel server provides a set of data types you can use to define exact numerix approximate numerix date and time characters unicode strings binary data and other types an exact numeric data type stores the literal representation of the numbers value they are split in whole numbers small int tiny int integer begins and decimals numeric decimal money small money integers whole numbers that are whole or without a decimal point they are some of the most commonly used types because they are efficient from a storage perspective as a best practice you should use the smallest data type that can reliably contain all possible values of your data decimals are numeric types the find by precision and scale precision is an integer representing the total number of digits a number can have the scale represents the number of decimal digits that will be stored to the right of the decimal point you should keep in mind that your numeric data will occupy more or less storage on disk depending on the precision you set the flow Tyrael are known as approximate data types they do not store the exact values specified for numbers instead they store an extremely close approximation of that value you should use these types carefully and avoid using them in the where clause with an equality operator because you may not get the expected results for storing date and time information you can use several types the difference between them is in regards to the range of possible values and accuracy date has the smallest accuracy while day time to is the most exact character types store strings they vary in length and storage characteristics and are split in ASCII and Unicode types the ASCII types are char varchar text the unicode ones are n char and watch are and text ASCII and Unicode are standards for representing characters in a computer ASCII types are used to store strings with English characters with unicode types you can store characters from all languages around the world like Japanese sequel server has other data types that are not included in the previous categories these are not so commonly used and are outside the scope of this course if you wanted to take a more in-depth look at them take a look at the MSDN documentation which provides extensive information about each of these types now that you've learned which are the most important data types in sequel server and what purpose each of them serves let's test your knowledge by answeringhello and welcome to this course on sequel server functions for manipulating data my name is Anna Vega and I will guide you on your path to learning how to make use of the most important functions for data manipulation using the built-in capabilities of sequel server proves to be a lot more useful in terms of efficiency and performance than writing complex code from scratch you can use these functions for processing and transforming data to get the results you want depending on the type of data you want to manipulate you can use a different set of functions we will discuss the most commonly used ones in this course first you will learn what are the most important data types you can use then you will take a more in-depth look but the functions for each category date and time character and functions working with numeric data so let's get started in a database system each column local variable expression and parameter has a data type sequel server provides a set of data types you can use to define exact numerix approximate numerix date and time characters unicode strings binary data and other types an exact numeric data type stores the literal representation of the numbers value they are split in whole numbers small int tiny int integer begins and decimals numeric decimal money small money integers whole numbers that are whole or without a decimal point they are some of the most commonly used types because they are efficient from a storage perspective as a best practice you should use the smallest data type that can reliably contain all possible values of your data decimals are numeric types the find by precision and scale precision is an integer representing the total number of digits a number can have the scale represents the number of decimal digits that will be stored to the right of the decimal point you should keep in mind that your numeric data will occupy more or less storage on disk depending on the precision you set the flow Tyrael are known as approximate data types they do not store the exact values specified for numbers instead they store an extremely close approximation of that value you should use these types carefully and avoid using them in the where clause with an equality operator because you may not get the expected results for storing date and time information you can use several types the difference between them is in regards to the range of possible values and accuracy date has the smallest accuracy while day time to is the most exact character types store strings they vary in length and storage characteristics and are split in ASCII and Unicode types the ASCII types are char varchar text the unicode ones are n char and watch are and text ASCII and Unicode are standards for representing characters in a computer ASCII types are used to store strings with English characters with unicode types you can store characters from all languages around the world like Japanese sequel server has other data types that are not included in the previous categories these are not so commonly used and are outside the scope of this course if you wanted to take a more in-depth look at them take a look at the MSDN documentation which provides extensive information about each of these types now that you've learned which are the most important data types in sequel server and what purpose each of them serves let's test your knowledge by answering\n"