We already created a database so that we could get our project started. Review the necessary steps to create a database and a user with access privileges for the database.
- [Josh] If we're going to use a databse…with our Rails application, then of course,…we need to have one created first.…If you've been following along with me,…then you already created your database…back in chapter two when we configured our project.…Let's do a quick review of the process.…There are four useful SQL commands that you should learn.…Show databases, which shows a list…of all the databases inside my SQL.…Create database, followed by the name…of the database we want to create.…Use, and then the name of the database we want to use.…That's especially useful for switching between databases.…
And then, drop database, with the name of the database…we want to drop or completely remove.…And that removes the database…and all tables associated with it.…Earlier we did create database…and we created two databases.…Simple CMS development and simple CMS test.…That created database containers, but there's no tables…on those databases yet.…It's a best practice not to connect to our database…as the root database user.…
- Creating and configuring a new Ruby on Rails project
- Generating controllers and views
- Handling server requests
- Using different types of routes
- Rendering and viewing templates
- Generating migrations and models
- Creating, updating, and deleting records
- Finding records with queries
- Understanding relationship types
- Writing controllers for CRUD
- Working with layouts and helpers
- Managing application assets
- Building forms
- Validating data
- Authenticating users
Skill Level Beginner
1. What Is Ruby on Rails?
2. Get Started
3. Controllers, Views, and Dynamic Content
4. Databases and Migrations
5. Models and ActiveRecord
7. CRUD, REST, and Resourceful Routes
8. Controllers and CRUD
9. Layouts, Partials, and View Helpers
12. Data Validation
13. Controller Features
14. User Authentication
15. Improve the Simple CMS
Next steps1m 44s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.