Shoping cart:
Empty
Cheap Software
Search by Letter:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z All programs New Mac

Addison-Wesley Professional Learning SQL LiveLessons Video Training

20$
Buy!Download Size: 1.79 GB


2015
Addison-Wesley Professional
Ben Forta
1:27
English

In Learning SQL LiveLessons bestselling author Ben Forta teaches you the basic skills you need to succeed with SQL.
Drawing on his experience helping thousands of developers and other IT pros at all levels, Forta guides you, one-on-one, from the absolute basics all the way to queries, joins, and beyond.
One step at a time, you'll learn how to retrieve data with SELECT; sort, filter, group, and summarize data; create calculated fields; manipulate data with string and date functions; build queries and subqueries; create basic and advanced table joins; combine queries with UNION; sort your queries; insert, update, and delete data; and even discover what you can do with triggers and stored procedures.
Based on Forta's bestselling book, Sams Teach Yourself SQL in 10 Minutes, everything's organized into bite-sized, self-contained lessons, so you can learn key SQL skills quickly and easily.

Lesson 1: Introducing SQL
Review database basics such as tables, rows, columns, and keys; understand what relational databases are; choose a DBMS; and learn what SQL is and what it does.
Lesson 2: Retrieving Data
Work with SELECT, the most used SQL statement. Retrieve individual, multiple, or all columns; retrieve specific rows; and limit the data you retrieve. Master and refine some important SQL skills and best practices.
Lesson 3: Sorting Retrieved Data
Use SELECT ORDER BY, sort by one or multiple columns, and specify the direction of your sort.
Lesson 4: Filtering Data
Use SELECT WHERE and its clause operators, use BETWEEN to filter for a range of values, and use NULL to filter for no value.
Lesson 5: Advanced Data Filtering
Combine WHERE filters using AND and OR; correctly manage “order of evaluation”; use IN to filter by a defined set of matches; and negate clauses with NOT.
Lesson 6: Using Wildcard Filtering
Create wildcard filters with the LIKE keyword, and learn three wildcards you can use to search for any character combinations.
Lesson 7: Creating Calculated Fields
Use concatenation and aliases, and perform on-the-fly mathematical calculations using calculate fields and mathematical operators.
Lesson 8: Using Data Manipulation Functions
Manipulate data with string and date functions.


Addison-Wesley Professional Learning SQL LiveLessons Video Training

20$
Buy!Download Size: 1.79 GB


Customers who bought this program also bought:


WireShark Network Forensics And Security (1 cd) $25 BUY!
Subrosasoft PodSalvage 6.1.5 for Mac $10 BUY!
Subrosasoft MacForensicsLab 2.5.5 for Mac $30 BUY!
Subrosasoft FileSalvage 6.1.5 for Mac $15 BUY!
Subrosasoft FileDefense 1.5 for Mac $5 BUY!
Lynda.com SQL Essential Training $15 BUY!
SQL for MySQL Developers A Comprehensive Tutorial and Reference PDF eBook $10 BUY!
EnCase Computer Forensics The Official EnCE EnCase Certified Examiner Study Guide by Steve Bunting PDF eBook $10 BUY!
Guidance Software EnCase Forensic 7.09.00.111 x64 $20 BUY!


Software Store Deal of the Day

2010 SUPER PACK 4

2010 SUPER PACK 4

Unclude: Adobe Acrobat 9.0 Pro Extended (1 dvd), Adobe Photoshop CS5 Extended 12.0 (1 dvd), Autodesk Autocad LT 2011 (1 dvd), Corel WinDVD Pro 2010 10.0.5.291 Multilingual, CorelDRAW Graphics Suite X5 15.0.0.486, DVD Cloner VII 7.10.992, TechSmith Camtasia Studio 7.0.0

Real PriceSaving Deal of the Day View it »
$2960 94.6%229$BUY!
We recommend
Categories
© 2010-2017. All rights reserved.