Databases

An Introduction to Oracle SQL Developer – Part V

by File in: Databases

Welcome to the final installment of the Oracle SQL Developer series. In this post, we will discuss how to connect Oracle’s SQL Developer with Non-Oracle databases. Oracle’s SQL Developer application is a very powerful GUI interface for working with Oracle databases or as in the case with this post, just about any brand of database. […]

An Introduction to Oracle SQL Developer – Part IV

by File in: Databases

Welcome back to our series introducing you to Oracle’s SQL Developer application. Check out Part I, Part II and Part III. In this post we are going to cover how to backup your data using SQL Developer. It’s a simple process involving a couple of clicks, menu choices and small amounts of typing. Backing up […]

An Introduction to Oracle SQL Developer – Part III

by File in: Databases

Welcome to the next installment of this Oracle SQL Developer series. You can check out Part I and Part II here. In this post, we will cover the creation of a database function using Oracle’s free SQL Developer application. Oracle’s SQL Developer application is a very powerful GUI interface for working with Oracle databases. SQL […]

An Introduction to Oracle SQL Developer – Part II

by File in: Databases

Welcome to part two of this several part series regarding Oracle’s SQL Developer application. SQL Developer is a wonderful GUI application that lets us non-Database Administrators (DBA’s) interact with Oracle databases. SQL Developer turns the intimidating command line DBA tasks into simple point and click actions. For those of you that are familiar with MySQL […]

An Introduction to Oracle SQL Developer – Part I

by File in: Databases

Although you might not be a Database Administrator (DBA), sometimes in the IT industry we have to perform tasks that really aren’t part of our training or job description. If you ever end up working with Oracle tables and would like to use a GUI to make your life easier, this series is for you. […]

Creating MySQL Stored Routines for Non-DBAs – Part Three

by File in: Databases

In part one of this three part series we covered how to create a stored function. In part two of this series we covered how to create a stored procedure. In this final part of the series, we are going to show you how to tie it all together, how to take it to the […]

Creating MySQL Stored Procedures for Non-DBAs – Part Two

by File in: Databases

In part one of this three part series, we went over the steps necessary to create a stored function in MySQL. In part two of this series we are going to introduce you to stored procedures. A stored procedure is different from a stored function in that a stored procedure has no return value but […]

Creating MySQL Stored Routines for Non-DBAs – Part One

by File in: Databases

Stored routines are fairly new to MySQL, but they have been available in other databases for some time.  A stored routine has the following advantages: Speed!  Stored routines use MySQL server caching technology. Speed!  Repetitive tasks can be handled at the database level therefore reducing the amount of “back and forth” network traffic. Speed!  Stored […]