arrow_back
Back
lock
Getting Started
lock
1 SQL Query Types
lock
2 SELECT Statement Retrieve records from a table
lock
3 SELECT LIMIT Statement Retrieve records from a table and limit results
lock
4 SELECT TOP Statement Retrieve records from a table and limit results
lock
5 INSERT Statement Insert records into a table
lock
6 UPDATE Statement Update records in a table
lock
7 DELETE Statement Delete records from a table
lock
8 TRUNCATE TABLE Statement Delete all records from a table (no rollback)
lock
9 UNION Operator Combine 2 result sets (removes duplicates)
lock
10 UNION ALL Operator Combine 2 result sets (includes duplicates)
lock
11 INTERSECT Operator Intersection of 2 result sets
lock
12 MINUS Operator Result set of one minus the result set of another
lock
13 EXCEPT Operator Result set of one minus the result set of another
lock
14 SQL Comparison Operators
lock
15 Comparison Operators Operators such as greater than, less than and so on
lock
16 SQL Joins
lock
17 JOIN Tables Inner and Outer joins
lock
18 SQL Aliases
lock
19 ALIASES Create a temporary name for a column or table
lock
20 SQL Clauses
lock
21 DISTINCT Clause Retrieve unique records
lock
22 FROM Clause List tables and join information
lock
23 WHERE Clause Filter results
lock
24 ORDER BY Clause Sort query results
lock
25 GROUP BY Clause Group by one or more columns
lock
26 HAVING Clause Restrict the groups of returned rows
lock
27 SQL Functions
lock
28 COUNT Function Return the count of an expression
lock
29 SUM Function Return the sum of an expression
lock
30 MIN Function Return the min of an expression
lock
31 MAX Function Return the max of an expression
lock
32 AVG Function Return the average of an expression
lock
33 SQL Conditions
lock
34 AND Condition 2 or more conditions to be met
lock
35 OR Condition Any one of the conditions are met
lock
36 AND & OR Combining AND and OR conditions
lock
37 LIKE Condition Use wildcards in a WHERE clause
lock
38 IN Condition Alternative to multiple OR conditions
lock
39 NOT Condition Negate a condition
lock
40 IS NULL Condition Test for NULL value
lock
41 IS NOT NULL Condition Test for NOT NULL value
lock
42 BETWEEN Condition Retrieve within a range (inclusive)
lock
43 EXISTS Condition Condition is met if subquery returns at least one row
lock
44 SQL Tables and Views
lock
45 CREATE TABLE Create a table
lock
46 CREATE TABLE AS Create a table from another table's definition and data
lock
47 ALTER TABLE Add, modify or delete columns in a table; rename a table
lock
48 DROP TABLE Delete a table
lock
49 GLOBAL TEMP Tables Tables that are distinct within SQL session
lock
50 LOCAL TEMP Tables Tables that are distinct within modules and embedded SQL program
lock
51 SQL VIEW Virtual tables (views of other tables)
lock
52 SQL Keys, Constraints and Indexes
lock
53 Primary Keys Create or drop primary keys
lock
54 Indexes Create and drop indexes (performance tuning)
lock
55 SQL Data Types
lock
56 Data Types Data Types in SQL
lock
57 SQL Programming
lock
58 Comments How to create comments within your SQL statement
Preview - SQL Database Fundamentals for Data Science
Discuss (
0
)
navigate_before
Previous
Next
navigate_next