| Database Foundations - Creating and Manipulating Data/01.Welcome.78s.mp4 |
7 MB |
| Database Foundations - Creating and Manipulating Data/02.Preparing for MTA Exam 98-364 .103s.mp4 |
5.1 MB |
| Database Foundations - Creating and Manipulating Data/03.Using the exercise files.33s.mp4 |
957 KB |
| Database Foundations - Creating and Manipulating Data/04.Challenges explained.17s.mp4 |
838 KB |
| Database Foundations - Creating and Manipulating Data/05.What you should know - Restoring your database backup.127s.mp4 |
5.9 MB |
| Database Foundations - Creating and Manipulating Data/06.Understanding the built-in SQL Server data types.144s.mp4 |
4.7 MB |
| Database Foundations - Creating and Manipulating Data/07.Using exact numeric data types.112s.mp4 |
3.8 MB |
| Database Foundations - Creating and Manipulating Data/08.Using approximate numeric data types.126s.mp4 |
3.6 MB |
| Database Foundations - Creating and Manipulating Data/09.Storing date and time values.298s.mp4 |
13.4 MB |
| Database Foundations - Creating and Manipulating Data/10.Storing text as character strings.171s.mp4 |
5.7 MB |
| Database Foundations - Creating and Manipulating Data/11.Understanding spatial data types.350s.mp4 |
17.7 MB |
| Database Foundations - Creating and Manipulating Data/12.Working with binary strings and other data types.239s.mp4 |
11.3 MB |
| Database Foundations - Creating and Manipulating Data/13.Converting data types in calculations.289s.mp4 |
14 MB |
| Database Foundations - Creating and Manipulating Data/14.Defining your data needs.85s.mp4 |
2.6 MB |
| Database Foundations - Creating and Manipulating Data/15.Creating a table in SQL Server Management Studio.421s.mp4 |
18.8 MB |
| Database Foundations - Creating and Manipulating Data/16.Creating a table using Transact-SQL commands.259s.mp4 |
11.5 MB |
| Database Foundations - Creating and Manipulating Data/17.Applying data constraints and indexes in T-SQL.175s.mp4 |
7.9 MB |
| Database Foundations - Creating and Manipulating Data/18.Using SSMS to create reusable scripts.194s.mp4 |
10.1 MB |
| Database Foundations - Creating and Manipulating Data/19.Challenge - Writing T-SQL commands.26s.mp4 |
1.6 MB |
| Database Foundations - Creating and Manipulating Data/20.Solution - Writing T-SQL commands.226s.mp4 |
9.8 MB |
| Database Foundations - Creating and Manipulating Data/21.Selecting records from the database.335s.mp4 |
15.1 MB |
| Database Foundations - Creating and Manipulating Data/22.Combining multiple related tables with the JOIN clause.339s.mp4 |
15.8 MB |
| Database Foundations - Creating and Manipulating Data/23.Combining conditions with AND and OR.148s.mp4 |
6.5 MB |
| Database Foundations - Creating and Manipulating Data/24.Clarifying ranges with a BETWEEN clause.139s.mp4 |
6.4 MB |
| Database Foundations - Creating and Manipulating Data/25.Specifying data you don't want with NOT.59s.mp4 |
2.9 MB |
| Database Foundations - Creating and Manipulating Data/26.Sorting data with ORDER BY.141s.mp4 |
7.2 MB |
| Database Foundations - Creating and Manipulating Data/27.Combining returns with the UNION clause.143s.mp4 |
6.6 MB |
| Database Foundations - Creating and Manipulating Data/28.Using the EXCEPT and INTERSECT clauses.81s.mp4 |
3.8 MB |
| Database Foundations - Creating and Manipulating Data/29.Using aggregate functions.258s.mp4 |
11.4 MB |
| Database Foundations - Creating and Manipulating Data/30.Challenge - Making selections.25s.mp4 |
1.6 MB |
| Database Foundations - Creating and Manipulating Data/31.Solution - Making selections.262s.mp4 |
13 MB |
| Database Foundations - Creating and Manipulating Data/32.Understanding the role of SQL Server views.143s.mp4 |
4.6 MB |
| Database Foundations - Creating and Manipulating Data/33.Creating a view in SQL Server Management Studio.145s.mp4 |
6.9 MB |
| Database Foundations - Creating and Manipulating Data/34.Viewing related data from multiple tables.174s.mp4 |
9 MB |
| Database Foundations - Creating and Manipulating Data/35.Defining a view using Transact-SQL commands.283s.mp4 |
15.5 MB |
| Database Foundations - Creating and Manipulating Data/36.Challenge - Creating a view.25s.mp4 |
1.5 MB |
| Database Foundations - Creating and Manipulating Data/37.Solution - Creating a view.158s.mp4 |
7.4 MB |
| Database Foundations - Creating and Manipulating Data/38.Understanding the role of stored procedures.99s.mp4 |
3.2 MB |
| Database Foundations - Creating and Manipulating Data/39.Creating a stored procedure in SQL Server Management Studio.300s.mp4 |
14.9 MB |
| Database Foundations - Creating and Manipulating Data/40.Leveraging user-defined parameters.240s.mp4 |
11.9 MB |
| Database Foundations - Creating and Manipulating Data/41.Introducing user-defined functions.63s.mp4 |
2.1 MB |
| Database Foundations - Creating and Manipulating Data/42.Creating a user-defined scalar function.363s.mp4 |
18.4 MB |
| Database Foundations - Creating and Manipulating Data/43.Using SSMS to insert data into a table.179s.mp4 |
8.4 MB |
| Database Foundations - Creating and Manipulating Data/44.Inserting data using data manipulation language.231s.mp4 |
11.3 MB |
| Database Foundations - Creating and Manipulating Data/45.Updating data in SSMS.100s.mp4 |
4.9 MB |
| Database Foundations - Creating and Manipulating Data/46.Modifying data using the UPDATE clause.130s.mp4 |
5.9 MB |
| Database Foundations - Creating and Manipulating Data/47.Deleting records in SSMS.76s.mp4 |
3.9 MB |
| Database Foundations - Creating and Manipulating Data/48.Using the DELETE statement.132s.mp4 |
6.3 MB |
| Database Foundations - Creating and Manipulating Data/49.Clearing out a table with TRUNCATE TABLE.58s.mp4 |
2.9 MB |
| Database Foundations - Creating and Manipulating Data/50.Deleting a table with DROP TABLE.94s.mp4 |
4.3 MB |
| Database Foundations - Creating and Manipulating Data/51.Understanding transactions.207s.mp4 |
10.4 MB |
| Database Foundations - Creating and Manipulating Data/52.Next steps.46s.mp4 |
2.9 MB |
| Database Foundations - Creating and Manipulating Data/Info/01.Welcome.78s.info.json |
6 KB |
| Database Foundations - Creating and Manipulating Data/Info/02.Preparing for MTA Exam 98-364 .103s.info.json |
6 KB |
| Database Foundations - Creating and Manipulating Data/Info/03.Using the exercise files.33s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/04.Challenges explained.17s.info.json |
6 KB |
| Database Foundations - Creating and Manipulating Data/Info/05.What you should know - Restoring your database backup.127s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/06.Understanding the built-in SQL Server data types.144s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/07.Using exact numeric data types.112s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/08.Using approximate numeric data types.126s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/09.Storing date and time values.298s.info.json |
6 KB |
| Database Foundations - Creating and Manipulating Data/Info/10.Storing text as character strings.171s.info.json |
6 KB |
| Database Foundations - Creating and Manipulating Data/Info/11.Understanding spatial data types.350s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/12.Working with binary strings and other data types.239s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/13.Converting data types in calculations.289s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/14.Defining your data needs.85s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/15.Creating a table in SQL Server Management Studio.421s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/16.Creating a table using Transact-SQL commands.259s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/17.Applying data constraints and indexes in T-SQL.175s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/18.Using SSMS to create reusable scripts.194s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/19.Challenge - Writing T-SQL commands.26s.info.json |
6 KB |
| Database Foundations - Creating and Manipulating Data/Info/20.Solution - Writing T-SQL commands.226s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/21.Selecting records from the database.335s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/22.Combining multiple related tables with the JOIN clause.339s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/23.Combining conditions with AND and OR.148s.info.json |
6 KB |
| Database Foundations - Creating and Manipulating Data/Info/24.Clarifying ranges with a BETWEEN clause.139s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/25.Specifying data you don't want with NOT.59s.info.json |
6 KB |
| Database Foundations - Creating and Manipulating Data/Info/26.Sorting data with ORDER BY.141s.info.json |
6 KB |
| Database Foundations - Creating and Manipulating Data/Info/27.Combining returns with the UNION clause.143s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/28.Using the EXCEPT and INTERSECT clauses.81s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/29.Using aggregate functions.258s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/30.Challenge - Making selections.25s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/31.Solution - Making selections.262s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/32.Understanding the role of SQL Server views.143s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/33.Creating a view in SQL Server Management Studio.145s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/34.Viewing related data from multiple tables.174s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/35.Defining a view using Transact-SQL commands.283s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/36.Challenge - Creating a view.25s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/37.Solution - Creating a view.158s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/38.Understanding the role of stored procedures.99s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/39.Creating a stored procedure in SQL Server Management Studio.300s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/40.Leveraging user-defined parameters.240s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/41.Introducing user-defined functions.63s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/42.Creating a user-defined scalar function.363s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/43.Using SSMS to insert data into a table.179s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/44.Inserting data using data manipulation language.231s.info.json |
6 KB |
| Database Foundations - Creating and Manipulating Data/Info/45.Updating data in SSMS.100s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/46.Modifying data using the UPDATE clause.130s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/47.Deleting records in SSMS.76s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/48.Using the DELETE statement.132s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/49.Clearing out a table with TRUNCATE TABLE.58s.info.json |
7 KB |
| Database Foundations - Creating and Manipulating Data/Info/50.Deleting a table with DROP TABLE.94s.info.json |
6 KB |
| Database Foundations - Creating and Manipulating Data/Info/51.Understanding transactions.207s.info.json |
6 KB |
| Database Foundations - Creating and Manipulating Data/Info/52.Next steps.46s.info.json |
6 KB |
Magnet link
