SQL Create Table | Quick Tips Ep62
We cover the questions you need to ask when creating a table in SQL. Where should you put the table? What should you name the table and columns? What data types should you use? How big will the table be? And, more questions like these will be answered in this video.
SQL Create Table | Quick Tips Episode #62
TABLE OF CONTENTS
0:00 - Intro
0:19 - Create Table Syntax
1:47 - Outline
3:11 - Where to put the table
4:48 - Naming the table
5:28 - Size of the Table
6:52 - Table Relationships
7:54 - Table Columns
11:29 - Data Types
12:47 - Varchar and NVarchar
14:37 - Number Data Types
20:26 - Date Types
21:56 - Adding Data Types to Columns
27:29 - Null and Not Null Columns
28:24 - Capitalizing Keywords and Best Practices
29:59 - Null and Not Null Columns Continued
31:48 - Primary Key Column
33:53 - Foreign Key Column
36:03 - Recap
36:56 - Table Permissions
38:18 - Run Create Table Statement
39:59 - Conclusion
YOUTUBE NEWS UPDATES
/ sqltrainingonline
VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS
http://www.sqltrainingonline.com
SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
http://www.youtube.com/subscription_c...
SUBSCRIBE TO OUR EMAIL LIST!
http://www.sqltrainingonline.com
LET'S CONNECT!
LinkedIn: / joeyblue
SQLTrainingOnline: http://www.sqltrainingonline.com
Watch video SQL Create Table | Quick Tips Ep62 online without registration, duration hours minute second in high quality. This video was added by user Joey Blue 16 March 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 15,704 once and liked it 257 people.