Author
Bob Bryla
Released
3/30/2017- Design methodology and tools
- SQL query basics
- Advanced data manipulation
- Modifying and creating a database object
- Database architecture
- DBA configuration tools
- Managing tablespaces and disk space
- Table compression
- Manage system-related tablespaces
- Database monitoring
Skill Level Intermediate
Duration
Views
- [Bob] Hi, I'm Bob Bryla. I have been an Oracle DBA for over 30 years, and I started with Oracle version 6. We're going to cover quite a few things in this series, including database design, constructing useful SQL queries, creating tables, and performing a number of DBA-related activities, such as creating database objects, managing database disk space, monitoring database activity and performance, and much, much more.
-
Introduction
-
Welcome30s
-
-
1. Design Methodology and Tools
-
Logical database modeling5m 28s
-
Query and development tools7m 32s
-
2. SQL Query Basics
-
3. Advanced Data Manipulation
-
Sort and group data6m 10s
-
Single-row functions11m 37s
-
Aggregate (group) functions4m 17s
-
Using the set operators7m 38s
-
Join tables9m 5s
-
-
4. Modify and Create Database Object
-
5. Database Architecture
-
6. DBA Configuration Tools
-
Startup and shutdown4m 27s
-
Network naming methods4m 32s
-
-
7. Manage Tablespaces and Disk Space
-
8. Table Compression
-
9. Manage System-Related Tablespaces
-
Manage the UNDO tablespace2m 52s
-
Manage REDO logs5m 9s
-
Manage TEMP tablespaces3m 10s
-
-
10. Database Monitoring
-
Alert log2m 30s
-
ADDM, ASH, AWR6m 33s
-
Monitor memory usage2m 10s
-
-
Conclusion
-
Next steps50s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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.
Share this video
Embed this video
Video: Welcome