SQL Server 2017: Linux, Docker, and macOS is now available on LinkedIn Learning

SQL Server 2017: Now on Linux, Docker, and macOS

SQL Server has traditionally run only on Windows. New for 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 capitalize 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 diverse array of environments. Instructor Adam Wilbert also shows how to use SQL Operations Studio to perform routine SQL Server maintenance tasks, such as backups, from Windows, macOS, and Linux.

Topics Include:

  • 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


Duration: 1h 44m


This course is now available on LinkedIn Learning and Lynda.com. Not a member? Get 10 days of free unlimited access to Lynda.com.

Learning SQL Server 2017 is now available on LinkedIn Learning

Get Started Building Databases with SQL Server 2017

Microsoft SQL Server can be an intimidating system. In this course, instructor Adam Wilbert provides a quick overview of how SQL Server works—which can go a long way to making you feel more comfortable as you start exploring its powerful capabilities. Adam goes over the most important features of SQL Server 2017, helping to familiarize you with how the server operates. He introduces the main working environment—SQL Server Management Studio—and walks through how to start creating tables and manipulating data.

Topics Include:

  • Reviewing the different editions of SQL Server
  • Configuring and starting the server
  • Touring the SQL Server Management Studio (SSMS) interface
  • Creating a new database on the server
  • Creating a data table
  • Joining tables together with keys
  • Writing Transact-SQL commands

Duration: 1h 21m


This course is now available on LinkedIn Learning and Lynda.com. Not a member? Get 10 days of free unlimited access to Lynda.com.

SQL Server 2017: What's New is now available on LinkedIn Learning

Preview the newest features of SQL Server 2017

SQL Server 2017 is the start of the new annual release strategy by Microsoft. SQL developers no longer have to wait two or three years for enhancements. See what's new and notable in the 2017 release, in this overview with Adam Wilbert. See the new Linux compatibility in action, as Adam shows how to install SQL Server on Ubuntu, and learn how to use the machine learning services package, which includes R and Python scripting. Then find out how to use graph databases to model many-to-many relationships as nodes and edges. Adam also reviews the smaller enhancements like automatic query performance tuning and the new dynamic management views.


Duration: 1h 22m


This course is now available on LinkedIn Learning and Lynda.com. Not a member? Get 10 days of free unlimited access to Lynda.com.

SQL Server 2016: Provision a Database is now available on LinkedIn Learning

Provision SQL Server instances on your local machines or in the cloud

Learn the key skills you need to provision SQL Server instances both on premises and using the cloud-based Azure service. In this course, Adam Wilbert reviews several ways of getting a SQL database up and running, helping you see the benefits and trade-offs of each option. He begins by explaining how to get started with Azure SQL Database, demonstrating how to deploy a database and choose the right service tier for you. He also shows how to deploy a virtual Windows Server machine, and migrate on-premises SQL Server databases to a SQL Server instance hosted on an Azure virtual machine.

This course is also ideal for anybody preparing for the Provisioning SQL Databases (70-765) exam, one of two exams necessary to earn an MCSA: SQL 2016 Database Administration certification.

Duration: 2h 44m


This course is now available on LinkedIn Learning and Lynda.com. Not a member? Get 10 days of free unlimited access to Lynda.com.

Learning Relational Databases is now available on LinkedIn Learning

Your First Introduction to Relational Databases

Have you ever opened up a database that someone else built and felt a little lost? Or ever thought of designing your own simple database and been unsure of where to start? Or perhaps you need to work with a team of database professionals and don't know how to speak their language? This course can help you overcome these hurdles.

Adam Wilbert covers the basics of relational database design, regardless of whether you use Access, FileMaker, Open Office, or SQL Server. Learn how to prevent data anomalies, gather requirements to plan your design, and develop a conceptual data model—translating your ideas into components like tables, relationships, queries, and views. Plus, learn about logical design considerations that can help you construct a database that is easy to maintain.

Topics include:

  • What is a database management system (DBMS)?
  • Moving through the database development cycle
  • Preventing duplicate, inconsistent, and conflicting data entries
  • Gathering requirements
  • Developing relationships
  • Identifying key fields
  • Following a naming convention
  • Developing the actual database

Duration: 2h 43m


This course is now available on LinkedIn Learning and Lynda.com. Not a member? Get 10 days of free unlimited access to Lynda.com.