1. All topics
  2. Business
  3. Business Software and Tools
  4. Data Analysis
SQL for Testers Preview

SQL for Testers

With Dave Westerveld Liked by 4,079 users
Duration: 1h 33m Skill level: Beginner Released: 9/15/2020

Start my 1-month free trial

Course details

The SQL programming language opens the door to deeper and more efficient software testing. SQL allows testers to examine the back end of application, automate testing through scripting, and simplify and speed up data generation. This course provides a quick-start guide to database testing with SQL. Dave Westerveld shows how to choose the right tools, set up a local site, and start validating data using simple SQL table joins. Next, you can learn how to generate test data by creating, updating, and deleting table entries. Finally, learn how to test SQL queries and find bugs in transactions, implement field constraints to prevent future bugs, and use schema validation to improve the quality of your application. Plus, find out how to prevent unauthorized access to data and measure the runtime of your queries to make sure you're not impeding database performance.

Skills you’ll gain

Earn a sharable certificate

Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.

Sample certificate

Certificate of Completion

  • Showcase on your LinkedIn profile under “Licenses and Certificate” section

  • Download or print out as PDF to share with others

  • Share as image online to demonstrate your skill

Meet the instructor

Learner reviews

4.7 out of 5

1,858 ratings
  • 5 star
    Current value: 1,449 78%
  • 4 star
    Current value: 328 17%
  • 3 star
    Current value: 58 3%
  • 2 star
    Current value: 8 <1%
  • 1 star
    Current value: 15 <1%
  • Jitendra Sheliya Jitendra Sheliya

    Jitendra Sheliya

    Software Tester | Software Quality Assurance & Test Engineering

    1/5 March 14, 2024
    Buddy, at least show some proper steps to install Flask, i am not able to do the configuration with Flask.
    Helpful · Report
  • Sujana Kotike Sujana Kotike

    Sujana Kotike

    SQA Automation Engineer | Selenium | Cypress | Postman | Cloud, Web, API and Mobile Testing | ISTQB Foundation Software Testing Certified (CTFL) |…

    5/5 March 10, 2024
    The course till now is very clear and easy to understand, instructor makes the learners to involve in the course.
    Helpful · Report
  • Justin Braden CTAL-TAE Justin Braden CTAL-TAE

    Justin Braden CTAL-TAE

    Open to Sr. SDET, SDET Lead, or QA/SDET Management positions

    4/5 February 29, 2024
    While the course overall has a great structure, there are some "too simplified" scenarios that could cause issues for the less technical. For example: Having us install Python and some pip packages. I had issues with pip that I had to uncover and fix that could scare the less technical away. As well as having testers start a local server to pull up a website. There are some typos in the slides in the course and in the content titles of the course as well. A little more care in proofreading and slowing down can go a long way. In one of the challenge solutions, there was an extra join presented that wasn't needed that could cause confusion as well. One challenge has you "duplicate" data in a table even though they never went over how to do that. That's not a challenge, that's a pop quiz before being taught, which is very annoying.
    Helpful · Report

Contents

What’s included

  • Practice while you learn 1 exercise file
  • Test your knowledge 4 quizzes
  • Learn on the go Access on tablet and phone

Similar courses

Download courses

Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.

Download on the App Store Get it on Google Play