4.14 (54 reviews)
☑ To learning basic of Linux,how to install Linux,SQL Server 2017,Docker,Administration tools and many more
As we know SQL Server has traditionally run only on Windows. SQL 2017 is the ability to install server instances and work with databases on Linux and in Docker containers, which opens the possibility of running SQL Server on macOS. With the extension tools now available as native Linux and macOS applications, users can take advantage of on the variety of options available for running a database instance. This course shows how to install SQL Server on new platforms, and how to connect to it from a newly various environments and also shows how to use SQL Operations Studio to perform routine SQL Server maintenance tasks, such as backups, from Windows, macOS, and Linux.
These are topics covered in this course.
Working in Linux
Linux prerequisites for SQL Server
How to install Ubuntu
Install SQL Server on Ubuntu
Installing SQL Server on Ubuntu
Upgrading SQL Server 2017
Uninstalling SQL Server 2017
How to Stop and restart the SQL server 2017
Connect to SQL Server 2017 on Linux
Run sqlcmd in a Linux terminal
Issue T-SQL commands
Install additional services
Connect using SSMS on Windows
Get Started with Docker
Docker prerequisites for SQL Server
How to Install Docker on Windows
How to Install Docker on macOS
How to Pull the SQL Server image
Connect to SQL Server within a container
Connect from outside the container
Work in a Docker Container
Change the SA account password
Run multiple instances of SQL Server 2017
Sharing data across containers
Perform an external backup
Microsoft SQL Tools on macOS
Understand macOS integration
tap and brew mssql-tools
Connect to a SQL Server instance
Extract data with bcp
MS SQL Operations Center
What is Microsoft Operations Studio?
Get started with Operations Studio
Write T-SQL commands
Back up a database
I was able to follow the lectures from how to download mssql on mac using the terminal but i got lost when the lecturer was talking about sql server management studio.I am a beginner and i thought the lecturer would have taken his time to give us a step by step approach. But over all, i learned something.
Very new MS SQL 2017 running on Linux with hands-on it covers basic to advance how to install and configure SQL on Linux,Client connectivity very useful
Well,Done just sharing my experience to completed in this course i have learnt very new Microsoft SQL Server 2017 release on Linux using docker container and setup done on my laptop followed by instructor like Installing SQL Server on Ubuntu,stop/start SQL instance using CLI mode particular Docker setup and basic administration.
Instructor explained the concepts with examples very clearly including with new features of SQL 2017 amazing course i recommended Thanks so much Sir.
Instructor's lecture delivery is very engaging and straight to the point. Course has lots of useful and helpful information. I personally recommend this course. its valuable.
It is good to have the basic about the SQL Server 2017 cross the platform that how it works. Nice to see all these advance improvement.
really enjoying this course - bite size chunks presented in a clear and understandable and is good for who learn MS SQL on Linux platform