Has anyone subscribed to Oracle's My SQL Learning ...
# suiteql
a
Has anyone subscribed to Oracle's My SQL Learning Subscription or taken another online course? Looking for something that starts at the introductory level. Would love any feedback/recommendations!
s
just follow @tdietrich blog, should give you all the SQL you need
s
W3schools has always been an excellent resource for base learning - https://www.w3schools.com/sql/default.asp
z
Keep in mind that there are different variations of SQL. While it's true that Oracle owns MySQL, MySQL is a substantially different system in terms of its capabilities and SQL language implementation. MySQL's "dialect" is actually not the same as traditional Oracle SQL. I bring this up, because the SQL that appears in contexts like SuiteQL and Saved Search formula expressions is a subset of Oracle SQL--that is, the SQL of NetSuite's backend database. Why this matters: functions in Saved Search formulas, SuiteQL expressions, etc. frequently have names and characteristics that are specific to Oracle SQL. Let's say you want the function that gives you an alternate value if the first one happens to be null. In Oracle SQL, that function is NVL. In MySQL, it's IFNULL. In PostgreSQL, it's COASLESCE. In Microsoft SQL Server (T-SQL), it's ISNULL. NetSuite implements NVL, because under the hood that's the one that comes with the Oracle database. In addition to different names for more-or-less the same function, similarly named functions treating the same functional area may bear crucially different implementation details (regex functions come to mind). Finally, every database has a number of functions that are turn out to be unique—no counterpart in other SQL versions. It comes down to this: if you want to be as effective as possible in SuiteQL and other NetSuite contexts, make sure you are learning Oracle SQL specifically! 😄 P.S. SuiteAnalytics Connect is an exception to the "NetSuite uses Oracle SQL" rule. While a few Oracle-specific features can be identified (e.g., NVL), by and large the ODBC and JDBC drivers both implement what amounts to aa fairly constrained subset of the SQL-92 standard.
🙌🏻 1
🙌 1