LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL torrent

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