We continue covering built-in functions that affect strings or numeric values including FORMAT() as well as clauses like GROUP BY and ORDER BY.
Download the class notes for day 3.
Just another CUNY Academic Commons site
We continue covering built-in functions that affect strings or numeric values including FORMAT() as well as clauses like GROUP BY and ORDER BY.
Download the class notes for day 3.
The original article is available at https://opensource.com/article/18/5/books-kids-linux-open-source, but the list without commercial links is below.
Always support open source.
It is only day 2, but we have already covered how to retrieve fields from multiple tables
SELECT field1, field2 ... FROM table1 INNER|LEFT|RIGHT JOIN table2 ON table1.shared_field1 = table2.shared_field1 AND table1.shared_field2 = table2.shared_field2 ... INNER|LEFT|RIGHT JOIN table3 ON table1.shared_field1 = table3.shared_field1 AND table1.shared_field2 = table3.shared_field2 ...
and built-in functions both for strings and numeric values (aggregate).
Download the class notes for day 2.
Let me welcome to the world of SQL. There is no time to waste. It is time to get your hands wet.
Download the class notes for day 1.
Download the class notes for day 10 (the final). Thank you for taking this course.
We have covered how to CREATE, DROP and ALTER data objects — especially tables adding constraints like PK, FK and CPK.
Download the notes for day 9.
Get ready for the final!
We are finally in the fun section of the course — stored procedures (UDP) and user-defined functions (UDF). We can finally write code once and recycle it.
Download the notes for day 8.
We have only three (3) more days. We have covered how to CREATE, DROP and ALTER data objects (databases, schemas, tables and views) with the correct data types.
Download the notes for day 7.
We have finished section one (retrieving data) and have started section two (creating, destroying and modifying data objects).
CREATE object_type object_name AS ( some_structure );
DROP object_type object_name;
ALTER object_type object_name ADD|DROP|ALTER object_type data_type;
Download the notes for day 6.
We are half-way done with the course. We have covered how to retrieve data from table(s) and how to present that data in comprehensible manner.
SELECT [DISTINCT] table1.field1, table1.field2, ... table2.field1, table2.field2, .. FROM table1 INNER|LEFT JOIN table2 ON table1.sharedfile1 = table2.sharedfile1 AND|OR table1.sharedfile2 = table2.sharedfile3 ... INNER|LEFT JOIN table3 ON table1.sharedfile1 = table3.sharedfile1 AND|OR table1.sharedfile2 = table3.sharedfile3 ... WHERE condition1 AND|OR condition2 ... GROUP BY fields_not_in_aggregate_function ORDER BY field1, field2 ...;
Download the notes for day 5.