Completely updated for 2019, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL. All the lessons have been recorded in SQLiteStudio, an intuitive and easy-to-install database manager. Instructor Bill Weinman teaches all the major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and using subselects and views. He offers a solid working knowledge of the language and shows how to retrieve and manage data efficiently. The final chapter includes a real-world example of building a simple application using SQL.

The Program

1. Introduction.
2. Installation.
3. SQL Overview.
4. Fundamental Concepts.
5. Relationships.
6. Strings.
7. Numbers.
8. Dates and Times.
9. Aggregates.
10. Transactions.
11. Triggers.
12. Views and Subselects.
13. A Simple CRUD Application.
14. Conclusion.