Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
General Discussions
Switcher Hangout (Windows to Mac)
Doing SQL on the Mac
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Thud" data-source="post: 89889"><p>MySQL isn't the best for learning SQL beyond basic queries, since it doesn't fully implement the SQL spec in the current release version.</p><p></p><p></p><p>Oracle would be nice, more of a pain to install and configure though. Not sure how easily it installs on a mac, but on solaris I had to make changes to /dev/proc and tweak the memory settings or Oracle would not even load.</p><p></p><p></p><p>As far as medium-duty databases go, MS SQL is actually one of my favorites... never had problem with an MS SQL server, and setting up data links between them is easy. </p><p>We've had Oracle crap out a TON of times at work, including some issues that even Oracle consultants couldn't figure out.</p><p></p><p>Also keep in mind that Oracle didn't even support the "INNER JOIN" syntax until version 9 I believe, and there may be other differences between Oracle and MS SQL today, which may cause headaches in your assignments.</p><p>Doing outer joins in oracle is a different syntax than MS too.</p></blockquote><p></p>
[QUOTE="Thud, post: 89889"] MySQL isn't the best for learning SQL beyond basic queries, since it doesn't fully implement the SQL spec in the current release version. Oracle would be nice, more of a pain to install and configure though. Not sure how easily it installs on a mac, but on solaris I had to make changes to /dev/proc and tweak the memory settings or Oracle would not even load. As far as medium-duty databases go, MS SQL is actually one of my favorites... never had problem with an MS SQL server, and setting up data links between them is easy. We've had Oracle crap out a TON of times at work, including some issues that even Oracle consultants couldn't figure out. Also keep in mind that Oracle didn't even support the "INNER JOIN" syntax until version 9 I believe, and there may be other differences between Oracle and MS SQL today, which may cause headaches in your assignments. Doing outer joins in oracle is a different syntax than MS too. [/QUOTE]
Verification
Post reply
Forums
General Discussions
Switcher Hangout (Windows to Mac)
Doing SQL on the Mac
Top