Database Testing Using SQL Queries/MS Access

This course demonstrates on how to master database testing and SQL queries in MS Access database.
4.5 (10 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
393 students enrolled
Instructed by QAEversity . Development / Databases
$20
Take This Course
  • Lectures 9
  • Contents Video: 1.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2014 English

Course Description

This course demonstrates all the basic and advanced level concepts including SQL introduction, MS Access overview, Creating a small database in MS Access, Writing SQL queries, different SQL clauses, updating/deleting databases, SQL Joining and joining multiple tables. This is a total package to make you an expert database tester and SQL query writer. Just like our other courses, most of the videos in this course are free and available for preview. SQL has become essential for QA professionals in today’s market. In this course, our team tried to make SQL look pretty easy so that you can master the key concepts. This course demonstrates hands-on use of SQL instead of going over theories. This course should make you an expert in writing SQL queries within any types of databases. Whether you are new to the database industry or a software tester, understanding SQL has become essential in today's competitive market. Also, today's software testing industry requires extensive use of SQL as the demand of database testing is booming everyday. Moreover, this can be your starting point to become a database developer or administrator. The best thing about SQL is that it is used in all types of industry as a standard database language and you can take this knowledge to work with any types of databases including SQL Server, Oracle, MS Access, and MySQL. If you always wanted to learn database testing or if you need to extract important data from your database then this is the right course for you. This course takes a project based approach to make database testing look easy. Take your skills to the next level. If you are passionate about learning SQL and explore database, then let's enroll and dig in to the next level to master SQL and database testing using MS Access databases.

What are the requirements?

  • No prior SQL experience required
  • No prior MS Access database experience needed

What am I going to get from this course?

  • Master database testing using SQL and MS Access
  • Become an expert in writing SQL queries

What is the target audience?

  • Beginners in the database industry should take this course
  • Software testers should take this course

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
What is SQL
Preview
11:13
Writing SQL queries
Preview
11:10
SQL Where clauses
11:41
Section 2: Mid-level
And/Or clauses
07:52
Order By/Update/Delete database
07:53
Primary Key VS Foreign Key
04:28
Section 3: Advanced
Joining Tables
06:10
LEFT/RIGHT JOIN
11:33
Joining more than two tables- complex queries
11:00

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

QAEversity ., Become an expert IT Professional

About the Company:

QAEversty is a New York based IT training company that specializes in IT and Software Testing. Our team of instructors are committed to create an excellent learning experience for users that can be both affordable and easily accessible. We are focused to make software testing concepts much more easier to the audience and produce expert software test professionals.

Additional details as requested:

As one of the leading instructor and CEO of QAEversity, I am Rayan Khan, always focused on developing better learning environment for students. My expertise developed over time with bachelors and masters degrees in Information Systems Management from State University of New York (SUNY) and Devry University. I have over 5 years of experience in working as a senior software engineer and instructor in top power management and insurance companies. Since its inception, QAEversity has got very good response and popularity among software testing communities and professionals. Thousands of students from over 110 countries around the world are already taught through our website and YouTube channel. Please note that we have a team of instructors for developing different courses with expertise and this is why we are signing up with the company name. We look forward to work with Udemy.

Ready to start learning?
Take This Course