My Account Log in

1 option

Understanding SQL and R / Saternos, Casimir.

O'Reilly Online Learning: Academic/Public Library Edition Available online

View online
Format:
Video
Author/Creator:
Saternos, Casimir, author.
Language:
English
Subjects (All):
SQL (Computer program language).
R (Computer program language).
Genre:
Electronic videos.
Physical Description:
1 online resource (1 video file, approximately 6 hr., 10 min.)
Edition:
1st edition
Place of Publication:
Infinite Skills, 2016.
System Details:
video file
Summary:
This course is recommended for anyone (business analyst, researcher, social scientist, programmer, etc.) interested in analyzing and visualizing data. It shows you how to combine two of the most popular technologies used in data analytics: SQL and R. SQL is essential for communicating with relational databases, the type of database where most of the world's data is stored. R is a statistical analysis tool: It uses SQL to interact with databases for the purpose of creating charts, plots, reports, visualizations, and even web applications that incorporate data into a final product. Complete this course and you'll learn the basics of a skill set highly valued by employers around the globe. The course will go fastest for those with basic command line interface experience and some previous exposure to both SQL and R. Gain experience combining SQL and R for data analytics and visualization purposes Learn to write SQL queries that can retrieve and summarize data stored in databases Explore the statistical analysis and visualization capabilities of R See how R uses SQL to interact with databases Discover how to create graphics using R, based on data in databases Learn to use features of RStudio to streamline the analysis process Casimir Saternos has worked in IT since 1999 as a software architect, software engineer, systems engineer, developer, and database administrator. He's taught courses on Linux, R, and Oracle SQL; he holds multiple certifications (Statistical Inference, R Programming, etc.); he's written about SQL, R, and Java for Java Magazine, InfoQ.com, and others; and he's the author of the O'Reilly title "Client-Server Web Apps with JavaScript and Java".
Participant:
Presenter, Casimir Saternos.
Notes:
Online resource; Title from title screen (viewed November 18, 2016)
Title from resource description page (viewed December 20, 2016).
OCLC:
966617005

The Penn Libraries is committed to describing library materials using current, accurate, and responsible language. If you discover outdated or inaccurate language, please fill out this feedback form to report it and suggest alternative language.

Find

Home Release notes

My Account

Shelf Request an item Bookmarks Fines and fees Settings

Guides

Using the Find catalog Using Articles+ Using your account