The CREATE TABLE statement is used to creating a table in the provided schema. If a schema name is given, then the table will be create in the specified schema. Otherwise it will create in the current schema. The tables cannot have the same name as any existing data type in the same schema because CREATE TABLE statement automatically creates a data type that represents the composite type corresponding to one… Read More »Creating Tables in PostgreSQL
Many of the Microsoft Word document formats requires header only on the first page. There are different methods to achieve it. Some method includes insertion of section break in the first page as an additional step while other simply involves ticking a check box. Here we will cover the latter one which is simple and faster. Steps to Insert Header Only on First Page The following method works in Word… Read More »How to Insert Header Only on First Page of Ms Word document
For inserting a new field in an existing table, use the ALTER statement. The ALTER TABLE statement is used to add, delete, or modify columns in an existing table. To add a new column to an existing table, use the ADD COLUMN statement. Syntax Specify the name of the table that you want to add a new column to after the ALTER TABLE keyword and then specify the name of the new column with its data type and… Read More »Adding one or more Column in Existing Table in PostgreSQL
PostgreSQL is one of the popular object-relational database management system (ORDBMS). It was developed at the Computer Science Department at the University of California. PostgreSQL is easy to set up and install. It offers support for SQL and NoSQL. It has a great community which happy to serve you when you are facing issues while using PostgreSQL. Data Science has evolved, and while many data scientists still work with CSV files… Read More »PostgreSQL : DBMS of the Year
Alpha (α), the first Greek alphabets is one of the most commonly used Greek letters in mathematics and science. However, inserting alpha symbol in Word is not straightforward as there is not keys associated with it. So, in this blog you learn four different methods to type Alpha (α) symbol in Microsoft Word. Method 1: Math Autocorrect – The smartest way to insert Alpha To insert alpha, simply type “\alpha” and… Read More »How to insert alpha symbol in Word: 4 Methods
Degree (°) symbol is used to quantify temperature (°C or °F), angle (90°) and alcohol proof. However, typing degree symbol in Word is difficult as, there are no keyboard keys for it. In our earlier blog we have covered, four ways to type degree symbol in Word. This blog cover only the best method which will save your time and is very easy to remember. Word shortcut for degree symbol… Read More »Shortcut to type Degree Symbol (°) in Word
Greek letters delta (Upper case: Δ and Lower case: δ) is used widely in science and economics. It is the fourth letter of Greek alphabets. To type Delta in Word, there are four different ways. Methods to type Delta in Word There are four different ways to insert Delta in Word. Method 1: Math Autocorrect (Fastest) Shortcut for Delta in Word Type “\Delta” and press space to get Δ symbol.… Read More »Four methods to type Delta in Word (Δ/δ): Alt X, Alt Code, Insert > Symbols & Math Autocorrect Shortcut
Circle is one of the basic shapes that you may need. However, drawing a circle in Word and PowerPoint is not straightforward. But with the simple trick, you can quickly draw a perfect circle of any size in Word or PowerPoint. Steps to draw a Circle in Word and Power Point In the Insert Tab, click on Shapes From the drop-down list, click on Oval under Basic Shapes Left click… Read More »How to draw circle in Word or PowerPoint?
Ms Word has a feature to insert 112 arrows. Of these, we often used eight reaction arrows. This blog covers 4 different ways to insert these arrows in Ms Word. At the end, we summarize all the shortcut. Four methods to insert reaction arrows in Word Four methods to insert reaction arrows in Ms Word includes Math Autocorrect (similar to LaTeX and fastest & easiest to remember), Insert > Equations,… Read More »How to insert Reaction Arrows in Word: 4 Methods
Division sign (÷), written as a horizontal line with dot above and below it. It often incorrectly written as “/”. There are three different ways to write the correct division sign in Word. Place the cursor at the desired location and use any of the following methods. Method 1: Insert > Symbol Navigate to Insert Tab > Symbols and click on More Symbols.. to open Symbol window Select normal text… Read More »Division sign (÷) in Word and its shortcut
