| | | 01_01-Welcome.mp4 | 7.22 MB |
| | | 01_05-What you should know Restoring your database backup.mp4 | 5.88 MB |
| | | 01_02-Preparing for MTA 98364.mp4 | 5.11 MB |
| | | 01_03-Using the exercise files.mp4 | 970.37 KB |
| | | 01_04-Challenges explained.mp4 | 845.43 KB |
| | | 02_06-Understanding spatial data types.mp4 | 17.75 MB |
| | | 02_08-Converting data types in calculations.mp4 | 14.05 MB |
| | | 02_04-Storing date and time values.mp4 | 13.45 MB |
| | | 02_07-Working with binary strings and other data types.mp4 | 11.34 MB |
| | | 02_05-Storing text as character strings.mp4 | 5.89 MB |
| | | 02_01-Understanding the builtin SQL Server data types.mp4 | 4.68 MB |
| | | 02_02-Using exact numeric data types.mp4 | 3.79 MB |
| | | 02_03-Using approximate numeric data types.mp4 | 3.62 MB |
| | | 03_02-Creating a table in SQL Server Management Studio.mp4 | 18.8 MB |
| | | 03_03-Creating a table using TransactSQL commands.mp4 | 11.54 MB |
| | | 03_05-Using SSMS to create reusable scripts.mp4 | 10.19 MB |
| | | 03_07-Solution Writing TSQL commands.mp4 | 9.82 MB |
| | | 03_04-Applying data constraints and indexes in TSQL.mp4 | 7.91 MB |
| | | 03_01-Defining your data needs.mp4 | 2.71 MB |
| | | 03_06-Challenge Writing TSQL commands.mp4 | 1.59 MB |
| | | 04_02-Combining multiple related tables with the JOIN clause.mp4 | 15.8 MB |
| | | 04_01-Selecting records from the database.mp4 | 15.23 MB |
| | | 04_11-Solution Making selections.mp4 | 13.02 MB |
| | | 04_09-Using aggregate functions.mp4 | 9.31 MB |
| | | 04_06-Sorting data with ORDER BY.mp4 | 7.22 MB |
| | | 04_07-Combining returns with the UNION clause.mp4 | 6.63 MB |
| | | 04_03-Combining conditions with AND and OR.mp4 | 6.57 MB |
| | | 04_04-Clarifying ranges with a BETWEEN clause.mp4 | 6.42 MB |
| | | 04_08-Using the EXCEPT and INTERSECT clauses.mp4 | 3.82 MB |
| | | 04_05-Specifying data you dont want with NOT.mp4 | 2.96 MB |
| | | 04_10-Challenge Making selections.mp4 | 1.61 MB |
| | | 05_04-Defining a view using TransactSQL commands.mp4 | 15.56 MB |
| | | 05_03-Viewing related data from multiple tables.mp4 | 9.04 MB |
| | | 05_06-Solution Creating a view.mp4 | 7.46 MB |
| | | 05_02-Creating a view in SQL Server Management Studio.mp4 | 6.95 MB |
| | | 05_01-Understanding the role of SQL Server views.mp4 | 4.66 MB |
| | | 05_05-Challenge Creating a view.mp4 | 1.55 MB |
| | | 06_05-Creating a userdefined scalar function.mp4 | 18.41 MB |
| | | 06_02-Creating a stored procedure in SQL Server Management Studio.mp4 | 14.9 MB |
| | | 06_03-Leveraging userdefined parameters.mp4 | 12.03 MB |
| | | 06_01-Understanding the roll of stored procedures.mp4 | 3.24 MB |
| | | 06_04-Introducing userdefined functions.mp4 | 2.05 MB |
| | | 07_02-Inserting data using data manipulation language.mp4 | 11.35 MB |
| | | 07_01-Using SSMS to insert data into a table.mp4 | 8.42 MB |
| | | 07_04-Modifying data using the UPDATE clause.mp4 | 5.97 MB |
| | | 07_03-Updating data in SSMS.mp4 | 4.88 MB |
| | | 08_05-Understanding transactions.mp4 | 10.42 MB |
| | | 08_02-Using the DELETE statement.mp4 | 6.3 MB |
| | | 08_04-Deleting a table with DROP TABLE.mp4 | 4.34 MB |
| | | 08_01-Deleting records in SSMS.mp4 | 3.86 MB |
| | | 08_03-Clearing out a table with TRUNCATE TABLE.mp4 | 2.87 MB |
| | | 09_01-Next steps.mp4 | 2.92 MB |
| | | H+Active_CMD-Start.bak | 5.42 MB |
| | | ThermalVest.png | 63.48 KB |
| | | spatial.txt | 631 bytes |
| | | binary.txt | 369 bytes |
| | | CONVERT.txt | 249 bytes |
| | | ChallengeSolution.sql | 1.08 KB |
| | | CreateDepartments.sql | 923 bytes |
| | | CreateTable.txt | 646 bytes |
| | | constraints.txt | 286 bytes |
| | | aggregate.txt | 583 bytes |
| | | ChallengeSolution.txt | 358 bytes |
| | | Between.txt | 234 bytes |
| | | andor.txt | 232 bytes |
| | | union.txt | 182 bytes |
| | | IntersectExcept.txt | 181 bytes |
| | | orderby.txt | 157 bytes |
| | | not.txt | 149 bytes |
| | | view.txt | 757 bytes |
| | | ChallengeSolution.txt | 464 bytes |
| | | FUNCTION.txt | 1.38 KB |
| | | StoredProcedure.txt | 404 bytes |
| | | Parameters.txt | 324 bytes |
| | | InsertingData.txt | 348 bytes |
| | | transactions.txt | 329 bytes |