In this video you’ll learn how to use the All and Distinct keywords in your SQL query to return either every row from a data source or just the rows with unique values. You’ll see how to affect the sorting of the query results using the Order By clause and how to use unique row values to provide users with a choice using drop down lists on a user form. SQL stands for Structured Query Language designed for managing data in relational database management systems and it is one of the most important, widely used programming languages in the business world. SQL is essential for any professional including technical and non-technical roles like data/business analyst, marketing, operations, finance, sales, and support.

SQL Server 2014 Lessons

You’ll also see how to sort a query when the source data has no column headers and how to sort by a column without displaying it in the query results. SQL Server 2014 Lessons The increased functionality will streamline your ETL processes and smooth out your workflow, but the catch is that your workflow must change.

Synergie Training

This module introduces the fundamentals of the SELECT statement, focusing on queries against a single table. Learning Tree is the premier global provider of learning solutions to support organizations’ use of technology and effective business practices.

This video explains how to update existing data in an Excel workbook using SQL UPDATE statements. The final part of the video discusses how to import data from a separate workbook using a SELECT INTO statement and then use the imported data to update existing data. This video shows you how to merge multiple worksheets using a combination of union queries and outer joins. You’ll use a union query to create a master list of values to join on and use this query to populate a derived table subquery.

Best-selling in Adult Learning & University

You’ll see an alternative way to do the same thing without using an inner join. You’ll also learn the syntax required to include multiple tables in the same query and finally how to apply criteria and sorting to the results. One way to get data from a closed Excel workbook is to open it first, but did you know that in VBA you can connect to a workbook and extract data from it without needing to open the file? As a bonus, the video shows you how to add some basic criteria to the SQL query to control which rows of data you return from the workbook.

SQL Server 2014 Lessons

This video shows you how to use ADO commands to modify data in a SQL Server database. You’ll learn how to use the INSERT INTO, UPDATE and DELETE statements with an ADO command object to affect records. I came across Pluralsight about a year ago, as a library of developer focussed learning. Since then, they’ve expanded and acquired other course libraries, covering the whole spectrum of IT learning, including Open Source and Cloud Computing, as well as commercial software. The on-line, modular model allows me to learn in the time I have – most courses have modules in minute lengths, so they can be watched in a lunch break – and over several days you can cover a whole course. I find their approach to training to be conducive to learning, and the subscription model encourages you to learn and improve as much as you can, rather than each subject or area costing more money.

Module 11: Performing Ongoing Database Maintenance

SQL Server 2014 includes AlwaysOn Availability Groups to provide high availability for groups of databases. This module describes AlwaysOn Availability Groups in SQL Server 2014, explains the key concepts of AlwaysOn Availability Groups, and describes how you can use them to maintain highly available databases. In this module, you will learn about the core concepts on which the SQL Server security architecture is based, and how to manage security at the server and database levels. This module introduces T-SQL expressions which return a valid relational table, typically for further use in the query.

SQL Server 2014 Lessons