A PostgreSQL cheat sheet is a quick reference guide that provides a summary of commonly used commands and operations in PostgreSQL, a powerful open-source relational database management system. It typically includes essential SQL commands, psql (PostgreSQL command-line tool) commands, and other useful information for database administrators and developers working with PostgreSQL. SELECT Query SELECT col1,
PostgreSQL Cheat Sheet – Pedagogy Zone Read More »
A MySQL cheat sheet is a quick reference guide or document that provides a summary of the most important and commonly used commands and syntax in MySQL, a popular open-source relational database management system. It’s a handy resource for developers, database administrators, or anyone working with MySQL databases who wants a quick reminder of key
MySQL Cheat Sheet – Pedagogy Zone Read More »
An SQL Server Cheat Sheet is a quick reference guide or document that provides concise and handy information about SQL Server commands, syntax, and commonly used queries. It’s a helpful resource for database administrators, developers, or anyone working with SQL Server databases who wants to quickly look up commands or refresh their memory on how
SQL Server Cheat Sheet – Pedagogy Zone Read More »
here’s a basic cheat sheet for Oracle SQL SELECT Query SELECT col1, col2 FROM table JOIN table2 ON table1.col = table2.col WHERE condition GROUP BY column_name HAVING condition ORDER BY col1 ASC|DESC; SELECT Keywords DISTINCT: Removes duplicate results SELECT DISTINCT product_name FROM product; BETWEEN: Matches a value between two other values (inclusive) SELECT product_name FROM
Oracle SQL Cheat Sheet – Pedagogy Zone Read More »
Tech companies nowadays are looking for candidates with experience in object-oriented techniques and patterns, and they are holding interviews for those candidates. Hiring such personnel has the benefit of allowing them to simply pick up other OOP languages in accordance with organisational needs. As a result of reading this part, you can improve your chances
Object Oriented Programming (OOPs) Interview Questions Read More »
The sum of the moments of all the forces across the areas of all the filaments about the neutral axis, when a beam is bent is called the bending moment. When the beam is in equilibrium position the bending moment will be equal to the restoring couple or the moment of resistance of the bending.
Expression for Bending Moment of a Beam Read More »
When a wire is stretched, the length of the wire will increase. At the same time, the wire will become thinner, that is, there is a decrease in the cross section of the wire. The ratio of change in diameter of the wire to the original diameter of the wire is known as lateral strain.
Poisson’s Ratio (σ) – Pedagogy Zone Read More »
Effect of stress It is known that the action of large constant stress or the repeated number of cycles of stresses acting on a body decreases the elasticity of the body gradually. Taking these into account, the working stress on an engineering piece is kept far below its ultimate tensile strength. Effect of temperature Normally
Factors Affecting Elasticity – Physics Read More »
There are three types of modulus based on different kinds of strain. They are Young’s modulus (Y) (corresponding to longitudinal strain) Bulk modulus (K) (corresponding to volume strain) Rigidity modulus (N) (corresponding to shear strain) Young’s modulus (Y) Young’s modulus of the materials of the wire is defined as the ratio of longitudinal stress to
Three Types of Moduli Elasticity – Physics Read More »
Imagine a wire to be suspended from a rigid support and carrying a hanger on which suitable weights could be placed to study the behaviour of the wire under conditions of different loads. The extensions of the wire are suitably measured and thus stress and strain for the given wire is calculated. Now, if we
Stress – Strain Diagram Read More »