LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL

LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL

Name	LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL	DOWNLOAD Copy Link
Total Size	428.2 MB
Total Files	76
Hash	1B52EAEA2E19DDA4B4CC7FD0FC34761CD818AFB9

/01. Introduction/
01_01-Welcome.mp4	7.6 MB
01_05-What you should know Restoring your database backup.mp4	6.2 MB
01_02-Preparing for MTA 98364.mp4	5.4 MB
01_03-Using the exercise files.mp4	993.7 KB
01_04-Challenges explained.mp4	865.7 KB
/02. Defining Data Types/
02_06-Understanding spatial data types.mp4	18.6 MB
02_08-Converting data types in calculations.mp4	14.7 MB
02_04-Storing date and time values.mp4	14.1 MB
02_07-Working with binary strings and other data types.mp4	11.9 MB
02_05-Storing text as character strings.mp4	6.2 MB
02_01-Understanding the builtin SQL Server data types.mp4	4.9 MB
02_02-Using exact numeric data types.mp4	4.0 MB
02_03-Using approximate numeric data types.mp4	3.8 MB
/03. Understanding Tables and How to Create Them/
03_02-Creating a table in SQL Server Management Studio.mp4	19.7 MB
03_03-Creating a table using TransactSQL commands.mp4	12.1 MB
03_05-Using SSMS to create reusable scripts.mp4	10.7 MB
03_07-Solution Writing TSQL commands.mp4	10.3 MB
03_04-Applying data constraints and indexes in TSQL.mp4	8.3 MB
03_01-Defining your data needs.mp4	2.8 MB
03_06-Challenge Writing TSQL commands.mp4	1.7 MB
/04. Using Queries to Select Data/
04_02-Combining multiple related tables with the JOIN clause.mp4	16.6 MB
04_01-Selecting records from the database.mp4	16.0 MB
04_11-Solution Making selections.mp4	13.7 MB
04_09-Using aggregate functions.mp4	9.8 MB
04_06-Sorting data with ORDER BY.mp4	7.6 MB
04_07-Combining returns with the UNION clause.mp4	7.0 MB
04_03-Combining conditions with AND and OR.mp4	6.9 MB
04_04-Clarifying ranges with a BETWEEN clause.mp4	6.7 MB
04_08-Using the EXCEPT and INTERSECT clauses.mp4	4.0 MB
04_05-Specifying data you dont want with NOT.mp4	3.1 MB
04_10-Challenge Making selections.mp4	1.7 MB
/05. Working with Views/
05_04-Defining a view using TransactSQL commands.mp4	16.3 MB
05_03-Viewing related data from multiple tables.mp4	9.5 MB
05_06-Solution Creating a view.mp4	7.8 MB
05_02-Creating a view in SQL Server Management Studio.mp4	7.3 MB
05_01-Understanding the role of SQL Server views.mp4	4.9 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	19.3 MB
06_02-Creating a stored procedure in SQL Server Management Studio.mp4	15.6 MB
06_03-Leveraging userdefined parameters.mp4	12.6 MB
06_01-Understanding the roll of stored procedures.mp4	3.4 MB
06_04-Introducing userdefined functions.mp4	2.1 MB
/07. Inserting and Updating Data in a Table/
07_02-Inserting data using data manipulation language.mp4	11.9 MB
07_01-Using SSMS to insert data into a table.mp4	8.8 MB
07_04-Modifying data using the UPDATE clause.mp4	6.3 MB
07_03-Updating data in SSMS.mp4	5.1 MB
/08. Removing Data from the Database/
08_05-Understanding transactions.mp4	10.9 MB
08_02-Using the DELETE statement.mp4	6.6 MB
08_04-Deleting a table with DROP TABLE.mp4	4.6 MB
08_01-Deleting records in SSMS.mp4	4.0 MB
08_03-Clearing out a table with TRUNCATE TABLE.mp4	3.0 MB
/09. Conclusion/
09_01-Next steps.mp4	3.1 MB
/Exercice Files/Chapter 1/
H+Active_CMD-Start.bak	5.7 MB
ThermalVest.png	65.0 KB
Spatial.txt	0.6 KB
Binary.txt	0.4 KB
Convert.txt	0.2 KB
/Exercice Files/Chapter 2/
ChallengeSolution.sql	1.1 KB
CreateDepartments.sql	0.9 KB
CreateTable.txt	0.6 KB
Constraints.txt	0.3 KB
/Exercice Files/Chapter 3/
Aggregate.txt	0.6 KB
ChallengeSolution.txt	0.4 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
/Exercice Files/Chapter 4/
View.txt	0.8 KB
ChallengeSolution.txt	0.5 KB
/Exercice Files/Chapter 5/
Function.txt	1.4 KB
StoredProcedure.txt	0.4 KB
Parameters.txt	0.3 KB
/Exercice Files/Chapter 6/
InsertingData.txt	0.3 KB
/Exercice Files/Chapter 7/
Transactions.txt	0.3 KB
Total files 76