Monday, December 22, 2008
gmat blogs
http://outbeat-the-gmat.blogspot.com/2007/04/guide-to-buy-gmat-books-and-preparation.html
Sunday, December 21, 2008
online learning web site links
http://www.awsurveys.com/Main.cfm
http://www.vindale.com/v/join2.jsp?cid=3000&s1=3000&s2=6699&FiliAff=6699&sid=filitrack
http://www.mypoints.com/emp/u/mypoints.vm?AID=10468488&PID=1900080&campaign=4sAxwGrYrpdGTsbJ3DzR
http://media303.com/
http://www.paidgameplayer.com/admin/landing.aspx?a=8502/CD3160&refstr=
http://mindfieldonline.com/affiliate/af/MjM2|
http://www.vindale.com/v/join2.jsp?cid=3000&s1=3000&s2=6699&FiliAff=6699&sid=filitrack
http://www.mypoints.com/emp/u/mypoints.vm?AID=10468488&PID=1900080&campaign=4sAxwGrYrpdGTsbJ3DzR
http://media303.com/
http://www.paidgameplayer.com/admin/landing.aspx?a=8502/CD3160&refstr=
http://mindfieldonline.com/affiliate/af/MjM2|
Monday, December 01, 2008
FILM INSTITUTE LINKS
http://rabikisku.blogspot.com/2008/11/filmmaking-104-comprehensive-filmmaking.html
Sunday, November 30, 2008
GOVERNMENT LINKS
Academics
University Grants Commission - www.ugc.ac.in
• Central Board Of Secondary Education - www.cbsc.nic.in
• Delhi University - www.du.ac.in
• Jawaharlal Nehru University - www.jnu.ac.in
• National Council for Teacher Education - www.ncte-in.org
• National Council for Educational Research & Training - www.ncert.nic.in
• Ministry of HRD (Education) - www.education.nic.in
Aviation
• Directorate General of Civil Aviation - www.dgca.nic.in
• IATA training - www.iata.org
• Ministry of Civil Aviation - www.civilaviation.nic.in
• Indira Gandhi Rashtriya Uran Akademi - www.igrua.gov.in
Banking
• Reserve Bank of India - www.rbi.org.in
• State Bank of India - www.statebankofindia.com
• Panjab National Bank - www.pnbindia.com
• Corporation Bank - www.corpbank.com
Civil - Services
• Union Public Service Commission - www.ugc.gov.in
• Staff Selection Commission - www.ssc.nic.in
• Department of Personal & Training - www.dopt.nic.in
Defence
• National Defence Academy - www.nda.nic.in
• Indian Army - www.indianarmy.nic.in
• Join Indian Army - www.joinindianarmy.nic.in
• Indian Air Force - www.indianairforce.nic.in
• Indian Navy - www.indiannavy.nic.in
Engineering
• All India Council of Technical Education - www.aicte.ernet.in
• The Institutions of Engineers (India) - www.ieiindia.org
• IIT-Kharagpur - www.iitkgp.ac.in
• Bureau of Energy Efficiency - www.bee.gov.in
• Distance Education Council for distance education in Engineering - www.dec.ac.in
• Joint Entrance Examination (Orissa) - www.jeeorissa.com
Finance
• The Institute Of Chartered Accountant – www.icai.org
• The Institute Of Company Secretaries of India – www.icsi.edu
• National Stock exchange of India - www.nseindia.com
• Bombay Stock exchange - www.bseindia.com
• Indian Institute of Banking & Finance – www.iibf.org.in
• Indian Institute of Statistical Institute - www.isical.ac.in
Hospitality
• Incredible India - www.incredibleindia.org
• Ministry of Tourism - www.tourisminindia.com
IT
• NASSCOM - www.nasscom.in
• Ministry of IT - www.mit.gov.in
• DOECC - www.doeacc.edu.in
• Centre For Development of Advance Computing - www.cdac.in
• Indian Institute of Technology Madras - www.iitm.ac.in
Law
• Supreme Court of India - www.supremecourtofindia.nic.in
• Ministry of Law & Justice - www.lawmin.nic.in
• National Commission for Women - www.ncw.nic.in
• Central Administrative Tribunal - www.cgat.gov.in
Library Science
• Raja Rammohun Roy Library foundation - www.rrrlf.nic.in
• National Archives Of India - www.nationalarchives.gov.in
Management
• Indian Institute of Management, Calcutta - www.iimcal.ac.in
• Indian Institute of Management, Ahmedabad - www.iimahd.ernet.in
Media
• Indian Institute of Mass Commission - www.iimc.nic.in
• Publications Division - www.publicationsdivision.nic.in
• DoorDarshan - www.ddindia.com
• Directorate Of Advertising and Visual Publicity - www.davp.nic.in
• Press Information Bureau - www.pib.nic.in
Medicine
• Ministry of Health & Welfare - www.mohwf.nic.in
• Department of Ayurveda, Yoga & Naturopathy, Unani, Siddha and Homoeopathy (AYUSH) - www.indianmedicine.nic.in
• National Aids Control Organisation - www.nacoonline.org
• Armed Forces Medical College - www.armedforces.nic.in
Railways
• Indian Railways - www.indianrail.gov.in
• Indian Railways - www.indrailways.gov.in
• Ministry of Railways - www.railnet.gov.in
• IRCON - www.ircon.org
• Indian Railway Catering and Tourism Corporation Ltd. - www.irctc.co.in
Retail
• Indian Institute of Social Welfare and Business Management, Kolkata - www.iiswbm.edu
• CII Institute of Logistics, Chennai - www.ciilogistics.com
• Gobind Ballabh Pant University - www.gbpuat.ac.in
• Annamalai University - www.annauniv.edu/biotech
• Indian Institute of Foreign Trade, - www.iift.edu
Science
• Jawaharlal Nehru Technological University - www.jntu.ac.in
• IIT Bombay - www.iitb.ac.in
• Mumbai University - www.mu.ac.in
• Indian School of Mines, Dhanbad - www.ismdhanbad.ac.in
• CSIR-UGC (NET) - www.csirhrdg.res.in
• Indian Council of Medical Research, - www.icmr.nic.in
• Birla Institute of Technology, Ranchi - www.bitmesra.ac.in
• Madurai Kamaraj University, Madurai - www.mkudde.org
• Indian Institute of Technology, Kharagpur - www.iitkgp.ernet.in/pgdmom
• Central Institute of Fisheries Nautical and Engineering Training - www.cifnet.nic.in
• Bioinformatics Institute of India - www.bioinformaticscentre.org
Science-IPR/PATENTS
• Patent Office, Govt of India - www.ipindia.nic.in
• Institute of Intellectual Property Studies, Mumbai - www.iips.ac.in
• National Law School of India University, Nagarbhavi - www.nls.ac.in
• Indian Institute of Information Technology, Allahabad (Deemed University) - www.iiita.ac.in
Self Entrepreneurship
• Central Marine Fisheries Research Institute, Kochi - www.cmfri.com
• Tata Institute of Social Sciences, Mumbai - www.tiss.edu
• Tata Institute of Social Sciences, Mumbai - www.tiss.edu
• Ministry of Labour & Employment (Directorate General of Employment & Training) ADVANCED TRAINING INSTITUTE - http://dget.nic.in/atikanpur
Pharmacy
• Academy for Clinical Excellence (ACE) - www.aceindia.org
• Institute of Clinical Research (ICRI) - www.icriindia.com
• Bombay College of Pharmacy - www.bcpindia.org
• Jamia Hamdarad Islamia - www.jmi.ac.in
• National Institute of Pharmaceutical Education & Research (NIPER). S.A.S. Nagar, Punjab - www.niper.nic.in
• Guru Jambeshwar University, Hisar - www.gju.ernet.in
University Grants Commission - www.ugc.ac.in
• Central Board Of Secondary Education - www.cbsc.nic.in
• Delhi University - www.du.ac.in
• Jawaharlal Nehru University - www.jnu.ac.in
• National Council for Teacher Education - www.ncte-in.org
• National Council for Educational Research & Training - www.ncert.nic.in
• Ministry of HRD (Education) - www.education.nic.in
Aviation
• Directorate General of Civil Aviation - www.dgca.nic.in
• IATA training - www.iata.org
• Ministry of Civil Aviation - www.civilaviation.nic.in
• Indira Gandhi Rashtriya Uran Akademi - www.igrua.gov.in
Banking
• Reserve Bank of India - www.rbi.org.in
• State Bank of India - www.statebankofindia.com
• Panjab National Bank - www.pnbindia.com
• Corporation Bank - www.corpbank.com
Civil - Services
• Union Public Service Commission - www.ugc.gov.in
• Staff Selection Commission - www.ssc.nic.in
• Department of Personal & Training - www.dopt.nic.in
Defence
• National Defence Academy - www.nda.nic.in
• Indian Army - www.indianarmy.nic.in
• Join Indian Army - www.joinindianarmy.nic.in
• Indian Air Force - www.indianairforce.nic.in
• Indian Navy - www.indiannavy.nic.in
Engineering
• All India Council of Technical Education - www.aicte.ernet.in
• The Institutions of Engineers (India) - www.ieiindia.org
• IIT-Kharagpur - www.iitkgp.ac.in
• Bureau of Energy Efficiency - www.bee.gov.in
• Distance Education Council for distance education in Engineering - www.dec.ac.in
• Joint Entrance Examination (Orissa) - www.jeeorissa.com
Finance
• The Institute Of Chartered Accountant – www.icai.org
• The Institute Of Company Secretaries of India – www.icsi.edu
• National Stock exchange of India - www.nseindia.com
• Bombay Stock exchange - www.bseindia.com
• Indian Institute of Banking & Finance – www.iibf.org.in
• Indian Institute of Statistical Institute - www.isical.ac.in
Hospitality
• Incredible India - www.incredibleindia.org
• Ministry of Tourism - www.tourisminindia.com
IT
• NASSCOM - www.nasscom.in
• Ministry of IT - www.mit.gov.in
• DOECC - www.doeacc.edu.in
• Centre For Development of Advance Computing - www.cdac.in
• Indian Institute of Technology Madras - www.iitm.ac.in
Law
• Supreme Court of India - www.supremecourtofindia.nic.in
• Ministry of Law & Justice - www.lawmin.nic.in
• National Commission for Women - www.ncw.nic.in
• Central Administrative Tribunal - www.cgat.gov.in
Library Science
• Raja Rammohun Roy Library foundation - www.rrrlf.nic.in
• National Archives Of India - www.nationalarchives.gov.in
Management
• Indian Institute of Management, Calcutta - www.iimcal.ac.in
• Indian Institute of Management, Ahmedabad - www.iimahd.ernet.in
Media
• Indian Institute of Mass Commission - www.iimc.nic.in
• Publications Division - www.publicationsdivision.nic.in
• DoorDarshan - www.ddindia.com
• Directorate Of Advertising and Visual Publicity - www.davp.nic.in
• Press Information Bureau - www.pib.nic.in
Medicine
• Ministry of Health & Welfare - www.mohwf.nic.in
• Department of Ayurveda, Yoga & Naturopathy, Unani, Siddha and Homoeopathy (AYUSH) - www.indianmedicine.nic.in
• National Aids Control Organisation - www.nacoonline.org
• Armed Forces Medical College - www.armedforces.nic.in
Railways
• Indian Railways - www.indianrail.gov.in
• Indian Railways - www.indrailways.gov.in
• Ministry of Railways - www.railnet.gov.in
• IRCON - www.ircon.org
• Indian Railway Catering and Tourism Corporation Ltd. - www.irctc.co.in
Retail
• Indian Institute of Social Welfare and Business Management, Kolkata - www.iiswbm.edu
• CII Institute of Logistics, Chennai - www.ciilogistics.com
• Gobind Ballabh Pant University - www.gbpuat.ac.in
• Annamalai University - www.annauniv.edu/biotech
• Indian Institute of Foreign Trade, - www.iift.edu
Science
• Jawaharlal Nehru Technological University - www.jntu.ac.in
• IIT Bombay - www.iitb.ac.in
• Mumbai University - www.mu.ac.in
• Indian School of Mines, Dhanbad - www.ismdhanbad.ac.in
• CSIR-UGC (NET) - www.csirhrdg.res.in
• Indian Council of Medical Research, - www.icmr.nic.in
• Birla Institute of Technology, Ranchi - www.bitmesra.ac.in
• Madurai Kamaraj University, Madurai - www.mkudde.org
• Indian Institute of Technology, Kharagpur - www.iitkgp.ernet.in/pgdmom
• Central Institute of Fisheries Nautical and Engineering Training - www.cifnet.nic.in
• Bioinformatics Institute of India - www.bioinformaticscentre.org
Science-IPR/PATENTS
• Patent Office, Govt of India - www.ipindia.nic.in
• Institute of Intellectual Property Studies, Mumbai - www.iips.ac.in
• National Law School of India University, Nagarbhavi - www.nls.ac.in
• Indian Institute of Information Technology, Allahabad (Deemed University) - www.iiita.ac.in
Self Entrepreneurship
• Central Marine Fisheries Research Institute, Kochi - www.cmfri.com
• Tata Institute of Social Sciences, Mumbai - www.tiss.edu
• Tata Institute of Social Sciences, Mumbai - www.tiss.edu
• Ministry of Labour & Employment (Directorate General of Employment & Training) ADVANCED TRAINING INSTITUTE - http://dget.nic.in/atikanpur
Pharmacy
• Academy for Clinical Excellence (ACE) - www.aceindia.org
• Institute of Clinical Research (ICRI) - www.icriindia.com
• Bombay College of Pharmacy - www.bcpindia.org
• Jamia Hamdarad Islamia - www.jmi.ac.in
• National Institute of Pharmaceutical Education & Research (NIPER). S.A.S. Nagar, Punjab - www.niper.nic.in
• Guru Jambeshwar University, Hisar - www.gju.ernet.in
GOVT JOBS SITE LINKS
http://www.yuvajobs.com/indian-govt-jobs.asp
http://www.upscportal.com/civilservices/job/job-indian-space-research-organisation-isro-mechanical-engineer-jobs
http://www.freshershome.com/jobs/category/government-jobs-in-india.html
http://www.govtjobs.co.in/
http://www.employmentnews.gov.in/
http://www.govtjobs.com/
http://www.upscportal.com/civilservices/job/job-indian-space-research-organisation-isro-mechanical-engineer-jobs
http://www.freshershome.com/jobs/category/government-jobs-in-india.html
http://www.govtjobs.co.in/
http://www.employmentnews.gov.in/
http://www.govtjobs.com/
GOVT JOBS SITE LINKS
http://www.yuvajobs.com/indian-govt-jobs.asp
http://www.upscportal.com/civilservices/job/job-indian-space-research-organisation-isro-mechanical-engineer-jobs
http://www.freshershome.com/jobs/category/government-jobs-in-india.html
http://www.govtjobs.co.in/
http://www.employmentnews.gov.in/
http://www.govtjobs.com/
http://www.upscportal.com/civilservices/job/job-indian-space-research-organisation-isro-mechanical-engineer-jobs
http://www.freshershome.com/jobs/category/government-jobs-in-india.html
http://www.govtjobs.co.in/
http://www.employmentnews.gov.in/
http://www.govtjobs.com/
GOVT JOBS SITE LINKS
http://www.yuvajobs.com/indian-govt-jobs.asp
http://www.upscportal.com/civilservices/job/job-indian-space-research-organisation-isro-mechanical-engineer-jobs
http://www.freshershome.com/jobs/category/government-jobs-in-india.html
http://www.upscportal.com/civilservices/job/job-indian-space-research-organisation-isro-mechanical-engineer-jobs
http://www.freshershome.com/jobs/category/government-jobs-in-india.html
Friday, November 28, 2008
voter id details
Your Photograph has been successfully uploaded. Your Online Registration No. is 64660
Note Down the Application ID for future Reference
Note Down the Application ID for future Reference
CIVIL SERVESES EXAMS
List of Civil Services Coaching Centers
(Details provided are of informative nature only. This website does NOT endorse any of the following coaching centers. Do enquire about the institute before you join... List may be a partial list of coaching centers. Also please contact the institutes directly for updated optional list..... Enquire about availability of other centers before making any decision)
Ahmedabad
IAS Study Center
Sardar Patel Institute of Public Administration
Government of Gujarat,
OPP. "ISRO", SATELLITE ROAD, AHMEDABAD-380 015
Phone No. 26747612, 26747636, 26741879, 26741999
Email: ddinformation@gujarat.gov.in
Web: http://www.spipa.gujarat.gov.in/iasstudy_centre.htm
Allahabad
Career Coaching
13,Kamla Nehru Rd.
Allahabad U.P.211001
0532-600248
Krishna Coaching Institute
30,Motilal Nehru Rd. Allahabad
0532-600121
Centre for Excellence
G.S., essay, Public Admin.
8-B, Elgin Road, Opp. Mishra Bhawan,
Civil Lines, Allahabad
611518
Bangalore
Pre examination training center,
Direcotrate of social welfare,
Bangalore
http://sw.kar.nic.in/emptrng_files/empNtrng-pre-exam.htm
Swarnavalli Institute of Administration and Management (SWAIAM),
No 568/26, Hegde Complex, 2nd Floor, 8th Cross, Mathikere Main Road, Yeshwanthpur, Bangalore - 560 022.
Confluence Academy For Excellence
15, Church Road, Near Armugam Circle,
Basavanagudi, Bangalore - 560004
Phone: 6611341, Mobile: 98440-41704
Christ college, Hosur road
Address not available.... Please look at local telephone directory....
JSS Training Institute for Competitive Exams,
38th cross, 1st main, 8th block,
Jayanagar,
Bangalore.
phone: 080-26655086
Himalai IAS Center
173/B, 1st floor,
7th main, 4th block,
Opp. Sukshema clinic,
Rajaji nagar
Bangalore
Phone: 080-56691218
Sachedeva, Jaya Nagar
Address not available.... Please look at local telephone directory....
Bhopal
Rao'S IAS Institute
Gen. Studies, Essay, Public Administration,
History, Hindi Literature, Anthropology.
20, Jyoti Chamber,
Zone- II, M.P. Nagar,
Bhopal.
Chandigarh
Panjab University IAS Coaching Center
Panjab University
Chennai
Brilliant Tutorials (For all subjects)
P.O. Box: 4996-CM, 12,
Masilamani Street, T.Nagar,
Chennai-17
(033)-4342099, 4343308, 4341788,
Fax- (033)-4343829
All India Civil Services Coaching Center,
Government of TamilNadu
225, Second Avenue, Anna Nagar, Chennai - 40.
Phone: 6211475, 6211909
Email: director@civilservicecoaching.com
Web: www.civilservicecoaching.com
Pragnya Academy for Career Excellence (PACE),
534, II Floor, BOSTON School,
T.T.K Road, Chennai � 18.
Phone : 044-24345868
Netaji IAS Academy (For all subjects)
27-C, Rameshwaram road,
T.Nagar, Chennai-600 017
044-434 85601, 4347025
University Of Madras, Chennai
University Of Madras, Institute Of Correspondence Education, Chepauk, Chennai 600005
Delhi
Vajiram and Ravi IAS Study Centre
79, Old ajinder Nagar Market,
New Delhi-110060
Ph:25820000, 25734058
Sociology Center (For Sociology)
171, First Floor, Hari Nagar,
Ashram, New Delhi-14
011- 6922822
IAS Era (For G.S, Geography, History)
1/17, Roop Nagar, G.T. Karnal Road, (Near Shakti Nagar Chowk), New Delhi-7
011- 7444527
Delhi's IAS Study Circle (For all subjects)
E-29, Saket, New Dehi-17
Vajiram & Ravi (For Gen. Studies, Public Admin.Sociology Geography, commerce &accountancy, Psychology)
79,Old Rajinder Nagar,
New Delhi
011-5820000
Web: www.vajiramandravi.com
Erdkunde (For Geography)
C/o Thakran House,
148-C/9, Kishangarg,
Near Vasant Kunj,
New Delhi-17
Rau's IAS Study Circle (For G.S. Essay, History, Sociology, Anthropology, Public Admin., Geography, Zoology).
44-Dakshineshwar Building,
10, Haily Road, New Delhi-110 001
(011) 335-5906, 332-7995
Fax: 011-332-8849
Web: www.rauias.com
Shristi Study Circle (For Essay, General Studies, Sociology, Geography, Pali Literature, Political Science, Philosophy, Chemistry, Physics, Maths, Botany, Zoology History, Anthropology.)
F- 128/3, Mohammadpur,
New Delhi-66
Ph. 011- 2718372, 6167349.
IDP3 (For General Studies, Geography, Pali Literature, Sanskrit, Hindi Literature, Political Science, Philosophy, Maths, Botany,History, Anthropology.)
2nd Floor, Jaypee Complex,
Bank Street, Muinirka,
New Delhi-100067. Ph.- 011- 6161078. FAX - 011 - 4670266.
e-mail - idp3@mantraonline.
Career Shapers (For General Studies, Hindi Literature, Sociology, History, Samskrit, Urdu, Economics, Political Science, Public Administration, Geography.)
306, 301, 302, Third Floor,
Gyandeep Complex,
66A Laxmi Market,
Opp. Canra Bank, Munirka,
New Delhi. Ph.- 011- 6166928, 6106358
e-mail - careershapers@hotmail.com
Career Plus (For Physics, Chemistry, Zoology,Botany, Mechanical Engineering,
General Studies, History, Pali, Pub. Administration, Political Science, Commerce, Economics, Law, Geography, Hindi Literature, Sociolohy, Philosophy.)
302/A- 37,38, 39,
Ansal BuildingCommercial Compex,
Dr. Mukharjee Nagar,
Near Batra Cinema, Mother Dairy,
Delhi- 9. Ph.- 011- 7652829, 7222778
FAX- 011- 7651133.
Career Point
G.S., Geography, History, Law, Public Admin., Anthropology, Physics
North Delhi-2324,
Hudson Lines, Behind Syndicate Bank,
King way Camp,
Delhi-9.
011-7240105, 7457211
SNTPC- Sachdeva New P.T. College
For address of regional centers, see chronicle
29-CS, South Patel Nagar, New Delhi-110 008
011-5783399, 5787080, 5788070, 5788182
Fax: 011-578070
E-mail: sachdeva@giasdl01.vsnl.net.in
Meridian Courses (For Public Admin.)
1) 25-A, Bersarai, Near Old JNU Campus, New Delhi-110 016
2) A-35/36, Flat No.:303, Bhandari House Commercial Complex, Mukharji Nagar, Delhi-110 009
011-6856955
011-7258382
UIAS (Upendra's Institute For Admin. Services) (For Sociology, Public Admin., Psychology, Essay, G.S.)
42-A, Krishnanagar, Safdarjung Enclave,
New Delhi-100 029
011-6184095, 6109740
Chanakya Academy (For G.S., Essay, History, Political Science, Anthropology, Sociology, Botony, Zoology, Maths, Physics, Pali lit)
A/42-44, Manushree Building,
Commercial Complex,
Dr. Mukharjee Nagar,
Delhi-110 009
011-7652625, 7652337
IAS Study Forum (For G.S., history, Sociology, Essay).
C/o Jagjivan Vidhya Bhavan,
Dr. Ambedkar Marg(link road, near karol bagh)
New Delhi-110 055
Interactions (For Geography, G.S., Hindi Literature)
1) 1602, Outram Lines, Kingsway Camp,
New Delhi- 09
2) Competition Wizard Bulding, C-211,
Baba Ganganath Market, Munirka,
New Delhi-67
011-7442038, 5622226
Fax: 011-7259114
011-6106702
Vaid's IAS (For G.S., Essay, Anthropology, Geography, History, Hindi lit., Political Science, Philosphy, Sanskrit, Sociology, Physics, Maths, Zoology, Botany.)
1) AG-603, Shalimar Bagh, Delhi-110 052
2) F-128, Mohammadpur, New Delhi-66
3) U-188, Vikas Marg Shakarpur, Delhi-92
011-7221544, 7127317, 2044962, 6167349
DEC (Delhi Education Centre) (For Public Admin., Geography, History, Political Science, G.S., Maths.)
15-A, Jai Sarai, IIT,
Hauz Khas, New Delhi-110 016
011-6565890
Gyankunj's IAS Study Circle (For History, Hindi Literature, General Studies, Psychology, Essay.)
H.N.- 2, ,Bersarai, New Delhi-16
. Ph.- 011- 6524744
Ultimate IAS Study Circle
History C-9, Mahendra Park,
Pankha Road,
Opp. Chanan Devi Hospital,
New Delhi-59 Ph.- 011- 5613643
Hamdard Study Circle
Jamia Hamdard University
Talimabad, Sangam Vihar
New Delhi - 110 062
Phone: (011) 2604 8848, Fax: (011) 26042030
E-Mail : hpsdelhi@ndf.vsnl.net.in
Web: http://www.jamiahamdard.edu/study.asp
Hyderabad
BrainTree
Level 03, 3-6-432, Himayatnagar,
Hyderabad - 500 029.
Telephone: +91-40-7644110/7636928
email: info@braintreeindia.com
Web: www.braintreeindia.com
IAS Study Circle (For General Studies, Public Administration, History, Sociology, Geography, Essay, Anthropology and Telugu literature)
Ashok Nagar.
Phone: 7612673
IAS Academy (For General studies, Public Administration, History, Geography, Essay, Anthropology and Telugu literature).
Domalguda.
Phone: 7638527.
Jammu
SBL Institute of Management
Jammu
Address not available.... Please look at local telephone directory....
Kanpur
Utkarsh Academy (For History, Pol.Science, Sociology Philosophy, Botany, Economics, Maths. Zoology, Gen.Studies )
112/321,Swaroop Nagar,
Kanpur,U.P.
0512-256357
Lucknow
Sanchetna
Pub. Admn., History, General Studies.
3rd Floor, Arif Chamber,
Aliganj, Lucknow. Ph.- 0522- 383987
Academician's IAS (For Hindi Literature, History, Gen. Studies, Pol. Science, Sociology, Botany.)
B- 12, Basant Vihar,
Ist Floor, Sector- B, Aliganj,
Lucknow. Ph.- 0522- 331560.
Vaid's ICS, Lucknow
B-36, Sector-C, Aliganj, Lucknow
Ph.- 0522- 326249
Madurai
Arise Brilliant Chamber
36,West Vadampokki Street, Vivekananda Institute Upstair, Near Periyar Bus Stand, Madurai - 625 001. Tel.: 2339974
Bharathi IAS Study Centre : 39-U6, Avvaiyar Street, Narimedu, Madurai - 625 002.
Tel.: 2534179 Mobile: 9443418666
SPARK IAS Studies
A-19, Pandian Street, Alagappan Nagar,
Madurai - 625 003. Tel.: 2693345
Udhayam Kalvi Maiyam
44, Marudhupandiar Nagar, Narimedu, Madurai - 625 002.
Tel.: 2536343
Patna
Chauhan IAS Studies Circle
Room No. 501-3 Ashiana Apt.
Exhibition Road,Patna
0612-670189
East & West Academy
Arya Kumar Road,
Rajendra Nagar,
Patna-800016
0612-657332
Thiruvanthapuram
IAS Coaching Centre,
Botony Department
The University College
Address will be provided later...
Civil Service Academy
Address will be provided later...
Centre for Career Development Studies (CCDS)
Address will be provided later...
The Institute for Civil Services Examination Training,
PTP Nagar
Address will be provided later...
Varanasi
Center for IAS coaching
Banaras hindu university
Varanasi
Vellore
Indus IAS/IPS free coaching institute (For public administration, history, and geography)
Chitteri Road
Vellore
Phone: 0416-224762
Vishakapatinam
Chanakkya IAS Academy,
1st Lane, Dwarakanagar,
Phone: 2751965
DISC IAS Study Circle,
3rd Lane, Dwarakanagar
Phone: 2596326
Disclaimers:
1. Please make your own assessment of the authenticity of the coaching centers mentioned above before joining them
2. The list above is NOT comprehensive
Courtesy: http://www.geocities.com/indiancivilservices/
(Details provided are of informative nature only. This website does NOT endorse any of the following coaching centers. Do enquire about the institute before you join... List may be a partial list of coaching centers. Also please contact the institutes directly for updated optional list..... Enquire about availability of other centers before making any decision)
Ahmedabad
IAS Study Center
Sardar Patel Institute of Public Administration
Government of Gujarat,
OPP. "ISRO", SATELLITE ROAD, AHMEDABAD-380 015
Phone No. 26747612, 26747636, 26741879, 26741999
Email: ddinformation@gujarat.gov.in
Web: http://www.spipa.gujarat.gov.in/iasstudy_centre.htm
Allahabad
Career Coaching
13,Kamla Nehru Rd.
Allahabad U.P.211001
0532-600248
Krishna Coaching Institute
30,Motilal Nehru Rd. Allahabad
0532-600121
Centre for Excellence
G.S., essay, Public Admin.
8-B, Elgin Road, Opp. Mishra Bhawan,
Civil Lines, Allahabad
611518
Bangalore
Pre examination training center,
Direcotrate of social welfare,
Bangalore
http://sw.kar.nic.in/emptrng_files/empNtrng-pre-exam.htm
Swarnavalli Institute of Administration and Management (SWAIAM),
No 568/26, Hegde Complex, 2nd Floor, 8th Cross, Mathikere Main Road, Yeshwanthpur, Bangalore - 560 022.
Confluence Academy For Excellence
15, Church Road, Near Armugam Circle,
Basavanagudi, Bangalore - 560004
Phone: 6611341, Mobile: 98440-41704
Christ college, Hosur road
Address not available.... Please look at local telephone directory....
JSS Training Institute for Competitive Exams,
38th cross, 1st main, 8th block,
Jayanagar,
Bangalore.
phone: 080-26655086
Himalai IAS Center
173/B, 1st floor,
7th main, 4th block,
Opp. Sukshema clinic,
Rajaji nagar
Bangalore
Phone: 080-56691218
Sachedeva, Jaya Nagar
Address not available.... Please look at local telephone directory....
Bhopal
Rao'S IAS Institute
Gen. Studies, Essay, Public Administration,
History, Hindi Literature, Anthropology.
20, Jyoti Chamber,
Zone- II, M.P. Nagar,
Bhopal.
Chandigarh
Panjab University IAS Coaching Center
Panjab University
Chennai
Brilliant Tutorials (For all subjects)
P.O. Box: 4996-CM, 12,
Masilamani Street, T.Nagar,
Chennai-17
(033)-4342099, 4343308, 4341788,
Fax- (033)-4343829
All India Civil Services Coaching Center,
Government of TamilNadu
225, Second Avenue, Anna Nagar, Chennai - 40.
Phone: 6211475, 6211909
Email: director@civilservicecoaching.com
Web: www.civilservicecoaching.com
Pragnya Academy for Career Excellence (PACE),
534, II Floor, BOSTON School,
T.T.K Road, Chennai � 18.
Phone : 044-24345868
Netaji IAS Academy (For all subjects)
27-C, Rameshwaram road,
T.Nagar, Chennai-600 017
044-434 85601, 4347025
University Of Madras, Chennai
University Of Madras, Institute Of Correspondence Education, Chepauk, Chennai 600005
Delhi
Vajiram and Ravi IAS Study Centre
79, Old ajinder Nagar Market,
New Delhi-110060
Ph:25820000, 25734058
Sociology Center (For Sociology)
171, First Floor, Hari Nagar,
Ashram, New Delhi-14
011- 6922822
IAS Era (For G.S, Geography, History)
1/17, Roop Nagar, G.T. Karnal Road, (Near Shakti Nagar Chowk), New Delhi-7
011- 7444527
Delhi's IAS Study Circle (For all subjects)
E-29, Saket, New Dehi-17
Vajiram & Ravi (For Gen. Studies, Public Admin.Sociology Geography, commerce &accountancy, Psychology)
79,Old Rajinder Nagar,
New Delhi
011-5820000
Web: www.vajiramandravi.com
Erdkunde (For Geography)
C/o Thakran House,
148-C/9, Kishangarg,
Near Vasant Kunj,
New Delhi-17
Rau's IAS Study Circle (For G.S. Essay, History, Sociology, Anthropology, Public Admin., Geography, Zoology).
44-Dakshineshwar Building,
10, Haily Road, New Delhi-110 001
(011) 335-5906, 332-7995
Fax: 011-332-8849
Web: www.rauias.com
Shristi Study Circle (For Essay, General Studies, Sociology, Geography, Pali Literature, Political Science, Philosophy, Chemistry, Physics, Maths, Botany, Zoology History, Anthropology.)
F- 128/3, Mohammadpur,
New Delhi-66
Ph. 011- 2718372, 6167349.
IDP3 (For General Studies, Geography, Pali Literature, Sanskrit, Hindi Literature, Political Science, Philosophy, Maths, Botany,History, Anthropology.)
2nd Floor, Jaypee Complex,
Bank Street, Muinirka,
New Delhi-100067. Ph.- 011- 6161078. FAX - 011 - 4670266.
e-mail - idp3@mantraonline.
Career Shapers (For General Studies, Hindi Literature, Sociology, History, Samskrit, Urdu, Economics, Political Science, Public Administration, Geography.)
306, 301, 302, Third Floor,
Gyandeep Complex,
66A Laxmi Market,
Opp. Canra Bank, Munirka,
New Delhi. Ph.- 011- 6166928, 6106358
e-mail - careershapers@hotmail.com
Career Plus (For Physics, Chemistry, Zoology,Botany, Mechanical Engineering,
General Studies, History, Pali, Pub. Administration, Political Science, Commerce, Economics, Law, Geography, Hindi Literature, Sociolohy, Philosophy.)
302/A- 37,38, 39,
Ansal BuildingCommercial Compex,
Dr. Mukharjee Nagar,
Near Batra Cinema, Mother Dairy,
Delhi- 9. Ph.- 011- 7652829, 7222778
FAX- 011- 7651133.
Career Point
G.S., Geography, History, Law, Public Admin., Anthropology, Physics
North Delhi-2324,
Hudson Lines, Behind Syndicate Bank,
King way Camp,
Delhi-9.
011-7240105, 7457211
SNTPC- Sachdeva New P.T. College
For address of regional centers, see chronicle
29-CS, South Patel Nagar, New Delhi-110 008
011-5783399, 5787080, 5788070, 5788182
Fax: 011-578070
E-mail: sachdeva@giasdl01.vsnl.net.in
Meridian Courses (For Public Admin.)
1) 25-A, Bersarai, Near Old JNU Campus, New Delhi-110 016
2) A-35/36, Flat No.:303, Bhandari House Commercial Complex, Mukharji Nagar, Delhi-110 009
011-6856955
011-7258382
UIAS (Upendra's Institute For Admin. Services) (For Sociology, Public Admin., Psychology, Essay, G.S.)
42-A, Krishnanagar, Safdarjung Enclave,
New Delhi-100 029
011-6184095, 6109740
Chanakya Academy (For G.S., Essay, History, Political Science, Anthropology, Sociology, Botony, Zoology, Maths, Physics, Pali lit)
A/42-44, Manushree Building,
Commercial Complex,
Dr. Mukharjee Nagar,
Delhi-110 009
011-7652625, 7652337
IAS Study Forum (For G.S., history, Sociology, Essay).
C/o Jagjivan Vidhya Bhavan,
Dr. Ambedkar Marg(link road, near karol bagh)
New Delhi-110 055
Interactions (For Geography, G.S., Hindi Literature)
1) 1602, Outram Lines, Kingsway Camp,
New Delhi- 09
2) Competition Wizard Bulding, C-211,
Baba Ganganath Market, Munirka,
New Delhi-67
011-7442038, 5622226
Fax: 011-7259114
011-6106702
Vaid's IAS (For G.S., Essay, Anthropology, Geography, History, Hindi lit., Political Science, Philosphy, Sanskrit, Sociology, Physics, Maths, Zoology, Botany.)
1) AG-603, Shalimar Bagh, Delhi-110 052
2) F-128, Mohammadpur, New Delhi-66
3) U-188, Vikas Marg Shakarpur, Delhi-92
011-7221544, 7127317, 2044962, 6167349
DEC (Delhi Education Centre) (For Public Admin., Geography, History, Political Science, G.S., Maths.)
15-A, Jai Sarai, IIT,
Hauz Khas, New Delhi-110 016
011-6565890
Gyankunj's IAS Study Circle (For History, Hindi Literature, General Studies, Psychology, Essay.)
H.N.- 2, ,Bersarai, New Delhi-16
. Ph.- 011- 6524744
Ultimate IAS Study Circle
History C-9, Mahendra Park,
Pankha Road,
Opp. Chanan Devi Hospital,
New Delhi-59 Ph.- 011- 5613643
Hamdard Study Circle
Jamia Hamdard University
Talimabad, Sangam Vihar
New Delhi - 110 062
Phone: (011) 2604 8848, Fax: (011) 26042030
E-Mail : hpsdelhi@ndf.vsnl.net.in
Web: http://www.jamiahamdard.edu/study.asp
Hyderabad
BrainTree
Level 03, 3-6-432, Himayatnagar,
Hyderabad - 500 029.
Telephone: +91-40-7644110/7636928
email: info@braintreeindia.com
Web: www.braintreeindia.com
IAS Study Circle (For General Studies, Public Administration, History, Sociology, Geography, Essay, Anthropology and Telugu literature)
Ashok Nagar.
Phone: 7612673
IAS Academy (For General studies, Public Administration, History, Geography, Essay, Anthropology and Telugu literature).
Domalguda.
Phone: 7638527.
Jammu
SBL Institute of Management
Jammu
Address not available.... Please look at local telephone directory....
Kanpur
Utkarsh Academy (For History, Pol.Science, Sociology Philosophy, Botany, Economics, Maths. Zoology, Gen.Studies )
112/321,Swaroop Nagar,
Kanpur,U.P.
0512-256357
Lucknow
Sanchetna
Pub. Admn., History, General Studies.
3rd Floor, Arif Chamber,
Aliganj, Lucknow. Ph.- 0522- 383987
Academician's IAS (For Hindi Literature, History, Gen. Studies, Pol. Science, Sociology, Botany.)
B- 12, Basant Vihar,
Ist Floor, Sector- B, Aliganj,
Lucknow. Ph.- 0522- 331560.
Vaid's ICS, Lucknow
B-36, Sector-C, Aliganj, Lucknow
Ph.- 0522- 326249
Madurai
Arise Brilliant Chamber
36,West Vadampokki Street, Vivekananda Institute Upstair, Near Periyar Bus Stand, Madurai - 625 001. Tel.: 2339974
Bharathi IAS Study Centre : 39-U6, Avvaiyar Street, Narimedu, Madurai - 625 002.
Tel.: 2534179 Mobile: 9443418666
SPARK IAS Studies
A-19, Pandian Street, Alagappan Nagar,
Madurai - 625 003. Tel.: 2693345
Udhayam Kalvi Maiyam
44, Marudhupandiar Nagar, Narimedu, Madurai - 625 002.
Tel.: 2536343
Patna
Chauhan IAS Studies Circle
Room No. 501-3 Ashiana Apt.
Exhibition Road,Patna
0612-670189
East & West Academy
Arya Kumar Road,
Rajendra Nagar,
Patna-800016
0612-657332
Thiruvanthapuram
IAS Coaching Centre,
Botony Department
The University College
Address will be provided later...
Civil Service Academy
Address will be provided later...
Centre for Career Development Studies (CCDS)
Address will be provided later...
The Institute for Civil Services Examination Training,
PTP Nagar
Address will be provided later...
Varanasi
Center for IAS coaching
Banaras hindu university
Varanasi
Vellore
Indus IAS/IPS free coaching institute (For public administration, history, and geography)
Chitteri Road
Vellore
Phone: 0416-224762
Vishakapatinam
Chanakkya IAS Academy,
1st Lane, Dwarakanagar,
Phone: 2751965
DISC IAS Study Circle,
3rd Lane, Dwarakanagar
Phone: 2596326
Disclaimers:
1. Please make your own assessment of the authenticity of the coaching centers mentioned above before joining them
2. The list above is NOT comprehensive
Courtesy: http://www.geocities.com/indiancivilservices/
Thursday, November 27, 2008
CAT2009LINKS
http://totalgadha.com/index.php
http://www.careerlauncher.com/mba/online_cat/?gclid=CIX2z66UlpcCFcIupAodtS7o_Q
http://www.2iim.com/IIM_CAT_classes_correspondence_courses/intensive.shtml
http://www.onestopmba.com/
you can search it on these links. plz click
http://www.peakseekers.in/MBA-Entrance-E...
http://www.careerforum.in/default.htm
http://www.catiim.in/
ADMISSION NEWS
You can search it on this link. plz click
http://www.admissionnews.com/index.aspx
you can search it on these links. plz click
http://www.successcds.net/engineeringent...
http://www.bitsadmission.com/admn/bitsat...
http://www.ankur-gupta.com/blog/entrance...
http://www.winentrance.com/engineering_e...
http://www.quizmine.com/bitsat.aspx
http://www.indiaresults.com/notification...
http://collegesindia.wordpress.com/2007/...
http://www.entranceexamindia.com/2007/12...
http://www.bharathedu.com/EntranceExam/E...
http://www.onaptitude.com/org.praxis.practice.Practice/Practice.html#partA%3A0
http://www.2009cat.blogspot.com/
http://www.ets.org/portal/site/ets/menuitem.3a88fea28f42ada7c6ce5a10c3921509/?vgnextoid=85b65784623f4010VgnVCM10000022f95190RCRD
http://www.princetonreview.com/business/gmat-test-preparation.aspx?uidbadge=
www.
http://www.careerlauncher.com/mba/online_cat/?gclid=CIX2z66UlpcCFcIupAodtS7o_Q
http://www.2iim.com/IIM_CAT_classes_correspondence_courses/intensive.shtml
http://www.onestopmba.com/
you can search it on these links. plz click
http://www.peakseekers.in/MBA-Entrance-E...
http://www.careerforum.in/default.htm
http://www.catiim.in/
ADMISSION NEWS
You can search it on this link. plz click
http://www.admissionnews.com/index.aspx
you can search it on these links. plz click
http://www.successcds.net/engineeringent...
http://www.bitsadmission.com/admn/bitsat...
http://www.ankur-gupta.com/blog/entrance...
http://www.winentrance.com/engineering_e...
http://www.quizmine.com/bitsat.aspx
http://www.indiaresults.com/notification...
http://collegesindia.wordpress.com/2007/...
http://www.entranceexamindia.com/2007/12...
http://www.bharathedu.com/EntranceExam/E...
http://www.onaptitude.com/org.praxis.practice.Practice/Practice.html#partA%3A0
http://www.2009cat.blogspot.com/
http://www.ets.org/portal/site/ets/menuitem.3a88fea28f42ada7c6ce5a10c3921509/?vgnextoid=85b65784623f4010VgnVCM10000022f95190RCRD
http://www.princetonreview.com/business/gmat-test-preparation.aspx?uidbadge=
www.
ISRO APPLICATION NO 17/NOV/08
ISRO APPLICATION NO 17/NOV/08
APPLICATION NO:20109855
ADVNO:02/2008
POSTNO:01
http://www.isro.org/joboppor.htm
http://www.isac.gov.in/CentralBE/ShowStatus.jsp?postno=01&postname=Scientist/Engineer-SC[Mechanical]
APPLICATION NO:20109855
ADVNO:02/2008
POSTNO:01
http://www.isro.org/joboppor.htm
http://www.isac.gov.in/CentralBE/ShowStatus.jsp?postno=01&postname=Scientist/Engineer-SC[Mechanical]
Monday, November 17, 2008
isro links
http://www.123eng.com/placementpapers/isro1_2007.html
http://www.managementparadise.com/forums/articles/8213-isro-tests-indigenous-cryogenic-engine.html
http://www.geekinterview.com/Global-Interview-Questions/ISRO
http://www.123eng.com/forum/viewtopic.php?p=3337
http://www.123eng.com/forum/viewtopic.php?t=2629
http://www.chetanasforum.com/index.php?showtopic=2937&mode=threaded&pid=5558
http://www.itquestionbank.com/placement-papers/isro
http://www.babujobs.com/isro-recruitment-2008-be-btech-mechanical-engineering-freshers/
http://www.babujobs.com/isro-recruitment-2008-be-btech-mechanical-engineering-freshers/
http://www.geekinterview.com/Global-Interview-Questions/ISRO
http://india-results123.blogspot.com/2008/11/isro-indian-space-research-organisation.html
http://www.coders2020.com/isro-placement-papers
http://mcaexam.info/isro-indian-space-research-organisation-recruitment-for-scientist-engineer-bebtechmech/
http://mcaexam.info/isro-indian-space-research-organisation-recruitment-for-scientist-engineer-bebtechmech/
http://vanishd.wordpress.com/category/mechanical-engg/
http://www.scribd.com/doc/2467504/Resource-sharing-among-ISRO-Libraries-A-Case-Study-of-Consortia-Approach
http://www.indiastudychannel.com/resources/41122-Scientist-Engineer-SC-Mechanical-ISRO.aspx
http://www.naukri2000.com/careers/display.resume.php3?key=fnqnfvin&job=mechanical
http://indiastudycircle.blogspot.com/2008/10/training-facilities-at-isro.html
http://www.exforsys.com/forum/interview-questions/169-isro-sample-paper-needed.html
http://www.boredguru.com/modules/newbb/viewtopic.php?topic_id=2606&forum=58
http://www.yuvajobs.com/placement_paper/placement_paper.asp?id=100&h=ISRO
http://www.placementpapers.net/helpingroot/GOVERNMENT_JOBS_WEBSITES
http://www.managementparadise.com/forums/articles/8213-isro-tests-indigenous-cryogenic-engine.html
http://www.geekinterview.com/Global-Interview-Questions/ISRO
http://www.123eng.com/forum/viewtopic.php?p=3337
http://www.123eng.com/forum/viewtopic.php?t=2629
http://www.chetanasforum.com/index.php?showtopic=2937&mode=threaded&pid=5558
http://www.itquestionbank.com/placement-papers/isro
http://www.babujobs.com/isro-recruitment-2008-be-btech-mechanical-engineering-freshers/
http://www.babujobs.com/isro-recruitment-2008-be-btech-mechanical-engineering-freshers/
http://www.geekinterview.com/Global-Interview-Questions/ISRO
http://india-results123.blogspot.com/2008/11/isro-indian-space-research-organisation.html
http://www.coders2020.com/isro-placement-papers
http://mcaexam.info/isro-indian-space-research-organisation-recruitment-for-scientist-engineer-bebtechmech/
http://mcaexam.info/isro-indian-space-research-organisation-recruitment-for-scientist-engineer-bebtechmech/
http://vanishd.wordpress.com/category/mechanical-engg/
http://www.scribd.com/doc/2467504/Resource-sharing-among-ISRO-Libraries-A-Case-Study-of-Consortia-Approach
http://www.indiastudychannel.com/resources/41122-Scientist-Engineer-SC-Mechanical-ISRO.aspx
http://www.naukri2000.com/careers/display.resume.php3?key=fnqnfvin&job=mechanical
http://indiastudycircle.blogspot.com/2008/10/training-facilities-at-isro.html
http://www.exforsys.com/forum/interview-questions/169-isro-sample-paper-needed.html
http://www.boredguru.com/modules/newbb/viewtopic.php?topic_id=2606&forum=58
http://www.yuvajobs.com/placement_paper/placement_paper.asp?id=100&h=ISRO
http://www.placementpapers.net/helpingroot/GOVERNMENT_JOBS_WEBSITES
Friday, November 07, 2008
hvac
PEBS- Institute of Piping Engineering and Building Services based in Hyderabad offers quality professional training course for Mechanical Engineers in HVAC Design & Drafting with Placements Assistance in India and Abroad.HVAC Design & Drafting per ASHRAE Course includes the following contents in brief:- Introduction to Codes and Standards- Cooling Load Calculaitons- Heat Loss Calculations- Air Distribution System Design- Psychrometrics-Ventilaiton System Design-Kitchen Ventilation System Design-HVAC Controls- Building Energy Management Systems- Heating Systems Design- Cold Storage Design-Clean Room Design- Fans- Chilled Water System Design- Piping Design- Equipment Selection - Chillers, Fans, Blowers, Pumps, Air Handling Units, Package Units, Coils, Cooling Towers, Condensers, Compressors etc.- Detailed Energy Analysis for the System- HVAC Symbolism, Conventions and Schematics, Riser Diagrams, Duct Layouts etc.- Exposure to Softwares like CHVAC, RHVAC, HAP, Block Load.In addition to HVAC Design & Drafting training, IPEBS offers professional training programs in areas like- Process Piping Design and Engineering per ASME B 31.3- Process Plant Design- Pipeline Engineering per ASME B31.4 and B 31.8-MEP Design & Drafting-Plumbing Design & Drafting-Fire Safety Design & Drafting- Civil Drafting, Process piping drafting and MEP Drafting.- Piping Stress Analysis per ASME/ANSI StandardsAll the courses include 4 projects.For more information please visit our website http://www.ipebs.in Contact Address: IPEBS204, C-Block, Mayur Kushal ComplexAbids, HyderabadMobile : 91-9885946711Web : http://www.ipebs.inTel: 040-30623249
GEMSTECH INTERNATIONAL TRAINING centre
RECOGNIZED BY GOVT OF AP INDIA & also
GLOBALLY RECOGNIZED TRAINING centre offer
OUR FULLY EQUIPPED ADVANCE LAB,
QUALIFIED ENGINEERS/GRADUATES/PG STAFF,
offers INTERNATIONAL STANDARD ENGINEERING & IT TRAINING DIPLOMA CERTIFICATES,ENGINEERING PROGRAMMES in
1) MEP HVAC Auto Cad CIVIL ARCHITECTURE STRUCTURAL and more,
ALSO OFFERS COURSES
FIRE AND SAFETY,MCSE,CCNA,CCNP, A+.N+.,COMPTIA.,LINUX ADMIN.,
Advance WEB Designing / Graphic Designing
FREE 100 % DUBAI GULF JOBS PLACEMENT ASSISTANCE after training of any professional ..!engineering / I T course
NO HIDTaiba Engineering Consultants
040 –64604442,9963759411.
16-2-698/699, first floor
lane opp Mahesh Bank Paltan
Malakpet,Hyderabad
HVAC Designing and Drafting:-
COURSE CONTANT:-
1. Introduction and fundamentals of HVAC,
2. Definitions as per ASHRAE.
3. Terminology used in HVAC.
4. Modes of Heat transfer.
5. Study of Psychrometric chart.
6. Refrigeration components.
1) Compressor,2) Condenser,3) Expansion valve, 4) Evaporator.
7. Basic Refrigeration Cycle.
8. Line Diagrams and Cycle of
1) Window A/c ,2) Split A/c, 3) Packaged A/c, 4) Central A/c system.
9. Types Air Conditioning Systems.
1) All Air system , 2) All water system,3) Air water system,
4) Direct Refrigeration system.
10, Building Survey,
11. Orientation of Building.
12 To Read Latitude of location of Building.
12. Calculation of U factor for Walls, Glass, Roof, Partitions.
13. Calculation of Temperature Difference of Walls, Glass, Roof, Partitions,
14. Cooling and Heat load Calculations using ASHRAE Standards.
15. Filling of E-20 Form.
16. Calculation of Sensible Heat factor, ADP and Dehumidified CFM.
17 Duct designing : -
Ducted Air Velocities, Friction losses, Duct sizing methods (Equal friction method, Velocity reduction method, Static regain method), Aspect ratio,
Duct sizing by use of Ductulator and Duct sizing software, Types of ducts, Duct materials, Calculation of No. of sheets, Duct Insulations, Duct Installation method , Duct testing methods, Noise control.
18. Layouts of. Single line Diagrams.
19. Convertion of single line to Double line.
20. Static pressure calculations.
21. Calculations of the Horse power of Fan motor.
22. Types of fan and fan laws.
23. Air Distribution System.
CAV, VAV,
24 Designing of Chilled water piping,
25 Refrigerant piping.
26. Equipment Selection.
27. HVAC systems maintenance.
Two Projects:-
Heat load calculation, Duct sizing, Duct layout and Equipment Selection.
HVAC Operation and Maintenance
Course Content: -
1. Basic fundamentals of Air-conditioning
2. Basic refrigeration cycle
3. Types of the air-conditioning system
4. Components of air-conditioning system
5. Line diagrams of
a. Window A/c
b. Split A/c
c. Package A/c
d. Central A/c system
6. Terminology used in air-conditioning
7. Types of the compressors
8. Types of the condensers
9. Types of evaporators
10. Types of cooling towers
11. Types of Air Handling Units
12. Types of controls used in air-conditioning systems
13. Chilled water system
14. Direct expansion system
15. Operation :-
a. Operating procedures
b. Starting sequence
c. Stopping sequence
d. Log sheet for plant room readings
e. Log sheet for room temperature readings
f. Inspection and routine maintenance
g. Routine service operations
-Pumpdown of the A/c system
-Purging of the non condensable gas
-Gas charging of A/c system
16. Preventive maintenance of
a. Window A/c
b. Split A/c
c. Package A/c
d. Central A/c System
17. Maintenance schedules of air-conditioning systems
18. Condenser descaling method
19. Methods of control settings:-
a. HP-LP switches
b. Thermostat switches
c. Oil Pressure switches
20. Method of setting super heat of expansion valve
21. Diagnoses of the faults
22. Trouble shooting of faults
Two projects: - Case study of trouble shootings
Placement:- We will send you interview calls till you get jobs.
For more information contact:-
Ambay HVAC Training Center,
1st Floor, Unit -3 , Alay,
Opp Saibaba Temple,
Behind State Bank of India,
Near Punit Ashram,
Balvatika,
Maninagar,
Ahmedabad-380008
Gujarat.
Ph: - 079- 25471173.
Mobile:- 9998610690.
Email:ambayengineering@rediffmail.com
Web site:- www.ambayhvac.com
HEAD OFFICE : DUBAI,
ASIA : REGIONAL OFFICE
Flat 402,-Manzil Chambers,Mehdipatnam,
HYDERABAD,AP,INDIA.
Tel: 9346356290, 66106290,66715640,
Branches:Mehdipatnam,Tolichowki,Lakdi-ka-pul, Warangal,Nizamabad.
E-mail: www.gemstechnologies.com - info@gemstechnologies.com.
Send us your enquiry or feedback by filling out the form below:
HVAC Training HVAC Designing and Drafting course details www. meptrainings. com
mepenquiry(at)mepjobsindia. com or call 0091 40 40064413/ 16.
For Engineers and Diploma holders.
For Jobs: www. mepjobsindia. com
We provide Placement assistance till you get job.
Certificate Program Provided by Des HVAC Drafting and Designing
COURSE CONTENT
1. Introduction and Fundamentals of Air Conditioning.
2. Modes of Heat Transfer
3. Basic Components of Air-Conditioning and Refrigeration machines
4. Refrigeration cycle - Line Diagrams
1) Basic Refrigeration Cycle
2) Chill water cycle
1. Air cooled Chillers 2. Water cooled Chillers
5. Types of Air conditioning
1)Window A/ C 2)Spilt A/ C 3)Package A/ C 4)Central A/ C
6. Categories of Air Conditioning
1) All air system
2) All water system
3) Air water system
4) Direct Refrigerant system
7. Study of psychometric charts
8. Survey of Building
9. Materials used in the Building
Finding Temperature difference and U Factor
For Wall, Glass, Roof, Partition.
10. Load Calculations.
Filling of E-20 Forms as per ASHRAE Standards for finding TR
11. ADP &CFM calculation
12. Duct-Definition and types.
13. Materials of Duct and its specification (Gauges)
14. Duct design consideration for Duct sizing as per Aspect Ratio
15. Duct size method Equal Friction method
Velocity reduction method.
Static regain method
16. Finding Duct size using Ductalator & Duct sizer software
17. Calculation of No of sheets.
18. Symbols as per DW144 international standards.
19. Preparation of single line diagram (SLD) in drawing sheet.
20. Layouts (Double line) as per SMACNA rules.
21. Wall openings drawings wherever duct is passing through walls
22. Sectional Drawing of DUCTS & its supports.
23 Insulation 0f DUCT, Balancing of Duct, Leakage Test
24. Static Pressure calculation for selection of motor & Fan.
25. Pipe size. Calculation (chill water pipe)
26. Fittings used in piping.
27. Sectional drawing of pipe & its supports
28. Air Distribution system
29. Fire Fighting Equipment (Awareness).
30. HVAC software
And many more ..
Video s of Duct Fabrication, Energy saving (i. e. in HVAC systems)
Annexure as per ASHRAE
CD - Duct sizer, subject oriented topics and many important topics 400MB
NEW BATCHES START
Every month on 6th and 21st, duration would be 45 days 2 hrs.
Every month on 15th fast track, duration would be 15days 6hrs.
DCS Pvt Ltd.,
2nd Floor, Lenin Building
Above Alankar Tiffin Center
Besides Saibaba Temple.
Bhagya nagar Colony
Opp: KPHB Colony
Kukatpally, Hyderabad
500072
PH: 040 40063771
Mobile: 9908080816
www. meptrainings. Com
Floor, Lenin Building, Opp: Apollo Hospital, Bhagyanagar, Opp: KPHB, Hyderabad, India
9849172771,040-40063771.
Majety_cdhar@yahoo.com
HVAC practicle training progrrame
business - Nampalli - institute/school
Posted on: Tue, 2 Sep 2008, 10:00 PM
GOOD HVAC TRAINING CAN LAUNCH YOU INTO A REWARDING CAREER
BY EXPERT HAVING 22 YEARS OF TRAINING EXPERIANCE
THE FIRST & ONLY HVAC TRAINING WITH POINEERED EXPERIANCE
IN PRACTICLE TRAINING FOR MECHANICLE ENGINEERS FOR GULF JOBS
, THOUSANDS OF ENGINEERS R HANDLING CHALLENGING JOBS
for details visit www.hvac-guru.com 9346929920
9247278680
Mobile: +91-93469 29920
Posted by Abinitio at 7:07 PM 0 comments
DEN CHARGES .,for more details plz call us
GEMSTECH offers international standard professional training OUR ENGINEERS PRESENTLY WORKING IN <>WORLD TOP 10 COMPANIES>> >>FORTUNES 10 << <>WHY NOT YOU ! <> WE CARE YOUR CAREER At GEMSTECH, we offer complete courses PROFESSIONAL, DOCTORATE, ENGINEERING-diploma-certificates programs, including Information Technology. MCSE,MCP,MCSA,CCNA,CCNP,CCIE., A+ N+., Advance Hardware & Networking , web designing, Graphic designing, Accounts, SAP,Fico, BASIS,HR, Autocad,HVAC, MEP., FIRE AND SAFETY engineering, Health Safety Environment NFPA CERTIFIED course., MANY JOBS READY in India as well as in Gulf Countries like Dubai, Bahrain, Qatar, Kuwait, Saudi Arabia,Singapore, UK, USA, Canada.! our International accepted courses: 1. Fire & Safety 2. Construction Safety 3. Industrial Safety 4. Health and Environmental Safety Eligibility: SSC/INTERMEDIATE/DEGREE ANY LOCAL and INTERNATIONAL 100% jobs Placements assistance FROM DUBAI HEAD OFFICE Contact : ZEBA
Dhanush Computer Services Private Limited, formerly Dhanush Engineering Services, was established in the year 2004 in the Hi Tech City of Hyderabad. DCS Pvt Ltd provides services in MEP Training and Job Placements. The company is on a high growth trajectory within a short span of time due to our wide spread reach and innovative approach. Ever since our inception, we have been conducting employment oriented Training Courses for ITI, Diploma, B. E./ B. Tech. students and employees in Design and Drafting of HVAC, Plumbing, Electrical and Piping Process . The availability of highly experienced faculty members having 10 to 13 years of domestic experience and international exposure in HVAC, Plumbing, Electrical and Piping Industries is the an asset for the company.
Our well structured and highly valued training services are instrumental in the successful placements of a large number of our students in accordance to their preferences in a large number of Indian and multinational companies.
Business Objectives:-
We strongly believe in providing highly focused and industry oriented training services by continuously innovating in the areas of instructional design methodologies and development of cutting-edge curricula.
The details provided with our proposals precisely demonstrate the requisite eligibility as the best-fit option for the role of training of the candidates in the sunrise industry of HVAC, Plumbing, Electrical and Piping.
Strategic Activities:-
The company is working towards having Pan India presence for providing a comprehensive education and training environment in Building Services and Piping industry to individuals and enterprises along with providing customized training for the varied needs of the fast growing and ever changing specifications of the industry. A snapshot of our activities is mentioned below:
Campus placements through MOUs and Tie Ups with various reputed companies.
Employee training modules for corporates to cater to their company specific requirements.
Placement services for MEP trained job seekers and corporates through our exclusively focused MEP job portal.
Undertaking project works and outsourcing activities.
Infrastructural Facilities:-
We have a well equipped training center with excellent infrastructure in close proximity to the Hi Tech City in Hyderabad. The training center is spread in an area of 3500 square feet with well furnished class rooms, training aids and further expansions are on the anvil. The training center is fully computerized and has a training lab with 25 Pentium - 4 computers. In order to provide appropriate power back-up facility, we have installed a number of 18 KVA grade UPS systems in our computer lab.
Courses Offered:-
We are India s No. 1 trainer and a leading Talent Development Corporation offering learning and knowledge solutions in the latest HVAC grade industrial services to our trainees. Prior to enrollment we evaluate the compatibility of the trainees and counsel them to undertake an appropriate course based on their educational qualifications and aptitude. We assign a higher priority to the trainees with ITI, Diploma or B. E./ B. Tech. The entire course curriculum has been designed and developed with the help of our expert insight and industry requirements. The range of services, which we have been providing to trainees can be broadly categorized into six major categories:
HVAC Design and Drafting
Electrical-HVAC Design and Drafting
Plumbing, Fire Protection & Sanitary Design and Drafting
Piping Design and Drafting Oil & Gas / Process
Faculty Members:-
Our founder has an extensive insight into the dynamics of the industry and long experience in MEP services. Over a period of time we have inducted a highly motivated team of well qualified faculty members with vast industry experience both in the domestic as well as in the international industry. Each of the faculty members is well versed in nurturing talent, providing required learning and knowledge solutions along with giving adequate exposure to the industrial applications.
Achievements
Within a short duration of three years, we have earned a lot many accolades of the customers through our distinguished training schedule, high expertise and industry versed faculty team, well equipped modern infrastructural facilities and more over the placement assistance training programs. During our journey of three years, we have been able to place about 1000 students in varied reputed Indian industries & 176 students in overseas industries.
Why Us?
We have been catering to the MEP industry service sector with our vast resources and have received accolades and appreciation from numerous segments of the industry. Some of our areas of expertise are:
We have a modern infrastructure equipped with latest equipment and R&D facilities.
The faculty of our organization are well versed in their respective domains, have vast experience and are instrumental in capitalizing on the new employment opportunities.
We have made an indelible imprint on our clients by offering pro-active services.
Services provided by us are of exceptional quality, highly efficient and very cost effective.
We render comprehensive knowledge about the mechanical systems that can heat, filter, cool or re-humidify the air either in room or in an industry workplace.
Our Clients:-
We provide our trainees a conducive academic environment and training for the realization of their career ambitions and offer a perfect platform to grow. We specially cater to the candidates who have already received higher technical education in various engineering streams and are looking forward for a job oriented course. We have achieved a very high level of consistency in placement of our trainees across a wide spectrum of reputed companies.
Our clients are well placed in Petro-Chemical industry, Oil & Gas industry, Heavy Engineering, Construction industry etc and have expressed their satisfaction regarding the excellent on the job performance of our trainees.
Des is based in Hyderabad, Andhra Pradesh, India
· Provider Overview
· Locations
· Provider Profile
· Training Seminars
Head Office DCS-www.meptrainings.com, 2nd Floor Lenin Building, Besides Sai baba Temple, Bhagyanagar colony,opp:KPHB Colony, KukatpallyHyderabadAndhra Pradesh500072India Training and Seminar Locations · DCS, Hyderabad, A.P.
· Provider Overview
· Locations
· Provider Profile
· Training Seminars
Dhanush Computer Services Private Limited, formerly Dhanush Engineering Services, was established in the year 2004 in the Hi Tech City of Hyderabad. DCS Pvt Ltd provides services in MEP Training and Job Placements. The company is on a high growth trajectory within a short span of time due to our wide spread reach and innovative approach. Ever since our inception, we have been conducting employment oriented Training Courses for ITI, Diploma, B. E./ B. Tech. students and employees in Design and Drafting of HVAC, Plumbing, Electrical and Piping Process . The availability of highly experienced faculty members having 10 to 13 years of domestic experience and international exposure in HVAC, Plumbing, Electrical and Piping Industries is the an asset for the company.
Our well structured and highly valued training services are instrumental in the successful placements of a large number of our students in accordance to their preferences in a large number of Indian and multinational companies.
Business Objectives:-
We strongly believe in providing highly focused and industry oriented training services by continuously innovating in the areas of instructional design methodologies and development of cutting-edge curricula.
The details provided with our proposals precisely demonstrate the requisite eligibility as the best-fit option for the role of training of the candidates in the sunrise industry of HVAC, Plumbing, Electrical and Piping.
Strategic Activities:-
The company is working towards having Pan India presence for providing a comprehensive education and training environment in Building Services and Piping industry to individuals and enterprises along with providing customized training for the varied needs of the fast growing and ever changing specifications of the industry. A snapshot of our activities is mentioned below:
Campus placements through MOUs and Tie Ups with various reputed companies.
Employee training modules for corporates to cater to their company specific requirements.
Placement services for MEP trained job seekers and corporates through our exclusively focused MEP job portal.
Undertaking project works and outsourcing activities.
Infrastructural Facilities:-
We have a well equipped training center with excellent infrastructure in close proximity to the Hi Tech City in Hyderabad. The training center is spread in an area of 3500 square feet with well furnished class rooms, training aids and further expansions are on the anvil. The training center is fully computerized and has a training lab with 25 Pentium - 4 computers. In order to provide appropriate power back-up facility, we have installed a number of 18 KVA grade UPS systems in our computer lab.
Courses Offered:-
We are India s No. 1 trainer and a leading Talent Development Corporation offering learning and knowledge solutions in the latest HVAC grade industrial services to our trainees. Prior to enrollment we evaluate the compatibility of the trainees and counsel them to undertake an appropriate course based on their educational qualifications and aptitude. We assign a higher priority to the trainees with ITI, Diploma or B. E./ B. Tech. The entire course curriculum has been designed and developed with the help of our expert insight and industry requirements. The range of services, which we have been providing to trainees can be broadly categorized into six major categories:
HVAC Design and Drafting
Electrical-HVAC Design and Drafting
Plumbing, Fire Protection & Sanitary Design and Drafting
Piping Design and Drafting Oil & Gas / Process
Faculty Members:-
Our founder has an extensive insight into the dynamics of the industry and long experience in MEP services. Over a period of time we have inducted a highly motivated team of well qualified faculty members with vast industry experience both in the domestic as well as in the international industry. Each of the faculty members is well versed in nurturing talent, providing required learning and knowledge solutions along with giving adequate exposure to the industrial applications.
Achievements
Within a short duration of three years, we have earned a lot many accolades of the customers through our distinguished training schedule, high expertise and industry versed faculty team, well equipped modern infrastructural facilities and more over the placement assistance training programs. During our journey of three years, we have been able to place about 1000 students in varied reputed Indian industries & 176 students in overseas industries.
Why Us?
We have been catering to the MEP industry service sector with our vast resources and have received accolades and appreciation from numerous segments of the industry. Some of our areas of expertise are:
We have a modern infrastructure equipped with latest equipment and R&D facilities.
The faculty of our organization are well versed in their respective domains, have vast experience and are instrumental in capitalizing on the new employment opportunities.
We have made an indelible imprint on our clients by offering pro-active services.
Services provided by us are of exceptional quality, highly efficient and very cost effective.
We render comprehensive knowledge about the mechanical systems that can heat, filter, cool or re-humidify the air either in room or in an industry workplace.
Our Clients:-
We provide our trainees a conducive academic environment and training for the realization of their career ambitions and offer a perfect platform to grow. We specially cater to the candidates who have already received higher technical education in various engineering streams and are looking forward for a job oriented course. We have achieved a very high level of consistency in placement of our trainees across a wide spectrum of reputed companies.
Our clients are well placed in Petro-Chemical industry, Oil & Gas industry, Heavy Engineering, Construction industry etc and have expressed their satisfaction regarding the excellent on the job performance of our trainees.
Job Portal: www. mepjobsindia. com
Training Portal: www. meptrainings. com
Office: 2nd Floor, Lenin Building, Besides Saibaba Temple, Bhagyanagar Colony, Opp: KPHB colony, Hyderabad, INDIA.
Ph: 040-40064413/ 16,(0)9849172771
C-block, 204 / 206, Mayur Kushal Complex. Beside Chermas Showroom , Abids- 1. Hyderabad. India.
E-mail: info@ipebs.in
Tel: 0091-9885946711, 040-30623249
GOOD HVAC TRAINING CAN LAUNCH YOU INTO A REWARDING CAREERBY EXPERT HAVING 22 YEARS OF TRAINING EXPERIANCE THE FIRST & ONLY HVAC TRAINING WITH POINEERED EXPERIANCE IN PRACTICLE TRAINING FOR MECHANICLE ENGINEERS FOR GULF JOBS , THOUSANDS OF ENGINEERS R HANDLING CHALLENGING JOBS for details visit www.hvac-guru.com 9346929920 9247278680
GEMSTECH INTERNATIONAL TRAINING centre
RECOGNIZED BY GOVT OF AP INDIA & also
GLOBALLY RECOGNIZED TRAINING centre offer
OUR FULLY EQUIPPED ADVANCE LAB,
QUALIFIED ENGINEERS/GRADUATES/PG STAFF,
offers INTERNATIONAL STANDARD ENGINEERING & IT TRAINING DIPLOMA CERTIFICATES,ENGINEERING PROGRAMMES in
1) MEP HVAC Auto Cad CIVIL ARCHITECTURE STRUCTURAL and more,
ALSO OFFERS COURSES
FIRE AND SAFETY,MCSE,CCNA,CCNP, A+.N+.,COMPTIA.,LINUX ADMIN.,
Advance WEB Designing / Graphic Designing
FREE 100 % DUBAI GULF JOBS PLACEMENT ASSISTANCE after training of any professional ..!engineering / I T course
NO HIDTaiba Engineering Consultants
040 –64604442,9963759411.
16-2-698/699, first floor
lane opp Mahesh Bank Paltan
Malakpet,Hyderabad
HVAC Designing and Drafting:-
COURSE CONTANT:-
1. Introduction and fundamentals of HVAC,
2. Definitions as per ASHRAE.
3. Terminology used in HVAC.
4. Modes of Heat transfer.
5. Study of Psychrometric chart.
6. Refrigeration components.
1) Compressor,2) Condenser,3) Expansion valve, 4) Evaporator.
7. Basic Refrigeration Cycle.
8. Line Diagrams and Cycle of
1) Window A/c ,2) Split A/c, 3) Packaged A/c, 4) Central A/c system.
9. Types Air Conditioning Systems.
1) All Air system , 2) All water system,3) Air water system,
4) Direct Refrigeration system.
10, Building Survey,
11. Orientation of Building.
12 To Read Latitude of location of Building.
12. Calculation of U factor for Walls, Glass, Roof, Partitions.
13. Calculation of Temperature Difference of Walls, Glass, Roof, Partitions,
14. Cooling and Heat load Calculations using ASHRAE Standards.
15. Filling of E-20 Form.
16. Calculation of Sensible Heat factor, ADP and Dehumidified CFM.
17 Duct designing : -
Ducted Air Velocities, Friction losses, Duct sizing methods (Equal friction method, Velocity reduction method, Static regain method), Aspect ratio,
Duct sizing by use of Ductulator and Duct sizing software, Types of ducts, Duct materials, Calculation of No. of sheets, Duct Insulations, Duct Installation method , Duct testing methods, Noise control.
18. Layouts of. Single line Diagrams.
19. Convertion of single line to Double line.
20. Static pressure calculations.
21. Calculations of the Horse power of Fan motor.
22. Types of fan and fan laws.
23. Air Distribution System.
CAV, VAV,
24 Designing of Chilled water piping,
25 Refrigerant piping.
26. Equipment Selection.
27. HVAC systems maintenance.
Two Projects:-
Heat load calculation, Duct sizing, Duct layout and Equipment Selection.
HVAC Operation and Maintenance
Course Content: -
1. Basic fundamentals of Air-conditioning
2. Basic refrigeration cycle
3. Types of the air-conditioning system
4. Components of air-conditioning system
5. Line diagrams of
a. Window A/c
b. Split A/c
c. Package A/c
d. Central A/c system
6. Terminology used in air-conditioning
7. Types of the compressors
8. Types of the condensers
9. Types of evaporators
10. Types of cooling towers
11. Types of Air Handling Units
12. Types of controls used in air-conditioning systems
13. Chilled water system
14. Direct expansion system
15. Operation :-
a. Operating procedures
b. Starting sequence
c. Stopping sequence
d. Log sheet for plant room readings
e. Log sheet for room temperature readings
f. Inspection and routine maintenance
g. Routine service operations
-Pumpdown of the A/c system
-Purging of the non condensable gas
-Gas charging of A/c system
16. Preventive maintenance of
a. Window A/c
b. Split A/c
c. Package A/c
d. Central A/c System
17. Maintenance schedules of air-conditioning systems
18. Condenser descaling method
19. Methods of control settings:-
a. HP-LP switches
b. Thermostat switches
c. Oil Pressure switches
20. Method of setting super heat of expansion valve
21. Diagnoses of the faults
22. Trouble shooting of faults
Two projects: - Case study of trouble shootings
Placement:- We will send you interview calls till you get jobs.
For more information contact:-
Ambay HVAC Training Center,
1st Floor, Unit -3 , Alay,
Opp Saibaba Temple,
Behind State Bank of India,
Near Punit Ashram,
Balvatika,
Maninagar,
Ahmedabad-380008
Gujarat.
Ph: - 079- 25471173.
Mobile:- 9998610690.
Email:ambayengineering@rediffmail.com
Web site:- www.ambayhvac.com
HEAD OFFICE : DUBAI,
ASIA : REGIONAL OFFICE
Flat 402,-Manzil Chambers,Mehdipatnam,
HYDERABAD,AP,INDIA.
Tel: 9346356290, 66106290,66715640,
Branches:Mehdipatnam,Tolichowki,Lakdi-ka-pul, Warangal,Nizamabad.
E-mail: www.gemstechnologies.com - info@gemstechnologies.com.
Send us your enquiry or feedback by filling out the form below:
HVAC Training HVAC Designing and Drafting course details www. meptrainings. com
mepenquiry(at)mepjobsindia. com or call 0091 40 40064413/ 16.
For Engineers and Diploma holders.
For Jobs: www. mepjobsindia. com
We provide Placement assistance till you get job.
Certificate Program Provided by Des HVAC Drafting and Designing
COURSE CONTENT
1. Introduction and Fundamentals of Air Conditioning.
2. Modes of Heat Transfer
3. Basic Components of Air-Conditioning and Refrigeration machines
4. Refrigeration cycle - Line Diagrams
1) Basic Refrigeration Cycle
2) Chill water cycle
1. Air cooled Chillers 2. Water cooled Chillers
5. Types of Air conditioning
1)Window A/ C 2)Spilt A/ C 3)Package A/ C 4)Central A/ C
6. Categories of Air Conditioning
1) All air system
2) All water system
3) Air water system
4) Direct Refrigerant system
7. Study of psychometric charts
8. Survey of Building
9. Materials used in the Building
Finding Temperature difference and U Factor
For Wall, Glass, Roof, Partition.
10. Load Calculations.
Filling of E-20 Forms as per ASHRAE Standards for finding TR
11. ADP &CFM calculation
12. Duct-Definition and types.
13. Materials of Duct and its specification (Gauges)
14. Duct design consideration for Duct sizing as per Aspect Ratio
15. Duct size method Equal Friction method
Velocity reduction method.
Static regain method
16. Finding Duct size using Ductalator & Duct sizer software
17. Calculation of No of sheets.
18. Symbols as per DW144 international standards.
19. Preparation of single line diagram (SLD) in drawing sheet.
20. Layouts (Double line) as per SMACNA rules.
21. Wall openings drawings wherever duct is passing through walls
22. Sectional Drawing of DUCTS & its supports.
23 Insulation 0f DUCT, Balancing of Duct, Leakage Test
24. Static Pressure calculation for selection of motor & Fan.
25. Pipe size. Calculation (chill water pipe)
26. Fittings used in piping.
27. Sectional drawing of pipe & its supports
28. Air Distribution system
29. Fire Fighting Equipment (Awareness).
30. HVAC software
And many more ..
Video s of Duct Fabrication, Energy saving (i. e. in HVAC systems)
Annexure as per ASHRAE
CD - Duct sizer, subject oriented topics and many important topics 400MB
NEW BATCHES START
Every month on 6th and 21st, duration would be 45 days 2 hrs.
Every month on 15th fast track, duration would be 15days 6hrs.
DCS Pvt Ltd.,
2nd Floor, Lenin Building
Above Alankar Tiffin Center
Besides Saibaba Temple.
Bhagya nagar Colony
Opp: KPHB Colony
Kukatpally, Hyderabad
500072
PH: 040 40063771
Mobile: 9908080816
www. meptrainings. Com
Floor, Lenin Building, Opp: Apollo Hospital, Bhagyanagar, Opp: KPHB, Hyderabad, India
9849172771,040-40063771.
Majety_cdhar@yahoo.com
HVAC practicle training progrrame
business - Nampalli - institute/school
Posted on: Tue, 2 Sep 2008, 10:00 PM
GOOD HVAC TRAINING CAN LAUNCH YOU INTO A REWARDING CAREER
BY EXPERT HAVING 22 YEARS OF TRAINING EXPERIANCE
THE FIRST & ONLY HVAC TRAINING WITH POINEERED EXPERIANCE
IN PRACTICLE TRAINING FOR MECHANICLE ENGINEERS FOR GULF JOBS
, THOUSANDS OF ENGINEERS R HANDLING CHALLENGING JOBS
for details visit www.hvac-guru.com 9346929920
9247278680
Mobile: +91-93469 29920
Posted by Abinitio at 7:07 PM 0 comments
DEN CHARGES .,for more details plz call us
GEMSTECH offers international standard professional training OUR ENGINEERS PRESENTLY WORKING IN <>WORLD TOP 10 COMPANIES>> >>FORTUNES 10 << <>WHY NOT YOU ! <> WE CARE YOUR CAREER At GEMSTECH, we offer complete courses PROFESSIONAL, DOCTORATE, ENGINEERING-diploma-certificates programs, including Information Technology. MCSE,MCP,MCSA,CCNA,CCNP,CCIE., A+ N+., Advance Hardware & Networking , web designing, Graphic designing, Accounts, SAP,Fico, BASIS,HR, Autocad,HVAC, MEP., FIRE AND SAFETY engineering, Health Safety Environment NFPA CERTIFIED course., MANY JOBS READY in India as well as in Gulf Countries like Dubai, Bahrain, Qatar, Kuwait, Saudi Arabia,Singapore, UK, USA, Canada.! our International accepted courses: 1. Fire & Safety 2. Construction Safety 3. Industrial Safety 4. Health and Environmental Safety Eligibility: SSC/INTERMEDIATE/DEGREE ANY LOCAL and INTERNATIONAL 100% jobs Placements assistance FROM DUBAI HEAD OFFICE Contact : ZEBA
Dhanush Computer Services Private Limited, formerly Dhanush Engineering Services, was established in the year 2004 in the Hi Tech City of Hyderabad. DCS Pvt Ltd provides services in MEP Training and Job Placements. The company is on a high growth trajectory within a short span of time due to our wide spread reach and innovative approach. Ever since our inception, we have been conducting employment oriented Training Courses for ITI, Diploma, B. E./ B. Tech. students and employees in Design and Drafting of HVAC, Plumbing, Electrical and Piping Process . The availability of highly experienced faculty members having 10 to 13 years of domestic experience and international exposure in HVAC, Plumbing, Electrical and Piping Industries is the an asset for the company.
Our well structured and highly valued training services are instrumental in the successful placements of a large number of our students in accordance to their preferences in a large number of Indian and multinational companies.
Business Objectives:-
We strongly believe in providing highly focused and industry oriented training services by continuously innovating in the areas of instructional design methodologies and development of cutting-edge curricula.
The details provided with our proposals precisely demonstrate the requisite eligibility as the best-fit option for the role of training of the candidates in the sunrise industry of HVAC, Plumbing, Electrical and Piping.
Strategic Activities:-
The company is working towards having Pan India presence for providing a comprehensive education and training environment in Building Services and Piping industry to individuals and enterprises along with providing customized training for the varied needs of the fast growing and ever changing specifications of the industry. A snapshot of our activities is mentioned below:
Campus placements through MOUs and Tie Ups with various reputed companies.
Employee training modules for corporates to cater to their company specific requirements.
Placement services for MEP trained job seekers and corporates through our exclusively focused MEP job portal.
Undertaking project works and outsourcing activities.
Infrastructural Facilities:-
We have a well equipped training center with excellent infrastructure in close proximity to the Hi Tech City in Hyderabad. The training center is spread in an area of 3500 square feet with well furnished class rooms, training aids and further expansions are on the anvil. The training center is fully computerized and has a training lab with 25 Pentium - 4 computers. In order to provide appropriate power back-up facility, we have installed a number of 18 KVA grade UPS systems in our computer lab.
Courses Offered:-
We are India s No. 1 trainer and a leading Talent Development Corporation offering learning and knowledge solutions in the latest HVAC grade industrial services to our trainees. Prior to enrollment we evaluate the compatibility of the trainees and counsel them to undertake an appropriate course based on their educational qualifications and aptitude. We assign a higher priority to the trainees with ITI, Diploma or B. E./ B. Tech. The entire course curriculum has been designed and developed with the help of our expert insight and industry requirements. The range of services, which we have been providing to trainees can be broadly categorized into six major categories:
HVAC Design and Drafting
Electrical-HVAC Design and Drafting
Plumbing, Fire Protection & Sanitary Design and Drafting
Piping Design and Drafting Oil & Gas / Process
Faculty Members:-
Our founder has an extensive insight into the dynamics of the industry and long experience in MEP services. Over a period of time we have inducted a highly motivated team of well qualified faculty members with vast industry experience both in the domestic as well as in the international industry. Each of the faculty members is well versed in nurturing talent, providing required learning and knowledge solutions along with giving adequate exposure to the industrial applications.
Achievements
Within a short duration of three years, we have earned a lot many accolades of the customers through our distinguished training schedule, high expertise and industry versed faculty team, well equipped modern infrastructural facilities and more over the placement assistance training programs. During our journey of three years, we have been able to place about 1000 students in varied reputed Indian industries & 176 students in overseas industries.
Why Us?
We have been catering to the MEP industry service sector with our vast resources and have received accolades and appreciation from numerous segments of the industry. Some of our areas of expertise are:
We have a modern infrastructure equipped with latest equipment and R&D facilities.
The faculty of our organization are well versed in their respective domains, have vast experience and are instrumental in capitalizing on the new employment opportunities.
We have made an indelible imprint on our clients by offering pro-active services.
Services provided by us are of exceptional quality, highly efficient and very cost effective.
We render comprehensive knowledge about the mechanical systems that can heat, filter, cool or re-humidify the air either in room or in an industry workplace.
Our Clients:-
We provide our trainees a conducive academic environment and training for the realization of their career ambitions and offer a perfect platform to grow. We specially cater to the candidates who have already received higher technical education in various engineering streams and are looking forward for a job oriented course. We have achieved a very high level of consistency in placement of our trainees across a wide spectrum of reputed companies.
Our clients are well placed in Petro-Chemical industry, Oil & Gas industry, Heavy Engineering, Construction industry etc and have expressed their satisfaction regarding the excellent on the job performance of our trainees.
Des is based in Hyderabad, Andhra Pradesh, India
· Provider Overview
· Locations
· Provider Profile
· Training Seminars
Head Office DCS-www.meptrainings.com, 2nd Floor Lenin Building, Besides Sai baba Temple, Bhagyanagar colony,opp:KPHB Colony, KukatpallyHyderabadAndhra Pradesh500072India Training and Seminar Locations · DCS, Hyderabad, A.P.
· Provider Overview
· Locations
· Provider Profile
· Training Seminars
Dhanush Computer Services Private Limited, formerly Dhanush Engineering Services, was established in the year 2004 in the Hi Tech City of Hyderabad. DCS Pvt Ltd provides services in MEP Training and Job Placements. The company is on a high growth trajectory within a short span of time due to our wide spread reach and innovative approach. Ever since our inception, we have been conducting employment oriented Training Courses for ITI, Diploma, B. E./ B. Tech. students and employees in Design and Drafting of HVAC, Plumbing, Electrical and Piping Process . The availability of highly experienced faculty members having 10 to 13 years of domestic experience and international exposure in HVAC, Plumbing, Electrical and Piping Industries is the an asset for the company.
Our well structured and highly valued training services are instrumental in the successful placements of a large number of our students in accordance to their preferences in a large number of Indian and multinational companies.
Business Objectives:-
We strongly believe in providing highly focused and industry oriented training services by continuously innovating in the areas of instructional design methodologies and development of cutting-edge curricula.
The details provided with our proposals precisely demonstrate the requisite eligibility as the best-fit option for the role of training of the candidates in the sunrise industry of HVAC, Plumbing, Electrical and Piping.
Strategic Activities:-
The company is working towards having Pan India presence for providing a comprehensive education and training environment in Building Services and Piping industry to individuals and enterprises along with providing customized training for the varied needs of the fast growing and ever changing specifications of the industry. A snapshot of our activities is mentioned below:
Campus placements through MOUs and Tie Ups with various reputed companies.
Employee training modules for corporates to cater to their company specific requirements.
Placement services for MEP trained job seekers and corporates through our exclusively focused MEP job portal.
Undertaking project works and outsourcing activities.
Infrastructural Facilities:-
We have a well equipped training center with excellent infrastructure in close proximity to the Hi Tech City in Hyderabad. The training center is spread in an area of 3500 square feet with well furnished class rooms, training aids and further expansions are on the anvil. The training center is fully computerized and has a training lab with 25 Pentium - 4 computers. In order to provide appropriate power back-up facility, we have installed a number of 18 KVA grade UPS systems in our computer lab.
Courses Offered:-
We are India s No. 1 trainer and a leading Talent Development Corporation offering learning and knowledge solutions in the latest HVAC grade industrial services to our trainees. Prior to enrollment we evaluate the compatibility of the trainees and counsel them to undertake an appropriate course based on their educational qualifications and aptitude. We assign a higher priority to the trainees with ITI, Diploma or B. E./ B. Tech. The entire course curriculum has been designed and developed with the help of our expert insight and industry requirements. The range of services, which we have been providing to trainees can be broadly categorized into six major categories:
HVAC Design and Drafting
Electrical-HVAC Design and Drafting
Plumbing, Fire Protection & Sanitary Design and Drafting
Piping Design and Drafting Oil & Gas / Process
Faculty Members:-
Our founder has an extensive insight into the dynamics of the industry and long experience in MEP services. Over a period of time we have inducted a highly motivated team of well qualified faculty members with vast industry experience both in the domestic as well as in the international industry. Each of the faculty members is well versed in nurturing talent, providing required learning and knowledge solutions along with giving adequate exposure to the industrial applications.
Achievements
Within a short duration of three years, we have earned a lot many accolades of the customers through our distinguished training schedule, high expertise and industry versed faculty team, well equipped modern infrastructural facilities and more over the placement assistance training programs. During our journey of three years, we have been able to place about 1000 students in varied reputed Indian industries & 176 students in overseas industries.
Why Us?
We have been catering to the MEP industry service sector with our vast resources and have received accolades and appreciation from numerous segments of the industry. Some of our areas of expertise are:
We have a modern infrastructure equipped with latest equipment and R&D facilities.
The faculty of our organization are well versed in their respective domains, have vast experience and are instrumental in capitalizing on the new employment opportunities.
We have made an indelible imprint on our clients by offering pro-active services.
Services provided by us are of exceptional quality, highly efficient and very cost effective.
We render comprehensive knowledge about the mechanical systems that can heat, filter, cool or re-humidify the air either in room or in an industry workplace.
Our Clients:-
We provide our trainees a conducive academic environment and training for the realization of their career ambitions and offer a perfect platform to grow. We specially cater to the candidates who have already received higher technical education in various engineering streams and are looking forward for a job oriented course. We have achieved a very high level of consistency in placement of our trainees across a wide spectrum of reputed companies.
Our clients are well placed in Petro-Chemical industry, Oil & Gas industry, Heavy Engineering, Construction industry etc and have expressed their satisfaction regarding the excellent on the job performance of our trainees.
Job Portal: www. mepjobsindia. com
Training Portal: www. meptrainings. com
Office: 2nd Floor, Lenin Building, Besides Saibaba Temple, Bhagyanagar Colony, Opp: KPHB colony, Hyderabad, INDIA.
Ph: 040-40064413/ 16,(0)9849172771
C-block, 204 / 206, Mayur Kushal Complex. Beside Chermas Showroom , Abids- 1. Hyderabad. India.
E-mail: info@ipebs.in
Tel: 0091-9885946711, 040-30623249
GOOD HVAC TRAINING CAN LAUNCH YOU INTO A REWARDING CAREERBY EXPERT HAVING 22 YEARS OF TRAINING EXPERIANCE THE FIRST & ONLY HVAC TRAINING WITH POINEERED EXPERIANCE IN PRACTICLE TRAINING FOR MECHANICLE ENGINEERS FOR GULF JOBS , THOUSANDS OF ENGINEERS R HANDLING CHALLENGING JOBS for details visit www.hvac-guru.com 9346929920 9247278680
Monday, November 03, 2008
hvac links
http://www.contractortalk.com/showthread.php?s=0316d4b8e4bd15efbd5e9789aaeaa278&t=21927
http://dms.myflorida.com/business_operations/state_purchasing/vendor_information/state_contracts_agreements_and_price_lists/state_term_contracts/maintenance_repair_and_operation_mro_supplies/price_sheets_compressors_pumps_hvac_heating_ventilation_hardware_material_handling_equipment_paint_supplies_and_plumbing_equipment_ww_grainger
http://www.cadpipe.com/hvac/hvacBOM.html
http://www.hvac-talk.com/vbb/showthread.php?p=1909783
http://www.hvactraining.com/
http://www.hvactraining.com/downloads.html
http://www.pipeflow.co.uk/public/control.php
http://dms.myflorida.com/business_operations/state_purchasing/vendor_information/state_contracts_agreements_and_price_lists/state_term_contracts/maintenance_repair_and_operation_mro_supplies/price_sheets_compressors_pumps_hvac_heating_ventilation_hardware_material_handling_equipment_paint_supplies_and_plumbing_equipment_ww_grainger
http://www.cadpipe.com/hvac/hvacBOM.html
http://www.hvac-talk.com/vbb/showthread.php?p=1909783
http://www.hvactraining.com/
http://www.hvactraining.com/downloads.html
http://www.pipeflow.co.uk/public/control.php
hvac Training Information
Taiba Engineering Consultants
040 –64604442,9963759411.
16-2-698/699, first floor
lane opp Mahesh Bank Paltan
Malakpet,Hyderabad
HVAC Designing and Drafting:-
COURSE CONTANT:-
1. Introduction and fundamentals of HVAC,
2. Definitions as per ASHRAE.
3. Terminology used in HVAC.
4. Modes of Heat transfer.
5. Study of Psychrometric chart.
6. Refrigeration components.
1) Compressor,2) Condenser,3) Expansion valve, 4) Evaporator.
7. Basic Refrigeration Cycle.
8. Line Diagrams and Cycle of
1) Window A/c ,2) Split A/c, 3) Packaged A/c, 4) Central A/c system.
9. Types Air Conditioning Systems.
1) All Air system , 2) All water system,3) Air water system,
4) Direct Refrigeration system.
10, Building Survey,
11. Orientation of Building.
12 To Read Latitude of location of Building.
12. Calculation of U factor for Walls, Glass, Roof, Partitions.
13. Calculation of Temperature Difference of Walls, Glass, Roof, Partitions,
14. Cooling and Heat load Calculations using ASHRAE Standards.
15. Filling of E-20 Form.
16. Calculation of Sensible Heat factor, ADP and Dehumidified CFM.
17 Duct designing : -
Ducted Air Velocities, Friction losses, Duct sizing methods (Equal friction method, Velocity reduction method, Static regain method), Aspect ratio,
Duct sizing by use of Ductulator and Duct sizing software, Types of ducts, Duct materials, Calculation of No. of sheets, Duct Insulations, Duct Installation method , Duct testing methods, Noise control.
18. Layouts of. Single line Diagrams.
19. Convertion of single line to Double line.
20. Static pressure calculations.
21. Calculations of the Horse power of Fan motor.
22. Types of fan and fan laws.
23. Air Distribution System.
CAV, VAV,
24 Designing of Chilled water piping,
25 Refrigerant piping.
26. Equipment Selection.
27. HVAC systems maintenance.
Two Projects:-
Heat load calculation, Duct sizing, Duct layout and Equipment Selection.
HVAC Operation and Maintenance
Course Content: -
1. Basic fundamentals of Air-conditioning
2. Basic refrigeration cycle
3. Types of the air-conditioning system
4. Components of air-conditioning system
5. Line diagrams of
a. Window A/c
b. Split A/c
c. Package A/c
d. Central A/c system
6. Terminology used in air-conditioning
7. Types of the compressors
8. Types of the condensers
9. Types of evaporators
10. Types of cooling towers
11. Types of Air Handling Units
12. Types of controls used in air-conditioning systems
13. Chilled water system
14. Direct expansion system
15. Operation :-
a. Operating procedures
b. Starting sequence
c. Stopping sequence
d. Log sheet for plant room readings
e. Log sheet for room temperature readings
f. Inspection and routine maintenance
g. Routine service operations
-Pumpdown of the A/c system
-Purging of the non condensable gas
-Gas charging of A/c system
16. Preventive maintenance of
a. Window A/c
b. Split A/c
c. Package A/c
d. Central A/c System
17. Maintenance schedules of air-conditioning systems
18. Condenser descaling method
19. Methods of control settings:-
a. HP-LP switches
b. Thermostat switches
c. Oil Pressure switches
20. Method of setting super heat of expansion valve
21. Diagnoses of the faults
22. Trouble shooting of faults
Two projects: - Case study of trouble shootings
Placement:- We will send you interview calls till you get jobs.
For more information contact:-
Ambay HVAC Training Center,
1st Floor, Unit -3 , Alay,
Opp Saibaba Temple,
Behind State Bank of India,
Near Punit Ashram,
Balvatika,
Maninagar,
Ahmedabad-380008
Gujarat.
Ph: - 079- 25471173.
Mobile:- 9998610690.
Email:ambayengineering@rediffmail.com
Web site:- www.ambayhvac.com
HEAD OFFICE : DUBAI,
ASIA : REGIONAL OFFICE
Flat 402,-Manzil Chambers,Mehdipatnam,
HYDERABAD,AP,INDIA.
Tel: 9346356290, 66106290,66715640,
Branches:Mehdipatnam,Tolichowki,Lakdi-ka-pul, Warangal,Nizamabad.
E-mail: www.gemstechnologies.com - info@gemstechnologies.com.
Send us your enquiry or feedback by filling out the form below:
HVAC Training HVAC Designing and Drafting course details www. meptrainings. com
mepenquiry(at)mepjobsindia. com or call 0091 40 40064413/ 16.
For Engineers and Diploma holders.
For Jobs: www. mepjobsindia. com
We provide Placement assistance till you get job.
Certificate Program Provided by Des HVAC Drafting and Designing
COURSE CONTENT
1. Introduction and Fundamentals of Air Conditioning.
2. Modes of Heat Transfer
3. Basic Components of Air-Conditioning and Refrigeration machines
4. Refrigeration cycle - Line Diagrams
1) Basic Refrigeration Cycle
2) Chill water cycle
1. Air cooled Chillers 2. Water cooled Chillers
5. Types of Air conditioning
1)Window A/ C 2)Spilt A/ C 3)Package A/ C 4)Central A/ C
6. Categories of Air Conditioning
1) All air system
2) All water system
3) Air water system
4) Direct Refrigerant system
7. Study of psychometric charts
8. Survey of Building
9. Materials used in the Building
Finding Temperature difference and U Factor
For Wall, Glass, Roof, Partition.
10. Load Calculations.
Filling of E-20 Forms as per ASHRAE Standards for finding TR
11. ADP &CFM calculation
12. Duct-Definition and types.
13. Materials of Duct and its specification (Gauges)
14. Duct design consideration for Duct sizing as per Aspect Ratio
15. Duct size method Equal Friction method
Velocity reduction method.
Static regain method
16. Finding Duct size using Ductalator & Duct sizer software
17. Calculation of No of sheets.
18. Symbols as per DW144 international standards.
19. Preparation of single line diagram (SLD) in drawing sheet.
20. Layouts (Double line) as per SMACNA rules.
21. Wall openings drawings wherever duct is passing through walls
22. Sectional Drawing of DUCTS & its supports.
23 Insulation 0f DUCT, Balancing of Duct, Leakage Test
24. Static Pressure calculation for selection of motor & Fan.
25. Pipe size. Calculation (chill water pipe)
26. Fittings used in piping.
27. Sectional drawing of pipe & its supports
28. Air Distribution system
29. Fire Fighting Equipment (Awareness).
30. HVAC software
And many more ..
Video s of Duct Fabrication, Energy saving (i. e. in HVAC systems)
Annexure as per ASHRAE
CD - Duct sizer, subject oriented topics and many important topics 400MB
NEW BATCHES START
Every month on 6th and 21st, duration would be 45 days 2 hrs.
Every month on 15th fast track, duration would be 15days 6hrs.
DCS Pvt Ltd.,
2nd Floor, Lenin Building
Above Alankar Tiffin Center
Besides Saibaba Temple.
Bhagya nagar Colony
Opp: KPHB Colony
Kukatpally, Hyderabad
500072
PH: 040 40063771
Mobile: 9908080816
www. meptrainings. Com
Floor, Lenin Building, Opp: Apollo Hospital, Bhagyanagar, Opp: KPHB, Hyderabad, India
9849172771,040-40063771.
Majety_cdhar@yahoo.com
HVAC practicle training progrrame
business - Nampalli - institute/school
Posted on: Tue, 2 Sep 2008, 10:00 PM
GOOD HVAC TRAINING CAN LAUNCH YOU INTO A REWARDING CAREER
BY EXPERT HAVING 22 YEARS OF TRAINING EXPERIANCE
THE FIRST & ONLY HVAC TRAINING WITH POINEERED EXPERIANCE
IN PRACTICLE TRAINING FOR MECHANICLE ENGINEERS FOR GULF JOBS
, THOUSANDS OF ENGINEERS R HANDLING CHALLENGING JOBS
for details visit www.hvac-guru.com 9346929920
9247278680
Mobile: +91-93469 29920
040 –64604442,9963759411.
16-2-698/699, first floor
lane opp Mahesh Bank Paltan
Malakpet,Hyderabad
HVAC Designing and Drafting:-
COURSE CONTANT:-
1. Introduction and fundamentals of HVAC,
2. Definitions as per ASHRAE.
3. Terminology used in HVAC.
4. Modes of Heat transfer.
5. Study of Psychrometric chart.
6. Refrigeration components.
1) Compressor,2) Condenser,3) Expansion valve, 4) Evaporator.
7. Basic Refrigeration Cycle.
8. Line Diagrams and Cycle of
1) Window A/c ,2) Split A/c, 3) Packaged A/c, 4) Central A/c system.
9. Types Air Conditioning Systems.
1) All Air system , 2) All water system,3) Air water system,
4) Direct Refrigeration system.
10, Building Survey,
11. Orientation of Building.
12 To Read Latitude of location of Building.
12. Calculation of U factor for Walls, Glass, Roof, Partitions.
13. Calculation of Temperature Difference of Walls, Glass, Roof, Partitions,
14. Cooling and Heat load Calculations using ASHRAE Standards.
15. Filling of E-20 Form.
16. Calculation of Sensible Heat factor, ADP and Dehumidified CFM.
17 Duct designing : -
Ducted Air Velocities, Friction losses, Duct sizing methods (Equal friction method, Velocity reduction method, Static regain method), Aspect ratio,
Duct sizing by use of Ductulator and Duct sizing software, Types of ducts, Duct materials, Calculation of No. of sheets, Duct Insulations, Duct Installation method , Duct testing methods, Noise control.
18. Layouts of. Single line Diagrams.
19. Convertion of single line to Double line.
20. Static pressure calculations.
21. Calculations of the Horse power of Fan motor.
22. Types of fan and fan laws.
23. Air Distribution System.
CAV, VAV,
24 Designing of Chilled water piping,
25 Refrigerant piping.
26. Equipment Selection.
27. HVAC systems maintenance.
Two Projects:-
Heat load calculation, Duct sizing, Duct layout and Equipment Selection.
HVAC Operation and Maintenance
Course Content: -
1. Basic fundamentals of Air-conditioning
2. Basic refrigeration cycle
3. Types of the air-conditioning system
4. Components of air-conditioning system
5. Line diagrams of
a. Window A/c
b. Split A/c
c. Package A/c
d. Central A/c system
6. Terminology used in air-conditioning
7. Types of the compressors
8. Types of the condensers
9. Types of evaporators
10. Types of cooling towers
11. Types of Air Handling Units
12. Types of controls used in air-conditioning systems
13. Chilled water system
14. Direct expansion system
15. Operation :-
a. Operating procedures
b. Starting sequence
c. Stopping sequence
d. Log sheet for plant room readings
e. Log sheet for room temperature readings
f. Inspection and routine maintenance
g. Routine service operations
-Pumpdown of the A/c system
-Purging of the non condensable gas
-Gas charging of A/c system
16. Preventive maintenance of
a. Window A/c
b. Split A/c
c. Package A/c
d. Central A/c System
17. Maintenance schedules of air-conditioning systems
18. Condenser descaling method
19. Methods of control settings:-
a. HP-LP switches
b. Thermostat switches
c. Oil Pressure switches
20. Method of setting super heat of expansion valve
21. Diagnoses of the faults
22. Trouble shooting of faults
Two projects: - Case study of trouble shootings
Placement:- We will send you interview calls till you get jobs.
For more information contact:-
Ambay HVAC Training Center,
1st Floor, Unit -3 , Alay,
Opp Saibaba Temple,
Behind State Bank of India,
Near Punit Ashram,
Balvatika,
Maninagar,
Ahmedabad-380008
Gujarat.
Ph: - 079- 25471173.
Mobile:- 9998610690.
Email:ambayengineering@rediffmail.com
Web site:- www.ambayhvac.com
HEAD OFFICE : DUBAI,
ASIA : REGIONAL OFFICE
Flat 402,-Manzil Chambers,Mehdipatnam,
HYDERABAD,AP,INDIA.
Tel: 9346356290, 66106290,66715640,
Branches:Mehdipatnam,Tolichowki,Lakdi-ka-pul, Warangal,Nizamabad.
E-mail: www.gemstechnologies.com - info@gemstechnologies.com.
Send us your enquiry or feedback by filling out the form below:
HVAC Training HVAC Designing and Drafting course details www. meptrainings. com
mepenquiry(at)mepjobsindia. com or call 0091 40 40064413/ 16.
For Engineers and Diploma holders.
For Jobs: www. mepjobsindia. com
We provide Placement assistance till you get job.
Certificate Program Provided by Des HVAC Drafting and Designing
COURSE CONTENT
1. Introduction and Fundamentals of Air Conditioning.
2. Modes of Heat Transfer
3. Basic Components of Air-Conditioning and Refrigeration machines
4. Refrigeration cycle - Line Diagrams
1) Basic Refrigeration Cycle
2) Chill water cycle
1. Air cooled Chillers 2. Water cooled Chillers
5. Types of Air conditioning
1)Window A/ C 2)Spilt A/ C 3)Package A/ C 4)Central A/ C
6. Categories of Air Conditioning
1) All air system
2) All water system
3) Air water system
4) Direct Refrigerant system
7. Study of psychometric charts
8. Survey of Building
9. Materials used in the Building
Finding Temperature difference and U Factor
For Wall, Glass, Roof, Partition.
10. Load Calculations.
Filling of E-20 Forms as per ASHRAE Standards for finding TR
11. ADP &CFM calculation
12. Duct-Definition and types.
13. Materials of Duct and its specification (Gauges)
14. Duct design consideration for Duct sizing as per Aspect Ratio
15. Duct size method Equal Friction method
Velocity reduction method.
Static regain method
16. Finding Duct size using Ductalator & Duct sizer software
17. Calculation of No of sheets.
18. Symbols as per DW144 international standards.
19. Preparation of single line diagram (SLD) in drawing sheet.
20. Layouts (Double line) as per SMACNA rules.
21. Wall openings drawings wherever duct is passing through walls
22. Sectional Drawing of DUCTS & its supports.
23 Insulation 0f DUCT, Balancing of Duct, Leakage Test
24. Static Pressure calculation for selection of motor & Fan.
25. Pipe size. Calculation (chill water pipe)
26. Fittings used in piping.
27. Sectional drawing of pipe & its supports
28. Air Distribution system
29. Fire Fighting Equipment (Awareness).
30. HVAC software
And many more ..
Video s of Duct Fabrication, Energy saving (i. e. in HVAC systems)
Annexure as per ASHRAE
CD - Duct sizer, subject oriented topics and many important topics 400MB
NEW BATCHES START
Every month on 6th and 21st, duration would be 45 days 2 hrs.
Every month on 15th fast track, duration would be 15days 6hrs.
DCS Pvt Ltd.,
2nd Floor, Lenin Building
Above Alankar Tiffin Center
Besides Saibaba Temple.
Bhagya nagar Colony
Opp: KPHB Colony
Kukatpally, Hyderabad
500072
PH: 040 40063771
Mobile: 9908080816
www. meptrainings. Com
Floor, Lenin Building, Opp: Apollo Hospital, Bhagyanagar, Opp: KPHB, Hyderabad, India
9849172771,040-40063771.
Majety_cdhar@yahoo.com
HVAC practicle training progrrame
business - Nampalli - institute/school
Posted on: Tue, 2 Sep 2008, 10:00 PM
GOOD HVAC TRAINING CAN LAUNCH YOU INTO A REWARDING CAREER
BY EXPERT HAVING 22 YEARS OF TRAINING EXPERIANCE
THE FIRST & ONLY HVAC TRAINING WITH POINEERED EXPERIANCE
IN PRACTICLE TRAINING FOR MECHANICLE ENGINEERS FOR GULF JOBS
, THOUSANDS OF ENGINEERS R HANDLING CHALLENGING JOBS
for details visit www.hvac-guru.com 9346929920
9247278680
Mobile: +91-93469 29920
Friday, October 03, 2008
Thursday, October 02, 2008
Cognos 8BI information Sites
http://www.cognoise.com
http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos8-l/cognos-8-bi-installation-1437733?cv=expanded#
http://books.google.co.in/books?id=A55Ng8EMGVQC&pg=PA6&lpg=PA6&dq=cognos+8bi++installation+steps&source=web&ots=Ox36-MKXEL&sig=j74I7_3EGeTXHWM10BWHpGWtOjo&hl=en&sa=X&oi=book_result&resnum=5&ct=result#PPA16,M1
http://cognosforums.com/forums/viewforum.php?f=8
http://www.prometricexam.com/BI0-132.htm
http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos8-l/cognos-8-bi-installation-1437733?cv=expanded#
http://books.google.co.in/books?id=A55Ng8EMGVQC&pg=PA6&lpg=PA6&dq=cognos+8bi++installation+steps&source=web&ots=Ox36-MKXEL&sig=j74I7_3EGeTXHWM10BWHpGWtOjo&hl=en&sa=X&oi=book_result&resnum=5&ct=result#PPA16,M1
http://cognosforums.com/forums/viewforum.php?f=8
http://www.prometricexam.com/BI0-132.htm
Cognos Installation steps
COGNOS CONFIGURATION
* BEFORE CONFIGURATION:
1. FIRST INSTALL THE SQL SERVER IN THE MIXED MODE (NOT IN WINDOWDS AUTHENTICATION MODE) WITH THE PASWWORD SA.
2. SECOND INSTALL THE COGNOS REPORTNET SOFTWARE CRN AND FWM ONE AFTER OTHER.
NOTE: THE OPRATING SYSTEM SHOULD CONTAIN IIS (INTERNET INFORMATION SERVICE) INSTALLED BEFORE ALL…!
* REPORTNET CONFIGURATION:
1. START->PROGRAM FILES->SQL SERVER->ENTERPRISE MANAGER.
2. ON LEFT HAND SIDE PANEL SELECT MICROSOFT SQL SERVER (EXPAND)-> SERVERGROUP (EXPAND)->WINDOWS NT SERVER (EXPAND).
3. SELECT DATABASES RIGHT CLICK ON IT->NEW DATABASE->NAME IT AS ‘CRN’-> COLLATION NAME AS ‘LATIN1-GENERAL-CI-AS’->CLICK OK->CRN DATABASE IS CREATED.
4. CREATE 2 MORE DATABASES WITH NAME GOSL AND GORT (TO CREATE GOSL, GORT FOLLOW THE ABOVE STEPS WHAT WE HAVE DONE FOR ‘CRN’)->3 NEW DATABASES ARE CREATED.
5. SELECT ‘GORT’ DATABASE RIGHT CLICK ON IT->SELECT ‘ALL TASKS’->CLICK ‘RESTORE DATABASE OPTION’->ONE DIALOG BOX WILL OPENS.
6. SELECT THE BUTTON ‘FROM THE DEVICES’->CLICK ‘SELECT DEVICES’->CLICK ‘ADD’ BUTTON->SELECT THE ‘BROWSE’ BUTTON.
7. PROVIDE THE PATH (C:\PROGAMFILES\COGNOS\CRN\WEBCONTENT\SAMPLES\DATABASE\SQL SERVER\GORT)->CLICK OK-> CLICK OK-> CLICK OK.
8. SELECT THE OPTIONS TAB-> SELECT THE CHECK BOX ‘FORCE RESTORE OVER THE EXISTING DATABASE’->UNDER PHYSICAL DATA FILES WE HAVE TO PROVIDE THE FOLLOWING PATHS INSTEAD OF EXISTING PATHS:
1. C:\PROGRAM FILES\MICROSOFT SQL SERVER\MS SQL\DATA\GORT.mdf
2. C:\PROGRAMFILES\MICROSOFT SQL SERVER\MS SQL\DATA\GORT_log.ldf
9. FOLLOW THE SAME STEPS FOR GOSL DATABASE ASLO (WHAT WE HAVE DONE FOR GORT)
* CONFIGURATION OF REPORT NET SERVER:
1. START->PROGRAM FILES COGNOS REPORTNET-> CLICK ON COGNOS CONFIGURATION.
2. IN THE EXPLORER WINDOW->CLICK ON CONTENT STORE->CORRESPONDING DATABASE PROPERTIES WILL DISPLAYS->PROVIDE DATABASE NAME AS ‘CRN’.
3. CLICK ON USER ID AND PASSWORK->ENTER ‘SA’ FOR USER ID AND PASSWORK->CLICK OK.
4. IN EXPLORER WINDOW CLICK ON COGNOS REPORT NET->HERE SET’DISPATCHED MAXIMUM MEMORY FROM 128 TO 384’-> AFTER THIS SAVE CHANCES MADE-> CLICK ON SAVE BUTTON ON TOOL BAR->CLOSE.
5. IN THIS EXPLORER ONLY WE HAVE TO START REPORT NET SERVER SERVICE FOR THAT-> WE WILL FINE ONE GREEN ARROW BUTTON PRESS THAT BUTTON-> AFTER PRESSING THAT BUTTON IT WILL AUTOMATICALLY CONFIGURES THE SERVER->AFTER COMPLETION OF THAT CLOSE THE EXPLORER.
* CREATION OF VIRTUAL DIRECTORIES:
1. START-> SETTINGS-> CONTROLPANEL->ADMINISTRATIVE TOOLS->INTERNET SERVICE MANAGER.
2. ON LEFT HAND SIDE THE MACHINE NAME WILL APPEAR-> OPEN IT-> EXPAND THE DEFAULT WEBSITE->RIGHT CLICK ON IT->SELECT NEW-> CLICK ON VIRTUAL DIRECTORY->NEXT->IT ASKS FOR ALIAS NAME-> GIVE IT AS ‘CRN’-> NEXT-> CLICK BROWSE->ENTER THE FOLLOWING PATH: (C:\PROGRAMFILES\COGNOS\CRN\WEBCONTENT)->NEXT->BY DEFAULT TWO CHECK BOXES ARE ACTIVATED->UNCHECK THE RUN SCRIPT DIALOG BOX->NEXT FINISH.
3. SELECT ‘CRN’ AND RIGHT CLICK ON IT->SELECT NEW->CLICK ON VIRTUAL DIRECTORY->NEXT-> ALIAS NAME AS ‘CGI-BIN’-> NEXT->PROVIDE FOLLOWING PATH NOW (C:\PROGRAM FILES\COGNOS\CRN\CGI-BIN)->NEXT-> BY DEFAULT TWO CHECK BOXES ARE ACTIVATED->THIS TIME WE NEED TO SELECT THE CHECK BOX ‘EXECUTE’ ALSO -> NEXT-> FINISH.
4. SELECT ‘CRN’ AND RIGHT CLICK ON IT->SELECT NEW->CLICK ON VIRTUAL DIRECTORY->NEXT-> ALIAS NAME AS ‘HELP’-> NEXT->PROVIDE FOLLOWING PATH NOW (C:\PROGRAM FILES\COGNOS\CRN\WEBCONTENT\DOCUMENTATION) ->NEXT-> BY DEFAULT TWO CHECK BOXES ARE ACTIVATED-> UNCHECK THE ‘RUN SCRIPT’ DIALOG BOX->NEXT-> FINISH.
5. UNDER ‘CRN’-> EXPAND SAMPLES FOLDER->SELECT IMAGES FOLDER->RIGHT CLICK ON IMAGES FOLDER->CLICK ON PROPERTIES->SELECT THE CHECK BOX CALLED ‘DIRECTORY BROWSE’ -> CLICK APPLY->OK.
6. TYPE THE FOLLOWING URL IN THE INTERNER EXPLORER (BROWSER)-> http:\localhost\crn.
7. CLICK ON DIRECTORY LINK -> CLICK ON DATASOURCES LINK-> CREATE NEW DATASOURCE (WE WILL FIND ONE DATABASE ICON AT THE RIGHT SIDE TOP OF THE TOOL BAR IN THE EXPLORER) -> PROVIDE NAME AS GOSALES -> CLICK NEXT.
8. SELECT TYPE AS MICROSOFT SQL SERVER -> PROVIDE SERVERNAME AS ‘LOCAL HOST’ AND DATABASE NAME AS ‘GOSL’->SELECT THE CHECK BOX USERID AND PASSWORD THEN ENTER USER ID AND PASSWORK AS ‘SA’ -> TEST-> CLICK OK-> CLICK OK-> CLOSE-> FINISH.
9. AFTER THIS YOU WILL FIND ONE DIALOG BOX (GOSALES DATASOURCE CREATED SUCESSFULLY) THEN CLICK OK
10. SIMILARLY CREATE DATASOURCE FOR GORT (PROVIDE THE NAME AS GORETAILERS) AND FOLLOW THE SAME STEPS WHAT WE HAVE DONE ABOVE FOR GOSL.
11. GO TO HOME PAGE AND CLOSE.
THE END
* BEFORE CONFIGURATION:
1. FIRST INSTALL THE SQL SERVER IN THE MIXED MODE (NOT IN WINDOWDS AUTHENTICATION MODE) WITH THE PASWWORD SA.
2. SECOND INSTALL THE COGNOS REPORTNET SOFTWARE CRN AND FWM ONE AFTER OTHER.
NOTE: THE OPRATING SYSTEM SHOULD CONTAIN IIS (INTERNET INFORMATION SERVICE) INSTALLED BEFORE ALL…!
* REPORTNET CONFIGURATION:
1. START->PROGRAM FILES->SQL SERVER->ENTERPRISE MANAGER.
2. ON LEFT HAND SIDE PANEL SELECT MICROSOFT SQL SERVER (EXPAND)-> SERVERGROUP (EXPAND)->WINDOWS NT SERVER (EXPAND).
3. SELECT DATABASES RIGHT CLICK ON IT->NEW DATABASE->NAME IT AS ‘CRN’-> COLLATION NAME AS ‘LATIN1-GENERAL-CI-AS’->CLICK OK->CRN DATABASE IS CREATED.
4. CREATE 2 MORE DATABASES WITH NAME GOSL AND GORT (TO CREATE GOSL, GORT FOLLOW THE ABOVE STEPS WHAT WE HAVE DONE FOR ‘CRN’)->3 NEW DATABASES ARE CREATED.
5. SELECT ‘GORT’ DATABASE RIGHT CLICK ON IT->SELECT ‘ALL TASKS’->CLICK ‘RESTORE DATABASE OPTION’->ONE DIALOG BOX WILL OPENS.
6. SELECT THE BUTTON ‘FROM THE DEVICES’->CLICK ‘SELECT DEVICES’->CLICK ‘ADD’ BUTTON->SELECT THE ‘BROWSE’ BUTTON.
7. PROVIDE THE PATH (C:\PROGAMFILES\COGNOS\CRN\WEBCONTENT\SAMPLES\DATABASE\SQL SERVER\GORT)->CLICK OK-> CLICK OK-> CLICK OK.
8. SELECT THE OPTIONS TAB-> SELECT THE CHECK BOX ‘FORCE RESTORE OVER THE EXISTING DATABASE’->UNDER PHYSICAL DATA FILES WE HAVE TO PROVIDE THE FOLLOWING PATHS INSTEAD OF EXISTING PATHS:
1. C:\PROGRAM FILES\MICROSOFT SQL SERVER\MS SQL\DATA\GORT.mdf
2. C:\PROGRAMFILES\MICROSOFT SQL SERVER\MS SQL\DATA\GORT_log.ldf
9. FOLLOW THE SAME STEPS FOR GOSL DATABASE ASLO (WHAT WE HAVE DONE FOR GORT)
* CONFIGURATION OF REPORT NET SERVER:
1. START->PROGRAM FILES COGNOS REPORTNET-> CLICK ON COGNOS CONFIGURATION.
2. IN THE EXPLORER WINDOW->CLICK ON CONTENT STORE->CORRESPONDING DATABASE PROPERTIES WILL DISPLAYS->PROVIDE DATABASE NAME AS ‘CRN’.
3. CLICK ON USER ID AND PASSWORK->ENTER ‘SA’ FOR USER ID AND PASSWORK->CLICK OK.
4. IN EXPLORER WINDOW CLICK ON COGNOS REPORT NET->HERE SET’DISPATCHED MAXIMUM MEMORY FROM 128 TO 384’-> AFTER THIS SAVE CHANCES MADE-> CLICK ON SAVE BUTTON ON TOOL BAR->CLOSE.
5. IN THIS EXPLORER ONLY WE HAVE TO START REPORT NET SERVER SERVICE FOR THAT-> WE WILL FINE ONE GREEN ARROW BUTTON PRESS THAT BUTTON-> AFTER PRESSING THAT BUTTON IT WILL AUTOMATICALLY CONFIGURES THE SERVER->AFTER COMPLETION OF THAT CLOSE THE EXPLORER.
* CREATION OF VIRTUAL DIRECTORIES:
1. START-> SETTINGS-> CONTROLPANEL->ADMINISTRATIVE TOOLS->INTERNET SERVICE MANAGER.
2. ON LEFT HAND SIDE THE MACHINE NAME WILL APPEAR-> OPEN IT-> EXPAND THE DEFAULT WEBSITE->RIGHT CLICK ON IT->SELECT NEW-> CLICK ON VIRTUAL DIRECTORY->NEXT->IT ASKS FOR ALIAS NAME-> GIVE IT AS ‘CRN’-> NEXT-> CLICK BROWSE->ENTER THE FOLLOWING PATH: (C:\PROGRAMFILES\COGNOS\CRN\WEBCONTENT)->NEXT->BY DEFAULT TWO CHECK BOXES ARE ACTIVATED->UNCHECK THE RUN SCRIPT DIALOG BOX->NEXT FINISH.
3. SELECT ‘CRN’ AND RIGHT CLICK ON IT->SELECT NEW->CLICK ON VIRTUAL DIRECTORY->NEXT-> ALIAS NAME AS ‘CGI-BIN’-> NEXT->PROVIDE FOLLOWING PATH NOW (C:\PROGRAM FILES\COGNOS\CRN\CGI-BIN)->NEXT-> BY DEFAULT TWO CHECK BOXES ARE ACTIVATED->THIS TIME WE NEED TO SELECT THE CHECK BOX ‘EXECUTE’ ALSO -> NEXT-> FINISH.
4. SELECT ‘CRN’ AND RIGHT CLICK ON IT->SELECT NEW->CLICK ON VIRTUAL DIRECTORY->NEXT-> ALIAS NAME AS ‘HELP’-> NEXT->PROVIDE FOLLOWING PATH NOW (C:\PROGRAM FILES\COGNOS\CRN\WEBCONTENT\DOCUMENTATION) ->NEXT-> BY DEFAULT TWO CHECK BOXES ARE ACTIVATED-> UNCHECK THE ‘RUN SCRIPT’ DIALOG BOX->NEXT-> FINISH.
5. UNDER ‘CRN’-> EXPAND SAMPLES FOLDER->SELECT IMAGES FOLDER->RIGHT CLICK ON IMAGES FOLDER->CLICK ON PROPERTIES->SELECT THE CHECK BOX CALLED ‘DIRECTORY BROWSE’ -> CLICK APPLY->OK.
6. TYPE THE FOLLOWING URL IN THE INTERNER EXPLORER (BROWSER)-> http:\localhost\crn.
7. CLICK ON DIRECTORY LINK -> CLICK ON DATASOURCES LINK-> CREATE NEW DATASOURCE (WE WILL FIND ONE DATABASE ICON AT THE RIGHT SIDE TOP OF THE TOOL BAR IN THE EXPLORER) -> PROVIDE NAME AS GOSALES -> CLICK NEXT.
8. SELECT TYPE AS MICROSOFT SQL SERVER -> PROVIDE SERVERNAME AS ‘LOCAL HOST’ AND DATABASE NAME AS ‘GOSL’->SELECT THE CHECK BOX USERID AND PASSWORD THEN ENTER USER ID AND PASSWORK AS ‘SA’ -> TEST-> CLICK OK-> CLICK OK-> CLOSE-> FINISH.
9. AFTER THIS YOU WILL FIND ONE DIALOG BOX (GOSALES DATASOURCE CREATED SUCESSFULLY) THEN CLICK OK
10. SIMILARLY CREATE DATASOURCE FOR GORT (PROVIDE THE NAME AS GORETAILERS) AND FOLLOW THE SAME STEPS WHAT WE HAVE DONE ABOVE FOR GOSL.
11. GO TO HOME PAGE AND CLOSE.
THE END
Wednesday, October 01, 2008
SQL QUERIES
TABLE SALESPEOPLE
SNUM SNAME CITY COMM
1001 Peel London .12
1002 Serres San Jose .13
1004 Motika London .11
1007 Rafkin Barcelona .15
1003 Axelrod New york .1
TABLE CUST
CNUM CNAME CITY RATING SNUM
2001 Hoffman London 100 1001
2002 Giovanne Rome 200 1003
2003 Liu San Jose 300 1002
2004 Grass Brelin 100 1002
2006 Clemens London 300 1007
2007 Pereira Rome 100 1004
ORDERS
ONUM AMT ODATE CNUM SNUM
3001 18.69 03-OCT-94 2008 1007
3003 767.19 03-OCT-94 2001 1001
3002 1900.10 03-OCT-94 2007 1004
3005 5160.45 03-OCT-94 2003 1002
3006 1098.16 04-OCT-94 2008 1007
3009 1713.23 04-OCT-94 2002 1003
3007 75.75 05-OCT-94 2004 1002
3008 4723.00 05-OCT-94 2006 1001
3010 1309.95 06-OCT-94 2004 1002
3011 9891.88 06-OCT-94 2006 1001
Problems :
1. Display snum,sname,city and comm of all salespeople.
Select snum, sname, city, comm
from salespeople;
2. Display all snum without duplicates from all orders.
Select distinct snum
from orders;
3. Display names and commissions of all salespeople in london.
Select sname,comm
from salespeople
where city = ‘London’;
4. All customers with rating of 100.
Select cname
from cust
where rating = 100;
5. Produce orderno, amount and date form all rows in the order table.
Select ordno, amt, odate
from orders;
6. All customers in San Jose, who have rating more than 200.
Select cname
from cust
where rating > 200;
7. All customers who were either located in San Jose or had a rating above 200.
Select cname
from cust
where city = ‘San Jose’ or
rating > 200;
8. All orders for more than $1000.
Select *
from orders
where amt > 1000;
9. Names and citires of all salespeople in london with commission above 0.10.
Select sname, city
from salepeople
where comm > 0.10 and
city = ‘London’;
10. All customers excluding those with rating <= 100 unless they are located in Rome.
Select cname
from cust
where rating <= 100 or
city = ‘Rome’;
11. All salespeople either in Barcelona or in london.
Select sname, city
from salespeople
where city in (‘Barcelona’,’London’);
12. All salespeople with commission between 0.10 and 0.12. (Boundary values should be excluded)
Select sname, comm
from salespeople
where comm > 0.10 and comm < 0.12;
13. All customers with NULL values in city column.
Select cname
from cust
where city is null;
14. All orders taken on Oct 3Rd and Oct 4th 1994.
Select *
from orders
where odate in (‘03-OCT-94’,’04-OCT-94’);
15. All customers serviced by peel or Motika.
Select cname
from cust, orders
where orders.cnum = cust.cnum and
orders.snum in ( select snum
from salespeople
where sname in 'Peel','Motika'));
16. All customers whose names begin with a letter from A to B.
Select cname
from cust
where cname like ‘A%’ or
cname like ‘B%’;
17. All orders except those with 0 or NULL value in amt field.
Select onum
from orders
where amt != 0 or
amt is not null;
18. Count the number of salespeople currently listing orders in the order table.
Select count(distinct snum)
from orders;
19. Largest order taken by each salesperson, datewise.
Select odate, snum, max(amt)
from orders
group by odate, snum
order by odate,snum;
20. Largest order taken by each salesperson with order value more than $3000.
Select odate, snum, max(amt)
from orders
where amt > 3000
group by odate, snum
order by odate,snum;
21. Which day had the hightest total amount ordered.
Select odate, amt, snum, cnum
from orders
where amt = (select max(amt)
from orders)
22. Count all orders for Oct 3rd.
Select count(*)
from orders
where odate = ‘03-OCT-94’;
23. Count the number of different non NULL city values in customers table.
Select count(distinct city)
from cust;
24. Select each customer’s smallest order.
Select cnum, min(amt)
from orders
group by cnum;
25. First customer in alphabetical order whose name begins with G.
Select min(cname)
from cust
where cname like ‘G%’;
26. Get the output like “ For dd/mm/yy there are ___ orders.
Select 'For ' || to_char(odate,'dd/mm/yy') || ' there are '||
count(*) || ' Orders'
from orders
group by odate;
27. Assume that each salesperson has a 12% commission. Produce order no., salesperson no., and amount of salesperson’s commission for that order.
Select onum, snum, amt, amt * 0.12
from orders
order by snum;
28. Find highest rating in each city. Put the output in this form. For the city (city), the highest rating is : (rating).
Select 'For the city (' || city || '), the highest rating is : (' ||
max(rating) || ')'
from cust
group by city;
29. Display the totals of orders for each day and place the results in descending order.
Select odate, count(onum)
from orders
group by odate
order by count(onum);
30. All combinations of salespeople and customers who shared a city. (ie same city).
Select sname, cname
from salespeople, cust
where salespeople.city = cust.city;
31. Name of all customers matched with the salespeople serving them.
Select cname, sname
from cust, salespeople
where cust.snum = salespeople.snum;
32. List each order number followed by the name of the customer who made the order.
Select onum, cname
from orders, cust
where orders.cnum = cust.cnum;
33. Names of salesperson and customer for each order after the order number.
Select onum, sname, cname
from orders, cust, salespeople
where orders.cnum = cust.cnum and
orders.snum = salespeople.snum;
34. Produce all customer serviced by salespeople with a commission above 12%.
Select cname, sname, comm
from cust, salespeople
where comm > 0.12 and
cust.snum = salespeople.snum;
35. Calculate the amount of the salesperson’s commission on each order with a rating above 100.
Select sname, amt * comm
from orders, cust, salespeople
where rating > 100 and
salespeople.snum = cust.snum and
salespeople.snum = orders.snum and
cust.cnum = orders.cnum
36. Find all pairs of customers having the same rating.
Select a.cname, b.cname,a.rating
from cust a, cust b
where a.rating = b.rating and
a.cnum != b.cnum
37. Find all pairs of customers having the same rating, each pair coming once only.
Select a.cname, b.cname,a.rating
from cust a, cust b
where a.rating = b.rating and
a.cnum != b.cnum and
a.cnum < b.cnum;
38. Policy is to assign three salesperson to each customers. Display all such combinations.
Select cname, sname
from salespeople, cust
where sname in ( select sname
from salespeople
where rownum <= 3)
order by cname;
39. Display all customers located in cities where salesman serres has customer.
Select cname
from cust
where city = ( select city
from cust, salespeople
where cust.snum = salespeople.snum and sname = 'Serres');
Select cname
from cust
where city in ( select city
from cust, orders
where cust.cnum = orders.cnum and
orders.snum in ( select snum
from salespeople
where sname = 'Serres'));
40. Find all pairs of customers served by single salesperson.
Select cname from cust
where snum in (select snum from cust
group by snum
having count(snum) > 1);
Select distinct a.cname
from cust a ,cust b
where a.snum = b.snum and a.rowid != b.rowid;
41. Produce all pairs of salespeople which are living in the same city. Exclude combinations of salespeople with themselves as well as duplicates with the order reversed.
Select a.sname, b.sname
from salespeople a, salespeople b
where a.snum > b.snum and
a.city = b.city;
42. Produce all pairs of orders by given customer, names that customers and eliminates duplicates.
Select c.cname, a.onum, b.onum
from orders a, orders b, cust c
where a.cnum = b.cnum and
a.onum > b.onum and
c.cnum = a.cnum;
43. Produce names and cities of all customers with the same rating as Hoffman.
Select cname, city
from cust
where rating = (select rating
from cust
where cname = 'Hoffman')
and cname != 'Hoffman';
44. Extract all the orders of Motika.
Select Onum
from orders
where snum = ( select snum
from salespeople
where sname = ‘Motika’);
45. All orders credited to the same salesperson who services Hoffman.
Select onum, sname, cname, amt
from orders a, salespeople b, cust c
where a.snum = b.snum and
a.cnum = c.cnum and
a.snum = ( select snum
from orders
where cnum = ( select cnum
from cust
where cname = 'Hoffman'));
46. All orders that are greater than the average for Oct 4.
Select *
from orders
where amt > ( select avg(amt)
from orders
where odate = '03-OCT-94');
47. Find average commission of salespeople in london.
Select avg(comm)
from salespeople
where city = ‘London’;
48. Find all orders attributed to salespeople servicing customers in london.
Select snum, cnum
from orders
where cnum in (select cnum
from cust
where city = 'London');
49. Extract commissions of all salespeople servicing customers in London.
Select comm
from salespeople
where snum in (select snum
from cust
where city = ‘London’);
50. Find all customers whose cnum is 1000 above the snum of serres.
Select cnum, cname from cust
where cnum > ( select snum+1000
from salespeople
where sname = 'Serres');
51. Count the customers with rating above San Jose’s average.
Select cnum, rating
from cust
where rating > ( select avg(rating)
from cust
where city = 'San Jose');
52. Obtain all orders for the customer named Cisnerous. (Assume you don’t know his customer no. (cnum)).
Select onum, odate
from orders
where cnum = ( select cnum
from cust
where cname = ‘Cisnerous’);
53. Produce the names and rating of all customers who have above average orders.
Select max(b.cname), max(b.rating), a.cnum
from orders a, cust b
where a.cnum = b.cnum
group by a.cnum
having count(a.cnum) > ( select avg(count(cnum))
from orders
group by cnum);
54. Find total amount in orders for each salesperson for whom this total is greater than the amount of the largest order in the table.
Select snum,sum(amt)
from orders
group by snum
having sum(amt) > ( select max(amt)
from orders);
55. Find all customers with order on 3rd Oct.
Select cname
from cust a, orders b
where a.cnum = b.cnum and
odate = ‘03-OCT-94’;
56. Find names and numbers of all salesperson who have more than one customer.
Select sname, snum
from salespeople
where snum in ( select snum
from cust
group by snum
having count(snum) > 1 );
57. Check if the correct salesperson was credited with each sale.
Select onum, a.cnum, a.snum, b.snum
from orders a, cust b
where a.cnum = b.cnum and
a.snum != b.snum;
58. Find all orders with above average amounts for their customers.
select onum, cnum, amt
from orders a
where amt > ( select avg(amt)
from orders b
where a.cnum = b.cnum
group by cnum);
59. Find the sums of the amounts from order table grouped by date, eliminating all those dates where the sum was not at least 2000 above the maximum amount.
Select odate, sum(amt)
from orders a
group by odate
having sum(amt) > ( select max(amt)
from orders b
where a.odate = b.odate
group by odate);
60. Find names and numbers of all customers with ratings equal to the maximum for their city.
Select a.cnum, a.cname
from cust a
where a.rating = ( select max(rating)
from cust b
where a.city = b.city);
61. Find all salespeople who have customers in their cities who they don’t service. ( Both way using Join and Correlated subquery.)
Select distinct cname
from cust a, salespeople b
where a.city = b.city and
a.snum != b.snum;
Select cname
from cust
where cname in ( select cname
from cust a, salespeople b
where a.city = b.city and
a.snum != b.snum );
62. Extract cnum,cname and city from customer table if and only if one or more of the customers in the table are located in San Jose.
Select * from cust
where 2 < (select count(*)
from cust
where city = 'San Jose');
63. Find salespeople no. who have multiple customers.
Select snum
from cust
group by snum
having count(*) > 1;
64. Find salespeople number, name and city who have multiple customers.
Select snum, sname, city
from salespeople
where snum in ( select snum
from cust
group by snum
having count(*) > 1);
65. Find salespeople who serve only one customer.
Select snum
from cust
group by snum
having count(*) = 1;
66. Extract rows of all salespeople with more than one current order.
Select snum, count(snum)
from orders
group by snum
having count(snum) > 1;
67. Find all salespeople who have customers with a rating of 300. (use EXISTS)
Select a.snum
from salespeople a
where exists ( select b.snum
from cust b
where b.rating = 300 and
a.snum = b.snum)
68. Find all salespeople who have customers with a rating of 300. (use Join).
Select a.snum
from salespeople a, cust b
where b.rating = 300 and
a.snum = b.snum;
69. Select all salespeople with customers located in their cities who are not assigned to them. (use EXISTS).
Select snum, sname
from salespeople
where exists ( select cnum
from cust
where salespeople.city = cust.city and
salespeople.snum != cust.snum);
70. Extract from customers table every customer assigned the a salesperson who currently has at least one other customer ( besides the customer being selected) with orders in order table.
Select a.cnum, max(c.cname)
from orders a, cust c
where a.cnum = c.cnum
group by a.cnum,a.snum
having count(*) < ( select count(*)
from orders b
where a.snum = b.snum)
order by a.cnum;
71. Find salespeople with customers located in their cities ( using both ANY and IN).
Select sname
from salespeople
where snum in ( select snum from cust
where salespeople.city = cust.city and
salespeople.snum = cust.snum);
Select sname
from salespeople
where snum = any ( select snum
from cust
where salespeople.city = cust.city and
salespeople.snum = cust.snum);
72. Find all salespeople for whom there are customers that follow them in alphabetical order. (Using ANY and EXISTS)
Select sname
from salespeople
where sname < any ( select cname
from cust
where salespeople.snum = cust.snum);
Select sname
from salespeople
where exists ( select cname
from cust
where salespeople.snum = cust.snum and
salespeople.sname < cust.cname);
73. Select customers who have a greater rating than any customer in rome.
Select a.cname
from cust a
where city = 'Rome' and
rating > ( select max(rating)
from cust
where city != 'Rome');
74. Select all orders that had amounts that were greater that atleast one of the orders from Oct 6th.
Select onum, amt
from orders
where odate != '06-oct-94' and
amt > ( select min(amt)
from orders
where odate = '06-oct-94');
75. Find all orders with amounts smaller than any amount for a customer in San Jose. (Both using ANY and without ANY)
Select onum, amt
from orders
where amt < any ( select amt
from orders, cust
where city = 'San Jose' and
orders.cnum = cust.cnum);
Select onum, amt
from orders
where amt < ( select max(amt)
from orders, cust
where city = 'San Jose' and
orders.cnum = cust.cnum);
76. Select those customers whose ratings are higher than every customer in Paris. ( Using both ALL and NOT EXISTS).
Select * from cust
where rating > any (select rating from cust
where city = 'Paris');
Select *
from cust a
where not exists ( select b.rating from cust b
where b.city != 'Paris' and
b.rating > a.rating);
77. Select all customers whose ratings are equal to or greater than ANY of the Seeres.
Select cname, sname
from cust, salespeople
where rating >= any ( select rating
from cust
where snum = (select snum
from salespeople
where sname = 'Serres'))
and sname != 'Serres'
and salespeople.snum(+) = cust.snum;
78. Find all salespeople who have no customers located in their city. ( Both using ANY and ALL)
Select sname
from salespeople
where snum in ( select snum
from cust
where salespeople.city != cust.city and
salespeople.snum = cust.snum);
Select sname
from salespeople
where snum = any ( select snum
from cust
where salespeople.city != cust.city and
salespeople.snum = cust.snum);
79. Find all orders for amounts greater than any for the customers in London.
Select onum, amt
from orders
where amt > any ( select amt
from orders, cust
where city = ‘London’ and
orders.cnum = cust.cnum);
80. Find all salespeople and customers located in london.
Select sname, cname
from cust, salespeople
where cust.city = 'London' and
salespeople.city = 'London' and
cust.snum = salespeople.snum;
81. For every salesperson, dates on which highest and lowest orders were brought.
Select a.amt, a.odate, b.amt, b.odate
from orders a, orders b
where (a.amt, b.amt) in (select max(amt), min(amt)
from orders
group by snum);
82. List all of the salespeople and indicate those who don’t have customers in their cities as well as those who do have.
Select snum, city, 'Customer Present'
from salespeople a
where exists ( select snum from cust
where a.snum = cust.snum and
a.city = cust.city)
UNION
select snum, city, 'Customer Not Present'
from salespeople a
where exists ( select snum from cust c
where a.snum = c.snum and
a.city != c.city and
c.snum not in ( select snum
from cust
where a.snum = cust.snum and
a.city = cust.city));
83. Append strings to the selected fields, indicating weather or not a given salesperson was matched to a customer in his city.
Select a.cname, decode(a.city,b.city,'Matched','Not Matched')
from cust a, salespeople b
where a.snum = b.snum;
84. Create a union of two queries that shows the names, cities and ratings of all customers. Those with a rating of 200 or greater will also have the words ‘High Rating’, while the others will have the words ‘Low Rating’.
Select cname, cities, rating, ‘Higher Rating’
from cust
where rating >= 200
UNION
Select cname, cities, rating, ‘Lower Rating’
from cust
where rating < 200;
85. Write command that produces the name and number of each salesperson and each customer with more than one current order. Put the result in alphabetical order.
Select 'Customer Number ' || cnum "Code ",count(*)
from orders
group by cnum
having count(*) > 1
UNION
select 'Salesperson Number '||snum,count(*)
from orders
group by snum
having count(*) > 1;
86. Form a union of three queries. Have the first select the snums of all salespeople in San Jose, then second the cnums of all customers in San Jose and the third the onums of all orders on Oct. 3. Retain duplicates between the last two queries, but eliminates and redundancies between either of them and the first.
Select 'Customer Number ' || cnum "Code "
from cust
where city = 'San Jose'
UNION
select 'Salesperson Number '||snum
from salespeople
where city = 'San Jose'
UNION ALL
select 'Order Number '|| onum
from Orders
where odate = '03-OCT-94';
87. Produce all the salesperson in London who had at least one customer there.
Select snum, sname
from salespeople
where snum in ( select snum
from cust
where cust.snum = salespeople.snum and
cust.city = 'London')
and city = ‘London’;
88. Produce all the salesperson in London who did not have customers there.
Select snum, sname
from salespeople
where snum in ( select snum
from cust
where cust.snum = salespeople.snum and
cust.city = 'London')
and city = 'London';
89. We want to see salespeople matched to their customers without excluding those salesperson who were not currently assigned to any customers. (User OUTER join and UNION)
Select sname, cname
from cust, salespeople
where cust.snum(+) = salespeople.snum;
Select sname, cname
from cust, salespeople
where cust.snum = salespeople.snum
UNION
select distinct sname, 'No Customer'
from cust, salespeople
where 0 = (select count(*) from cust
where cust.snum = salespeople.snum);
SNUM SNAME CITY COMM
1001 Peel London .12
1002 Serres San Jose .13
1004 Motika London .11
1007 Rafkin Barcelona .15
1003 Axelrod New york .1
TABLE CUST
CNUM CNAME CITY RATING SNUM
2001 Hoffman London 100 1001
2002 Giovanne Rome 200 1003
2003 Liu San Jose 300 1002
2004 Grass Brelin 100 1002
2006 Clemens London 300 1007
2007 Pereira Rome 100 1004
ORDERS
ONUM AMT ODATE CNUM SNUM
3001 18.69 03-OCT-94 2008 1007
3003 767.19 03-OCT-94 2001 1001
3002 1900.10 03-OCT-94 2007 1004
3005 5160.45 03-OCT-94 2003 1002
3006 1098.16 04-OCT-94 2008 1007
3009 1713.23 04-OCT-94 2002 1003
3007 75.75 05-OCT-94 2004 1002
3008 4723.00 05-OCT-94 2006 1001
3010 1309.95 06-OCT-94 2004 1002
3011 9891.88 06-OCT-94 2006 1001
Problems :
1. Display snum,sname,city and comm of all salespeople.
Select snum, sname, city, comm
from salespeople;
2. Display all snum without duplicates from all orders.
Select distinct snum
from orders;
3. Display names and commissions of all salespeople in london.
Select sname,comm
from salespeople
where city = ‘London’;
4. All customers with rating of 100.
Select cname
from cust
where rating = 100;
5. Produce orderno, amount and date form all rows in the order table.
Select ordno, amt, odate
from orders;
6. All customers in San Jose, who have rating more than 200.
Select cname
from cust
where rating > 200;
7. All customers who were either located in San Jose or had a rating above 200.
Select cname
from cust
where city = ‘San Jose’ or
rating > 200;
8. All orders for more than $1000.
Select *
from orders
where amt > 1000;
9. Names and citires of all salespeople in london with commission above 0.10.
Select sname, city
from salepeople
where comm > 0.10 and
city = ‘London’;
10. All customers excluding those with rating <= 100 unless they are located in Rome.
Select cname
from cust
where rating <= 100 or
city = ‘Rome’;
11. All salespeople either in Barcelona or in london.
Select sname, city
from salespeople
where city in (‘Barcelona’,’London’);
12. All salespeople with commission between 0.10 and 0.12. (Boundary values should be excluded)
Select sname, comm
from salespeople
where comm > 0.10 and comm < 0.12;
13. All customers with NULL values in city column.
Select cname
from cust
where city is null;
14. All orders taken on Oct 3Rd and Oct 4th 1994.
Select *
from orders
where odate in (‘03-OCT-94’,’04-OCT-94’);
15. All customers serviced by peel or Motika.
Select cname
from cust, orders
where orders.cnum = cust.cnum and
orders.snum in ( select snum
from salespeople
where sname in 'Peel','Motika'));
16. All customers whose names begin with a letter from A to B.
Select cname
from cust
where cname like ‘A%’ or
cname like ‘B%’;
17. All orders except those with 0 or NULL value in amt field.
Select onum
from orders
where amt != 0 or
amt is not null;
18. Count the number of salespeople currently listing orders in the order table.
Select count(distinct snum)
from orders;
19. Largest order taken by each salesperson, datewise.
Select odate, snum, max(amt)
from orders
group by odate, snum
order by odate,snum;
20. Largest order taken by each salesperson with order value more than $3000.
Select odate, snum, max(amt)
from orders
where amt > 3000
group by odate, snum
order by odate,snum;
21. Which day had the hightest total amount ordered.
Select odate, amt, snum, cnum
from orders
where amt = (select max(amt)
from orders)
22. Count all orders for Oct 3rd.
Select count(*)
from orders
where odate = ‘03-OCT-94’;
23. Count the number of different non NULL city values in customers table.
Select count(distinct city)
from cust;
24. Select each customer’s smallest order.
Select cnum, min(amt)
from orders
group by cnum;
25. First customer in alphabetical order whose name begins with G.
Select min(cname)
from cust
where cname like ‘G%’;
26. Get the output like “ For dd/mm/yy there are ___ orders.
Select 'For ' || to_char(odate,'dd/mm/yy') || ' there are '||
count(*) || ' Orders'
from orders
group by odate;
27. Assume that each salesperson has a 12% commission. Produce order no., salesperson no., and amount of salesperson’s commission for that order.
Select onum, snum, amt, amt * 0.12
from orders
order by snum;
28. Find highest rating in each city. Put the output in this form. For the city (city), the highest rating is : (rating).
Select 'For the city (' || city || '), the highest rating is : (' ||
max(rating) || ')'
from cust
group by city;
29. Display the totals of orders for each day and place the results in descending order.
Select odate, count(onum)
from orders
group by odate
order by count(onum);
30. All combinations of salespeople and customers who shared a city. (ie same city).
Select sname, cname
from salespeople, cust
where salespeople.city = cust.city;
31. Name of all customers matched with the salespeople serving them.
Select cname, sname
from cust, salespeople
where cust.snum = salespeople.snum;
32. List each order number followed by the name of the customer who made the order.
Select onum, cname
from orders, cust
where orders.cnum = cust.cnum;
33. Names of salesperson and customer for each order after the order number.
Select onum, sname, cname
from orders, cust, salespeople
where orders.cnum = cust.cnum and
orders.snum = salespeople.snum;
34. Produce all customer serviced by salespeople with a commission above 12%.
Select cname, sname, comm
from cust, salespeople
where comm > 0.12 and
cust.snum = salespeople.snum;
35. Calculate the amount of the salesperson’s commission on each order with a rating above 100.
Select sname, amt * comm
from orders, cust, salespeople
where rating > 100 and
salespeople.snum = cust.snum and
salespeople.snum = orders.snum and
cust.cnum = orders.cnum
36. Find all pairs of customers having the same rating.
Select a.cname, b.cname,a.rating
from cust a, cust b
where a.rating = b.rating and
a.cnum != b.cnum
37. Find all pairs of customers having the same rating, each pair coming once only.
Select a.cname, b.cname,a.rating
from cust a, cust b
where a.rating = b.rating and
a.cnum != b.cnum and
a.cnum < b.cnum;
38. Policy is to assign three salesperson to each customers. Display all such combinations.
Select cname, sname
from salespeople, cust
where sname in ( select sname
from salespeople
where rownum <= 3)
order by cname;
39. Display all customers located in cities where salesman serres has customer.
Select cname
from cust
where city = ( select city
from cust, salespeople
where cust.snum = salespeople.snum and sname = 'Serres');
Select cname
from cust
where city in ( select city
from cust, orders
where cust.cnum = orders.cnum and
orders.snum in ( select snum
from salespeople
where sname = 'Serres'));
40. Find all pairs of customers served by single salesperson.
Select cname from cust
where snum in (select snum from cust
group by snum
having count(snum) > 1);
Select distinct a.cname
from cust a ,cust b
where a.snum = b.snum and a.rowid != b.rowid;
41. Produce all pairs of salespeople which are living in the same city. Exclude combinations of salespeople with themselves as well as duplicates with the order reversed.
Select a.sname, b.sname
from salespeople a, salespeople b
where a.snum > b.snum and
a.city = b.city;
42. Produce all pairs of orders by given customer, names that customers and eliminates duplicates.
Select c.cname, a.onum, b.onum
from orders a, orders b, cust c
where a.cnum = b.cnum and
a.onum > b.onum and
c.cnum = a.cnum;
43. Produce names and cities of all customers with the same rating as Hoffman.
Select cname, city
from cust
where rating = (select rating
from cust
where cname = 'Hoffman')
and cname != 'Hoffman';
44. Extract all the orders of Motika.
Select Onum
from orders
where snum = ( select snum
from salespeople
where sname = ‘Motika’);
45. All orders credited to the same salesperson who services Hoffman.
Select onum, sname, cname, amt
from orders a, salespeople b, cust c
where a.snum = b.snum and
a.cnum = c.cnum and
a.snum = ( select snum
from orders
where cnum = ( select cnum
from cust
where cname = 'Hoffman'));
46. All orders that are greater than the average for Oct 4.
Select *
from orders
where amt > ( select avg(amt)
from orders
where odate = '03-OCT-94');
47. Find average commission of salespeople in london.
Select avg(comm)
from salespeople
where city = ‘London’;
48. Find all orders attributed to salespeople servicing customers in london.
Select snum, cnum
from orders
where cnum in (select cnum
from cust
where city = 'London');
49. Extract commissions of all salespeople servicing customers in London.
Select comm
from salespeople
where snum in (select snum
from cust
where city = ‘London’);
50. Find all customers whose cnum is 1000 above the snum of serres.
Select cnum, cname from cust
where cnum > ( select snum+1000
from salespeople
where sname = 'Serres');
51. Count the customers with rating above San Jose’s average.
Select cnum, rating
from cust
where rating > ( select avg(rating)
from cust
where city = 'San Jose');
52. Obtain all orders for the customer named Cisnerous. (Assume you don’t know his customer no. (cnum)).
Select onum, odate
from orders
where cnum = ( select cnum
from cust
where cname = ‘Cisnerous’);
53. Produce the names and rating of all customers who have above average orders.
Select max(b.cname), max(b.rating), a.cnum
from orders a, cust b
where a.cnum = b.cnum
group by a.cnum
having count(a.cnum) > ( select avg(count(cnum))
from orders
group by cnum);
54. Find total amount in orders for each salesperson for whom this total is greater than the amount of the largest order in the table.
Select snum,sum(amt)
from orders
group by snum
having sum(amt) > ( select max(amt)
from orders);
55. Find all customers with order on 3rd Oct.
Select cname
from cust a, orders b
where a.cnum = b.cnum and
odate = ‘03-OCT-94’;
56. Find names and numbers of all salesperson who have more than one customer.
Select sname, snum
from salespeople
where snum in ( select snum
from cust
group by snum
having count(snum) > 1 );
57. Check if the correct salesperson was credited with each sale.
Select onum, a.cnum, a.snum, b.snum
from orders a, cust b
where a.cnum = b.cnum and
a.snum != b.snum;
58. Find all orders with above average amounts for their customers.
select onum, cnum, amt
from orders a
where amt > ( select avg(amt)
from orders b
where a.cnum = b.cnum
group by cnum);
59. Find the sums of the amounts from order table grouped by date, eliminating all those dates where the sum was not at least 2000 above the maximum amount.
Select odate, sum(amt)
from orders a
group by odate
having sum(amt) > ( select max(amt)
from orders b
where a.odate = b.odate
group by odate);
60. Find names and numbers of all customers with ratings equal to the maximum for their city.
Select a.cnum, a.cname
from cust a
where a.rating = ( select max(rating)
from cust b
where a.city = b.city);
61. Find all salespeople who have customers in their cities who they don’t service. ( Both way using Join and Correlated subquery.)
Select distinct cname
from cust a, salespeople b
where a.city = b.city and
a.snum != b.snum;
Select cname
from cust
where cname in ( select cname
from cust a, salespeople b
where a.city = b.city and
a.snum != b.snum );
62. Extract cnum,cname and city from customer table if and only if one or more of the customers in the table are located in San Jose.
Select * from cust
where 2 < (select count(*)
from cust
where city = 'San Jose');
63. Find salespeople no. who have multiple customers.
Select snum
from cust
group by snum
having count(*) > 1;
64. Find salespeople number, name and city who have multiple customers.
Select snum, sname, city
from salespeople
where snum in ( select snum
from cust
group by snum
having count(*) > 1);
65. Find salespeople who serve only one customer.
Select snum
from cust
group by snum
having count(*) = 1;
66. Extract rows of all salespeople with more than one current order.
Select snum, count(snum)
from orders
group by snum
having count(snum) > 1;
67. Find all salespeople who have customers with a rating of 300. (use EXISTS)
Select a.snum
from salespeople a
where exists ( select b.snum
from cust b
where b.rating = 300 and
a.snum = b.snum)
68. Find all salespeople who have customers with a rating of 300. (use Join).
Select a.snum
from salespeople a, cust b
where b.rating = 300 and
a.snum = b.snum;
69. Select all salespeople with customers located in their cities who are not assigned to them. (use EXISTS).
Select snum, sname
from salespeople
where exists ( select cnum
from cust
where salespeople.city = cust.city and
salespeople.snum != cust.snum);
70. Extract from customers table every customer assigned the a salesperson who currently has at least one other customer ( besides the customer being selected) with orders in order table.
Select a.cnum, max(c.cname)
from orders a, cust c
where a.cnum = c.cnum
group by a.cnum,a.snum
having count(*) < ( select count(*)
from orders b
where a.snum = b.snum)
order by a.cnum;
71. Find salespeople with customers located in their cities ( using both ANY and IN).
Select sname
from salespeople
where snum in ( select snum from cust
where salespeople.city = cust.city and
salespeople.snum = cust.snum);
Select sname
from salespeople
where snum = any ( select snum
from cust
where salespeople.city = cust.city and
salespeople.snum = cust.snum);
72. Find all salespeople for whom there are customers that follow them in alphabetical order. (Using ANY and EXISTS)
Select sname
from salespeople
where sname < any ( select cname
from cust
where salespeople.snum = cust.snum);
Select sname
from salespeople
where exists ( select cname
from cust
where salespeople.snum = cust.snum and
salespeople.sname < cust.cname);
73. Select customers who have a greater rating than any customer in rome.
Select a.cname
from cust a
where city = 'Rome' and
rating > ( select max(rating)
from cust
where city != 'Rome');
74. Select all orders that had amounts that were greater that atleast one of the orders from Oct 6th.
Select onum, amt
from orders
where odate != '06-oct-94' and
amt > ( select min(amt)
from orders
where odate = '06-oct-94');
75. Find all orders with amounts smaller than any amount for a customer in San Jose. (Both using ANY and without ANY)
Select onum, amt
from orders
where amt < any ( select amt
from orders, cust
where city = 'San Jose' and
orders.cnum = cust.cnum);
Select onum, amt
from orders
where amt < ( select max(amt)
from orders, cust
where city = 'San Jose' and
orders.cnum = cust.cnum);
76. Select those customers whose ratings are higher than every customer in Paris. ( Using both ALL and NOT EXISTS).
Select * from cust
where rating > any (select rating from cust
where city = 'Paris');
Select *
from cust a
where not exists ( select b.rating from cust b
where b.city != 'Paris' and
b.rating > a.rating);
77. Select all customers whose ratings are equal to or greater than ANY of the Seeres.
Select cname, sname
from cust, salespeople
where rating >= any ( select rating
from cust
where snum = (select snum
from salespeople
where sname = 'Serres'))
and sname != 'Serres'
and salespeople.snum(+) = cust.snum;
78. Find all salespeople who have no customers located in their city. ( Both using ANY and ALL)
Select sname
from salespeople
where snum in ( select snum
from cust
where salespeople.city != cust.city and
salespeople.snum = cust.snum);
Select sname
from salespeople
where snum = any ( select snum
from cust
where salespeople.city != cust.city and
salespeople.snum = cust.snum);
79. Find all orders for amounts greater than any for the customers in London.
Select onum, amt
from orders
where amt > any ( select amt
from orders, cust
where city = ‘London’ and
orders.cnum = cust.cnum);
80. Find all salespeople and customers located in london.
Select sname, cname
from cust, salespeople
where cust.city = 'London' and
salespeople.city = 'London' and
cust.snum = salespeople.snum;
81. For every salesperson, dates on which highest and lowest orders were brought.
Select a.amt, a.odate, b.amt, b.odate
from orders a, orders b
where (a.amt, b.amt) in (select max(amt), min(amt)
from orders
group by snum);
82. List all of the salespeople and indicate those who don’t have customers in their cities as well as those who do have.
Select snum, city, 'Customer Present'
from salespeople a
where exists ( select snum from cust
where a.snum = cust.snum and
a.city = cust.city)
UNION
select snum, city, 'Customer Not Present'
from salespeople a
where exists ( select snum from cust c
where a.snum = c.snum and
a.city != c.city and
c.snum not in ( select snum
from cust
where a.snum = cust.snum and
a.city = cust.city));
83. Append strings to the selected fields, indicating weather or not a given salesperson was matched to a customer in his city.
Select a.cname, decode(a.city,b.city,'Matched','Not Matched')
from cust a, salespeople b
where a.snum = b.snum;
84. Create a union of two queries that shows the names, cities and ratings of all customers. Those with a rating of 200 or greater will also have the words ‘High Rating’, while the others will have the words ‘Low Rating’.
Select cname, cities, rating, ‘Higher Rating’
from cust
where rating >= 200
UNION
Select cname, cities, rating, ‘Lower Rating’
from cust
where rating < 200;
85. Write command that produces the name and number of each salesperson and each customer with more than one current order. Put the result in alphabetical order.
Select 'Customer Number ' || cnum "Code ",count(*)
from orders
group by cnum
having count(*) > 1
UNION
select 'Salesperson Number '||snum,count(*)
from orders
group by snum
having count(*) > 1;
86. Form a union of three queries. Have the first select the snums of all salespeople in San Jose, then second the cnums of all customers in San Jose and the third the onums of all orders on Oct. 3. Retain duplicates between the last two queries, but eliminates and redundancies between either of them and the first.
Select 'Customer Number ' || cnum "Code "
from cust
where city = 'San Jose'
UNION
select 'Salesperson Number '||snum
from salespeople
where city = 'San Jose'
UNION ALL
select 'Order Number '|| onum
from Orders
where odate = '03-OCT-94';
87. Produce all the salesperson in London who had at least one customer there.
Select snum, sname
from salespeople
where snum in ( select snum
from cust
where cust.snum = salespeople.snum and
cust.city = 'London')
and city = ‘London’;
88. Produce all the salesperson in London who did not have customers there.
Select snum, sname
from salespeople
where snum in ( select snum
from cust
where cust.snum = salespeople.snum and
cust.city = 'London')
and city = 'London';
89. We want to see salespeople matched to their customers without excluding those salesperson who were not currently assigned to any customers. (User OUTER join and UNION)
Select sname, cname
from cust, salespeople
where cust.snum(+) = salespeople.snum;
Select sname, cname
from cust, salespeople
where cust.snum = salespeople.snum
UNION
select distinct sname, 'No Customer'
from cust, salespeople
where 0 = (select count(*) from cust
where cust.snum = salespeople.snum);
SQL Material
DATA ARE RAW FACTS
EX : CUSTOMER NAME IN BANK
TOTAL MARKS OBTAINED BY STUDENT
INFORMATION: AN ORGANIZED DATA IS CALLED INFORMATION
EX : CUSTOMER NAME WITH BALANCES.
STUDENT REG NO WITH TOTAL MARKS.
DATA HIERARCHY:
BIT IT MAY BE EITHER 0 OR 1
IT REPRESENTS THE SMALLEST PART OF INFORMATION THAT COMPUTER CAN PROCESS.
BYTE : IT IS GROUP OF 8 BITS IT REPRESENTS A DIGIT, LETTERS OR SPECIAL SYMBOL.
FILED: IT IS A GROUP OF CHARACTERS.
EMPNO ENAME SAL JOB
100 SMITH 800 CLERK
RECORD: IT IS A GROUP OF LOGICALLY RELATED FIELD.
FILE : GROUP OF LOGICALLY RELATED RECORDS OR IT IS A FLOW OF CHARACTERS.
DATABASE: IT IS A GROUP OF LOGICALLY RELATED DATA.
(OR)
IT IS THE COLLECTION OF DATA STORED IN A FILE ON DISC
CLASSIFICATION OF DATA BASE BASED ON SIZE
· NORMAL DATABASE:<10 GB
· LARGE DATABASE : 10 GB TO 100 GB
· VERY LARGE DATABASE : 100 GB TO 1000 GB
· EXTREMELY LARGE DATABASE :> 1000 GB
FILE MANAGEMENT SYSTEM
FILE : IT IS A STREAM OF CHARACTERS
DISADVANTAGES :
1. NOT SUPPORT VARIABLES DECLARATION TO STORE (OR) HOLD DATA.
2. WASTAGE OF MEMORY DUE TO DATA REDUNDANCY.
3. MULTIPLE USERS CANNOT ACCESS THE SINGLE FILE AT A TIME.
4. SEARCHING IS A DIFFICULT TASK.
5. INFORMATION ACCESS IS SLOW.
DATABASE MANAGEMENT SYSTEM (DBMS)
IT IS A SUIT OF SOFTWARE PROGRAM FOR CREATING, MAINTAINING & MANIPULATING THE DATA IN DATABASE. (OR)
IT IS A COLLECTION OF INTER RELATED DATA AND SET OF PROGRAM TO ACCESS THE DATA
IT ALLOWS THE ORGANIZATION TO STORE THE DATA IN ONE LOCATION FLOW, WHICH MULTIPLE USERS CAN ACCESS, THE DATA.
DIFFERENT DATABASE MODELS:
1. HIERARCHICAL MODEL
2. NETWORK MODEL
3. RELATIONAL MODEL
DATA IS ORGANIZED IN THE FORM OF TREE STRUCTURE WITH ONE LIMITATION THAT IS
“EVERY SUB NODE SHOULD HAVE ONLY ONE ROOT NODE
DRAWBACKS:
1. DATA REDUNDANCY
2. WASTAGE OF MEMORY
3.CROSS COMMUNICATION IS NOT POSSIBLE
2. NET WORK MODEL:
DATA IS ORGANIZED IN THE FORM OF ARBITRARY GRAPHS.
THERE IS NO GUARANTEE FOR ACCESS OF DATABASE WHENEVER THE DATABASE SIZE INCREASES.
CROSS COMMUNICATION IS POSSIBLE IN NDBMS.
IT CANNOT PROVIDE PROPER QUERY FACILITY, SO THAT WE HAVE TO BIG PROGRAMS EVEN FOR SMALL OPERATION.
3. RELATIONAL MODEL
IT USES THE COLLECTION OF TABLES TO REPRESENT BOTH THE DATA AND RELATIONSHIP AMONG THE DATA.
FEATURES OF RELATIONAL MODEL:
1. DATA IS STORED IN TABLES.
2. INTERSECTION OF ROWS AND COLUMNS WILL GIVE ONLY ONE VALUE.
3. RELATION AMONG DATA IS ESTABLISHED LOGICALLY.
4. THERE IS NO PHYSICAL LINK AMONG DATA
5. THERE IS NO DATA REDUNDANCY
6. HIGH SECURITY FOR DATA
7. IT SUPPORTS ANY TYPE OF DATA (EX: NUMBERS, NUMERIC, DATA, CHARACTER, DATE IMAGES ETC).
8. IT SUPPORTS NULL VALUES.
9. SUPPORT CODD RULES
10. IT SUPPORTS INTEGRITY CONSTRAINTS
11. MULTIPLE USERS CAN ACCESS DATA FROM ANY LOCATION.
NULL VALUE: IT IS UNKNOWN, UNASSIGNED AND UN COMPARABLE VALUE.
EX: 500 + NULL=NULL
ANY ARITHMETIC EXPRESSION CONTAINING NULL IS EVALUATED TO NULL
NULL IS NOT EQUAL TO ZERO OR NOT EQUAL TO SPACE.
RELATIONAL DATABSE: A DATABASE BASED ON RELATIONAL MODEL IS CALLED RELATIONAL DATABASE.
RELATIONAL DATABASE MANAGEMENT SYSTEM (RDBMS): IT IS A SUIT OF SOFTWARE PROGRAMS FOR CREATING, MARINATING AND MANIPULATING THE DATA IN THE RELATIONAL DATABASE.
DIFFERENT RDBMS PACKAGES:
Ø ORACLE
Ø SQL SERVER
Ø DB2
Ø SYBASE
SQL SERVER:
SQL SERVER 2000 IS AN RDBMS THAT USES TRANSACT-SQL TO SEND REQUESTS BETWEEN A CLIENT
COMPUTER AND A SQL SERVER 2000 COMPUTER. AN RDBMS INCLUDES DATABASES, THE DATABASE
ENGINE, AND THE APPLICATIONS THAT ARE NECESSARY TO MANAGE THE DATA AND THE COMPONENTS OF
THE RDBMS. THE RDBMS ORGANIZES DATA INTO RELATED ROWS AND COLUMNS WITHIN THE DATABASE.
THE RDBMS IS RESPONSIBLE FOR ENFORCING THE DATABASE STRUCTURE, INCLUDING THE FOLLOWING
TASKS:
■ MAINTAINING THE RELATIONSHIPS AMONG DATA IN THE DATABASE
■ ENSURING THAT DATA IS STORED CORRECTLY AND THAT THE RULES DEFINING DATA RELATIONSHIPS
ARE NOT VIOLATED
■ RECOVERING ALL DATA TO A POINT OF KNOWN CONSISTENCY IN CASE OF SYSTEM FAILURES
VERSIONS OF SQL SERVER:
1. IN 1993 MICRO SOFT AND SYBASE RELEASES 4.2 VERSION OF SQL SERVER FOR WINDOWS NT ENVIRONMENT.
2. 1995à MICROSOFT RELEASES SQL SERVER 6.0
3. 1996à MICROSOFT RELEASES SQL SERVER 6.5
4. 2000à MICROSOFT RELEASES SQL SERVER 2000
LATEST VERSION SQL SERVER 2005 NOT YET RELEASED.
FEATURES OF SQL SERVER 2000:
1. INTRODUCING SUPPORT FOR XML
2. USER DEFINED FUNCTION ARE INTRODUCED.
3. OLAP (ONLINE ANALYTICAL PROCESS) SERVICES AVAILABLE IN SQL SERVER 7.0 ARE NOW CALLED AS SQL SERVER 2000 ANALYSIS SERVICES
4. REPOSITORY COMPONENTS AVAILABLE IN SQL SERVER NOW CALLED META DATA SERVICES.
DATABASE SIZES:
· MS ACCESS à 2 GB
· SQL SERVER – 6.0 à 1 TB
· SQL SERVER – 7.0 à 1,048,516 TB 3
· SQL SERVER – 2000 à 1,048,516 TB 3
DATABASE IN SQL SERVER:
1) SYSTEM DATABASES
2) USERS DEFINED DATABASES
SYSTEM DATABASES: COMPLETE SYSTEM LEVEL INFORMATION SQL SERVER IS STORED IN SYSTEM DATABASES. SQL SERVER USES SYSTEM DATABASES TO OPERATE USER DATABASES.
USER DATABASES: THE DATABASES CREATED BY USER.
NORMALIZATION
ENTITY : A PERSON, PLACE OR EVENT ABOUT WHICH THE INFORMATION IS STORED IS CALLED ENTITY.
EX: EMPLOYEE, DEPARTMENT, STUDENT, CUSTOMER.
ATTRIBUTE: THE CHARACTERISTIC OR PROPERTY THAT DESCRIBES AN ENTITY IS CALLED ATTRIBUTE.
EX : EMPNO, ENAME, JOB ETC ARE ATTRIBUTE OF ENTITY EMPLOYEE
CUSTID, NAME, ADDRESS ARE ATTRIBUTE OF ENTITY CUSTOMER
FUNCTIONAL DEPENDENCY: IN A RELATION R, AN ATTRIBUTE B IS SAID TO BE FUNCTIONALLY DEPENDENT AN ATTRIBUTE A IF THE VALUE IN B IS UNIQUELY IDENTIFY BY THE VALUE IN A.
THE FUNCTION DEPENDENCY OF ‘B’ AN ‘A’ IS REPRESENTED AS FOLLOWS
R: AàB
EX: 1. SSN à NAME, ADDRESS, DATE OF BIRTH
IE A PERSON NAME, ADDRESS, DATE OF BIRTH
FUNCTIONALLY DEPENDENT ON SOCIAL SECURITY NUMBER(SSN)
2. VIN à MAKE, MODEL, COLOR
IE MAKE, MODEL & COLOR OF VEHICLE FUNCTIONALLY
DEPENDS ON VIN (VEHICLE IDENTIFICATION NUMBER)
PARTIAL FUNCTIONAL DEPENDENCY:
PARTIAL FUNCTIONAL DEPENDENCY IS THE FUNCTIONAL DEPENDENCY IN WHICH SOME NON-KEY COLUMNS DEPENDS ON PART OF KEY COLUMN OR PRIMARY COLUMN.
IN THE ABOVE TABLE EMP NAME, SAL DEPENDS ONLY ON EMP NO BUT THE COURSE COMPLETED DAT WILL DEPENDS ON BOTH EMP NO & COURSE TITLE TO IDENTIFY THE ROW UNIQUELY IN A TABLE EMP NO, COURSE TITLE SHOULD BE DECLARED AS PRIMARY KEY COLUMNS. BUT THE NON-KEY ATTRIBUTES NAME, SQL DEPENDS ONLY EMP NO, IE PART OF A KEY COLUMN THIS TYPE OF FUNCTIONAL DEPENDENCY IS CALLED IT PARTIAL FUNCTIONAL DEPENDENCY.
TRANSITIVE DEPENDENCY
FUNCTIONAL DEPENDENCY BETWEEN THE TWO NON-KEY ATTRIBUTES IS CALLED THE TRANSITIVE DEPENDENCY.
Ø IN THE ABOVE TABLE CUSTID IS IDENTIFIED AS KEY COLUMN
Ø BUT REGION DEPENDS ONLY ON SALESMAN, IS CALLED TRANSITIVE DEPENDENCY.
COLUMNS REGION AND SALESMAN IS CALLED TRANSITIVE DEPENDENCY.
NORMALIZATION ; IT IS THE PROCESS OF DECOMPOSING THE RELATIONS (TABLES) IN TO SMALLER AND WELL STRUCTERD RELATIONS TO MINIMIZE THE DATA REDUNDANCY.
(OR)
IT IS THE PROCESS OF DECIDING WHICH ATTRIBUTED HAS TO GROUPED TO AVOID DATA REDUNDANCY.
THERE ARE SOME RULES IN NORMALIZATION EACH RULE IS CALLED NORMAL FORM.
NORMAL FORMS:
1. FIRST NORMAL FORM (1NF)
2. SECOND NORMAL FORM (2NF)
3. THIRD NORMAL FORM (3NF)
FIRST NORMAL FORMS (1NF): MULTI VALUED ATTRIBUTED SHOULD BE REMOVED FROM THE TABLE.
EXPLANATION: IN THE ABOVE TABLE EMP COURSE TITLE, COURSE COMPLETED DATE ARE MULTI VALUED ATTRIBUTES SINCE AT THE INTERSECTIONS OF ROW AND COLUMN THEY WILL GIVE MOVE THAN ON VALUE. TO BRING THE ABOVE TABLE TO INF MULTI VALUED ATTRIBUTED SHOULD BE REMOVED BY FILLING THE EMPTY FIELD WITH SUITABLE DATA AS SHOWN BELOW.
SECOND NORMAL FORM (2NF) : THE RELATION SHOULD BE IN INF AND THE PARTIAL FUNCTIONAL DEPENDENCY SHOULD BE REMOVED.
IN THE ABOVE TABLE EMP NO, COURSE TITLE ARE IDENTIFIED AS KEY COLUMN BUT NON-KEY COL LIKE NAME AND SQL WILL DEPENDS.
TO BRING THE TABLE TO SECOND NORMAL FORM THE NORMAL FUNCTIONAL DEPENDENCY SHOULD BE REMOVED BY DIVIDING THE TABLE INTO TWO TABLES AS SHOWN ABOVE.
THIRD NORMAL FORM (3NF): THE TABLE SHOULD BE IN THE 2NF AND TRANSITIVE DEPENDENCY SHOULD BE REMOVED.
EX: CUSTOMER
· CUSTID IS IDENTIFIED AS KEY-COLUMN BUT REGION DEPENDS ON SALESMAN.
· THE FUNCTIONAL DEPENDENCY BETWEEN NON-KEY ATTRIBUTES SALES MAN & REGION IS CALLED TRANSITIVE DEPENDENCY.
· TO BRING THE TABLE TO THIRD NORMAL FORM, TRANSITIVE DEPENDENCY SHOULD BE REMOVED BY DIVIDING THE TABLE INTO TWO TABLE AS SHOWN BELOW
SYSTEM AND SAMPLE DATABASE IN SQL SERVER:
WHEN SQL SERVER IS INSTALLED IN A SYSTEM SETUP WILL CREATES THE FOLLOWING SYSTEM AND SAMPLE DATABASE.
SYSTEM DATABASES:
1. MASTER
2. MODEL
3. TEMPDB
4. MSDB
SAMPLE DATABASES:
1. PUBS
2. NORTH WIND
1. MASTER DATABASE : IT CONTAINS SYSTEM LEVEL INFORMATION OF SQL SERVER. ALL LOGINS AND DATABASE INFORMATION IS STORED IN MASTER DATABASE.
2. MODEL DATABASE : IT IS A TEMPLATE FOR USER DATABASES. WHEN USES IS CREATED A DATABASE THE COMPLETE INFORMATION WHICH IS THERE IN MODEL DATA WILL BE COPIED INTO THE USER DATABASE.
3. TEMPDB: IT FOR HOLDING TEMPORARY OBJECTS WHICH ARE CREATED WHEN SQL SERVER STARTS.
4. MSDB: SQL SERVER AGENT FOR SCHEDULING JOBS AND ALERTS USES IT.
PUBS & NORTH WIND: SAMPLE DATABASES
SUB LANGUAGES IN T-SQL COMMANDS:
1. DDL (DATA DEFINITION LANGUAGE)
2. DML (DATA MANIPULATION LANGUAGE)
3. DCL (DATA CONTROL LANGUAGE)
Ø DDL : THESE ARE USED TO CREATE, ALTER AND DROP THE DATABASE OBJECTS.
COMMANDS 1.CREATE
2. ALTER
3. DROP
Ø DML : THESE ARE USED TO INSERT, MODIFY AND DELETE THE DATA IN DATABASE OBJECTS.
à THESE COMMANDS ARE ALSO USED TO RETRIEVE THE DATA IN DB OBJECTS
COMMANDS 1.INSERT
2. UPDATE
3. DELETE
4. SELECT
Ø DCL : THESE ARE USED TO GRAND OR REVOKE THE PERMISSIONS ON DATABASE OBJECTS TO
OTHER USERS
COMMANDS 1.GRANT
2. REVOKE
TABLE IS THE PRIMARY STORAGE UNIT FOR DATA IN DB. MAX NO OF COLUMNS ALLOWED FOR A TABLES ARE 1024, MAX AMOUNT OF DATA ALLOWED PER A ROW 8060 BYTES.
DATA TYPE : THE DATA TYPE SPECIFIES THE TYPE OF DATA THAT CAN BE STORED IN A VARIABLE OR COLUMN OF A TABLE.
DATA TYPE IN SQL SERVER ARE CLASSIFIED INTO TWO TYPES:
1. PREDEFINED DATA TYPES.
2. USER DEFINED DATA TYPES.
PRE DEFINED DATA TYPES:
(a) CHAR [(N)]àFIXED LENGTH DATA TYPE USED TO STORE CHARACTER DATA, STATIC MEMORY ALLOCATION
à IT CAN STORE DATA UP TO 8000CHARACTERS.
à DEFAULT SIZE OF N IS 1 BYTE.
EX: 1.@V1 CHAR (5)
2.@V2 CHAR (10)
(b) VARCHAR (N)àVARIABLE LENGTH DATA TYPE. DYNAMIC MEMORY ALLOCATION
à IT CAN STORE DATA UP TO 8000CHARACTERS.
EX: 1. @ A VARCHAR (5)
MEMORY WILL BE ALLOCATED DYNAMICALLY
(c) NCHAR (N)àFIXED LENGTH OF CHARACTER DATA TYPE
à IT CAN STORE DATA UP TO 4000CHARACTERS.
(d) NVARCHAR (N)àVARIABLE LENGTH CHARACTER DATA TYPE
à IT CAN STORE DATA UP TO 4000 CHARACTERS.
NUMERIC DATA TYPE : USED TO STORE THE NUMERIC VALUES
DATATYPE SIZE
BIGINT 8 BYTES
INT 4 BYTES
SMALLINT 2 BYTES
TINYINT 1 BYTES
FLOAT 8 BYTES
REAL 4 BYTES
DATE DATA TYPE: USED TO STORE DATE AND TIME VALUES.
1. DATE TIME: à USED TO STORE DATE VALUES FROM 1ST JANUARY -1753 TO 31ST DECEMBER - 9999
à DEFAULT SIZE IS 8 BYTES
EX : IS DOJ DATE TIME.
2. DATE TIME: à USED TO STORE DATE VALUES FROM 1ST JANUARY -1990 TO 6TH JUNE - 1979
à DEFAULT SIZE IS 4 BYTES
SQL SERVER SERVICE MANAGER: BY USING THIS DBA CAN STOP, PAUSE OR START THE SERVER.
ENTERPRISE MANAGER: IT IS THE PRIMARY ADMINISTRATIVE TOOL FOR THE ADMINISTRATIVE TASK.
CREATING LOGINS: IN ENTERPRISE MANAGE.
SECURITYà LOGINS
↓ RIGHT CLICK ON THIS
à CLICK ON NEW LOGIN
à SELECT THE SQL SERVER AUTHENTICATION
NAME OF LOGIC
PASSWORD****
CLICK OK
VERIFYING THE PROPERTIES OF LOGIN: CLICK RIGHT CLICK ON LOGIN AND CLICK ON PROPERTIES
DEMO TABLES:
1. EMP TABLE
2. DEPT TABLE
EMP TABLE
EMPNO ENAME JOB MGR SAL COMM. HIREDATE DPTN
7369 SMITH CLERK 7902 800 NULL ----- 20
--- ---- --- --- --- --- ----- ---
--- ---- --- --- --- --- ---- ---
7934 MILLER CLERK 7506 1300 NULL --- 10
DEPT TABLE:
DEPT NO DNAME LOC
10 ACCOUNTING NEWYORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
DDL COMMANDS
CREATE : IT IS USED TO CREATE DATABASE AND ITS OBJECTS LIKE TABLE, VIEWS ETC
à CREATE TABLE STUDENTS ( RNO INT, NAME VARCHAR (20), ADDRESS VARCHAR(50))
[SHIFT+HOME]—COMMANDS IS SELECT
F5à EXECUTE THE COMMAND
DESCRIBING THE STRUCTURE OF A TABLE:
SYNTAX : SP_HELP
ADD
EX : CUSTOMER NAME IN BANK
TOTAL MARKS OBTAINED BY STUDENT
INFORMATION: AN ORGANIZED DATA IS CALLED INFORMATION
EX : CUSTOMER NAME WITH BALANCES.
STUDENT REG NO WITH TOTAL MARKS.
DATA HIERARCHY:
BIT IT MAY BE EITHER 0 OR 1
IT REPRESENTS THE SMALLEST PART OF INFORMATION THAT COMPUTER CAN PROCESS.
BYTE : IT IS GROUP OF 8 BITS IT REPRESENTS A DIGIT, LETTERS OR SPECIAL SYMBOL.
FILED: IT IS A GROUP OF CHARACTERS.
EMPNO ENAME SAL JOB
100 SMITH 800 CLERK
RECORD: IT IS A GROUP OF LOGICALLY RELATED FIELD.
FILE : GROUP OF LOGICALLY RELATED RECORDS OR IT IS A FLOW OF CHARACTERS.
DATABASE: IT IS A GROUP OF LOGICALLY RELATED DATA.
(OR)
IT IS THE COLLECTION OF DATA STORED IN A FILE ON DISC
CLASSIFICATION OF DATA BASE BASED ON SIZE
· NORMAL DATABASE:<10 GB
· LARGE DATABASE : 10 GB TO 100 GB
· VERY LARGE DATABASE : 100 GB TO 1000 GB
· EXTREMELY LARGE DATABASE :> 1000 GB
FILE MANAGEMENT SYSTEM
FILE : IT IS A STREAM OF CHARACTERS
DISADVANTAGES :
1. NOT SUPPORT VARIABLES DECLARATION TO STORE (OR) HOLD DATA.
2. WASTAGE OF MEMORY DUE TO DATA REDUNDANCY.
3. MULTIPLE USERS CANNOT ACCESS THE SINGLE FILE AT A TIME.
4. SEARCHING IS A DIFFICULT TASK.
5. INFORMATION ACCESS IS SLOW.
DATABASE MANAGEMENT SYSTEM (DBMS)
IT IS A SUIT OF SOFTWARE PROGRAM FOR CREATING, MAINTAINING & MANIPULATING THE DATA IN DATABASE. (OR)
IT IS A COLLECTION OF INTER RELATED DATA AND SET OF PROGRAM TO ACCESS THE DATA
IT ALLOWS THE ORGANIZATION TO STORE THE DATA IN ONE LOCATION FLOW, WHICH MULTIPLE USERS CAN ACCESS, THE DATA.
DIFFERENT DATABASE MODELS:
1. HIERARCHICAL MODEL
2. NETWORK MODEL
3. RELATIONAL MODEL
DATA IS ORGANIZED IN THE FORM OF TREE STRUCTURE WITH ONE LIMITATION THAT IS
“EVERY SUB NODE SHOULD HAVE ONLY ONE ROOT NODE
DRAWBACKS:
1. DATA REDUNDANCY
2. WASTAGE OF MEMORY
3.CROSS COMMUNICATION IS NOT POSSIBLE
2. NET WORK MODEL:
DATA IS ORGANIZED IN THE FORM OF ARBITRARY GRAPHS.
THERE IS NO GUARANTEE FOR ACCESS OF DATABASE WHENEVER THE DATABASE SIZE INCREASES.
CROSS COMMUNICATION IS POSSIBLE IN NDBMS.
IT CANNOT PROVIDE PROPER QUERY FACILITY, SO THAT WE HAVE TO BIG PROGRAMS EVEN FOR SMALL OPERATION.
3. RELATIONAL MODEL
IT USES THE COLLECTION OF TABLES TO REPRESENT BOTH THE DATA AND RELATIONSHIP AMONG THE DATA.
FEATURES OF RELATIONAL MODEL:
1. DATA IS STORED IN TABLES.
2. INTERSECTION OF ROWS AND COLUMNS WILL GIVE ONLY ONE VALUE.
3. RELATION AMONG DATA IS ESTABLISHED LOGICALLY.
4. THERE IS NO PHYSICAL LINK AMONG DATA
5. THERE IS NO DATA REDUNDANCY
6. HIGH SECURITY FOR DATA
7. IT SUPPORTS ANY TYPE OF DATA (EX: NUMBERS, NUMERIC, DATA, CHARACTER, DATE IMAGES ETC).
8. IT SUPPORTS NULL VALUES.
9. SUPPORT CODD RULES
10. IT SUPPORTS INTEGRITY CONSTRAINTS
11. MULTIPLE USERS CAN ACCESS DATA FROM ANY LOCATION.
NULL VALUE: IT IS UNKNOWN, UNASSIGNED AND UN COMPARABLE VALUE.
EX: 500 + NULL=NULL
ANY ARITHMETIC EXPRESSION CONTAINING NULL IS EVALUATED TO NULL
NULL IS NOT EQUAL TO ZERO OR NOT EQUAL TO SPACE.
RELATIONAL DATABSE: A DATABASE BASED ON RELATIONAL MODEL IS CALLED RELATIONAL DATABASE.
RELATIONAL DATABASE MANAGEMENT SYSTEM (RDBMS): IT IS A SUIT OF SOFTWARE PROGRAMS FOR CREATING, MARINATING AND MANIPULATING THE DATA IN THE RELATIONAL DATABASE.
DIFFERENT RDBMS PACKAGES:
Ø ORACLE
Ø SQL SERVER
Ø DB2
Ø SYBASE
SQL SERVER:
SQL SERVER 2000 IS AN RDBMS THAT USES TRANSACT-SQL TO SEND REQUESTS BETWEEN A CLIENT
COMPUTER AND A SQL SERVER 2000 COMPUTER. AN RDBMS INCLUDES DATABASES, THE DATABASE
ENGINE, AND THE APPLICATIONS THAT ARE NECESSARY TO MANAGE THE DATA AND THE COMPONENTS OF
THE RDBMS. THE RDBMS ORGANIZES DATA INTO RELATED ROWS AND COLUMNS WITHIN THE DATABASE.
THE RDBMS IS RESPONSIBLE FOR ENFORCING THE DATABASE STRUCTURE, INCLUDING THE FOLLOWING
TASKS:
■ MAINTAINING THE RELATIONSHIPS AMONG DATA IN THE DATABASE
■ ENSURING THAT DATA IS STORED CORRECTLY AND THAT THE RULES DEFINING DATA RELATIONSHIPS
ARE NOT VIOLATED
■ RECOVERING ALL DATA TO A POINT OF KNOWN CONSISTENCY IN CASE OF SYSTEM FAILURES
VERSIONS OF SQL SERVER:
1. IN 1993 MICRO SOFT AND SYBASE RELEASES 4.2 VERSION OF SQL SERVER FOR WINDOWS NT ENVIRONMENT.
2. 1995à MICROSOFT RELEASES SQL SERVER 6.0
3. 1996à MICROSOFT RELEASES SQL SERVER 6.5
4. 2000à MICROSOFT RELEASES SQL SERVER 2000
LATEST VERSION SQL SERVER 2005 NOT YET RELEASED.
FEATURES OF SQL SERVER 2000:
1. INTRODUCING SUPPORT FOR XML
2. USER DEFINED FUNCTION ARE INTRODUCED.
3. OLAP (ONLINE ANALYTICAL PROCESS) SERVICES AVAILABLE IN SQL SERVER 7.0 ARE NOW CALLED AS SQL SERVER 2000 ANALYSIS SERVICES
4. REPOSITORY COMPONENTS AVAILABLE IN SQL SERVER NOW CALLED META DATA SERVICES.
DATABASE SIZES:
· MS ACCESS à 2 GB
· SQL SERVER – 6.0 à 1 TB
· SQL SERVER – 7.0 à 1,048,516 TB 3
· SQL SERVER – 2000 à 1,048,516 TB 3
DATABASE IN SQL SERVER:
1) SYSTEM DATABASES
2) USERS DEFINED DATABASES
SYSTEM DATABASES: COMPLETE SYSTEM LEVEL INFORMATION SQL SERVER IS STORED IN SYSTEM DATABASES. SQL SERVER USES SYSTEM DATABASES TO OPERATE USER DATABASES.
USER DATABASES: THE DATABASES CREATED BY USER.
NORMALIZATION
ENTITY : A PERSON, PLACE OR EVENT ABOUT WHICH THE INFORMATION IS STORED IS CALLED ENTITY.
EX: EMPLOYEE, DEPARTMENT, STUDENT, CUSTOMER.
ATTRIBUTE: THE CHARACTERISTIC OR PROPERTY THAT DESCRIBES AN ENTITY IS CALLED ATTRIBUTE.
EX : EMPNO, ENAME, JOB ETC ARE ATTRIBUTE OF ENTITY EMPLOYEE
CUSTID, NAME, ADDRESS ARE ATTRIBUTE OF ENTITY CUSTOMER
FUNCTIONAL DEPENDENCY: IN A RELATION R, AN ATTRIBUTE B IS SAID TO BE FUNCTIONALLY DEPENDENT AN ATTRIBUTE A IF THE VALUE IN B IS UNIQUELY IDENTIFY BY THE VALUE IN A.
THE FUNCTION DEPENDENCY OF ‘B’ AN ‘A’ IS REPRESENTED AS FOLLOWS
R: AàB
EX: 1. SSN à NAME, ADDRESS, DATE OF BIRTH
IE A PERSON NAME, ADDRESS, DATE OF BIRTH
FUNCTIONALLY DEPENDENT ON SOCIAL SECURITY NUMBER(SSN)
2. VIN à MAKE, MODEL, COLOR
IE MAKE, MODEL & COLOR OF VEHICLE FUNCTIONALLY
DEPENDS ON VIN (VEHICLE IDENTIFICATION NUMBER)
PARTIAL FUNCTIONAL DEPENDENCY:
PARTIAL FUNCTIONAL DEPENDENCY IS THE FUNCTIONAL DEPENDENCY IN WHICH SOME NON-KEY COLUMNS DEPENDS ON PART OF KEY COLUMN OR PRIMARY COLUMN.
IN THE ABOVE TABLE EMP NAME, SAL DEPENDS ONLY ON EMP NO BUT THE COURSE COMPLETED DAT WILL DEPENDS ON BOTH EMP NO & COURSE TITLE TO IDENTIFY THE ROW UNIQUELY IN A TABLE EMP NO, COURSE TITLE SHOULD BE DECLARED AS PRIMARY KEY COLUMNS. BUT THE NON-KEY ATTRIBUTES NAME, SQL DEPENDS ONLY EMP NO, IE PART OF A KEY COLUMN THIS TYPE OF FUNCTIONAL DEPENDENCY IS CALLED IT PARTIAL FUNCTIONAL DEPENDENCY.
TRANSITIVE DEPENDENCY
FUNCTIONAL DEPENDENCY BETWEEN THE TWO NON-KEY ATTRIBUTES IS CALLED THE TRANSITIVE DEPENDENCY.
Ø IN THE ABOVE TABLE CUSTID IS IDENTIFIED AS KEY COLUMN
Ø BUT REGION DEPENDS ONLY ON SALESMAN, IS CALLED TRANSITIVE DEPENDENCY.
COLUMNS REGION AND SALESMAN IS CALLED TRANSITIVE DEPENDENCY.
NORMALIZATION ; IT IS THE PROCESS OF DECOMPOSING THE RELATIONS (TABLES) IN TO SMALLER AND WELL STRUCTERD RELATIONS TO MINIMIZE THE DATA REDUNDANCY.
(OR)
IT IS THE PROCESS OF DECIDING WHICH ATTRIBUTED HAS TO GROUPED TO AVOID DATA REDUNDANCY.
THERE ARE SOME RULES IN NORMALIZATION EACH RULE IS CALLED NORMAL FORM.
NORMAL FORMS:
1. FIRST NORMAL FORM (1NF)
2. SECOND NORMAL FORM (2NF)
3. THIRD NORMAL FORM (3NF)
FIRST NORMAL FORMS (1NF): MULTI VALUED ATTRIBUTED SHOULD BE REMOVED FROM THE TABLE.
EXPLANATION: IN THE ABOVE TABLE EMP COURSE TITLE, COURSE COMPLETED DATE ARE MULTI VALUED ATTRIBUTES SINCE AT THE INTERSECTIONS OF ROW AND COLUMN THEY WILL GIVE MOVE THAN ON VALUE. TO BRING THE ABOVE TABLE TO INF MULTI VALUED ATTRIBUTED SHOULD BE REMOVED BY FILLING THE EMPTY FIELD WITH SUITABLE DATA AS SHOWN BELOW.
SECOND NORMAL FORM (2NF) : THE RELATION SHOULD BE IN INF AND THE PARTIAL FUNCTIONAL DEPENDENCY SHOULD BE REMOVED.
IN THE ABOVE TABLE EMP NO, COURSE TITLE ARE IDENTIFIED AS KEY COLUMN BUT NON-KEY COL LIKE NAME AND SQL WILL DEPENDS.
TO BRING THE TABLE TO SECOND NORMAL FORM THE NORMAL FUNCTIONAL DEPENDENCY SHOULD BE REMOVED BY DIVIDING THE TABLE INTO TWO TABLES AS SHOWN ABOVE.
THIRD NORMAL FORM (3NF): THE TABLE SHOULD BE IN THE 2NF AND TRANSITIVE DEPENDENCY SHOULD BE REMOVED.
EX: CUSTOMER
· CUSTID IS IDENTIFIED AS KEY-COLUMN BUT REGION DEPENDS ON SALESMAN.
· THE FUNCTIONAL DEPENDENCY BETWEEN NON-KEY ATTRIBUTES SALES MAN & REGION IS CALLED TRANSITIVE DEPENDENCY.
· TO BRING THE TABLE TO THIRD NORMAL FORM, TRANSITIVE DEPENDENCY SHOULD BE REMOVED BY DIVIDING THE TABLE INTO TWO TABLE AS SHOWN BELOW
SYSTEM AND SAMPLE DATABASE IN SQL SERVER:
WHEN SQL SERVER IS INSTALLED IN A SYSTEM SETUP WILL CREATES THE FOLLOWING SYSTEM AND SAMPLE DATABASE.
SYSTEM DATABASES:
1. MASTER
2. MODEL
3. TEMPDB
4. MSDB
SAMPLE DATABASES:
1. PUBS
2. NORTH WIND
1. MASTER DATABASE : IT CONTAINS SYSTEM LEVEL INFORMATION OF SQL SERVER. ALL LOGINS AND DATABASE INFORMATION IS STORED IN MASTER DATABASE.
2. MODEL DATABASE : IT IS A TEMPLATE FOR USER DATABASES. WHEN USES IS CREATED A DATABASE THE COMPLETE INFORMATION WHICH IS THERE IN MODEL DATA WILL BE COPIED INTO THE USER DATABASE.
3. TEMPDB: IT FOR HOLDING TEMPORARY OBJECTS WHICH ARE CREATED WHEN SQL SERVER STARTS.
4. MSDB: SQL SERVER AGENT FOR SCHEDULING JOBS AND ALERTS USES IT.
PUBS & NORTH WIND: SAMPLE DATABASES
SUB LANGUAGES IN T-SQL COMMANDS:
1. DDL (DATA DEFINITION LANGUAGE)
2. DML (DATA MANIPULATION LANGUAGE)
3. DCL (DATA CONTROL LANGUAGE)
Ø DDL : THESE ARE USED TO CREATE, ALTER AND DROP THE DATABASE OBJECTS.
COMMANDS 1.CREATE
2. ALTER
3. DROP
Ø DML : THESE ARE USED TO INSERT, MODIFY AND DELETE THE DATA IN DATABASE OBJECTS.
à THESE COMMANDS ARE ALSO USED TO RETRIEVE THE DATA IN DB OBJECTS
COMMANDS 1.INSERT
2. UPDATE
3. DELETE
4. SELECT
Ø DCL : THESE ARE USED TO GRAND OR REVOKE THE PERMISSIONS ON DATABASE OBJECTS TO
OTHER USERS
COMMANDS 1.GRANT
2. REVOKE
TABLE IS THE PRIMARY STORAGE UNIT FOR DATA IN DB. MAX NO OF COLUMNS ALLOWED FOR A TABLES ARE 1024, MAX AMOUNT OF DATA ALLOWED PER A ROW 8060 BYTES.
DATA TYPE : THE DATA TYPE SPECIFIES THE TYPE OF DATA THAT CAN BE STORED IN A VARIABLE OR COLUMN OF A TABLE.
DATA TYPE IN SQL SERVER ARE CLASSIFIED INTO TWO TYPES:
1. PREDEFINED DATA TYPES.
2. USER DEFINED DATA TYPES.
PRE DEFINED DATA TYPES:
(a) CHAR [(N)]àFIXED LENGTH DATA TYPE USED TO STORE CHARACTER DATA, STATIC MEMORY ALLOCATION
à IT CAN STORE DATA UP TO 8000CHARACTERS.
à DEFAULT SIZE OF N IS 1 BYTE.
EX: 1.@V1 CHAR (5)
2.@V2 CHAR (10)
(b) VARCHAR (N)àVARIABLE LENGTH DATA TYPE. DYNAMIC MEMORY ALLOCATION
à IT CAN STORE DATA UP TO 8000CHARACTERS.
EX: 1. @ A VARCHAR (5)
MEMORY WILL BE ALLOCATED DYNAMICALLY
(c) NCHAR (N)àFIXED LENGTH OF CHARACTER DATA TYPE
à IT CAN STORE DATA UP TO 4000CHARACTERS.
(d) NVARCHAR (N)àVARIABLE LENGTH CHARACTER DATA TYPE
à IT CAN STORE DATA UP TO 4000 CHARACTERS.
NUMERIC DATA TYPE : USED TO STORE THE NUMERIC VALUES
DATATYPE SIZE
BIGINT 8 BYTES
INT 4 BYTES
SMALLINT 2 BYTES
TINYINT 1 BYTES
FLOAT 8 BYTES
REAL 4 BYTES
DATE DATA TYPE: USED TO STORE DATE AND TIME VALUES.
1. DATE TIME: à USED TO STORE DATE VALUES FROM 1ST JANUARY -1753 TO 31ST DECEMBER - 9999
à DEFAULT SIZE IS 8 BYTES
EX : IS DOJ DATE TIME.
2. DATE TIME: à USED TO STORE DATE VALUES FROM 1ST JANUARY -1990 TO 6TH JUNE - 1979
à DEFAULT SIZE IS 4 BYTES
SQL SERVER SERVICE MANAGER: BY USING THIS DBA CAN STOP, PAUSE OR START THE SERVER.
ENTERPRISE MANAGER: IT IS THE PRIMARY ADMINISTRATIVE TOOL FOR THE ADMINISTRATIVE TASK.
CREATING LOGINS: IN ENTERPRISE MANAGE.
SECURITYà LOGINS
↓ RIGHT CLICK ON THIS
à CLICK ON NEW LOGIN
à SELECT THE SQL SERVER AUTHENTICATION
NAME OF LOGIC
PASSWORD****
CLICK OK
VERIFYING THE PROPERTIES OF LOGIN: CLICK RIGHT CLICK ON LOGIN AND CLICK ON PROPERTIES
DEMO TABLES:
1. EMP TABLE
2. DEPT TABLE
EMP TABLE
EMPNO ENAME JOB MGR SAL COMM. HIREDATE DPTN
7369 SMITH CLERK 7902 800 NULL ----- 20
--- ---- --- --- --- --- ----- ---
--- ---- --- --- --- --- ---- ---
7934 MILLER CLERK 7506 1300 NULL --- 10
DEPT TABLE:
DEPT NO DNAME LOC
10 ACCOUNTING NEWYORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
DDL COMMANDS
CREATE : IT IS USED TO CREATE DATABASE AND ITS OBJECTS LIKE TABLE, VIEWS ETC
à CREATE TABLE STUDENTS ( RNO INT, NAME VARCHAR (20), ADDRESS VARCHAR(50))
[SHIFT+HOME]—COMMANDS IS SELECT
F5à EXECUTE THE COMMAND
DESCRIBING THE STRUCTURE OF A TABLE:
SYNTAX : SP_HELP