From the course: Scala Essential Training for Data Science
Join today to access over 23,200 courses taught by industry experts.
Summary of SQL in Scala - Scala Tutorial
From the course: Scala Essential Training for Data Science
Summary of SQL in Scala
- [Instructor] So to summarize our work with SQL and JDBC, some things I'd like to point out is that first of all, it requires the installation of a JDBC driver, so we have to have Java installed, but we also have to install a specific JDBC driver for the particular kind of database that you're working with. So if you're using MySQL, that would be one driver. If using Postgres, that would be another, and so on. Another thing to keep in mind is that when we work with queries they return a structure called a cursor, so you have to move through those using the next operator, and SQL statements can be constructed as string and executed but prepared statements are more efficient if we're repeatedly using those statements.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.