Resources
Information is power, so keeping in touch with related papers and documents is a must for all IT professionals. Here are some very useful resources that we use:
Oracle Architecture Diagrams:
- Oracle Architecture by BiTech @ VistaPrint
- Oracle Architecture @ Spotlight by Cho @ VistaPrint
- Oracle Flexible Architecture – OFA (Red outline) by cho @ Vistaprint
- Oracle Flexible Architecture – OFA (Black outline) by cho @ Vistaprint
- Oracle Components in Blocks by Cho @ VistaPrint
Oracle Links:
- Oracle Database Homepage
- Oracle Database Downloads
- Oracle Database Documentation
- Oracle Database Discussions
- Oracle Database Cloud Service
- Database App Developer Newsletter
- Database Learning Library
- Books for Database Admins and Developers
- Oracle
Sql Developer
Oracle Blogs
- Oracle Blog
- Oracle Developers | Youtube
- The ORACLE-BASE Blog
- Oakie Blog
- Reddit – Oracle
- Google News – Oracle Database
- AskTom
- Oracle | Youtube
- Oracle Learning Library | Youtube
- ThatJeffSmith
- Rittman Mead
- ORACLE-HELP – Oracle DBA and Cloud Articles
- Ashish Awasthi’s Blog (Jdev/ADF)
- MacLochlainns Weblog
- K21 Academy – Oracle Trainings Blog
- Oracle Scratchpad – Jonathan Lewis
- Kamran Agayev’s Oracle Blog
- Pete Finnigan’s Oracle security weblog
- Oracle Applications Users Group
- Helios’s Blog (E-Business Suite, Database General, Database Installation, Database Upgrade, Linux .. etc) in OTN Discussion Forum.
- DBA Genesis
- PeopleSoft Oracle | Youtube
- Laurent Schneider – Oracle Certified Master
- OracleBase
- See more blogs at Shttps://blog.feedspot.com/oracle_blogs/
Essential software for your class laptop:
- chrome
- Firefox
- 7zip
- Dropbox
- OneDrive
- Evernote
- Foxit Reader
- TeamViewer
- RealVNC
- FileZilla
- Notepad++
- WinSCP
- PuTTY
- WinDirStat
Contact
Address:
4920 Niagara Rd., Suite 418, College Park MD 20740
800 Olive Dr., Silver Spring, MD 20905
Email: admin@bitechinstitute.com
Business Hours: 8a-6:30p Mo. – Sa.
Recommended Books for SQL Server DBAs and Developers
Here’s my favorite list of SQL Server books for 2014-2016:
- T-SQL Fundamentals – (updated for SQL 2016) – don’t be fooled by this “fundamentals” title, because everybody who writes T-SQL queries needs this book. It’s the manual we should have been given when we started, and everyone’s going to learn something about concurrency, performance, and updates here.
- T-SQL Querying – (updated for SQL 2016) – if you need to make queries go faster, this is the book.
- SQL Server Performance Tuning – (updated for 2014) – if you need to make servers go faster, this is the book. The title says query tuning, but it’s actually more server-oriented than the above book. It’s good even if you can’t tune the T-SQL queries.
- Securing SQL Server – I know, security sounds like a boring topic, but Denny brings it to life.
- Time Management for System Administrators – As a knowledge worker, you’re never going to catch up. You’re always going to feel behind. Tom teaches you how to manage a deluge of requests in a way that works – I’ve used these approaches for over a decade.
Timely Support
Innovative Ideas
Advanced Technology
Clear Communication
Recent Blog Posts
Learn from the top thought leaders in the industry.
How to Move a Datafile from Filesystem to ASM Using ASMCMD CP Command
Question : A datafile was wrongly added on file system instead of ASM diskgroup. How can you move it to the ASM disk group? As root: [root@L160 ~]# mkdir -p /u02/oradata/PDEV chown -R oracle:oinstall /u02/oradata As oracle: sqlplus system/sys@PDEV drop tablespace...
Annotation example
This is an example of annotation, hover the highlighted "annotation" word to see it in action!If you find the plugin useful, I would love to get a review or rating: https://wordpress.org/support/view/plugin-reviews/tinymce-annotateAlso, any donation would also be...
How To Drop Database In Oracle 11 using SQLPLUS i.e. without Using DBCA
To blow away one of your newly created databases, instead of using the DBCA, try it manually in sqlplus. Requirements database must be closed, exclusively mounted, restricted 1- Start The database sqlplus / as sysdba SQL> startup ORACLE instance started. Total...