Download LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL torrent

LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL

Torrent:	LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL
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
Downloads:	2188
Category:	Other /Tutorials
Size:	408.3 MB
Show Files »	01. Introduction 01_01-Welcome.mp4 (7.2 MB) 01_05-What you should know Restoring your database backup.mp4 (5.9 MB) 01_02-Preparing for MTA 98364.mp4 (5.1 MB) 01_03-Using the exercise files.mp4 (970.4 KB) 01_04-Challenges explained.mp4 (845.4 KB) 02. Defining Data Types 02_06-Understanding spatial data types.mp4 (17.8 MB) 02_08-Converting data types in calculations.mp4 (14.1 MB) 02_04-Storing date and time values.mp4 (13.5 MB) 02_07-Working with binary strings and other data types.mp4 (11.3 MB) 02_05-Storing text as character strings.mp4 (5.9 MB) 02_01-Understanding the builtin SQL Server data types.mp4 (4.7 MB) 02_02-Using exact numeric data types.mp4 (3.8 MB) 02_03-Using approximate numeric data types.mp4 (3.6 MB) 03. Understanding Tables and How to Create Them 03_02-Creating a table in SQL Server Management Studio.mp4 (18.8 MB) 03_03-Creating a table using TransactSQL commands.mp4 (11.5 MB) 03_05-Using SSMS to create reusable scripts.mp4 (10.2 MB) 03_07-Solution Writing TSQL commands.mp4 (9.8 MB) 03_04-Applying data constraints and indexes in TSQL.mp4 (7.9 MB) 03_01-Defining your data needs.mp4 (2.7 MB) 03_06-Challenge Writing TSQL commands.mp4 (1.6 MB) 04. Using Queries to Select Data 04_02-Combining multiple related tables with the JOIN clause.mp4 (15.8 MB) 04_01-Selecting records from the database.mp4 (15.2 MB) 04_11-Solution Making selections.mp4 (13.0 MB) 04_09-Using aggregate functions.mp4 (9.3 MB) 04_06-Sorting data with ORDER BY.mp4 (7.2 MB) 04_07-Combining returns with the UNION clause.mp4 (6.6 MB) 04_03-Combining conditions with AND and OR.mp4 (6.6 MB) 04_04-Clarifying ranges with a BETWEEN clause.mp4 (6.4 MB) 04_08-Using the EXCEPT and INTERSECT clauses.mp4 (3.8 MB) 04_05-Specifying data you dont want with NOT.mp4 (3.0 MB) 04_10-Challenge Making selections.mp4 (1.6 MB) 05. Working with Views 05_04-Defining a view using TransactSQL commands.mp4 (15.6 MB) 05_03-Viewing related data from multiple tables.mp4 (9.0 MB) 05_06-Solution Creating a view.mp4 (7.5 MB) 05_02-Creating a view in SQL Server Management Studio.mp4 (6.9 MB) 05_01-Understanding the role of SQL Server views.mp4 (4.7 MB) 05_05-Challenge Creating a view.mp4 (1.6 MB) 06. Creating Stored Procedures and Functions 06_05-Creating a userdefined scalar function.mp4 (18.4 MB) 06_02-Creating a stored procedure in SQL Server Management Studio.mp4 (14.9 MB) 06_03-Leveraging userdefined parameters.mp4 (12.0 MB) 06_01-Understanding the roll of stored procedures.mp4 (3.2 MB) 06_04-Introducing userdefined functions.mp4 (2.0 MB) 07. Inserting and Updating Data in a Table 07_02-Inserting data using data manipulation language.mp4 (11.3 MB) 07_01-Using SSMS to insert data into a table.mp4 (8.4 MB) 07_04-Modifying data using the UPDATE clause.mp4 (6.0 MB) 07_03-Updating data in SSMS.mp4 (4.9 MB) 08. Removing Data from the Database 08_05-Understanding transactions.mp4 (10.4 MB) 08_02-Using the DELETE statement.mp4 (6.3 MB) 08_04-Deleting a table with DROP TABLE.mp4 (4.3 MB) 08_01-Deleting records in SSMS.mp4 (3.9 MB) 08_03-Clearing out a table with TRUNCATE TABLE.mp4 (2.9 MB) 09. Conclusion 09_01-Next steps.mp4 (2.9 MB) Exercice Files Chapter 1 H+Active_CMD-Start.bak (5.4 MB) ThermalVest.png (63.5 KB) Spatial.txt (0.6 KB) Binary.txt (0.4 KB) Convert.txt (0.2 KB) Chapter 2 ChallengeSolution.sql (1.1 KB) CreateDepartments.sql (0.9 KB) CreateTable.txt (0.6 KB) Constraints.txt (0.3 KB) Chapter 3 Aggregate.txt (0.6 KB) ChallengeSolution.txt (0.3 KB) Between.txt (0.2 KB) AndOr.txt (0.2 KB) Union.txt (0.2 KB) IntersectExcept.txt (0.2 KB) OrderBy.txt (0.2 KB) Not.txt (0.1 KB) Chapter 4 View.txt (0.7 KB) ChallengeSolution.txt (0.5 KB) Chapter 5 Function.txt (1.4 KB) StoredProcedure.txt (0.4 KB) Parameters.txt (0.3 KB) Chapter 6 InsertingData.txt (0.3 KB) Chapter 7 Transactions.txt (0.3 KB) files
Added:	2016-06-20 13:38:16
Language:	English
Peers:	Seeders : 4 , Leechers : 2
Release name:	LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL
Trackers:	udp://tracker.openbittorrent.com:80/announce udp://tracker4.piratux.com:6969/announce udp://p4p.arenabg.ch:1337/announce udp://tracker.coppersurfer.tk:6969/announce udp://coppersurfer.tk:6969/announce udp://open.demonii.com:1337/announce udp://9.rarbg.com:2710/announce udp://tracker.pomf.se/announce udp://tracker.leechers-paradise.org:6969/announce udp://eddie4.nl:6969/announce udp://9.rarbg.me:2710/announce udp://tracker.tntvillage.scambioetico.org:2710/announce udp://p4p.arenabg.com:1337 udp://open.demonii.com:1337 udp://11.rarbg.com/announce