Learn Complete Testing (Manual+SQL+Unix+Rally+JIRA+AGILE)

Explore different testing types and their role in validating system functionality and essential specifications, using practical methods to ensure quality across projects.

Explore static testing and dynamic testing, their techniques, challenges such as false positives, and the role of automation in software testing.

Explore the software testing life cycle from requirements to planning, design, and execution, highlighting estimation, environment setup, and how each stage aligns with testing goals.

Learn the software development life cycle (SDLC) and its stages from planning and design to building and testing, with a focus on the waterfall model.

Define the defect life cycle and the defect format, including status, severity, assignment, fixes, reopenings, duplicates, and resolutions, to streamline testing workflows.

Explore black box testing techniques, including partitioning, boundary value analysis, and state transitions, guided by specification documents and practical error guessing for complete testing workflows.

Discover a practical test case format aligned with a test plan, detailing how to describe functionality, name tests, outline step-by-step actions, specify expected results and status, and consider security levels.

Explore various testing types and practical functional testing techniques, including GUI, usability, installation, sanity, and system testing, to ensure application behavior aligns with requirements.

Explore non-functional testing types, from performance testing to load and stress testing, and ensure applications meet speed, availability, accessibility, and documentation standards across platforms and environments.

Navigate the Rally team dashboard to access backlog, user stories, and reports. Learn to update statuses, add comments, and customize views to monitor sprint progress.

Create and manage a user story in Rally using the plan board and backlog. Define acceptance criteria, attach requirements, and move stories through milestones toward completion.

Learn how to create releases and iterations in rally, set time boxes and milestones, and manage project cycles to align team efforts across groups.

Log in to the rally dashboard using your email as username and password, receive the login email, and explore the dashboard for test management and customization.

Explore how to execute Rally test cases from the test cases window, expand the window to display all available test items, and select appropriate options for efficient test execution.

Create test cases in Rally's team dashboard, define preconditions and the expected result, and align testing with manual or automatic approaches for clear, actionable workflows.

Explore how sql joins work to combine data across tables, including left joins and right joins, and learn how unmatched rows yield nulls while matching records drive results.

Learn how to perform update and delete operations in MySQL, using update with set to change values by employee ID or name, and applying where conditions to target specific records.

Explore how delete, drop, and truncate commands affect SQL tables and databases, including removing data, dropping objects, and handling empty sets.

Learn to use aggregate functions in SQL to summarize data, such as calculating the minimum, maximum, and average salaries from an employee table.

Identify differences between two MySQL tables by extracting distinct values, finding records present in one table but not the other, and handling duplicates with left joins and unions.

Learn to get the 11th highest salary across SQL, Hive, and MySQL using top or limit with offset, and review inner, left outer, and right outer joins.

practice on-site login and navigation using the Lyceum app, enter your email to start, and use the left-side options to access and configure on-site tasks.

Explore how to create a defect in JIRA by turning a user story into a tracked issue, assigning it to the right person, and prioritizing work when it isn’t working.

Discover how to search tickets in a JIRA dashboard, filter by assignee and status, and navigate backlogs and open issues to track progress.

Learn to create users and groups in the Zeina dashboard, invite new users by email, and manage groups using search and sign-up options.

Explore the agile model's emphasis on the requirements, customer satisfaction, iterative development, and delivering valuable software through continuous testing and flexible cycles.

Testers collaborate with development in agile, gather information from the team, and emphasize facts over guesses, ensuring transparency, feedback, and consideration of legal aspects throughout the cycle.

Explore team events in the agile model and how teams cycle through the described cycle.

Explore Agile test strategy by tracing planning from the planning meeting through high-level planning, sprint planning, milestones and estimation, to documenting requirements and managing defects and releases.

Learn agile basics by exploring backlog management, stories, and requirements, and understand how iterations and flow drive planning and delivery in agile projects.

Learn how to copy and move files in Unix, practice moving between directories, verify success, and understand common issues.

Learn to use head and tail in unix to display the first or last lines of a file, control the number of lines shown, and apply through practical line-selection examples.

Explore how the more and less commands in Unix let you view and scroll text, navigate content with up and down keys, and adjust line wrapping for flexible reading.

Learn to perform arithmetic in Unix shells by adding and subtracting numbers, using variables with dollar signs, and evaluating expressions in shell scripts.

Learn how to use the sed command in Unix to replace words, modify lines by number, and perform line-by-line edits with practical examples.