Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

Friday, 6 October 2017

SQL Sample Database ~ niit post

  • Our Sample Database is a modernized version of Microsoft's Northwind.
  • The data model is kept simple and comes with only 5 tables.
  • You can play with a live database in our SQL Sandbox.
  • Or download our script and create your own sample database (model + data).








Sample Database ERD






ERD diagrams are an important tool for data professionals: they provide a wealth of information. 
This ERD displays tables, columns, data types, relationships, primary keys, foreign keys, and indexes.
Read More »

Tuesday, 4 July 2017

Top keywords ~ NIIT POST

FOUND JAVA
MKNIIT
NIIT POST
GNIITHELP
GNIITSOLUTION
KAMALNIIT
NIITLABS
JAVATPOINT
JAVATUTORIAL
JAVAONLINE
HTMLCODE
JAVADESK
JAVAHOME
JAVATUTORIALPOINT
ALEXA
BLOGGER
GOOGLE
TWITTER
FREE BACKLINKS
SUBMIT BLOG FREE
25 WAY TO INCREASE TRAFFIC
WEBSITE TRAFFIC
CODEPOINT
HTML
SQLHELP
SQLSTUDY
CSHARP
RUBY TUTORIAL
RUBY HELP
FOUND RUBY
BLOG TRAFFIC
WEBSITE TRAFFIC
WORDPRESS SITE
FREE SITE CREATE
PING MY URL
PING WEBSITE URL
PING BLOG URL
PYTHON PHP
JAVA
ORACLE
DATA STRUCTURE
OPERATING SYSTEM
MONGODB
CODECADEMY
FIRST CODE ACADEMY
IMDB
CODE SCHOOL
JAVA SCRIPT
.NET
PHP
GEEKSFORGEEKS
HACKERRANK
JAVA COFEE
JAVA SCHOOL
W3SCHOOLS
LEARN JAVA ONLINE

Read More »

Popular Blogs 2017 ~ NIIT POST

TOP JAVA BLOGS



TOP C++ BLOGS


TOP RUBY BLOGS
http://foundruby.blogspot.in/


TOP SERVLET BLOGS


TOP EXCEL BLOGS


TOP OPERATING SYSTEM BLOGS
http://foundosc.blogspot.in/


TOP MONGO DB BLOGS
TOP MIT APP INVENTER BLOGS


TOP MAVEN BLOGS


TOP JSP BLOGS


TOP JENKINS BLOGS


TOP GITHUB BLOGS


TOP DROOLS BLOGS



TOP DATA STRUCTURE BLOGS


TOP COMPUTER NETWORK BLOGS


TOP C LANGUAGE BLOGS


TOP NIIT BLOGS



Read More »

Viewing Slides in Powerpoint ~ NIIT POST

Viewing Slides

Once you create the presentation you can view it in different ways.
Select the View tab. Locate the Presentation Views group. It displays four options to view presentations; Normal View, Slide Sorter View, Slide Show View and Notes Page View.
Normal View: The normal view appears by default when we open the PowerPoint window. We create and edit slides in Normal View. This view also offers three view options out of four options in the form of buttons on the status bar.
See the image:
MSpowerpoint Viewing slides 1Slide Sorter View: It offers miniature or thumbnail version of all slides. You can see all your slides at one time in the screen. You can also drag or delete the slides to rearrange them.
See the image:
MSpowerpoint Viewing slides 2Slide Show View: It displays your presentation in full screen mode. It also offers an additional menu at the left bottom corner of the slide.
See the image:
MSpowerpoint Viewing slides 3Notes Page View
This view provides space below the slide to add notes.
See the image:
MSpowerpoint Viewing slides 4
Read More »

How to Advance Slides in Powerpoint ~ NIIT POST

How to Advance Slides

  • Select the slide
  • Select the Animations tab
  • In Transition to This Slide group locate the Advance Slide section
  • It shows two options; On Mouse Click and Automatically After
  • Enter the desired time for the selected slide in Automatically After option
  • Select the next slide and choose the desired time
  • Click Apply To All If you want to apply the same timing to all slides
See the image:
MSpowerpoint How to advance slides 1
Read More »

How to Set Slide Transition Speed in Powerpoint ~ NIIT POST

How to Set Slide Transition Speed

  • Select the slide
  • Select the Animation tab
  • In Transition to This Slide group click the drop-down arrow next to Transition Speed option
  • It will display three options for transition speed
  • Select the desired transition speed
  • Click Apply To All to apply the same transition speed to all slides
See the image:
MSpowerpoint How to set transition speed 1
Read More »

How to Apply Animation Effect in Powerpoint ~ NIIT POST

How to Apply Animation Effect

  • Select the text or object you want to animate
  • Select the Animations tab
  • In Animations group click the drop-down arrow next to Animate option
  • Animation options will appear
  • Move the cursor over different options to see live preview on the slide
  • Select the desired animation
See the image:
MSpowerpoint How to apply animation effect 1
Read More »

How to Insert Chart in Powerpoint ~ NIIT POST

How to Insert Chart

  • Select the Insert tab
  • In Illustrations group click on Chart command
  • An Insert Chart dialogue box appears
  • Select the desired Chart style and click Ok
  • Chart will be added to slide and an Excel worksheet appears on right side of the slide
See the images:
MSpowerpoint How to insert chart 1 MSpowerpoint How to insert chart 2

Read More »

