Learn how to load data into a PostgreSQL database.
[Instructor] We've installed the PostgreSQL software.…So now let's set it up by creating a database…and a user, and loading some data into it.…Now Postgres provides a couple of handy commands.…One is called createdb,…and I'll give it a name scala_db.…This will create a database called scala_db.…Now I also create a user…and I'll give that user the same name, scala_db.…Now what I'd like to do is create some tables…and load some data into those tables.…
Now I've created a script called emps.sql.…If you have access to the exercise files…you can download emps.sql and follow along.…And what I'm going to do is issue a command…using Psql, a command line for working with Postgres.…And I'm going to indicate that I want to log in…as a user scala_db,…and I want to use the database scala_db.…And now I want to execute a script…and to do that we pass in the dash a,…dash f options, and then we specify our file.…
Now I have emps.sql in my download directory,…so I'll just specify…the path to that location.…And the command executes.…
Dan also focuses on using Scala with Spark, a distributed processing platform. He first describes how to work with Resilient Distributed Datasets (RDDs)—a fundamental Spark data structure—and then explains how to use Scala with Spark DataFrames, a new class of data structure specially designed for analytic processing. He wraps up the course by providing a summary of advantages of using Scala for data science.
- The advantages of Scala for data science
- Scala data types
- Scala arrays, vectors, and ranges
- Parallel processing in Scala
- Mapping functions over parallel collections
- When and when not to use parallel collections
- Using SQL in Scala
- Scala and Spark RDDs
- Scala and Spark DataFrames
- Creating DataFrames
Skill Level Intermediate
Java for Data Scientists Essential Trainingwith Charles Kelly2h 43m Intermediate
1. Introduction to Scala
2. Parallel Processing in Scala
3. Using SQL in Scala
4. Scala and Spark RDDs
5. Scala and Spark DataFrames
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.