OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Pluralsight logo

Microsoft SQL Server on Linux in Azure

Landon Fowler

Microsoft SQL Server is a robust relational database management system with a number of intriguing features. Starting with SQL Server 2017, it is now available on many operating systems, including Linux! In this course, we go over how to install, configure, and manage SQL Server on Linux. We highlight some of the key benefits that Azure brings to the table for our SQL Server strategy. Whether you're an experienced SQL Server professional coming from a Windows background or a Linux guru getting into MSSQL for the first time, this course has something to offer.

Enroll now

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Examines a relational database management system with intriguing features
Highlights benefits Azure brings to SQL Server strategy
Taught by Landon Fowler
Meant for experienced SQL Server users coming from a Windows background
Meant for Linux gurus getting into MS SQL for the first time

Save this course

Save Microsoft SQL Server on Linux in Azure to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Microsoft SQL Server on Linux in Azure with these activities:
Re-familiarize yourself with SQL syntax and commands
Refresh your memory on SQL syntax and commands to ensure you have a strong base before delving into more advanced concepts covered in this course.
Browse courses on SQL Syntax
Show steps
  • Review SQL documentation or tutorials to refresh your knowledge of syntax and commands.
  • Try out simple SQL queries to practice and reinforce your understanding.
Review relational database concepts
Review essential concepts of relational databases such as tables, keys, relationships, and normalization to strengthen your foundational understanding for this course.
Browse courses on Relational Databases
Show steps
  • Revisit materials on data modeling, normalization, and SQL basics.
  • Work through practice exercises to reinforce your grasp of relational database fundamentals.
Review relational database management systems
Review the primary concepts of relational database management systems to strengthen the foundation for this course.
Browse courses on Relational Database Management Systems
Show steps
  • Read notes or textbooks on relational database management systems.
  • Take practice quizzes or review old exams on the topic.
15 other activities
Expand to see all activities and additional details
Show all 18 activities
Review fundamentals of SQL Server
Help refresh your memory on the basic concepts of SQL Server, such as data types, tables, and queries, to prepare for this course.
Browse courses on Database Management Systems
Show steps
  • Review online documentation or tutorials on SQL Server basics.
  • Complete practice exercises or quizzes on SQL Server fundamentals.
Compile a Glossary of SQL Server Terms and Concepts
Improve your understanding of SQL Server by creating a comprehensive glossary of key terms and concepts.
Browse courses on Terminology
Show steps
  • Gather a list of SQL Server terms and concepts from online resources, documentation, and class materials.
  • Define each term and concept clearly and concisely.
  • Organize the terms and concepts alphabetically or by category.
  • Review and update your glossary regularly.
Follow tutorials on SQL Server installation
Provide hands-on experience in installing SQL Server on Linux, which is a key skill covered in this course.
Show steps
  • Find tutorials or documentation on installing SQL Server on Linux.
  • Follow the steps in the tutorial to install SQL Server.
  • Verify that SQL Server is installed and running correctly.
Follow tutorials on installing SQL Server on Linux
Enhance your understanding of the installation process by following guided tutorials that provide step-by-step instructions for setting up SQL Server on a Linux operating system.
Show steps
  • Identify reputable sources offering tutorials on SQL Server installation for Linux.
  • Follow the tutorials carefully, taking notes and clarifying any areas of uncertainty.
  • Attempt to install SQL Server on your own Linux system, applying the knowledge gained from the tutorials.
Install and Configure SQL Server on Linux
Solidify your understanding of SQL Server installation and configuration on Linux.
Browse courses on Linux
Show steps
  • Review the prerequisites for installing SQL Server on Linux.
  • Install SQL Server on a Linux virtual machine or server.
  • Configure SQL Server settings using the command line or SQL Server Management Studio (SSMS).
  • Verify that SQL Server is running and accessible.
Create a Database and Tables in SQL Server
Develop your proficiency in creating and managing databases and tables in SQL Server.
Show steps
  • Follow a tutorial on creating a database in SQL Server.
  • Create a table in the database with appropriate columns and data types.
  • Insert, update, and delete data in the table using SQL commands.
Follow tutorials on installing SQL Server on Linux
Reinforce the concepts covered in the course by following guided tutorials on installing SQL Server on Linux.
Show steps
  • Identify reputable online resources or video tutorials on installing SQL Server on Linux.
  • Follow the steps outlined in the tutorials, taking notes as needed.
  • Experiment with different configuration options to gain a deeper understanding of the process.
Practice SQL Server queries and commands
Enhance your understanding and proficiency in writing and executing SQL queries and commands, a crucial aspect of working with SQL Server.
Show steps
  • Use online platforms or resources that provide SQL Server practice exercises.
  • Create your own practice database and tables.
  • Write and execute queries to retrieve, insert, update, and delete data.
