Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

Preview

Start a free Courses trial
to watch this video

Sign up for Treehouse

Databases with Frameworks

1:33 with Andrew Chalkley

Many developers, while using databases, aren't required to write a single line of SQL code. They use special software libraries called ORMs.

Definitions

ORM - Object-Relational Mapping – used to perform CRUD operations with a language other than SQL.
DML - Data Manipulation Language - the subset of the SQL programming language that deals with CRUD operations.

Examples of ORMs

Whilst many developers use databases to store their data, 0:00
many aren't required to write a single line of SQL code in their day-to-day jobs. 0:03
This is because they use special software libraries called ORMs, 0:08
which are used in most common programming languages. 0:13
ORM stands for Object-Relational Mapping. 0:17
It's a way for developers to use another programming language other 0:20
than SQL to interface with a database and perform CRUD operations. 0:24
ORMs handle transactions for developers. 0:31
This helps developers build robust applications. 0:34
An ORM still uses SQL under the hood. 0:38
The developer is only exposed to one programming language, 0:40
generally the languages that they're building the application in. 0:44
Some examples of ORMs include Hibernate for Java, CoreData for 0:49
Objective-C and Swift, Django ORM for Python, and ActiveRecord for Ruby. 0:54
Check the teacher's notes for the documentation sites for 1:01
all of these ORMs for examples. 1:04
In this course, you've learned all CRUD operations, creating, reading, updating, 1:07
and deleting rows. 1:12
This part of SQL is called DML or data manipulation language. 1:13
There's a lot more to SQL, but this is where you'll spend most of your time. 1:18
The other parts of SQL handle database design and maintenance. 1:22
Our time has come to an end. 1:26
So keep practicing your SQL skills and 1:28
I'm sure I'll see you again on your learning journey. 1:30

You need to sign up for Treehouse in order to download course files.

Sign up