Tequality Logo
  • Automation
    • Selenium WebDriver Tutorial
    • Cucumber
    • BrowserStack
    • Rest Assured
  • Testing
    • Manual Testing
    • Agile Testing
  • Database
    • SQL Fundamentals
  • API Test
    • Rest Assured
    • Postman
  • Blog
    • Machine Learning
    • HealthTech
    • Data Science
    • NLP
    • AI For Testing
    • Automation Trends
  • Automation
    • Selenium WebDriver Tutorial
    • Cucumber
    • BrowserStack
    • Rest Assured
  • Testing
    • Manual Testing
    • Agile Testing
  • Database
    • SQL Fundamentals
  • API Test
    • Rest Assured
    • Postman
  • Blog
    • Machine Learning
    • HealthTech
    • Data Science
    • NLP
    • AI For Testing
    • Automation Trends
SQL Fundamentals
Course Process
Part 1Introduction to SQL
Lecture 1Types of Databases
Lecture 2SQL Commands
Lecture 3MYSQL Data Types
Lecture 4SQL Server Data Types
Lecture 5MYSQL Setup
Part 2SQL Statements
Lecture 6SHOW Database MYSQL
Lecture 7CREATE Statement on MYSQL
Lecture 8INSERT Statement MYSQL
Lecture 9UPDATE Statement MYSQL
Lecture 10DELETE STATEMENT MYSQL
Lecture 11SELECT Statement MYSQL
Part 3SQL Clauses
Lecture 12WHERE clause MYSQL
Lecture 13DISTINCT Clause MYSQL
Lecture 14ORDER BY Clause MYSQL
Lecture 15GROUP BY Clause MYSQL
Lecture 16HAVING Clause MYSQL
Part 4SQL Operators
Lecture 17LIKE Operator in MYSQL
Lecture 18BETWEEN Operator in MYSQL
Lecture 19SQL Operators
Lecture 20IN Operator MYSQL
Part 5Aggregate Functions
Lecture 21MIN and MAX Function
Lecture 22COUNT Function
Lecture 23AVERAGE Function
Lecture 24SUM Function
Part 6JOINS
Lecture 25INNER Join
Lecture 26LEFT Join
Lecture 27RIGHT Join
Lecture 28SELF Join

COUNT Function

The COUNT() function returns the number of rows that matches a specified criterion.


Syntax
:

SELECT COUNT(column_name)
FROM table_name
WHERE condition;

Query:

SELECT count(emp_no) FROM `employees`

Output:

Count Function Example

Tester Usage Tips:

  • Validate number of records from UI to Database
Previous PartNext Part

Learn More

  • Testing
    • Automation Testing
    • Manual Testing

Explore Blogs

  • AI For Testing
  • Automation Trends
  • Data Science
  • HealthTech
  • Linux
  • Machine Learning
  • NLP
  • Uncategorized

Trending Courses

Junit tutorial
JUnit Tutorial
Created on Nov 1, 2020
Postman Tutorial
POSTMAN Tutorial
Created on Oct 10, 2020
Cucumber
Cucumber Tutorial
Created on Sep 3, 2020
BrowserStack Testing
BrowserStack
Created on Aug 15, 2020

Trending Blogs

  • Machine Learning Algorithm
  • Business Intelligence trends 2020
  • Hive Access BigData
  • HL7 Interface

Trending Tags

adt ai Algorithms API automation BI BusinessIntelligence Datascience DataVisualization healthcare healthlevel7 hl7 interfaces Linux MachineLearning MicroStrategy ML NLP PowerBI programming language python QlikSense selenese self testing Sisense software testing Spotfire Tableau testing
This is a software powered world
Copyright © 2020- All Right Reserved - TEQuality
/home/b0eee662nkt0/public_html/wp-content/plugins/goodlayers-lms/single-course-content.php