Just another CUNY Academic Commons site
There is no native installation for macOS, but there are instructions how to install the Linux port using a Docker container. https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-ver15&pivots=cs1-bash More information: Installing SQL Server Express in macOS Installing SQL Server Express in macOS #2
Download the instructions. Follow these steps with admin privileges.
This is an alternative to the previous post — Installing SQL Server Express in macOS. INSTRUCTIONS: Open or sign in to your Docker ID (https://id.docker.com/login/). Install Docker Toolbox (https://docs.docker.com/toolbox/toolbox_install_mac/). Install Kitematic (https://kitematic.com/). Read the documentation (https://docs.docker.com/kitematic/userguide/). Download and run the SQL Server image from the Docker Hub using Kitematic (https://hub.docker.com/_/microsoft-mssql-server).
Instructions: Open `Terminal`. Application/Utilities/Terminal.app Install the Homebrew package manager system. /usr/bin/ruby -e “$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)” Test Homebrew installation. brew doctor Install Docker using Homebrew. brew install docker Run Docker and download the latest package of SQL Server. sudo docker pull mcr.microsoft.com/mssql/server:2017-latest Accept the EULA (End-User Licensing Agreement) and enter a `sa` (system administrator) password (position […]
Although these instructions refer to the 2016 version, the instructions are similar for previous versions. You can also also query YouTube.
The quote below is neither an endorsement nor an advert. SQL is a language that enables storing, retrieving, and manipulating data in databases… SQL has a lot of career options in the business domain as well as in the data science sector. When data is of interest in the gap analysis, SQL can be used […]
As a quick review, SQL is the language to interact with a relational database. to request data (SELECT) from database objects (databases, schemas, tables and views) to create (CREATE) where to store data, database objects (databases, schemas, tables including columns, etc.) to modify (ALTER) database objects to delete (DROP) database objects, automatic COMMIT in SQL Server […]
Let me welcome to the world of SQL. There is no time to waste. It is time to get your hands wet. Download the class notes for day 1.
We have started working with the WHERE clause and its operators. Download the notes for day 4.
We have started having fun with built-in functions (set of instructions) for numeric values. SUM() — total value of row AVG() — average value of a row COUNT() — how many records ROUND() — rounding a number to a specific decimal point (decimal, float, double, money…) CEILING() — rounding up to the closest whole number value (integer) […]
