Topic 0 : Before we begin

50 %
50 %
Information about Topic 0 : Before we begin

Published on November 24, 2013

Author: PradipKharbuja


DATABASE Er. Pradip Kharbuja

Knowledge without memory is meaningless.

Module Database : Exam Pattern  Global Exam : 75%  Global Assignment : 25%

Module Database : Software  MySQL  Oracle  SQL Server

Excel Interface

SQL Server Interface

Excel vs Databse Excel Filename Sheet Name Column Name Database Database Name Database Table Name Database Field / Column

Database Table : departments dept_no 1 2 3 4 department_name Packing Account Human Resources Research location Cairo Lagos London INSERT INTO departments VALUES (1, 'Packing', 'Cairo'); INSERT INTO departments VALUES (4, 'Research'); INSERT INTO departments (dept_no, department_name) VALUES (4, 'Research');

Updating Data  UPDATE departments SET location = 'Nepal';  UPDATE departments SET location = 'Nepal' WHERE dept_no = 4;  UPDATE departments SET location = 'Nepal', department_name = 'Information Technology' WHERE dept_no = 4;

Deleting Data  DELETE FROM departments;  DELETE FROM departments WHERE dept_no = 1;

Selecting Data  SELECT * FROM departments;  SELECT dept_no, department_name FROM departments;  SELECT location, department_name FROM departments;  SELECT * FROM departments WHERE dept_no = 2;

Add a comment

Related presentations

Related pages

MaGLX2 - 0 - before we begin - YouTube

MaGLX2 - 0 - before we begin raocow. Subscribe Subscribed Unsubscribe 28,477 28K. ... 169 0. Don't like this video? Sign in to make your opinion ...
Read more

How Long Before a Move Should We Begin Making Preparations ...

How Long Before a Move Should We Begin Making Preparations? ... 0. Spice Down × Confirm ... Are you sure you would like to put this topic into moderation?
Read more

Before We Begin - YouTube

16 0. Don't like this video? Sign in to make your opinion count. ... Before We Begin · Martin Courtney Many Moons ℗ 2015 Domino Recording Co ...
Read more

Research Preparation - California State University, Los ...

Research Preparation Things to do Before Starting Library ... Select a Research Topic ... we recommend that you begin by selecting an appropriate broad ...
Read more

How to Research a Topic: 9 Steps (with Pictures) - wikiHow

How to Research a Topic. ... you can start with just looking into information about Hamlet before you narrow it down to ... Begin Writing a Research ...
Read more

Asking Good Questions - Learning Historical Research

It can be difficult to select a research topic. You may feel unsure of where to begin, ... Before you can begin ... Historical research is constantly ...
Read more

Choosing a Topic - Claremont Graduate University: Welcome ...

Choosing a Topic. Choosing a topic poses a major ... broad topic we want ... have said on a topic. Then, you can begin to determine if the topic ...
Read more

Purdue OWL: Research Papers

Purdue OWL; Writing Lab; OWL News; Engagement; Research; ... Where do I begin? ... topic, and audience, ...
Read more

introduction (essays and speeches) - English Grammar ...

An introduction is the opening of an essay or speech. Typically it identifies the topic, ... before we begin to speak or write, ...
Read more