Share Description
In this course, you will learn:
- Learn the major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and using subselects and views.
Syllabus:
- Introduction
- Understanding SQL
- How to use the exercise files
- Course overview
1. Installation
- Installing on Windows
- Installing on a Mac
2. SQL Overview
- About SQL
- Database organization
- The SELECT statement
- Selecting rows
- Selecting columns
- Counting rows
- Inserting data
- Updating data
- Deleting data
3. Fundamental Concepts
- Creating a table
- Deleting a table
- Inserting rows
- Deleting rows
- The NULL value
- Constraining columns
- Changing a schema
- ID columns
- Filtering data
- Removing duplicates
- Ordering output
- Conditional expressions
4. Relationships
- Understanding JOIN
- Accessing related tables
- Relating multiple tables
5. Strings
- About SQL strings
- Finding the length of a string
- Selecting part of a string
- Removing spaces
- Folding case
6. Numbers
- Numeric types
- What type is that value?
- Integer division
- Rounding numbers
7. Dates and Times
- Dates and times
- Date- and time-related functions
8. Aggregates
- What are aggregates?
- Using aggregate functions
- Aggregating DISTINCT values
9. Transactions
- What are transactions?
- Data integrity
- Performance
10. Triggers
- Automating data with triggers
- Preventing updates
- Example: Timestamps
11. Views and Subselects
- Creating a subselect
- Searching within a result set
- Creating a view
- Creating a joined view
12. A Simple CRUD Application
- Embedding SQL
- The SELECT functions
- The INSERT, UPDATE, and DELETE functions
