SQL Create Table | Quick Tips Ep62
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
بـار بازدید شده