Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.
Databases with Frameworks1: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.
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,
many aren't required to write a single line of SQL code in their day-to-day jobs.
This is because they use special software libraries called ORMs,
which are used in most common programming languages.
ORM stands for Object-Relational Mapping.
It's a way for developers to use another programming language other
than SQL to interface with a database and perform CRUD operations.
ORMs handle transactions for developers.
This helps developers build robust applications.
An ORM still uses SQL under the hood.
The developer is only exposed to one programming language,
generally the languages that they're building the application in.
Some examples of ORMs include Hibernate for Java, CoreData for
Objective-C and Swift, Django ORM for Python, and ActiveRecord for Ruby.
Check the teacher's notes for the documentation sites for
all of these ORMs for examples.
In this course, you've learned all CRUD operations, creating, reading, updating,
and deleting rows.
This part of SQL is called DML or data manipulation language.
There's a lot more to SQL, but this is where you'll spend most of your time.
The other parts of SQL handle database design and maintenance.
Our time has come to an end.
So keep practicing your SQL skills and
I'm sure I'll see you again on your learning journey.
You need to sign up for Treehouse in order to download course files.Sign up