Learning SQL Programming
For this LinkedinLearning, we revisit the basics of SQL Programming. We learn what a database is and what SQL stands for. SQL is Structured Query Language and it helps us ask questions for the database to respond to. We learn about SELECT, FROM, WHERE. We learn about specifying our results with additional clauses such as GROUP BY, ORDER BY (descending or ascending), LIMIT. You can also join tables together using joins such as LEFT JOIN and inner joins. We also learn about the data types that are stored in a field. For example, you can have text, numeric and binary. You also learn how to modify the data which helps us with our course learning in Web Service Programming. This includes how to add information, delete information or to update/modify a record.