Practice SQL queries and commands
Solidify your grasp of SQL by practicing writing queries and commands through various exercises, reinforcing the concepts covered in this course.
Show steps
  • Find online platforms or textbooks that provide SQL practice exercises.
  • Work through the exercises, testing your ability to manipulate data, retrieve information, and modify database structures.
  • Review your solutions against provided answers or consult resources for guidance when needed.
Practice SQL queries on sample databases
Enhance your SQL proficiency by practicing queries on sample databases, reinforcing both syntax and logical operations.
Browse courses on SQL Queries
Show steps
  • Download sample databases relevant to the topics covered in the course.
  • Write queries to retrieve, manipulate, and analyze data from the sample databases.
Collaborate on a Database Design Project
Enhance your collaborative skills while working on a database design project with peers.
Browse courses on Teamwork
Show steps
  • Form a team of 2-3 classmates.
  • Choose a database design project to work on.
  • Collaborate on designing the database schema, creating tables, and populating data.
  • Present your project to the class.
Create a cheat sheet or summary of SQL Server features
Enhance your retention and understanding of SQL Server features by creating a cheat sheet or summary that consolidates key concepts and commands for easy reference during your learning journey.
Browse courses on Database Management
Show steps
  • Gather information about SQL Server features from the course materials and other reliable sources.
  • Organize the features logically, categorizing them based on functionality or purpose.
  • Create a visually appealing and easy-to-navigate cheat sheet or summary using tools like diagrams, tables, or bullet points.
Develop a Database Schema for a Real-World Application
Apply your knowledge to create a robust database schema that meets the requirements of a specific application.
Show steps
  • Identify the requirements of the real-world application.
  • Design an entity-relationship diagram (ERD) to represent the data model.
  • Create a database schema based on the ERD.
  • Document the schema and its relationships.
Develop a database schema for a specific business scenario
Apply your knowledge by designing and implementing a database schema for a specific business scenario, showcasing your understanding of data structures and relationships.
Show steps
  • Identify a specific business scenario and its data requirements.
  • Design the database schema, including tables, columns, and relationships.
  • Create the database and implement the schema using SQL Server.
  • Test the functionality and performance of the database.
Participate in a SQL Server Coding Challenge
Test your SQL Server skills and compete with others in a coding challenge.
Browse courses on Problem Solving
Show steps
  • Find a SQL Server coding challenge or competition.
  • Study the problem statement and requirements.
  • Develop a solution using SQL Server.
  • Submit your solution and compete for prizes or recognition.

Career center

