Learn Microsoft SQL Server from Lynda

Lynda offers you 28 courses, to learn Microsoft SQL Server now!

Lynda, is a leading online learning platform that helps anyone learn business, software, technology and creative skills to achieve personal and professional goals. Through individual, corporate, academic and government subscriptions, members have access to the Lynda.com video library of engaging, top-quality courses taught by recognized industry experts. For 20 years, Lynda.com has helped students, leaders, IT and design pros, project managers—anyone in any role—develop software, creative, and business skills. Now part of Linkedin, Lynda.com serves more than 10,000 organizations. With tutorials in five languages, Lynda.com is a global platform for success.

  • flag Lynda
  • student All Levels
  • database eLearning
  • earth English
  • clock 4h 8m

SQL Server Integration Services (2015)

Microsoft SQL Server Integration Services^ or SSIS^ is an enterprise-level ETL tool: a tool for extracting^ transforming^ and loading data. Whether you re looking for information in flat files^ via FTP^ or on the web^ SSIS allows you to transform …

Read More
  • flag Lynda
  • student Expert
  • database eLearning
  • earth English
  • clock 3h 14m

Designing Database Solutions for SQL Server 2016

When you re working with a team to design a SQL Server 2016 database solution for your organization^ there are certain advanced concepts you need to know. In this course^ Adam Wilbert introduces you to some of the concepts you …

Read More
  • flag Lynda
  • student All Levels
  • database eLearning
  • earth English
  • clock 3h 6m

Implementing a Data Warehouse with Microsoft SQL Server 2012

Learn how to design and implement an enterprise data warehouse. Microsoft Certified Trainer Martin Guidry shows how to design fact and dimension tables using both the star and snowflake techniques^ use data quality services to cleanse data^ and implement an …

Read More
  • flag Lynda
  • student Beginner
  • database eLearning
  • earth English
  • clock 3h 3m

Installing SQL Server 2012

Learn how to install^ secure^ and maintain SQL Server 2012. This course is designed to teach new database administrators how to choose the correct SQL Server edition^ install it using the GUI or from the command prompt^ configure services and …

Read More
  • flag Lynda
  • student Intermediate
  • database eLearning
  • earth English
  • clock 1h 22m

Microsoft SQL Server 2014: Backup and Recovery

Being able to perform a database backup—and recover data when something goes wrong—is a key skill any database administrator should have. In this focused course^ author Martin Guidry covers the key topics necessary to master backup and recovery of a …

Read More
  • flag Lynda
  • student Intermediate
  • database eLearning
  • earth English
  • clock 3h 18m

Microsoft SQL Server 2016 Essential Training

SQL Server supports mission-critical applications and big data solutions—without having to buy expensive add-ons or high-end appliances. Learn the essentials of Microsoft s latest release^ SQL Server 2016. Use tools like SQL Management Studio and the Configuration Monitor to deploy …

Read More
  • flag Lynda
  • student Intermediate
  • database eLearning
  • earth English
  • clock 2h 35m

Microsoft SQL Server 2016: Installation and Administration

SQL Server is the database used with Azure and many on-premises environments and is quickly becoming a very popular RDBMS. Get an overview of installing^ administering^ and managing SQL Server 2016 in this course with SQL Server expert Gerry O …

Read More
  • flag Lynda
  • student Intermediate
  • database eLearning
  • earth English
  • clock 2h 38m

Migrating Access Databases to SQL Server

At one point Access was adequate. But what happens when your database grows and you need more powerful tools? You can move it! Migration allows you to take advantage of SQL Server s advanced features^ and maintain a link to …

Read More
  • flag Lynda
  • student Beginner
  • database eLearning
  • earth English
  • clock 5h 34m

Querying Microsoft SQL Server 2012

Learn how to query data from SQL Server tables. Microsoft Certified Trainer Gerry O Brien reviews the history of SQL and relational theory^ so you ll understand exactly where this data manipulation language^ and Microsoft s seminal database program^ got …

Read More
  • flag Lynda
  • student Beginner
  • database eLearning
  • earth English
  • clock 1h 36m

Securing SQL Server 2012

Make sure your network s SQL Servers are secure^ using best practices for physical^ instance^ network^ and file system security. Gerry O Brien introduces basics like SQL Server securables^ principals^ logins^ users^ and roles. Then learn how SQL Server checks …

Read More
  • flag Lynda
  • student Beginner
  • database eLearning
  • earth English
  • clock 6h 54m

SQL Server 2008 Essential Training

In ^ Simon Allardice explores all the major features of SQL Server 2008 R2^ beginning with core concepts: installing^ planning^ and building a first database. Explore how Transact-SQL is used to retrieve^ update^ and insert information^ and gain insight into …

Read More
  • flag Lynda
  • student Intermediate
  • database eLearning
  • earth English
  • clock 1h 58m

SQL Server 2012: Designing Database Solutions

Learn how to design databases^ secure databases^ and keep them in tip-top shape^ with SQL Server 2012. Join Martin Guidry in this course^ as he reviews each step in the process: from designing the infrastructure^ a logical schema^ and execution …

Read More