Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай Database Testing with SQL & Unix / Linux commands for Tester, а также все другие курсы, прямо сейчас!
Премиум
  • Урок 1. 00:05:56
    Course Architecture : Must for Everyone
  • Урок 2. 00:01:54
    Database Setup Introduction
  • Урок 3. 00:06:15
    Approach-1: Mysql Server Installation
  • Урок 4. 00:04:52
    MySQL Client Installation : Workbench
  • Урок 5. 00:04:33
    Setup Tables and Data for practice
  • Урок 6. 00:02:38
    Approach-2: Execute SQL query online
  • Урок 7. 00:09:04
    What is Database Testing
  • Урок 8. 00:06:28
    Select Query Basics : Fetch Data from Table
  • Урок 9. 00:11:31
    Select data from table : Data filtration using WHERE Clause
  • Урок 10. 00:08:34
    Select Query : Data Filtration : Where Clause with Logical AND and OR
  • Урок 11. 00:12:29
    Select Query : Data Filtration using List and Range
  • Урок 12. 00:05:48
    Fetch unique data from column and Table structure
  • Урок 13. 00:07:44
    Display data with Column Alias
  • Урок 14. 00:08:26
    Display data in Sorting order
  • Урок 15. 00:15:45
    Select data with Pattern Matching - Part 1
  • Урок 16. 00:07:22
    Select data with Pattern Matching - Part 2
  • Урок 17. 00:08:36
    SQL - SubQuery
  • Урок 18. 00:03:35
    Select Query : Fetch Null data
  • Урок 19. 00:03:24
    Arithmetic operations on Column data
  • Урок 20. 00:13:00
    SQL - Delete data from tables( Delete | Drop | Truncate)
  • Урок 21. 00:06:04
    Group Functions
  • Урок 22. 00:13:55
    Display data with Grouping
  • Урок 23. 00:10:16
    Filter data before and after Grouping
  • Урок 24. 00:02:31
    What is Join
  • Урок 25. 00:08:04
    Cross or Cartesian Join
  • Урок 26. 00:11:26
    Inner Join | Equi Join | Simple Join
  • Урок 27. 00:08:07
    Left Join | Left Outer Join
  • Урок 28. 00:06:52
    Right Join | Right Outer Join
  • Урок 29. 00:05:04
    Full Join | Full Outer Join
  • Урок 30. 00:07:37
    Self Join
  • Урок 31. 00:08:31
    Create Tables by Coping another Table
  • Урок 32. 00:09:49
    Create Table
  • Урок 33. 00:11:02
    Insert data into table
  • Урок 34. 00:10:32
    Update data of a table
  • Урок 35. 00:11:05
    Update Table Structure
  • Урок 36. 00:16:49
    SQL - Views
  • Урок 37. 00:07:29
    SQL - Indexes
  • Урок 38. 00:08:13
    SQL- Union & Union All
  • Урок 39. 00:06:41
    SQL - Not Null constraint
  • Урок 40. 00:04:46
    Check Constraint
  • Урок 41. 00:05:01
    Default Constraint
  • Урок 42. 00:05:04
    SQL - Unique Key constraint
  • Урок 43. 00:10:24
    Primary Key
  • Урок 44. 00:10:43
    Foreign Key
  • Урок 45. 00:01:41
    Difference between Primary Key and Unique Key
  • Урок 46. 00:03:38
    Copy a Table without Structure
  • Урок 47. 00:10:38
    Find 2nd(Any number) Highest | Lowest Salary of Employee
  • Урок 48. 00:05:42
    Find Duplicate Records
  • Урок 49. 00:12:00
    Why as Tester, you should learn Unix/ Linux
  • Урок 50. 00:02:30
    Environment for Unix/Linux Commands Practice
  • Урок 51. 00:09:19
    Setup Environment on Windows Machine
  • Урок 52. 00:07:40
    Start working with Basic Commands
  • Урок 53. 00:14:46
    Working with Directories - Part 1
  • Урок 54. 00:04:44
    Working with Directories - Part 2
  • Урок 55. 00:12:16
    Different option to create files
  • Урок 56. 00:10:58
    Listing files and Folders
  • Урок 57. 00:11:25
    All uses of CAT command
  • Урок 58. 00:02:05
    Setup Sample Data
  • Урок 59. 00:06:40
    Check complete file content : CAT Command
  • Урок 60. 00:07:05
    Check file content : Top few lines
  • Урок 61. 00:03:31
    Check file content : bottom few lines
  • Урок 62. 00:05:07
    Check file content : with Paging - More Command
  • Урок 63. 00:02:26
    Check file content : with Paging - Less Command
  • Урок 64. 00:01:39
    Check file content : with VIM editor
  • Урок 65. 00:04:00
    Commonly Asked Question : Get few lines from middle of the File
  • Урок 66. 00:05:58
    What is Grep | Search data in 1 file
  • Урок 67. 00:04:04
    Search data in more than 1 files
  • Урок 68. 00:03:38
    Search data in all files of current directory
  • Урок 69. 00:04:40
    Search data by ignoring case
  • Урок 70. 00:03:12
    Search Data : Display Line number
  • Урок 71. 00:12:36
    Copy file/folder from one location to another location - Part 1
  • Урок 72. 00:06:11
    Copy file/folder from one location to another location - Part 2
  • Урок 73. 00:07:53
    Cut file/ folder from one location to another location
  • Урок 74. 00:02:50
    Rename File and Folder
  • Урок 75. 00:03:41
    Check File Detail
  • Урок 76. 00:06:14
    Sort File Data
  • Урок 77. 00:02:31
    History Command
  • Урок 78. 00:08:35
    Fetch Uniq data
  • Урок 79. 00:03:31
    Basic System Commands
  • Урок 80. 00:07:59
    Shell Scripting Basics
  • Урок 81. 00:11:20
    Write First Shell Script
  • Урок 82. 00:06:02
    Take User Input
  • Урок 83. 00:06:29
    Shell script with simple shell commands
  • Урок 84. 00:11:20
    Shell Scripting - Use Case 1
  • Урок 85. 00:06:26
    Shell Scripting - Use Case 2
  • Урок 86. 00:09:17
    Update Shell Script - Printf & RANDOM
  • Урок 87. 00:04:19
    Shell Basics
  • Урок 88. 00:04:48
    First Shell Script
  • Урок 89. 00:08:13
    Variable in Shell Script
  • Урок 90. 00:03:19
    User interaction for input
  • Урок 91. 00:06:35
    Command line Argument
  • Урок 92. 00:08:59
    Condition handling - If else
  • Урок 93. 00:07:15
    Condition Handling - Multiple conditions
  • Урок 94. 00:02:54
    SQL - Select Query Basics
  • Урок 95. 00:05:05
    SQL- Select with Where clause
  • Урок 96. 00:05:13
    SQL - Select data (In & Between)
  • Урок 97. 00:03:56
    SQL - Select data(With Sorting)
  • Урок 98. 00:02:01
    SQL - Select Unique data(Distinct)
  • Урок 99. 00:04:40
    SQL - Select data( Patten matching - Like)
  • Урок 100. 00:02:24
    SQL - Subquery
  • Урок 101. 00:05:56
    SQL - Delete data from tables( Delete | Drop | Truncate)
  • Урок 102. 00:03:20
    Group Functions
  • Урок 103. 00:05:37
    Create Tables
  • Урок 104. 00:02:10
    Insert data into Tables
  • Урок 105. 00:02:36
    Update data in Tables
  • Урок 106. 00:05:43
    SQL - Group By & Having
  • Урок 107. 00:04:23
    SQL - Not Null constraint
  • Урок 108. 00:03:58
    SQL - Unique Key constraint
  • Урок 109. 00:03:12
    SQL - Views
  • Урок 110. 00:03:52
    SQL - Indexes
  • Урок 111. 00:03:13
    SQL - Primary key constraint
  • Урок 112. 00:03:04
    SQL - Difference between Unique and Primary key
  • Урок 113. 00:03:55
    Cross or Cartesian Join
  • Урок 114. 00:06:45
    Inner Join | Equi Join | Simple Join
  • Урок 115. 00:05:37
    Outer Join( Left and Right outer)
  • Урок 116. 00:05:34
    Self Join
  • Урок 117. 00:03:37
    File Comparison
  • Урок 118. 00:04:09
    Why we need to learn Unix ?
  • Урок 119. 00:04:08
    Unix Basic Commands
  • Урок 120. 00:04:33
    Working with Log files
  • Урок 121. 00:09:56
    Backup commands
  • Урок 122. 00:02:51
    Search content
  • Урок 123. 00:02:49
    Working with Memory
  • Урок 124. 00:03:16
    Miscellaneous commands
  • Урок 125. 00:01:42
    Processes
  • Урок 126. 00:02:28
    Advance Process work