Course Content

Introduction to PHP

10m 23s

Understanding SDLC Process

13m 58s

Client Server Architecture

5m 18s

How to set up PHP Environment?

18m 6s

Understanding HTTP Methods

33m 26s

Understanding PHP Program structure Comments in PHP

13m 7s

Variables in PHP

11m 46s

Arithmetic & Assignment Operators in PHP

24m 28s

Comparison & Logical Operators in PHP

33m 17s

Ternary Operator in PHP

14m 38s

Assignment : Operators

1m 22s

Super Global Variable in PHP

19m 30s

GET & POST Variable in PHP

12m 21s

$_FILES & $_ENV in PHP

15m 24s

Assignment : Super Global Variables

2m 16s

If-else in PHP

26m 25s

switch case in PHP

15m 2s

Assignment : Conditional Statements

2m 28s

Functions in PHP

39m 46s

Call by value vs Call by reference in PHP

17m 28s

Assignment : Functions

5m 25s

Array Functions in PHP

44m 28s

Array in PHP

19m 35s

Assignment : Array

7m 18s

String and its Functions in PHP

27m 53s

Assignment : String

3m 44s

Loops in PHP

19m 28s

More examples on Loops in PHP

17m 20s

Assignment : Loops

8m 32s

Cookies in PHP

15m 45s

Session in PHP

35m 42s

Header Function in PHP

17m 11s

Assignment : Header Functions

1m 57s

Date and Time functions in PHP

36m 14s

Assignment : Date Time Functions

4m 29s

Include & Require Statement in PHP

13m 52s

Error Handling in PHP

15m 18s

File Upload in PHP

42m 55s

Database Connection in PHP Part 1

29m 17s

Database Connection in PHP Part 2

32m

SQL Injection in PHP

30m 33s

Crud - Registration and DB connection Part 1

31m 31s

Crud - Registration and DB connection Part 2

24m 2s

Log in Operation

27m 25s

Read Operation

30m 27s

Update Operation Part 1

12m 53s

Update Operation Part 2

27m 17s

Log out Operation

9m 29s

MySQL Interview Question 1

33m 7s

MySQL Interview Question 2

25m 23s

MySQL Interview Question 3

24m 27s

PHP Course For Beginners

MY SQL with PHP In & NOt in Condition

Enroll Now For Free
Previous Next
Discussion
Previous Discussion Next
Previous
Next

Course Content

Introduction to PHP

10m 23s

Understanding SDLC Process

13m 58s

Client Server Architecture

5m 18s

How to set up PHP Environment?

18m 6s

Understanding HTTP Methods

33m 26s

Understanding PHP Program structure Comments in PHP

13m 7s

Variables in PHP

11m 46s

Arithmetic & Assignment Operators in PHP

24m 28s

Comparison & Logical Operators in PHP

33m 17s

Ternary Operator in PHP

14m 38s

Assignment : Operators

1m 22s

Super Global Variable in PHP

19m 30s

GET & POST Variable in PHP

12m 21s

$_FILES & $_ENV in PHP

15m 24s

Assignment : Super Global Variables

2m 16s

If-else in PHP

26m 25s

switch case in PHP

15m 2s

Assignment : Conditional Statements

2m 28s

Functions in PHP

39m 46s

Call by value vs Call by reference in PHP

17m 28s

Assignment : Functions

5m 25s

Array Functions in PHP

44m 28s

Array in PHP

19m 35s

Assignment : Array

7m 18s

String and its Functions in PHP

27m 53s

Assignment : String

3m 44s

Loops in PHP

19m 28s

More examples on Loops in PHP

17m 20s

Assignment : Loops

8m 32s

Cookies in PHP

15m 45s

Session in PHP

35m 42s

Header Function in PHP

17m 11s

Assignment : Header Functions

1m 57s

Date and Time functions in PHP

36m 14s

Assignment : Date Time Functions

4m 29s

Include & Require Statement in PHP

13m 52s

Error Handling in PHP

15m 18s

File Upload in PHP

42m 55s

Database Connection in PHP Part 1

29m 17s

Database Connection in PHP Part 2

32m

SQL Injection in PHP

30m 33s

Crud - Registration and DB connection Part 1

31m 31s

Crud - Registration and DB connection Part 2

24m 2s

Log in Operation

27m 25s

Read Operation

30m 27s

Update Operation Part 1

12m 53s

Update Operation Part 2

27m 17s

Log out Operation

9m 29s

MySQL Interview Question 1

33m 7s

MySQL Interview Question 2

25m 23s

MySQL Interview Question 3

24m 27s

In & NOt in Condition

SQL is the most important language for any developer. It is used in all the major industries and applications. But, there are some quirks at play in SQL that can cause difficulties to developers.
Show More Hide

FAQs

SQL is a common language for database management. It is very useful for many applications in digital businesses, but it has some limitations when compared with the native languages of the database. The table "condition" in MySQL can be used to describe conditions that are used to compare two values. For example, "a>5" means that if value A is greater than 5 then value B must be greater than 5. As an example of using condition with SQL, let’s say you want to perform arithmetic using only numbers between 0 and 10:

There was a time when SQL was the king of databases. It was used by many people and companies to store data, manipulate it and run multiple operations, but as technology moved forward and computers became more powerful, SQL became outdated. It didn't help that the language itself has been replaced with newer ones such as Java or C++. The other problem is that we cannot find an easy way to create a new database configuration for our application without having to learn brand new programming languages like C# or Ruby on Rails. SQL is still useful if you need something like: Create queries that work against certain data structures (for example: tables) rather than specific fields; Get information from certain tables; Maintain complex indexes; Find all values in specific fields; Retrieve information from other databases.

We can nest the above query to find the second largest salary. select *from employee group by salary order by salary desc limit 1,1; There are other ways : SELECT name, MAX(salary) AS salary FROM employee WHERE salary IN (SELECT salary FROM employee MINUS SELECT MAX(salary) FROM employee);

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
App Store
397K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
13K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere