Get Expertise in Database Testing SQL Linux for Testers

/.../9. Advance SQL Queries Views, Index and Union/

1. SQL - Views Create dummy table structure to allow limited access on data.mp4

TutsNode.com.txt

[TGx]Downloaded from torrentgalaxy.to .txt

/.../13. SQL Interview Questions Must for all Interview Aspirants/

1.1 DATABASE INTERVIEW QUESTIONS-converted.pdf

2. Find 2nd(Any number) Highest Lowest Salary of Employee.mp4

3. Find Duplicate Records.mp4

1. Copy a Table without Structure.mp4

/.../1. Course introduction & Setup Instructions/

5.1 mysqlsampledatabase_reference.zip

7.1 DB.pdf

6. Sample Database, Tables with Data.html

8. What is Database Testing What all testing activities we will do on Database.mp4

1. Course Architecture Must for Everyone What we will learn in this course.mp4

3. Approach-1 Mysql Server Installation on Windows Machine (Database Server Setup).mp4

5. Setup Sample Tables and Test Data for practice.mp4

4. MySQL Client Installation Workbench on Windows Machine (Database Client Setup).mp4

7. Approach-2 Execute SQL query online (Incase you do not have Installed DB).mp4

2. Database Setup Introduction.mp4

/.../14. Introduction to Unix (Linux) Why as Tester we should Learn Environment Setup/

3.1 DB (1).pdf

1. Documentation.html

4. Setup Environment.html

2. Why as TesterQA to learn UnixLinux Commands Practical areas to use it as QA.mp4

5. Setup Practice Environment on Windows Machine (Suggestive for better practicing).mp4

3. Use online environment for practice(In case you don't have practice environment).mp4

/.../2. Fetch Data from Table using Basic Select Queries - With Data Filtration/

1.1 SelectQueries_Basics.rtf

11. Test your learning by solving these Practice Questions.html

2. Reference Document Last Session Queries.html

8. Reference Document Last Session Queries.html

10. Reference Document Last Session Queries.html

12. Its Time for QUIZ Check Your Knowledge.html

5. Select Query Data Filtration using List and Range (IN and BETWEEN).mp4

3. Select data from table Data filtration using WHERE Clause.mp4

9. Display data in Sorting order (Ascending & Descending ).mp4

4. Select Query Data Filtration Where Clause with Logical AND and OR.mp4

7. Display data with Column Alias.mp4

1. Select Query Basics Fetch Data from Table- Select all data or Few columns.mp4

6. Fetch unique data from column and Table structure.mp4

/.../8. Working with Tables Create table, Insert, Update and Delete data from table/

6. All Queries of this section.html

5. Update Table Structure (Conditionally update data).mp4

3. Insert data into table One row at a time.mp4

4. Update data of a table By giving some conditions.mp4

1. Create Tables by Coping content from another Table.mp4

2. Create Table with Structure.mp4

/.../3. Advance Select Queries Pattern Matching(Like with Characters) and Sub Queries/

1.1 SelectQueries_Advance.rtf

7. Test your learning by solving these Practice Questions.html

2. Document Select data with Pattern Matching - Part 1.html

4. Document Select data with Pattern Matching - Part 2.html

6. Reference Document SQL - SubQuery.html

1. Select data with Pattern Matching(Like with Wild Card Character) - Part 1.mp4

5. SQL - SubQuery Write Query inside a Query.mp4

3. Select data with Pattern Matching(Like with Wild Card Character) - Part 2.mp4

/.../7. Joins Fetch Data from multiple Tables (Inner, Outer , Simple & Cross Join)/

10. Queries of this complete section.html

4. Queries to run before next video.html

9. Test your learning by solving these Practice Questions.html

3. Inner Join Equi Join Simple Join Fetch data by merging 2 tables(condition).mp4

2. Cross or Cartesian Join Fetch data by Complete merging of 2 or more tables).mp4

5. Left Join Left Outer Join Fetch data by merging 2 tables(condition)+Left data.mp4

8. Self Join Join table by Itself.mp4

6. Right Join Right Outer Join Fetch data by merging 2 table(condition)+Right.mp4

7. Full Join Full Outer Join.mp4

1. What is Join Why and How we write join in SQL queries.mp4

/.../9. Advance SQL Queries Views, Index and Union/

4. Queries of this complete section.html

2. SQL - Indexes Increase Search statement performance.mp4

3. SQL- Union & Union All Simply adding data of 2 or more tables.mp4

/.../6. Data Fetch and Display after Grouping (Group By and Having)/

4. Queries of this complete section.html

5. Test your learning by solving these Practice Questions.html

2. Display data with Grouping - Use Group by Clause.mp4

3. Filter data before and after Grouping - Where and Having in a Single Query.mp4

1. Group Functions - Mix, Max, Avg, Count, Sum.mp4

/.../4. Other Common Select Query Operations/

3. Queries of this complete section.html

4. Its Time for QUIZ Check Your Knowledge.html

