Skip to main content

Programmering i SQL

De fleste hæfter (Libris, Globe, IDG etc) om SQL programmering er af ældre årgang.
Derfor kan de alligevel danne et udgangspunkt for at lære SQL, når man ønsker en bred introduktion i forbindelse med SAS' Proc SQL, embedded SQL i VBA, på servere i sammenhæng med PHP eller som del af datamanagement forud for analyser.

Vedhæftet er fire filer, der danner grundlaget for eksempler i bogen Programmering i SQL der er udgivet på Globe i 2001. Der er en del ændringer, da jeg har anvendt mySQL, og bogen behandler ACCESS samt Microsofts SQL Server.

Filerne kan hentes ved at klikke på følgende links:


Jeg har tilføjet en del kommentarer, så man er hurtigt kørende, når man tager udgangspunkt i community pakken med Oracle MySQL Workbench, der kan downloades på mySQL:


MySQL bliver brugt i forbindelse med udtræk til summarisk statistik, selv estimater i Poisson og Cox PH regressionsmodeller kan udregnes med brug af SQL kode. 

Mange har lavet interface til SAS, VBA, Python, C med mere, der giver mulighed for at benytte SQL i data management delen af ens statistiske analyser. Se f.eks. Apophenia og ikke mindst siden for bogen Modeling with Data.

Comments

Popular posts from this blog

HackRF on Windows 8

This technical note is based on an extract from thread. I have made several changes and added recommendations. I have experienced lot of latency using GnuRadio and HackRF on Pentoo Linux, so I wanted to try out GnuRadio on Windows.



HackRF One is a transceiver, so besides SDR capabilities, it can also transmit signals, inkluding sweeping a given range, uniform and Gaussian signals. Pentoo Linux provides the most direct access to HackRF and toolboxes. Install Pentoo Linux on a separate drive, then you can use osmocom_siggen from a terminal to transmit signals such as near-field GSM bursts, which will only be detectable within a meter.









Installation of MGWin and cmake: Download and install the following packages:
- MinGW Setup (Go to the Installer directory and download setup file)
- CMake (I am using CMake 3.2.2 and I installed it in C:\CMake, this path is important in the commands we must send in the MinGW shell)
Download and extract the packages respectively in the path C:\MinGW\msys\…

Example: Beeswarm plot in R

library(foreign)

data <- read.dta("C:/Users/hellmund/Documents/MyStataDataFile.dta")

names(data)

install.packages('beeswarm')

library(beeswarm)

levels(data$group)

png(file="C:/Users/hellmund/Documents/il6.png", bg="transparent")

beeswarm(data$il6~data$group,data=data, method=c("swarm"),pch=16,pwcol=data$Gender,xlab='',ylab='il6',ylim=c(0,20))

legend('topright',legend=levels(data$Gender),title='Gender',pch=16,col=2:1)

boxplot(data$il6~data$group, data=data, add = T, names = c("","",""), col="#0000ff22")

dev.off()

Example: Business cards typeset with LaTeX

So you enjoy the quality of a professional typesetting system? You got Avery labels, a working MikTeX and the ticket package installed...
You might find some assistance from a half criminal paranoid zealot system administrator, willing to guide you through a dinosaur kingdom of TeX ... but that kind of assistance might also just leave you with nothing.

It was easy to get the layout of the labels with the option zw32010, but how about page margins? I tried to set things straight with the layouts package (\usepackage{layouts}\currentpage \pagedesign), but then there was still some unwanted white space and margins...

To make things less complicated I decided to make a single card. The solution is a hack because it needs customization (with voffset and hoffset as you see n the TeX code below) but the adjustment is more straightforward, especially if you use the boxed option with ticket.

The card was converted to png with Ghostscript and I could easily print the business cards with Averys …