SQL Server 2016 Part 5 - Basic Table Design, Data Types and Constraints

Published: 08 November 2016
on channel: WiseOwlTutorials

43,647

407

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould

https://www.wiseowl.co.uk - Designing basic tables in SQL Server involves deciding which columns the table should include, what the data type of those columns should be (not always an easy choice!) and a few additional properties such as whether the column can be left empty (or NULL) and whether there should be any constraints on the values entered into the column. This video takes you through that process to design and create a simple table to store information about people. The video contains a discussion of the main text, number and date data types in SQL Server - you'll learn the difference between char, varchar, nchar and nvarchar data types, as well as the difference between exact and approximate numerics. The video also covers the basics of inserting and editing data before the final part shows how to automatically generate scripts that will recreate the table and its precious data in the event that you delete it.

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio and more

On this page of the site you can watch the video online SQL Server 2016 Part 5 - Basic Table Design, Data Types and Constraints with a duration of hours minute second in good quality, which was uploaded by the user WiseOwlTutorials 08 November 2016, share the link with friends and acquaintances, this video has already been watched 43,647 times on youtube and it was liked by 407 viewers. Enjoy your viewing!

7,320

201