Microsoft SQL Server 2017: Linux, Docker and macOS Hands-On

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.

• Installing, upgrading, and uninstalling SQL Server on Linux
• Connecting to SQL Server on Linux
• Issuing T-SQL commands
• Installing Docker on Windows and macOS
• Connecting to SQL Server from inside and outside a container
• Sharing data across containers
• Installing SQL tools on macOS
• Connecting to SQL Server on macOS
• Using SQL Operations Studio
• Backing up a database in Operations Studio

--- **Overall Course Rating:** 4.45/5 ### **Course Review Summary** The course has received positive feedback from recent reviewers, with a consensus that it provides valuable content for those looking to understand and work with Microsoft SQL Server 2017 on Linux platforms. The reviews highlight the clarity of instruction, the practical hands-on approach, and the inclusion of new features in SQL 2017. #### **Pros:** - **Instructive Clarity:** The instructor explained concepts with examples, making the learning process clear and effective, especially for beginners. - **Coverage of Fundamentals to Advanced Topics:** The course successfully covered basic to advanced aspects of installing and configuring SQL Server on Linux, including client connectivity, which was described as "very useful." - **Hands-On Learning:** Reviewers appreciated the practical hands-on component, with one learner successfully setting up SQL Server 2017 in a Docker container on their laptop. - **Engaging Lecture Delivery:** The instructor's engaging and concise lecture style was commended, making learning efficient and enjoyable. - **Coverage of New Features:** The course included up-to-date information on SQL 2017, highlighting the new features and cross-platform capabilities. - **Step-by-Step Approach:** Some learners found the step-by-step guidance helpful for tasks such as installing SQL Server on Ubuntu and managing SQL instances through the command line interface (CLI), particularly within the Docker setup. - **Real-World Application:** The course content was deemed valuable, with practical implications that could be applied in real-world scenarios. #### **Cons:** - **Assumed Knowledge Level:** Some beginners found themselves struggling with certain aspects, such as understanding SQL Server Management Studio (SSMS), which they expected to be introduced more gradually. - **Pacing and Detail for Beginners:** A few reviewers suggested that the pace and level of detail were not always suitable for complete beginners, though this may be mitigated by prerequisite learning or introductory content preceding these sections. ### **Course Content Breakdown:** - **Installation and Configuration:** Reviewers appreciated the detailed instructions on how to install and configure SQL Server 2017 on various Linux distributions, including within Docker containers. - **Advanced Features:** The course effectively covered new features and improvements in SQL 2017, providing a solid understanding of advancements in SQL server technology. - **Cross-Platform Capabilities:** The course highlighted the importance and utility of SQL Server's cross-platform functionality. ### **Learner Experience:** - **Engagement and Satisfaction:** Overall, learners expressed satisfaction with the course and found it engaging, particularly due to the instructor's delivery style and the course content's practicality. - **Learning Outcomes:** Many learners reported achieving their learning objectives and gaining valuable skills applicable to their professional development in working with MS SQL on Linux platforms. ### **Conclusion:** Based on recent reviews, this course is highly recommended for individuals looking to learn or improve their understanding of Microsoft SQL Server 2017, especially as it relates to running SQL Server on a Linux platform. The course's strong points in instructional clarity and hands-on learning make it a valuable resource for both beginners and those with some prior experience. Potential students should note that while the course is comprehensive, there may be sections more suited to learners who already have some familiarity with SQL Server management and Linux environments.