Share Description
In this course, you will :
- Learn how to ask a server for data, limit and sort the responses, aggregate data from multiple tables using joins, and edit and delete data.
- It also demonstrates how to perform basic math operations and convert data between formats.
Syllabus :
1. Ask for Data from a Database
- Ask for data with SELECT
- Narrow down a query with WHERE
- Add more criteria to a statement
- Limit responses
- Organize responses with ORDER BY
- Find information about the data
2. Ask for Data from Two or More Tables
- Ask for data across two or more tables
- Understand JOIN types
- Combine results
3. Data Types, Math, and Helpful Functions
- Data types in SQL
- Math in SQL
- Compound Select
- Transform data
- Use aliases to shorten field names
4. Add or Modify Data
- Add data to a table
- Modify data in a table
- Remove data from a table