1. Select Query Fetch Null data.mp4

2. Arithmetic operations on Column data.mp4

/.../5. Delete Table Structure & Table Data (Delete, Drop, Truncate)/

2. Document Delete data from tables( Delete Drop Truncate).html

1. SQL - Delete data from tables( Delete Drop Truncate).mp4

/.../16. Check content of File(Log Files) Must Learning Conceptspractical for Tester/

1. Documentation Sample Data to be used for Practicing with me.html

4. Check file content Top few lines - Head Command.mp4

3. Check complete file content CAT Command.mp4

6. Check file content with Paging - More Command.mp4

5. Check file content bottom few lines - Tail Command.mp4

7. Check file content with Paging - Less Command.mp4

9. Commonly Asked Question Get few lines from middle of the File.mp4

8. Check file content with VIM editor.mp4

2. Setup Sample Data to be used for Practicing with me.mp4

/.../12. -------QUIZ for SQL Queries ------- 25 Questions in 25 mins/

1. Test your SQL skills.html

.pad/

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

/.../18. Cut & Copy Files and Folder Taking Files and Folders from one location to Other/

1. Copy filefolder from one location to another location - Part 1.mp4

3. Cut file folder from one location to another location.mp4

2. Copy filefolder from one location to another location - Part 2.mp4

4. Rename File and Folder.mp4

/.../11. Advance Constraints Must for Realtime DB Testing and Interviews/

2. Foreign Key Create Reference of Primary Key.mp4

1. Primary Key Set one or more columns as Primary key(Unique + Not Null).mp4

3. Difference between Primary Key and Unique Key.mp4

/.../15. Let's Start Practical Session with very basic Unix Linux Commands/

6. All uses of CAT command Must for Practical Implementation & Interviews.mp4

2. Working with Directories - Create Directory, Move in & Move out to Directories.mp4

5. Listing files and Folders Hidden Files, List Format and Sorted Order.mp4

4. Different option to create files Blank File, File with Content, Insert Data.mp4

1. Start working with Basic Commands Current Directory, Clear Terminal & Help.mp4

3. Working with Directories - Create Multiple Directories, Delete Directory.mp4

/.../20. Introduction to Shell Scripting, Lets start Writing Shell Scripting/

5. Shell Scripting - Use Case 1 Must to Try for Every Learner.mp4

7. Update Shell Script - Printf & RANDOM.mp4

2. Write First Shell Script, Basic rules and Steps to Execute.mp4

1. Shell Scripting Introduction How to create Shell file.mp4

6. Shell Scripting - Use Case 2 Must to Try for Every Learner.mp4

4. Shell script with simple shell commands.mp4

3. How to pass user inputs to Shell Script file.mp4

/.../19. Miscellaneous commands Some rarely use but effective commands/

4. Fetch Uniq data.mp4

2. Sort File Data.mp4

1. Check File Detail.mp4

5. Basic System Commands.mp4

3. History Command.mp4

/.../22. Database Testing using JMeter - Execute Query & Validate Result/

4. Functional Validation of SELECT query Response.mp4

5. Pass parameters to Select Queries.mp4

1. Setup JDBC Driver for Database Connection.mp4

2. Setup Connection with MySQL Database.mp4

7. Convert Functional Testcase to Performance TestCase.mp4

3. Execute SELECT query on database.mp4

6. Perform DML Operations ( INSERT and UPDATE queries).mp4

/.../21. Database Testing using JMeter - Functional and Performance Testing of SQL Query/

5. Jmeter Different type of steps in Jmeter- Part 1.mp4

8. Execution order of Elements-Part2.mp4

10. First Test case in Jmeter.mp4

1. JMeter Setup Step 1 Setup Java.mp4

7. Execution order of Elements-Part1.mp4

9. Environment Walkthrough.mp4

2. JMeter Setup Step 2 Install JMeter.mp4

3. Introduction to JMeter.mp4

6. Jmeter Different type of steps in Jmeter- Part 2.mp4

4. Test Plan, Thread Group, Thread.mp4

11. Declare Variables & Use It.mp4

/.../10. Data Constraint Apply rules to columns for Data insertion and update/

1. SQL - Not Null constraint (Not allow to insert Null data into column).mp4

4. SQL - Unique Key constraint Apply rule to insert only unique data.mp4

2. Check Constraint Apply condition for data to insert of update.mp4

3. Default Constraint Apply default value to column in case not value given.mp4

/.../17. Search Data in a File This Section is also MUST for Realtime Work + Interviews/

1. What is Grep Command Search data in 1 file by giving Search String.mp4

3. Search data in all files of current directory Practical Implementation.mp4

4. Search data by ignoring case Must to be use which checking Log files.mp4

2. Search data in more than 1 file Giving Search String, Practical Implementation.mp4

5. Search Data Display Line number in front of each display line.mp4

6. Search Data Display File Name (When we are searching content in multiple file).mp4

Total files 241