xREL.v3

KYRIE
ELEISON

RELEASE INFORMATION

TITLE: DATABASE FUNDAMENTALS: CREATING AND
MANIPULATING DATA

PUBLISHER..........: LYNDA
LINK...............: http://is.gd/AERBza
AUTHOR.............: ADAM WILBERT
LEVEL..............: BEGINNER
RUNTIME............: 2H 24M
LANGUAGE...........: ENGLISH
RELEASE TYPE.......: RETAIL
RELEASE FORMAT.....: ISO
STORE DATE:........: 2015.08.20
RELEASE DATE.......: 2015.08.20
ISO SIZE...........: 423.315.456 B
ISO CHECKSUM.......: 1BCE01A3
DISKCOUNT..........: 09 X 50MB
SAVED MONEY........: YOU DID!
DISKNAME...........: keiso_ldfcandmd

TUTORIAL

Brand new to database administration? Take it one step
at a time with Database Fundamentals, a series designed to
support a new career or lifelong journey in IT. This
installment is devoted to data: getting it into and out of
tables and databases. Adam Wilbert shows how to get the most
out of each data type, including numbers, characters, and
specialized types like spatial data. Next are queues. Learn
how to write commands and invoke functions in the SQL
Editor to select just the records you want. Finally, get
comfortable inserting, updating, and deleting data with the
SQL Server Management Studio (SSMS), a suite of graphical
tools and rich editors that make working with databases
much more intuitive. Do you want to test your knowledge?
Watch the challenge videos to practice what you've learned
along the way.

Note: This course will also prepare certification candidates
for the Microsoft Technology Associate Exam 98-364,
Database Administration Fundamentals.

Topics include:

* Storing dates, times, and text

* Converting data types

* Creating tables

* Writing T-SQL commands

* Selecting records with queries

* Combining and sorting data

* Creating views

* Creating stored procedures and functions

* Inserting and updating data in a table
* Deleting records and tables

NOTES / NEWS

Huh? No news are good news!

RESPECTS

BBL - DDU - EEn - iNTENSiTY - JGT - RBS

SHOUTOUTS

AZR - BRD - COMPRISED - CORE - DEBOOK - DVT
DVTISO - DVTPDA - iRONiSO - LAXiTY
PANTHEON - PARADOX - POSTMORTEM
PRESSECiTRON - SO - TAX - TSX

H7/BREAK