SQL Essential Training

Listing closed

  • Item ID


  • Condition

    Brand New

  • Watch List

Item description

▬▬ 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

  • You might also like

    See all Items

    • loading...