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, 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