SQL Create Table | Quick Tips Ep62

Joey Blue
Joey Blue
14.5 هزار بار بازدید - 4 سال پیش - We cover the questions you
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 youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS www.sqltrainingonline.com/ SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! youtube.com/subscription_center?add_user=sqltraini… SUBSCRIBE TO OUR EMAIL LIST! www.sqltrainingonline.com/ LET'S CONNECT! LinkedIn: linkedin.com/in/joeyblue SQLTrainingOnline: www.sqltrainingonline.com/
4 سال پیش در تاریخ 1399/12/26 منتشر شده است.
14,563 بـار بازدید شده
... بیشتر