Why Learn Local SQL?
The simple answer is that Local SQL provides users and developers with yet another tool that can be used in data analysis and software development. There are times when youll find that Local SQL provides a simpler and/or faster solution to a given problem than QBE or ObjectPAL. Additionally, SQL can be used to do things that QBE cannot, like creating and restructuring tables. Also, there are several functions that can be used in SQL queries that are not available within QBE queries, such as SUBSTRING, which extracts a portion of a string, or EXTRACT, which extracts the day, month, or year from a date. Last (but not least), SQL has become the lingua franca of databases. Knowledge of Local SQL can be directly applied to working with the SQL dialect of just about any other RDBMS available. How Do I Learn Local SQL? The easiest approach is to first familiarize yourself with the basic syntax and rules of SQL, then apply that knowledge and begin writing SQL queries. If you have existing proc
