Currently, my access to SQL is limited to Microsoft SQL Server Management Studio on my client's desktop. I use SQL daily to create and run queries for proprietary software used by health insurance companies. Since I have access only through a client's proprietary software, I cannot use this access for my own purpose to create and sell my own SQL course.
I did some digging today to find a SQL application I can use on my Mac to create my course. I don't need anything fancy or complicated. After all, this will be a course for true beginners and people who only have a passing familiarity with SQL.
Most of the articles I found seem to suggest that SQLite is a good place to start. There is a site called SQlite.org that has a C source code file that needs to be installed using Terminal. No thanks. *Insert Ain't nobody got time for dat* meme My course is for beginners. Beginners don't open the terminal and type commands. They (and I) want to install an app like any other app.
Fortunately, I found something called DBeaver, which besides having a great name, is a free, open-source universal database tool that supports popular databases such as SQLite, MySQL, PostgreSQL, SQL Server, Access, Oracle, DB2, etc. Even better, there is a Mac OS X version, as well as a version for Windows and Linux.
I downloaded the DMG file and installed the application without an issue. There's even a sample database that gives me some ideas to create examples.
One step closer.
I did some digging today to find a SQL application I can use on my Mac to create my course. I don't need anything fancy or complicated. After all, this will be a course for true beginners and people who only have a passing familiarity with SQL.
Most of the articles I found seem to suggest that SQLite is a good place to start. There is a site called SQlite.org that has a C source code file that needs to be installed using Terminal. No thanks. *Insert Ain't nobody got time for dat* meme My course is for beginners. Beginners don't open the terminal and type commands. They (and I) want to install an app like any other app.
Fortunately, I found something called DBeaver, which besides having a great name, is a free, open-source universal database tool that supports popular databases such as SQLite, MySQL, PostgreSQL, SQL Server, Access, Oracle, DB2, etc. Even better, there is a Mac OS X version, as well as a version for Windows and Linux.
I downloaded the DMG file and installed the application without an issue. There's even a sample database that gives me some ideas to create examples.
One step closer.