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

Modifying Data with SQL

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

Related Discussions

Have questions about this video? Start a discussion with the community and Treehouse staff.

Sign up

    Related Discussions

    Have questions about this video? Start a discussion with the community and Treehouse staff.

    Sign up

    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

      You need to sign up for Treehouse in order to set up Workspace

      Sign up