PPT-SQL & ADVANCED SQL Marcin Blaszczyk (CERN IT-DB)

m arcinblaszczykcernch Goal of this tutorial Present the overview of basic SQL capabilities Explain several selected advanced SQL features Outline Introduction SQL basics Joins amp Complex queries. Grouping. Presented by. : Jared Still. About Me. Worked with Oracle since version 7.0. Have an affinity for things . Perlish. , such as DBD::Oracle. Working as a DBA at . Pythian. since Jan 2011. Hobbies and extracurricular activities usually do not involve computers or databases.. Dr. Maneesh Wadhwa . SIX Swiss Exchange AG. Flash Back . of last . 12 years working at CERN. Why I am telling . you all this?. Do you realize?. Skills . and . qualifications . you attain while working at CERN are countless. . 2. nd. update . . For T1SCM . http://indico.cern.ch/conferenceDisplay.py?confId=126076. 2011/02/10. Presentation given to the CERN IT Service Managers now working in PRMS on 2011/01/25. Slides . December 12th-16th, 2011. Table of Contents. CERN Higgs boson Flash Report. . Executive Summary & Findings 3-4. Background 5. Pre-announcement overview 6. Announcement overview 7. an R&D Partnership . Bill Jonhson,. Director of Research and Development for Hewlett-Packard ProCurve Networking Business. . 3. rd. Oct.2008. Footer text. 2. HP ProCurve Confidential. HP History of Engagement at CERN OpenLab. Elvis Fornasiere. CERN, Geneva (CH). On behalf of . CERN BLIP Project, EN-STI-TCD. Outline. Assembly of the of the high-Z capsule. Corrective actions and second design. Timeline. E. . F. ornasiere. 29.11.2016. Departament Technologii Akceleratorów. CERN – pierwsze globalne laboratorium. A. . Siemko. Plan wykładu . . CERN . – trochę historii. Kto pracuje w CERN . Misja . i zadania . CERN. . Kompleks . N.Ziogas, KT group. FLUKA . - . FLUktuierende. . KAskade. . A fully integrated particle physics . MonteCarlo. simulation package. 40 years history & evolution. First generation (the CERN SPS . Substantial activities related to accelerator work and now also detectors. Based on CERN-KEK agreement and CLIC – ILC common working groups . Plans at CERN the common years . Accelerator collaborations. Palomäki. IDEASQUARE IN BRIEF. “Ideasquare is an experiment that brings together researchers, engineers, industrial partners and cross-disciplinary student teams . to work together on detector upgrade R&D technologies. The dual purpose is to co-develop new technologies for research purposes and create a fruitful environment for socially and globally relevant new product ideas and innovation.”. APPEC. Is . the . A. stro. P. article. . P. hysics . E. uropean . C. onsortium . An . international coordinating . structure. Founded . in . 2012. Developed . within the EU-funded projects ASPERA and . Dan Noyes (CERN Communications). Overview of top-level domains. Top-level domain (TLD) – to the right of the dot (.com, .org, .. ch. ). ICANN – Internet Corporation for Assigned Names and Numbers. Oracle Tutorials – May 2013. Outline. Advanced Queries . Analytical Functions & Set Operators. Indexes & IOTs. Partitioning. Undo . & Flashback technologies. Disclaimer: “this is not a SQL tuning tutorial”. Frédéric . Ferrand. CERN, Geneva, Switzerland. On behalf of CERN Cryogenics Group. OUTLOOK. Introduction. . Definition of maintenance strategy for critical Assets. . . Maintenance Policy for cryogenic equipment at CERN.