Posted on 2019-12-03, by everest555.
MP4 | Video: AVC, 1280x720 30 fps | Audio: AAC, 48 KHz, 2 Ch | Duration: 3h
Skill Level: Intermediate | Genre: eLearning | Language: English + Subtitles | Size: 449 MB
Knowing how to code and manage relational databases and database-driven applications is a valuable skill for any career in tech. 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.
This course was created by Bill Weinman. We are pleased to offer this training in our library.
How databases are organized
Selecting rows and columns
Creating new tables
Inserting and updating data
Sorting and filtering
Accessing related tables with JOIN
Working with strings
Understanding numeric types
Using aggregate functions and transactions
Automating data with triggers
Using CRUD functions
- Ebooks list page : 41988
- 2019-11-23Logic Pro X Essential Training [released 8 2019]
- 2019-11-23Firewall Administration Essential Training [released 8 14 2019]
- 2019-11-23Asp Net Mvc 5 Essential Training [released 8122019]
- 2019-11-19Google Docs Essential Training (Released 11/2019)
- 2019-11-08Google Docs Essential Training (Released 112019)
- 2019-11-02iCloud Essential Training (Released 10/22/2019)
- 2019-10-22iCloud Essential Training (Released 10222019)
- 2019-10-20Visual Basic Essential Training (Released 10182019)
- 2019-08-24ASP.NET MVC 5 Essential Training [Released 8.2019]
- 2019-08-23Logic Pro X Essential Training [Released 8.2019]
- 2019-08-23Logic Pro X Essential Training [Released 892019]
- 2019-08-23ASP.NET MVC 5 Essential Training [Released 8122019] - Removed
- 2019-08-18ASP.NET MVC 5 Essential Training [Released 8.2019] - Removed
- 2019-08-15Firewall Administration Essential Training [Released 8142019]
- 2019-08-13Logic Pro X Essential Training [Released 8/9/2019][
- 2019-08-13ASP.NET MVC 5 Essential Training (Released 82019)
- 2019-08-12Logic Pro X Essential Training [Released 8.2019]
- 2019-06-13Navisworks Essential Training [Released 6122019]
- 2019-05-05Prezi Next Essential Training (Released 42019)
- 2019-04-02Gmail Essential Training (Released 12172018)
- Download links and password may be in the description section, read description carefully!
- Do a search to find mirrors if no download links or dead links.