LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL

seeders: 68
leechers: 12
Added on August 22, 2015 by BarCraftin Other > Tutorials
Torrent verified.



LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL (Size: 408.34 MB)
 01_01-Welcome.mp47.22 MB
 01_05-What you should know Restoring your database backup.mp45.88 MB
 01_02-Preparing for MTA 98364.mp45.11 MB
 01_03-Using the exercise files.mp4970.37 KB
 01_04-Challenges explained.mp4845.43 KB
 02_06-Understanding spatial data types.mp417.75 MB
 02_08-Converting data types in calculations.mp414.05 MB
 02_04-Storing date and time values.mp413.45 MB
 02_07-Working with binary strings and other data types.mp411.34 MB
 02_05-Storing text as character strings.mp45.89 MB
 02_01-Understanding the builtin SQL Server data types.mp44.68 MB
 02_02-Using exact numeric data types.mp43.79 MB
 02_03-Using approximate numeric data types.mp43.62 MB
 03_02-Creating a table in SQL Server Management Studio.mp418.8 MB
 03_03-Creating a table using TransactSQL commands.mp411.54 MB
 03_05-Using SSMS to create reusable scripts.mp410.19 MB
 03_07-Solution Writing TSQL commands.mp49.82 MB
 03_04-Applying data constraints and indexes in TSQL.mp47.91 MB
 03_01-Defining your data needs.mp42.71 MB
 03_06-Challenge Writing TSQL commands.mp41.59 MB
 04_02-Combining multiple related tables with the JOIN clause.mp415.8 MB
 04_01-Selecting records from the database.mp415.23 MB
 04_11-Solution Making selections.mp413.02 MB
 04_09-Using aggregate functions.mp49.31 MB
 04_06-Sorting data with ORDER BY.mp47.22 MB
 04_07-Combining returns with the UNION clause.mp46.63 MB
 04_03-Combining conditions with AND and OR.mp46.57 MB
 04_04-Clarifying ranges with a BETWEEN clause.mp46.42 MB
 04_08-Using the EXCEPT and INTERSECT clauses.mp43.82 MB
 04_05-Specifying data you dont want with NOT.mp42.96 MB
 04_10-Challenge Making selections.mp41.61 MB
 05_04-Defining a view using TransactSQL commands.mp415.56 MB
 05_03-Viewing related data from multiple tables.mp49.04 MB
 05_06-Solution Creating a view.mp47.46 MB
 05_02-Creating a view in SQL Server Management Studio.mp46.95 MB
 05_01-Understanding the role of SQL Server views.mp44.66 MB
 05_05-Challenge Creating a view.mp41.55 MB
 06_05-Creating a userdefined scalar function.mp418.41 MB
 06_02-Creating a stored procedure in SQL Server Management Studio.mp414.9 MB
 06_03-Leveraging userdefined parameters.mp412.03 MB
 06_01-Understanding the roll of stored procedures.mp43.24 MB
 06_04-Introducing userdefined functions.mp42.05 MB
 07_02-Inserting data using data manipulation language.mp411.35 MB
 07_01-Using SSMS to insert data into a table.mp48.42 MB
 07_04-Modifying data using the UPDATE clause.mp45.97 MB
 07_03-Updating data in SSMS.mp44.88 MB
 08_05-Understanding transactions.mp410.42 MB
 08_02-Using the DELETE statement.mp46.3 MB
 08_04-Deleting a table with DROP TABLE.mp44.34 MB
 08_01-Deleting records in SSMS.mp43.86 MB
 08_03-Clearing out a table with TRUNCATE TABLE.mp42.87 MB
 09_01-Next steps.mp42.92 MB
 H+Active_CMD-Start.bak5.42 MB
 ThermalVest.png63.48 KB
 spatial.txt631 bytes
 binary.txt369 bytes
 CONVERT.txt249 bytes
 ChallengeSolution.sql1.08 KB
 CreateDepartments.sql923 bytes
 CreateTable.txt646 bytes
 constraints.txt286 bytes
 aggregate.txt583 bytes
 ChallengeSolution.txt358 bytes
 Between.txt234 bytes
 andor.txt232 bytes
 union.txt182 bytes
 IntersectExcept.txt181 bytes
 orderby.txt157 bytes
 not.txt149 bytes
 view.txt757 bytes
 ChallengeSolution.txt464 bytes
 FUNCTION.txt1.38 KB
 StoredProcedure.txt404 bytes
 Parameters.txt324 bytes
 InsertingData.txt348 bytes
 transactions.txt329 bytes


Description

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

Sharing Widget


Download torrent
408.34 MB
seeders:68
leechers:12
LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL