Understanding SQL Data Types using Scenarios
Learn with valuetechacademy
9 modules
T-SQL
Lifetime access
Understand the different data types available in Microsoft SQL and the key differences between them
Overview
Understand the different data types available in Microsoft SQL and the key differences between them. SQL Queries in this course can be practiced using both SQL Server Management Studio(SSMS) or Azure Data Studio.
- Understand the different data types available in Microsoft SQL and the key differences between them.
- Learn SQL data types using real-world Scenarios. Get the confidence to choose the right data type
- Practical Hands-on explaining each SQL data type in detail.
- The ultimate practical course that helps you master Microsoft SQL Data Types.
- At the end of the course you will learn how to choose the right Data Type for different scenarios.
Key Highlights
Learn SQL data types using real-world Scenarios
Practical Hands-on explaining each SQL data type in detail
The ultimate practical course that helps you master Microsoft SQL Data Types
At the end of the course you will learn how to choose the right Data Type for different scenarios
What you will learn
Exact Numeric data types
Exact Numeric data types - Tinyint, Smallint, int, Bigint, Bit, Decimal,Numeric, Smallmoney, Money.
Approximate Numeric data types
Approximate Numeric data types - Float & Real
Date and Time data types
Date and Time data types - Date, Time, Datetime, Datetime2, Smalldatetime, Datetimeoffset
Character String data types
Character String data types - Char, Varchar, Varchar(max), Text
Unicode Character string data types
Unicode Character string data types - Nchar, Nvarchar, Nvarchar(max), Ntext
Binary String data types
Binary String data types - Binary, Varbinary, Varbinary(max), Image
Modules
1.Introduction to Course
1 attachment • 49 sec
About this course
3.Exact Numeric data types
10 attachments • 37.27 mins
2.Tinyint
3.Smallint
4.Int
5.Bigint
6.Bit
7.Decimal
8.Numeric
9.Smallmoney
10.Money
Exact Numeric - SQL scripts
4.Approximate Numeric data types
2 attachments • 7.06 mins
11.Float & Real
11.float_and_real- SQL script
5.Date and Time data types
7 attachments • 21.03 mins
12.Date
13.Time
14.Datetime
15.Datetime2
16.Smalldatetime
17.Datetimeoffset
Date and Time - SQL Scripts
6.Character String data types
5 attachments • 20.17 mins
18.Char
19.Varchar
20.Varchar(max)
21.Text
Character String - SQL Scripts
7.Unicode Character string data types
5 attachments • 13.19 mins
8.Binary String data types
5 attachments • 16.32 mins
26.Binary
27. Varbinary
28.Varbinary(max)
29.Image
Binary String - SQL Scripts
9.Course Completion
1 attachment
Thank You!
FAQs
How can I enrol in a course?
Enrolling in a course is simple! Just browse through our website, select the course you're interested in, and click on the "Enrol Now" button. Follow the prompts to complete the enrolment process, and you'll gain immediate access to the course materials.
Can I access the course materials on any device?
Yes, our platform is designed to be accessible on various devices, including computers, laptops, tablets, and smartphones. You can access the course materials anytime, anywhere, as long as you have an internet connection.
How can I access the course materials?
Once you enrol in a course, you will gain access to a dedicated online learning platform. All course materials, including video lessons, lecture notes, and supplementary resources, can be accessed conveniently through the platform at any time.
Can I interact with the instructor during the course?
Absolutely! we are committed to providing an engaging and interactive learning experience. You will have opportunities to interact with them through our community. Take full advantage to enhance your understanding and gain insights directly from the expert.
About the creator
Learn with valuetechacademy
Rate this Course
$ 19.00
$49
Order ID:
This course is in your library
What are you waiting for? It’s time to start learning!
Wait up!
We see you’re already enrolled in this course till Lifetime. Do you still wish to enroll again?
