If you’re working with Oracle SQL and need to load CSV data into one of your tables, using Oracle SQL Developer makes this process a breeze. Continue reading to see a simple example and learn how…
(more…)data
How to Use SQL in SEO
If you talk to any search engine optimization specialist, they’ll surely tell you how many tools are used throughout their workday – from keyword research and backlinking to crawling and metric analysis tools. SEO is a world of its own with countless facets of information that need tweaking and examination constantly. It can quickly become overwhelming if you don’t have the right tools at your disposal. Or if you simply don’t understand how to make your job easier with SQL.
(more…)PHP strtoupper() and strtolower() string functions
Manipulating text or string data is such a common task that most all programming languages provide built-in functions for this specific purpose. PHP is no different in that regard. The language comes chock-full of different string manipulating functions. If you need string data in all capitalized or upper-cased letters, you can use strtoupper(). What about all lower-case strings? The strtolower() function takes of that. In this post, we visit some rudimentary examples and gain a feel for how these 2 functions operate.
CSV resource for SQL and Data professionals
Most any data professional deals with CSV data at some point in their work-flow. Let’s face it, CSV’s are everywhere and are one of the more common data interchange formats. A common task SQL professionals have is loading CSV data into a database table. Or on the converse, extracting SQL data into a CSV file. I have written several posts about CSV’s with MySQL, PostgreSQL, and the Python pandas library, and still to this day, refer to many of those posts for help when working with CSV’s. This compilation post is for SQL and data professionals who would find value in this type of resource as well.
[Keep reading for more SQL database and PHP/Python-centric content >>>]Import CSV file with MySQL Workbench
CSV imports with MySQL Workbench, is super simple. Since CSV’s are probably the most common data interchange format, it goes without saying that importing CSV data into MySQL is a staple task for all DBA’s and Developers. Continue reading to learn how easy it is using MySQL Workbench…
[Keep reading for more SQL database and PHP/Python-centric content >>>]