->

SQL Essential Training
SQL Essential Training
Whatever database application you create—whether it's for bookkeeping, sales, inventory, or even the lowly to-do list—it's all about the data. Completely updated for 2018, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL. 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 and complete database application using SQL.


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


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Coktum   |  

Information
Members of Guests cannot leave comments.




rss