Tags
Language
Tags
March 2024
Su Mo Tu We Th Fr Sa
25 26 27 28 29 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6

SQL Essential Training

Posted By: U.N.Owen
SQL Essential Training

SQL Essential Training | 455MB
Duration: 3h 28m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 44.1KHz 1ch
Genre: eLearning | Level: Beginner | Language: English

Whatever a database is being used for—websites, bookkeeping, sales and inventory, or even the lowly to-do list—it's still all about the data. Completely updated for 2014, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL. Beginning with a quick start introduction for those who want to start working with data immediately, 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 working with 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 CRUD (Create, Read, Update, and Delete) application using SQL.

* Understanding SQL terminology and syntax
* Creating new tables and records
* Inserting and updating data
* Writing basic SQL queries
* Sorting and filtering
* Accessing related tables with JOIN
* Working with strings
* Finding the numeric type of a value
* Using aggregate functions and transactions
* Updating a table with triggers
* Creating views

SQL Essential Training

No mirrors below please.
Download @Uploaded.net: Folder

Mirror @Keep2Share: Folder

Password: www.AvaxHome.ru