Important SQL terms and its meaning - Part 1

• 举报此文章

Rahul K.B

Rahul K.B

Data Scientist | MSc Data Science, Statistics, Data Analysis

发布日期: 2023年7月30日

+ 关注

1. ALTER with CHANGE - They let you change both the name and data type of an existing column.
2. ALTER with MODIFY - Lets you change just the data type of an existing column.
3. ALTER with ADD - Lets you add a column to your table in the order you choose.
4. ALTER with DROP - Lets you drop a column from your table.
5. ALTER TABLE - Lets you change the name of your table and its entire structure while retaining the data inside of it.
6. AND and OR - With AND and OR, you can combine your conditional statements in your WHERE clauses for more precision.
7. ATOMIC DATA - Data in your columns is atomic if it's been broken down into the smallest pieces that you need.
8. ATOMIC DATA RULE 1 - Atomic data can't have several bits of the same type of data in the same column.
9. ATOMIC DATA RULE 2 - Atomic data can't have multiple columns with the same type of data.
10. AUTO_INCREMENT - When used in your column declaration, that column will automatically be given a unique integer value each time a insert command is performed.
11. AVG - Returns the average value in a numeric column.

要查看或添加评论，请登录

Rahul K.B的更多文章

• Git Commands

  2023年8月26日

  Git Commands

  Clone - Bring a repository that is hosted somewhere like GitHub into folder on your local machine. add - Track your…

  1
• Important SQL terms and its meaning - Final Part

  2023年8月7日

  Important SQL terms and its meaning - Final Part

  Third Normal Form (3NF) - Your table must be in 2NF and have no transitive dependencies. Transitive functional…

• Important SQL terms and its meaning - Part 6

  2023年8月6日

  Important SQL terms and its meaning - Part 6

  Schema - A description of the data in your database along with any other related objects and the way they all connect…

  2
• Important SQL terms and its meaning - Part 5

  2023年8月5日

  Important SQL terms and its meaning - Part 5

  Noncorrelated Subquery - A subquery which stands alone and doesn't reference anything from the outer query…

  2
• Important SQL terms and its meaning - Part 4

  2023年8月3日

  Important SQL terms and its meaning - Part 4

  INNER JOIN - Any join that combines the records from two tables using some condition. Inner query - A query inside…

• Important SQL terms and its meaning - Part 3

  2023年8月2日

  Important SQL terms and its meaning - Part 3

  DELETE - This is your tool for deleting rows of data from your table. Use it with a WHERE clause to precisely pinpoint…

  2
• Important SQL terms and its meaning - Part 2

  2023年8月1日

  Important SQL terms and its meaning - Part 2

  BETWEEN - Lets you select ranges of values. CHECK CONSTRAINTS - Use these to only allow specific values to be inserted…

  1

Show more

See all articles