Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.

Preview

Start a free Basic 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

  • 0:00

    Whilst many developers use databases to store their data,

  • 0:03

    many aren't required to write a single line of SQL code in their day-to-day jobs.

  • 0:08

    This is because they use special software libraries called ORMs,

  • 0:13

    which are used in most common programming languages.

  • 0:17

    ORM stands for Object-Relational Mapping.

  • 0:20

    It's a way for developers to use another programming language other

  • 0:24

    than SQL to interface with a database and perform CRUD operations.

  • 0:31

    ORMs handle transactions for developers.

  • 0:34

    This helps developers build robust applications.

  • 0:38

    An ORM still uses SQL under the hood.

  • 0:40

    The developer is only exposed to one programming language,

  • 0:44

    generally the languages that they're building the application in.

  • 0:49

    Some examples of ORMs include Hibernate for Java, CoreData for

  • 0:54

    Objective-C and Swift, Django ORM for Python, and ActiveRecord for Ruby.

  • 1:01

    Check the teacher's notes for the documentation sites for

  • 1:04

    all of these ORMs for examples.

  • 1:07

    In this course, you've learned all CRUD operations, creating, reading, updating,

  • 1:12

    and deleting rows.

  • 1:13

    This part of SQL is called DML or data manipulation language.

  • 1:18

    There's a lot more to SQL, but this is where you'll spend most of your time.

  • 1:22

    The other parts of SQL handle database design and maintenance.

  • 1:26

    Our time has come to an end.

  • 1:28

    So keep practicing your SQL skills and

  • 1:30

    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