SQL Essential Training

▬▬ SQL Essential Training ▬▬


Size: 412.9MB
Language: English

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.

■ Topics include
• Understanding SQL terminology and syntax
• Creating new tables
• Inserting and updating data
• Writing basic SQL queries
• Sorting and filtering
• Accessing related tables with JOIN
• Working with strings
• Understanding numeric types
• Using aggregate functions and transactions
• Automating data with triggers
• Creating views
• Defining functions in PHP