MS SQL Server Training Video Review

We are posting one of the video reviews of our students on MS SQL Server DBA Training in DBA University.  For more videos about DBA University faculty and students, please visit http://video.dbauniversity.com

Computer Science Faculty Jobs DBA University

Introduction

 

We are looking for IT professionals in the USA who have a strong passion for teaching and motivating students with at least 4 years of professional work experience. DBA University is well positioned for fast growth in USA.

Qualifications

• Weekly 10 hour commitment. (Weekends or Weekday evenings)
• Must be a resident in USA or Canada. 
• We have faculty positions open in Microsoft .NET, Sharepoint, Java, Software Testing Tools (Manual, Automation), Oracle E-Business Suite, Big Data,  TIBCO and Oracle OBIEE etc.
• Good opportunity to get experience in innovative e-learning technologies and advanced higher education technology systems. Minimum of 4 years of strong professional work experience the related field

Benefits

• Competitive Pay 
• Long term positions. 
• Good opportunity to get experience in innovative e-learning technologies and advanced higher education technology systems.

Contact Us

Please send us a brief cover letter and resume to info@DBAuniversity.com

Oracle RAC Training

Oracle RAC, ASM and Data Guard Training

We have some exciting news for you. Michelle Malcher will be conducting the Oracle RAC, ASM and Data Guard course. This course will now be offered in the latest Oracle 12c database release from Mar 15th 2014.  Michelle is a well experience Oracle Database Administrator. She is a well known author of several Oracle Press books. Also, she is an Oracle ACE Director (only a few in the world are recognized as ACE Director by Oracle Corporation) and a noted contributor to Oracle Magazine.

Click here to watch Michelle's video about this course.

Course Highlights

1) About 40 hours course  for 5 weeks.

2) Training will contain Oracle RAC, ASM and Data Guard topics in Oracle 12c version.

3) Evenings - Sun, Mon, Tue and Thu  - 7 pm Central Time to 9 pm Central Time

4) DBA University's e-Book will be provided.

5) Click here for a FREE DEMO session  (Name and Email only)

6) Click here to register for the online training course

Lab work

1) For majority of the topics, each student will get a remote lab computer to practice the course work.  

2) The training will be on Oracle Linux 64 bit as the operating system.

3) 10 hours Remote LAB access on Saturday, Sunday

4) 5 hours Remote LAB access on weekdays

Links and Resources

1) Click here to download Oracle RAC, ASM and Data Guard course brochure

2) Click here for a FREE DEMO session  (Name and Email only)

3) Click here to register for the online training course

How to print line numbers in PL/SQL

Introduction

Any one who wants to be a good programmer must also acquire good debugging skills. Oracle PL/SQL database programming offers several easy code debugging options through the DBMS_UTILITY package. This article provides some naunces about printing line numbers in PL/SQL code.

DBMS_UTILITY.FORMAT_ERROR_BACKTRACE

One can print the exact line number that caused the PL/SQL error by using the supplied DBMS_FORMAT.FORMAT_ERROR_BACKTRACE procedure.  It can be called directly in the dbms_output.put_line procedure.  An example is shown below. 

How to print line numbers in SQL*Developer

Many Oracle developers use Oracle SQL*Developer IDE (Integrated Development Environment) for working on SQL and PL/SQL code. One can let SQL*Developer display the line numbers by using the  TOOLS => Preferences => Code Editor => Line Gutter option

PL/SQL anonymous blocks are always counted from the DECLARE section

One common mistake that PL/SQL programmers do is to assume that the line number shown by the DBMS_FORMAT.FORMAT_ERROR_BACKTRACE is counted from the first line of the code. In the above example, the 1st line number is for the line that contains "set serveroutput on". The PL/SQL code starts only from DECLARE section (line 2). So for the PL/SQL compiler, line 1 is what shown as line 2 in the above screenshot. 

The error occurred in PL/SQL code line 7 v_name := 'DBA UNIVERSITY'; (which is line 8 for SQL*Developer). So when debugging anonymous PL/SQL code, one should always count the 1st line from the line that contains DECLARE.

Conclusion

Hope this helps !  We are always looking for your participation in this blog. Please feel free to provide more tips by commenting below to help other readers.

BEST JOBS in America - Database Administrator

CNNMoney.com has released the BEST JOBS in AMERICA report for 2013 today. Database Administrator (DBA) is now the 14th best job in america with a 30% job growth forecast until 2023. 

Here is the LINK for more information. Another interesting statistic in this report that among all the IT/computer best jobs in this list, Database Administrator job has the highest job growth forecast for the next 10 years until 2023

This is the 5th time in a row that Database Administrator has been among the best jobs in America by CNN.com 

Are you interested in becoming a database administrator ? DBA University can help you. We are an Oracle Education Partner and we are offering online training courses in Oracle Database Administration training and Microsoft SQL Server Database  Administration training with affordable cost.   If you are interested, you can register online  for a FREE DEMO session or sign up for one of our upcoming training courses.

Registration - http://www.dbauniversity.com/

Student Video Reviews - http://video.dbauniversity.com/reviews/

Oracle 12c DBA Training

Oracle 12c DBA Training

We want to give some new updates about DBA University's Oracle DBA Training course.  This course will now be offered in the latest Oracle 12c database release from Jan 18th 2014.  

Course Highlights

1) About 60 hours course  for 8 weekends.

2) Training will contain topics from both Oracle 11g and the latest Oracle 12c database version. 

3) Students Video Reviews -  Click Here to watch Oracle DBA Training reviews.

3) Weekends: Saturday, Sunday - 8 am Central Time to 12:30 pm Central Time (with a 30 min break)

4) DBA University Oracle DBA Tutorial will be provided.

5) Click here for a FREE DEMO session  (Name and Email only)

6) Click here to register for the online training course

Lab work

1) Each student will get a remote lab computer to practice the course work.  

2) The training will be on both Oracle 11g and Oracle 12c version with Oracle Linux 64 bit as the operating system.

3) 16 hours Remote LAB access on Saturday, Sunday

4) 5 hours Remote LAB access on weekdays

Links and Resources

1) Click here to download Oracle DBA course brochure

2) Click here for a FREE DEMO session  (Name and Email only)

3) Click here to register for the online training course

vnc server in Oracle Enterprise Linux 6.4

Introduction

 

In Oracle Enterprise Linux 6.4 (OEL 6.4) 64-bit edition , the installation of vnc server package (RPM) is not very straight forward. In the blog post, we will explain about all the RPMs required for setup of vncserver utility in OEL 6.4

 

The vnc and vnc-server RPMs are not enough

 

1) Login as root

2) yum install vnc (installs tigervnc RPM)

3) yum install vnc-server (installs tigervnc-server-module RPM)

4) vncserver   (Attempt to start vncserver service. But you will receive  vncserver: command not found error message)

 

The vnc and vnc-server RPMs alone are not sufficient.  You must also install tigervnc-server RPM explicity (the 3rd vnc server related RPM)

 

5) yum install tigervnc-server (This is the RPM that installs the vncserver utility in the path)

 

Conclusion

 

The yum utility seems to favor tigervnc  software by default as it automatically downloads and installs tigervnc.  As seen above, the number of RPMs needed for setting vncserver is not straightforward and you have to install the three RPMs above in that order.