HTML
CSS
PHP
JavaScript
SQL
Bootstrap
Solidity
jQuery
Git
Chrome DevTools
C++
PythonContents
Arithmetic operators
| Operator | Definition | Example |
|---|---|---|
| + | Addition | SELECT 42 + 7; |
| - | Subtraction | SELECT 42 - 7; |
| * | Multiplication | SELECT 42 * 7; |
| / | Division | SELECT 42 / 7; |
| % | Modulus | SELECT 42 % 7; |
Comparison operators
| Operator | Definition | Example |
|---|---|---|
| = | Equal to | SELECT * FROM Products |
| > | Greater than | SELECT * FROM Products |
| < | Less than | SELECT * FROM Products |
| >= | Greater than or equal to | SELECT * FROM Products |
| <= | Less than or equal to | SELECT * FROM Products |
| <> | Not equal to | SELECT * FROM Products |
Pros Main Features
- Simplistic design (no unnecessary information)
- High-quality courses (even the free ones)
- Variety of features
- Nanodegree programs
- Suitable for enterprises
- Paid certificates of completion
Pros Main Features
- Easy to navigate
- No technical issues
- Seems to care about its users
- Huge variety of courses
- 30-day refund policy
- Free certificates of completion
Pros Main Features
- Great user experience
- Offers quality content
- Very transparent with their pricing
- Free certificates of completion
- Focused on data science skills
- Flexible learning timetable
Logical operators
| Operator | True if |
|---|---|
| ALL | All of the subquery values meet the condition |
| AND | All the conditions separated by AND are TRUE |
| ANY | Any of the subquery values meet the condition |
| BETWEEN | The operand is within the range of comparisons |
| EXISTS | The subquery returns one or more records |
| IN | The operand is equal to one of the listed expressions |
| LIKE | The operand matches a pattern |
| NOT | The condition(s) is NOT TRUE |
| OR | Any of the conditions separated by OR are TRUE |
| SOME | Any of the subquery values meet the condition |
Compound operators
| Operator | Definition |
|---|---|
| += | Add assignment |
| -= | Subtract assignment |
| *= | Multiply assignment |
| /= | Divide assignment |
| %= | Modulus assignment |
Bitwise operators
Note: while bitwise SQL operators might seem similar to the logical SQL operators, they convert integers into binary bits and then perform the operations on each of them. The result is always an integer.
| Operator | Definition |
|---|---|
| & | Bitwise AND |
| &= | Bitwise AND EQUALS |
| | | Bitwise OR |
| |= | Bitwise OR EQUALS |
| ^ | Bitwise exclusive OR |
| ^= | Bitwise exclusive OR EQUALS |
| ~ | Bitwise NOT |
