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