WGU c170 The Most Important SQL Commands(SQL study guide)

Document Content and Description Below

CREATE DATABASE: CREATE TABLE: This study source was downloaded by 100000831988016 from CourseHero.com on 05-12-2022 13:25:00 GMT -05:00 https://www.coursehero.com/file/35399377/SQL-Study-Guide-2doc... x/ ALTER TABLE: DROP TABLE DROP INDEX DROP DATABASE CREATE VIEW: This study source was downloaded by 100000831988016 from CourseHero.com on 05-12-2022 13:25:00 GMT -05:00 https://www.coursehero.com/file/35399377/SQL-Study-Guide-2docx/ ALTER TABLE & VIEW: DISTINCT: DROP VIEW: The IF EXISTS clause prevents an error from occurring for views that don't exist. When this clause is given, a NOTE is generated for each nonexistent view. CREATE INDEX: DROP INDEX: AND / OR OPERATOR GRANT PRIVILEGES: GRANT privilege_name ON object_name TO {user_name |PUBLIC |role_name} [WITH GRANT OPTION]; REVOKE PRIVILEGES: This study source was downloaded by 100000831988016 from CourseHero.com on 05-12-2022 13:25:00 GMT -05:00 https://www.coursehero.com/file/35399377/SQL-Study-Guide-2docx/ GROUP BY: ORDER BY: Select all customers from the "Customers" table, sorted DESCENDING by the "Country" column: HAVING: ORDER BY SEVERAL COLUMNS: This study source was downloaded by 100000831988016 from CourseHero.com on 05-12-2022 13:25:00 GMT -05:00 https://www.coursehero.com/file/35399377/SQL-Study-Guide-2docx/ INSERT INTO: EXAMPLE: DELETE FROM: DELETE ALL DATA: This means that the table structure, attributes, and indexes will be intact: DELETE FROM table_name; or This study source was downloaded by 100000831988016 from CourseHero.com on 05-12-2022 13:25:00 GMT -05:00 https://www.coursehero.com/file/35399377/SQL-Study-Guide-2docx/ DELETE * FROM table_name; UPDATE TABLE: Update Warning! Be careful when updating records. If we had omitted the WHERE clause, in the example above, like this: CONSTRAINTS: The constraints available in SQL are Foreign Key, Not Null, Unique, Check. Constraints can be defined in two ways 1) The constraints can be specified immediately after the column definition. This is called column-level definition. 2) The constraints can be specified after all the columns are defined. This is called table-level definition. This study source was downloaded by 100000831988016 from CourseHero.com on 05-12-2022 13:25:00 GMT -05:00 https://www.coursehero.com/file/35399377/SQL-Study-Guide-2docx/ GROUP FUNCTIONS: These functions are: COUNT, MAX, MIN, AVG, SUM, DISTINCT. COMPLEX JOINS-USING WHERE SUBQUERIES: This study source was downloaded by 100000831988016 from CourseHero.com on 05-12-2022 13:25:00 GMT -05:00 https://www.coursehero.com/file/35399377/SQL-Study-Guide-2docx/ Multiple-Table Retrievals with Joins MySQL provides 2 statements for creating new tables from other tables or from query results: CREATE TABLE ... LIKE Advantages  creates a new table as an empty copy of the original one.  copies the original table structure exactly,  each column is preserved with all of its attributes. Disadvantages  Statement is needed (such as INSERT INTO ... SELECT).  cannot create a new table from a subset of the original table's columns.  Cannot use columns from any other table but the original one. [Show More]

Last updated: 1 year ago

Preview 1 out of 9 pages