From the course: Red Hat Enterprise Linux 8 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Perform simple SQL queries
From the course: Red Hat Enterprise Linux 8 Essential Training
Perform simple SQL queries
- [Instructor] Now that we have a working database with data in it, let's try some queries. But before we move on, let's verify our database is ready. Make sure you are logged into Maria DBS root, and that you're using the Linux dev database. Your prompts should reflect this. Now let's query all records in our database. Type in select space, asterisk, space from space developers, semi-colon. This will verify that everything is ready. Now let's do some more specific queries. Let's only show developers that are 50 years old. Bring your line back and add to the end, where, space age with a capital E, equals 50 semi-colon, and hit enter. This should show Alan Cox and Ted Tso. Now let's query for developers under 50. Bring your line back, change age equals 50 to age, space less than, space 50, and hit enter. This should only show Linus Torvalds. We can show a specific records as well by being more precise. Bring your line…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
Database services introduction44s
-
(Locked)
Install and configure MariaDB2m 3s
-
(Locked)
Manage SELinux for database services2m 58s
-
(Locked)
Perform logical database backups4m 5s
-
(Locked)
Create a database with tables4m 37s
-
(Locked)
Restore logical database backups2m 17s
-
(Locked)
Perform simple SQL queries3m 1s
-
(Locked)
Perform logical database backups4m 5s
-
(Locked)
Restore logical database backups2m 17s
-
(Locked)
Recover the MariaDB root password2m 47s
-
(Locked)
Set the root database password2m 8s
-
-
-
-
-
-
-
-