Learners who complete Microsoft SQL Server on Linux in Azure will develop knowledge and skills that may be useful to these careers:
Database Administrator
A Database Administrator ensures the smooth functioning of an organization's databases, optimizing performance and maintaining data integrity. This course can be highly beneficial as it delves into the specificities of managing Microsoft SQL Server on Linux. You'll gain insights into installation, configuration, and maintenance tasks, enabling you to effectively manage databases and ensure their availability and reliability. The course will enhance your knowledge and skills to excel as a Database Administrator.
See salaries and explore the career path for Database Administrator
Data Engineer
Data Engineers play a vital role in building and maintaining the infrastructure for data storage, processing, and analysis. This course on Microsoft SQL Server on Linux will provide you with a solid foundation in database management on this platform. You'll learn about data modeling, optimization techniques, and security measures, equipping yourself with the skills to design, implement, and manage data-driven solutions effectively.
See salaries and explore the career path for Data Engineer
Data Analyst
As a Data Analyst, your goal is to extract meaningful information from data, helping organizations make informed decisions. This course can help you develop the skills to collect, clean, and analyze complex data sets frequently encountered in this role. It covers installation, configuration, and management of Microsoft SQL Server on Linux, providing an understanding of the architecture and functionality of a relational database. This knowledge will be particularly valuable for analyzing large volumes of structured data.
See salaries and explore the career path for Data Analyst
DevOps Engineer
DevOps Engineers bridge the gap between development and operations teams, ensuring seamless software delivery. This course on Microsoft SQL Server on Linux can be beneficial as it provides insights into database management and optimization on this platform. You'll learn about continuous integration and delivery practices, enabling you to create automated pipelines for database changes and ensure efficient collaboration between development and operations teams.
See salaries and explore the career path for DevOps Engineer
Cloud Architect
Cloud Architects design, build, and manage cloud-based solutions, ensuring optimal performance and scalability. This course on Microsoft SQL Server on Linux can be highly relevant as it provides insights into the deployment and management of SQL Server in the cloud. You'll learn best practices for cloud migration, optimization techniques, and security considerations, empowering you to design and implement robust cloud-based data solutions.
See salaries and explore the career path for Cloud Architect
Solutions Architect
Solutions Architects design and develop technical solutions to meet business requirements. This course on Microsoft SQL Server on Linux may be helpful as it provides a foundational understanding of database management on this platform. You'll gain insights into data modeling, query optimization, and security measures, enabling you to contribute to the design and implementation of effective data-driven solutions.
See salaries and explore the career path for Solutions Architect
Software Engineer
Software Engineers design, develop, and maintain software applications. This course on Microsoft SQL Server on Linux may be useful as it introduces the fundamentals of database management on this platform. You'll gain a foundational understanding of data modeling, query optimization, and security measures, enabling you to integrate database functionality effectively into your software solutions.
See salaries and explore the career path for Software Engineer
IT Consultant
IT Consultants provide expertise and guidance to organizations on technology-related issues. This course on Microsoft SQL Server on Linux may be helpful as it provides a foundational understanding of database management on this platform. You'll gain insights into data modeling, query optimization, and security measures, enabling you to effectively advise clients on database-related matters.
See salaries and explore the career path for IT Consultant
Data Scientist
Data Scientists use advanced analytical techniques to extract insights from data. This course on Microsoft SQL Server on Linux may be useful as it provides a foundational understanding of database management on this platform. You'll gain insights into data modeling, query optimization, and security measures, enabling you to effectively manage and analyze large datasets for data science projects.
See salaries and explore the career path for Data Scientist
Product Manager
Product Managers are responsible for defining, developing, and launching software products. This course on Microsoft SQL Server on Linux may be useful as it provides a foundational understanding of database management on this platform. You'll gain insights into data modeling, query optimization, and security measures, enabling you to effectively evaluate and incorporate database-related features into your product development roadmap.
See salaries and explore the career path for Product Manager
Business Analyst
Business Analysts bridge the gap between business and technology, translating business requirements into technical specifications. This course on Microsoft SQL Server on Linux may be helpful as it provides a foundational understanding of database management on this platform. You'll gain insights into data modeling, query optimization, and security measures, enabling you to effectively communicate with technical teams and ensure that data-driven solutions align with business objectives.
See salaries and explore the career path for Business Analyst
Project Manager
Project Managers plan, execute, and deliver projects successfully. This course on Microsoft SQL Server on Linux may be helpful as it introduces the fundamentals of database management on this platform. You'll gain a foundational understanding of data modeling, query optimization, and security measures, enabling you to effectively manage database-related aspects of projects.
See salaries and explore the career path for Project Manager
Systems Analyst
Systems Analysts design and implement technology solutions to meet business needs. This course on Microsoft SQL Server on Linux may be helpful as it provides a foundational understanding of database management on this platform. You'll gain insights into data modeling, query optimization, and security measures, enabling you to effectively design and implement database-driven systems.
See salaries and explore the career path for Systems Analyst
Technical Writer
Technical Writers create documentation and training materials for software products. This course on Microsoft SQL Server on Linux may be helpful as it provides a foundational understanding of database management on this platform. You'll gain insights into data modeling, query optimization, and security measures, enabling you to effectively write clear and accurate technical documentation.
See salaries and explore the career path for Technical Writer
Network Administrator
Network Administrators manage and maintain computer networks. This course on Microsoft SQL Server on Linux may be useful as it introduces the fundamentals of database management on this platform. You'll gain a foundational understanding of data modeling, query optimization, and security measures, enabling you to effectively manage database-related aspects of network infrastructure.
See salaries and explore the career path for Network Administrator

Reading list

We've selected two books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Microsoft SQL Server on Linux in Azure.
Cover image
The Database Hacker's Handbook Defending Database
Save
Provides a comprehensive overview of SQL Server on Linux, covering topics such as installation, configuration, management, and performance tuning. It good resource for those who want to learn more about the different aspects of SQL Server on Linux.
The Database Hacker's Handbook Defending Database
Paperback
Check
The Database Hacker's Handbook Defending Database
Kindle Edition
Check
Cover image
SQL Server 2017 Query Performance Tuning
Save
Provides techniques for tuning and optimizing SQL Server 2016 performance.
SQL Server 2017 Query Performance Tuning:...
Kindle Edition
$$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to Microsoft SQL Server on Linux in Azure.
Microsoft SQL Server on Linux Quick Start
Most relevant
VirtualBox 1.9: Advanced Features and Practical Use
Most relevant
Administering Microsoft SQL Server Availability Groups
Most relevant
Managing SSRS Reporting Environments
Most relevant
Microsoft SQL Server 2012 Certification Training Exam 70...
Most relevant
SQL Server: Installing and Configuring SQL Server 2016
Most relevant
Extracting and Transforming Data in SSIS
Most relevant
VPN Tunneling with OpenVPN: Secure Network Connections
Most relevant
Creating a Terraform Configuration for Multi-Cloud Use
Most relevant
Course image
Time
255 hours
Level
Advanced
Via
Pluralsight
Instructor
Landon Fowler
Language
English
Good to know
Examines a relational database management system with intriguing features
Highlights benefits Azure brings to SQL Server strategy
Taught by Landon Fowler
Meant for experienced SQL Server users coming from a Windows background
Meant for Linux gurus getting into MS SQL for the first time
Share and help others discover this course.
Facebook LinkedIn X Reddit Link Email
Don't miss out
Enroll today to gain access to this course
Enroll in this course
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser