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
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
- Hibernate for Java
- CoreData for Objective-C or Swift
- Django ORM for Python
- ActiveRecord for Ruby
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