Database Foundations Creating and Manipulating Data

/

01.Welcome.78s.mp4

02.Preparing for MTA Exam 98-364 .103s.mp4

03.Using the exercise files.33s.mp4

04.Challenges explained.17s.mp4

05.What you should know - Restoring your database backup.127s.mp4

06.Understanding the built-in SQL Server data types.144s.mp4

07.Using exact numeric data types.112s.mp4

08.Using approximate numeric data types.126s.mp4

09.Storing date and time values.298s.mp4

10.Storing text as character strings.171s.mp4

11.Understanding spatial data types.350s.mp4

12.Working with binary strings and other data types.239s.mp4

13.Converting data types in calculations.289s.mp4

14.Defining your data needs.85s.mp4

15.Creating a table in SQL Server Management Studio.421s.mp4

16.Creating a table using Transact-SQL commands.259s.mp4

17.Applying data constraints and indexes in T-SQL.175s.mp4

18.Using SSMS to create reusable scripts.194s.mp4

19.Challenge - Writing T-SQL commands.26s.mp4

20.Solution - Writing T-SQL commands.226s.mp4

21.Selecting records from the database.335s.mp4

22.Combining multiple related tables with the JOIN clause.339s.mp4

23.Combining conditions with AND and OR.148s.mp4

24.Clarifying ranges with a BETWEEN clause.139s.mp4

25.Specifying data you don't want with NOT.59s.mp4

26.Sorting data with ORDER BY.141s.mp4

27.Combining returns with the UNION clause.143s.mp4

28.Using the EXCEPT and INTERSECT clauses.81s.mp4

29.Using aggregate functions.258s.mp4

30.Challenge - Making selections.25s.mp4

31.Solution - Making selections.262s.mp4

32.Understanding the role of SQL Server views.143s.mp4

33.Creating a view in SQL Server Management Studio.145s.mp4

34.Viewing related data from multiple tables.174s.mp4

35.Defining a view using Transact-SQL commands.283s.mp4

36.Challenge - Creating a view.25s.mp4

37.Solution - Creating a view.158s.mp4

38.Understanding the role of stored procedures.99s.mp4

39.Creating a stored procedure in SQL Server Management Studio.300s.mp4

40.Leveraging user-defined parameters.240s.mp4

41.Introducing user-defined functions.63s.mp4

42.Creating a user-defined scalar function.363s.mp4

43.Using SSMS to insert data into a table.179s.mp4

44.Inserting data using data manipulation language.231s.mp4

45.Updating data in SSMS.100s.mp4

46.Modifying data using the UPDATE clause.130s.mp4

47.Deleting records in SSMS.76s.mp4

48.Using the DELETE statement.132s.mp4

49.Clearing out a table with TRUNCATE TABLE.58s.mp4

50.Deleting a table with DROP TABLE.94s.mp4

51.Understanding transactions.207s.mp4

52.Next steps.46s.mp4

/Info/

01.Welcome.78s.info.json

02.Preparing for MTA Exam 98-364 .103s.info.json

03.Using the exercise files.33s.info.json

04.Challenges explained.17s.info.json

05.What you should know - Restoring your database backup.127s.info.json

06.Understanding the built-in SQL Server data types.144s.info.json

07.Using exact numeric data types.112s.info.json

08.Using approximate numeric data types.126s.info.json

09.Storing date and time values.298s.info.json

10.Storing text as character strings.171s.info.json

11.Understanding spatial data types.350s.info.json

12.Working with binary strings and other data types.239s.info.json

13.Converting data types in calculations.289s.info.json

14.Defining your data needs.85s.info.json

15.Creating a table in SQL Server Management Studio.421s.info.json

16.Creating a table using Transact-SQL commands.259s.info.json

17.Applying data constraints and indexes in T-SQL.175s.info.json

18.Using SSMS to create reusable scripts.194s.info.json

19.Challenge - Writing T-SQL commands.26s.info.json

20.Solution - Writing T-SQL commands.226s.info.json

21.Selecting records from the database.335s.info.json

22.Combining multiple related tables with the JOIN clause.339s.info.json

23.Combining conditions with AND and OR.148s.info.json

24.Clarifying ranges with a BETWEEN clause.139s.info.json

25.Specifying data you don't want with NOT.59s.info.json

26.Sorting data with ORDER BY.141s.info.json

27.Combining returns with the UNION clause.143s.info.json

28.Using the EXCEPT and INTERSECT clauses.81s.info.json

29.Using aggregate functions.258s.info.json

30.Challenge - Making selections.25s.info.json

31.Solution - Making selections.262s.info.json

32.Understanding the role of SQL Server views.143s.info.json

33.Creating a view in SQL Server Management Studio.145s.info.json

34.Viewing related data from multiple tables.174s.info.json

35.Defining a view using Transact-SQL commands.283s.info.json

36.Challenge - Creating a view.25s.info.json

37.Solution - Creating a view.158s.info.json

38.Understanding the role of stored procedures.99s.info.json

39.Creating a stored procedure in SQL Server Management Studio.300s.info.json

40.Leveraging user-defined parameters.240s.info.json

41.Introducing user-defined functions.63s.info.json

42.Creating a user-defined scalar function.363s.info.json

43.Using SSMS to insert data into a table.179s.info.json

44.Inserting data using data manipulation language.231s.info.json

45.Updating data in SSMS.100s.info.json

46.Modifying data using the UPDATE clause.130s.info.json

47.Deleting records in SSMS.76s.info.json

48.Using the DELETE statement.132s.info.json

49.Clearing out a table with TRUNCATE TABLE.58s.info.json

50.Deleting a table with DROP TABLE.94s.info.json

51.Understanding transactions.207s.info.json

52.Next steps.46s.info.json

Total files 104