{Learn-Intern-Certify}©

How to use rownum correctly in Oracle SQL ? by Rocky Jagtiani Oracle Certified Associate I train on Oracle Certification from last 7 years This is one such question , which freshers face a lot at on+off-campus interviews. The concept of rownum is quite simple. For each row returned by a query, the ROWNUM pseudocolumn returns a number indicating the order in which Oracle selects the row from a table or set of joined rows. The first row selected has a ROWNUM of 1, the second has 2, and so on. You can use ROWNUM to limit the number of rows returned by a query, as in this example: SELECT employee_id, first_name FROM Top_N_employees WHERE ROWNUM < 10; You would notice only 9 rows (as the condition is < 10). Contents : [ 20 mins read & execute ] 1> How to use rownum ? 2> Where not to use rownum ? 3> Face the most common interview question. For beginners, who wish get the schema and records of my test table : Top_N_employees , do see...

About : Adobe After Effects is a software program that allows its users to create animation and other special effects for graphic-related projects. Graphic designers use it to provide their projects with layer-based animation. After Effects is part of the Adobe family of software and is compatible with other Adobe software. Index 1. Creating a New Composition and Importing Files 2. Building a Composition with Layers 3. Adding Animations, Effects, and Preset 4. Previewing and Rendering Your Composition  1. Creating a New Composition and Importing Files I. Make and set up a new composition.  Projects in Adobe After Effects are called compositions, or comps. At the Welcome screen, locate and click on the “New Composition” button in the right column. If you already have the program open, you may either click on the “Composition” tab and select “New Composition” or use the keyboard shortcut Ctrl+N. Every time you create a new composition, a...

About Adobe After Effects : Adobe After Effects is a digital visual effects, motion graphics, and compositing application developed by Adobe Systems and used in the post-production process of film making and television production. Among other things, After Effects can be used for keying, tracking, compositing and animation. It also functions as a very basic non-linear editor, audio editor and media transcoder. After Effects CC (2015) system requirements : Windows : Intel Core2 Duo or AMD Phenom II processor with 64-bit support Microsoft Windows 7 with Service Pack 1, Windows 8, or Windows 8.1 8 GB of RAM (16 GB recommended) 5 GB of available hard-disk space; additional free space required during installation (cannot install on removable flash storage devices) Additional disk space for disk cache (10 GB recommended) 1280 x 1080 display OpenGL 2.0-capable system QuickTime 7.6.6 software required for QuickTime features Optional: Adobe-certified GPU card for GPU-accelerated ray-traced 3D...

Photoshop is Adobe's photo editing, image creation and graphic design software. The software provides many image editing features for raster (pixel-based) images as well as vector graphics. It uses a layer-based editing system that enables image creation and altering with multiple overlays that support transparency. Layers can also act as masks or filters, altering underlying colors. Shadows and other effects can be added to the layers. Photoshop actions include automation features to reduce the need for repetitive tasks. An option known as Photoshop CC (Creative Cloud) allows users to work on content from any computer. Photoshop been the industry standard image manipulation program for so long that its name has become a verb: It is common parlance to say that an image has been “photoshopped” or even just “shopped." Shopped, in this context, is synonymous with edited, manipulated or faked --  often regardless of the software actually used.  Photoshop is used by pho...

Logo is the most important asset of a company. Logo represents your  company. The dictionary meaning of a logo is a symbol, sign, or emblem. Human beings have used such symbols throughout time to convey a succinct message. In present times, logos tend to be graphical in nature, designed for easy recognition of an organization. It is a tool to build an identity for the organization, as part of its trademark or brand, and to generate favourable thoughts and feelings about the organization.   A logo needs to be original and memorable for the greatest impact.  A logo refers to an image that relates to a company. For example, the image to the right, is an example of the Suven Consultants logo. Features of a Corporate Logo Identify Target Market What type of customers are you trying to attract? The success of your company's branding efforts will rely on the customers you are pursuing. Trendy graphics and hip hop music may attract the younger consumer,...

Are you currently sitting at your desk, with your head in your hands, unsure whether you're in the  right place? or  “did you take a wrong turn in your career?”  are the kinds of ideas most job search websites build their promotional strategy upon. Similarly, career blogs and HR journals are also brimming over with write-ups on the same theme. This is actually a very effective tactic which appeals to hundreds of employees who think that they might have made a false move in picking out current career. Convinced by this idea, more and more professionals become restless in their respective jobs, leading to a counter-productive working condition which becomes harmful for them. So for the people engrossed in a career dilemma, the following write-up will explore different aspects of a so-called ‘wrong career choice’ and if it is really that wrong for your overall professional life. Did you really make a wrong turn? Before getting into the debate about the said topic...