× SQL Essential Training Close
SQL Essential Training
MP4 | Video: 720p | Duration: 3:17:06 | English | Subtitles: VTT | 412.9 MB


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




Download File Size:392.77 MB

---