How to Insert Table from Word or Excel in Powerpoint ~ NIIT POST


  • Open the desired word document or Excel spreadsheet you want to insert
  • Select and copy it
  • Then place the cursor on the PowerPoint slide where you want to paste it
  • Select Home tab and click the Paste command
  • Read More »

    How to Cut and Paste Text in Powerpoint ~ NIIT POST

    How to Cut and Paste Text

    • Select the text you want to cut
    • In Home tab click the Cut command in Clipboard group
    • Place the cursor where you want to paste the text
    • In Clipboard group click the Paste command
    See the image:
    MSpowerpoint How to cut and paste text 1
    Read More »

    Insert a Text Box in Powerpoint ~ NIIT POST

    How to Insert a Text Box

    In addition to placeholders you can insert text boxes in the slide. To add a text box follow the below listed steps.
    • Open the Insert tab
    • In Text group click the Text Box command
    • Click on the slide and drag the cursor until text box takes the desired width
    • Then release the mouse
    See the image:
    MSpowerpoint How to insert a text box 1
    You can move and resize the text box. To move the text box click in the box and drag the mouse to the desired location.
    See the image:
    MSpowerpoint How to insert a text box 2
    To resize the text box click the circle or square sizing handles of text box and drag the mouse to give it desired size.
    See the image:
    MSpowerpoint How to insert a text box 3

    Read More »

    Format Font Style in Powerpoint ~ NIIT POST

    How to Format Font Style

    • Select the text you want to modify
    • Select Home tab and locate the Font group
    • In Font group click the drop-down arrow next to font style option
    • A list of font styles appears
    • Move the cursor over the list and select the desired font style
    See the image:
    MSpowerpoint How to format font style 1
    Read More »

    Format Font Size in Powerpoint ~ NIIT POST

    How to Format Font Size

    • Select the text you want to modify
    • Open the Home tab and locate the Font group
    • In Font group click the drop-down arrow next to font size option
    • A list of various font sizes appears
    • Move the cursor over the list and select the desired font size
    See the image:
    MSpowerpoint How to format font size 1

    Read More »

    Delete Text in Powerpoint ~ NIIT POST

    How to Delete Text

    Two simple ways to delete text are:
    • Place the cursor next to the text then press the backspace key, as the cursor moves left it starts deleting text.
    • Keep the cursor next to text then left click the mouse and without releasing the mouse drag it over the text to select it. Then press the Delete key.
    Read More »

    Change Color in Themes in Powerpoint ~ NIIT POST

    How to Apply or Change Color in Themes

    • Open the Design tab
    • Click the drop-down arrow next to Colors in the Themes group
    • With a left click select the desired color set
    • To create new color set click the Create New Theme Colors
    See the image:
    MSpowerpoint How to apply or change color in themes 1
    Read More »

    Add Slide in Powerpoint ~ NIIT POST

    How to Add Slide

    There are multiple ways to add slide in PowerPoint presentation. The frequently used option is to click the New Slide button.
    See the image:
    MSpowerpoint How to add slide 1
    The other ways to add a slide are: Office Themes, Duplicate Selected Slide and Reuse Slides.
    1) Using Office Themes to add slide:
    • Select the slide next to which you want the new slide to appear
    • In Home tab, click the drop-down arrow on the New Slide button
    • It will display the office themes
    • Select the slide choice that suits your requirement
    See the image:
    MSpowerpoint How to add slide 2
    2) Using Duplicate Selected Slide option to add slide:
    • Select the slide you want to duplicate
    • In Home tab, click the drop-down arrow of New Slide button
    • Left click the Duplicate Selected Slide
    See the image:
    MSpowerpoint How to add slide 3
    3) Using Reuse Slides option to add slide:
    • Select the slide next to which you want the new slide to appear
    • In Home tab, click the drop-down arrow of New Slide button
    • Select the Reuse Slides option
    • Click on Browse then click on Browse File
    • Select the slide from the presentation that you want to import
    See the images:
    MSpowerpoint How to add slide 4 MSpowerpoint How to add slide 5

    Read More »

    Save a Presentation in Powerpoint ~ NIIT POST

    How to Save a Presentation

    There are multiple options to save a presentation. The frequently used options are:
    • Click on the Microsoft Office Button then select Save or Save As from the menu.
    • See the image:
      MSpowerpoint How to save a presentation 1
    • Click on the first icon MSpowerpoint How to save a presentation 2of the Quick Access Toolbar.
    Read More »

    Mini Toolbar ~ NIIT POST

    Mini Toolbar

    It is a floating toolbar that appears when you select text or right click the text. It comprises frequently used formatting tools like Bold, Italics, Font Size and Font Color.
    See the image:
    MSpowerpoint Mini toolbar 1
    Read More »

    Features of the Tabs ~ NIIT POST

    Features of the Tabs

    The features of Home tab are Clipboard, Slides, Font, Paragraph, Drawing and Editing.
    See the image:
    MSpowerpoint Features of the tabs 1
    The features of Insert tab are Tables, Illustrations, Links, Text and Media Clips.
    See the image:
    MSpowerpoint Features of the tabs 2
    The features of Design tab are Page Setup, Themes and Background.
    See the image:
    MSpowerpoint Features of the tabs 3
    The features of Animations tab are Preview, Animations and Transition to This Slide.
    See the image:
    MSpowerpoint Features of the tabs 4
    The features of Slide Show tab are Start Slide Show, Set Up and Monitors.
    See the image:
    MSpowerpoint Features of the tabs 5
    The features of Review tab are Proofing, Comments and Protect.
    See the image:
    MSpowerpoint Features of the tabs 6
    The features of View tab are Presentation Views, Show/Hide, Zoom, Color/Grayscale, Window and Macros.
    See the image:
    MSpowerpoint Features of the tabs 7

    Read More »