| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/01. Introduction/01_01-Welcome.mp4 |
7.2 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/01. Introduction/01_05-What you should know Restoring your database backup.mp4 |
5.9 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/01. Introduction/01_02-Preparing for MTA 98364.mp4 |
5.1 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/01. Introduction/01_03-Using the exercise files.mp4 |
970 KB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/01. Introduction/01_04-Challenges explained.mp4 |
845 KB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/02. Defining Data Types/02_06-Understanding spatial data types.mp4 |
17.8 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/02. Defining Data Types/02_08-Converting data types in calculations.mp4 |
14.1 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/02. Defining Data Types/02_04-Storing date and time values.mp4 |
13.5 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/02. Defining Data Types/02_07-Working with binary strings and other data types.mp4 |
11.3 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/02. Defining Data Types/02_05-Storing text as character strings.mp4 |
5.9 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/02. Defining Data Types/02_01-Understanding the builtin SQL Server data types.mp4 |
4.7 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/02. Defining Data Types/02_02-Using exact numeric data types.mp4 |
3.8 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/02. Defining Data Types/02_03-Using approximate numeric data types.mp4 |
3.6 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/03. Understanding Tables and How to Create Them/03_02-Creating a table in SQL Server Management Studio.mp4 |
18.8 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/03. Understanding Tables and How to Create Them/03_03-Creating a table using TransactSQL commands.mp4 |
11.5 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/03. Understanding Tables and How to Create Them/03_05-Using SSMS to create reusable scripts.mp4 |
10.2 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/03. Understanding Tables and How to Create Them/03_07-Solution Writing TSQL commands.mp4 |
9.8 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/03. Understanding Tables and How to Create Them/03_04-Applying data constraints and indexes in TSQL.mp4 |
7.9 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/03. Understanding Tables and How to Create Them/03_01-Defining your data needs.mp4 |
2.7 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/03. Understanding Tables and How to Create Them/03_06-Challenge Writing TSQL commands.mp4 |
1.6 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/04. Using Queries to Select Data/04_02-Combining multiple related tables with the JOIN clause.mp4 |
15.8 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/04. Using Queries to Select Data/04_01-Selecting records from the database.mp4 |
15.2 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/04. Using Queries to Select Data/04_11-Solution Making selections.mp4 |
13 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/04. Using Queries to Select Data/04_09-Using aggregate functions.mp4 |
9.3 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/04. Using Queries to Select Data/04_06-Sorting data with ORDER BY.mp4 |
7.2 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/04. Using Queries to Select Data/04_07-Combining returns with the UNION clause.mp4 |
6.6 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/04. Using Queries to Select Data/04_03-Combining conditions with AND and OR.mp4 |
6.6 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/04. Using Queries to Select Data/04_04-Clarifying ranges with a BETWEEN clause.mp4 |
6.4 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/04. Using Queries to Select Data/04_08-Using the EXCEPT and INTERSECT clauses.mp4 |
3.8 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/04. Using Queries to Select Data/04_05-Specifying data you dont want with NOT.mp4 |
3 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/04. Using Queries to Select Data/04_10-Challenge Making selections.mp4 |
1.6 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/05. Working with Views/05_04-Defining a view using TransactSQL commands.mp4 |
15.6 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/05. Working with Views/05_03-Viewing related data from multiple tables.mp4 |
9 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/05. Working with Views/05_06-Solution Creating a view.mp4 |
7.5 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/05. Working with Views/05_02-Creating a view in SQL Server Management Studio.mp4 |
6.9 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/05. Working with Views/05_01-Understanding the role of SQL Server views.mp4 |
4.7 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/05. Working with Views/05_05-Challenge Creating a view.mp4 |
1.6 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/06. Creating Stored Procedures and Functions/06_05-Creating a userdefined scalar function.mp4 |
18.4 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/06. Creating Stored Procedures and Functions/06_02-Creating a stored procedure in SQL Server Management Studio.mp4 |
14.9 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/06. Creating Stored Procedures and Functions/06_03-Leveraging userdefined parameters.mp4 |
12 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/06. Creating Stored Procedures and Functions/06_01-Understanding the roll of stored procedures.mp4 |
3.2 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/06. Creating Stored Procedures and Functions/06_04-Introducing userdefined functions.mp4 |
2 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/07. Inserting and Updating Data in a Table/07_02-Inserting data using data manipulation language.mp4 |
11.3 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/07. Inserting and Updating Data in a Table/07_01-Using SSMS to insert data into a table.mp4 |
8.4 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/07. Inserting and Updating Data in a Table/07_04-Modifying data using the UPDATE clause.mp4 |
6 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/07. Inserting and Updating Data in a Table/07_03-Updating data in SSMS.mp4 |
4.9 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/08. Removing Data from the Database/08_05-Understanding transactions.mp4 |
10.4 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/08. Removing Data from the Database/08_02-Using the DELETE statement.mp4 |
6.3 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/08. Removing Data from the Database/08_04-Deleting a table with DROP TABLE.mp4 |
4.3 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/08. Removing Data from the Database/08_01-Deleting records in SSMS.mp4 |
3.9 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/08. Removing Data from the Database/08_03-Clearing out a table with TRUNCATE TABLE.mp4 |
2.9 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/09. Conclusion/09_01-Next steps.mp4 |
2.9 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 1/H+Active_CMD-Start.bak |
5.4 MB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 1/ThermalVest.png |
63 KB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 1/Spatial.txt |
631 B |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 1/Binary.txt |
369 B |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 1/Convert.txt |
249 B |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 2/ChallengeSolution.sql |
1 KB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 2/CreateDepartments.sql |
923 B |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 2/CreateTable.txt |
646 B |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 2/Constraints.txt |
286 B |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 3/Aggregate.txt |
583 B |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 3/ChallengeSolution.txt |
358 B |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 3/Between.txt |
234 B |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 3/AndOr.txt |
232 B |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 3/Union.txt |
182 B |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 3/IntersectExcept.txt |
181 B |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 3/OrderBy.txt |
157 B |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 3/Not.txt |
149 B |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 4/View.txt |
757 B |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 4/ChallengeSolution.txt |
464 B |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 5/Function.txt |
1 KB |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 5/StoredProcedure.txt |
404 B |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 5/Parameters.txt |
324 B |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 6/InsertingData.txt |
348 B |
| LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL/Exercice Files/Chapter 7/Transactions.txt |
329 B |
Magnet link
