70-461 Session 1: Querying Microsoft SQL Server 2012/2014

Phillip Burton

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
31 Videos (3h 38m)
    • Introduction

      2:23
    • Curriculum

      8:54
    • Downloading SQL Server

      7:22
    • Installing SQL Server

      7:07
    • Opening SQL Server

      3:01
    • Looking at SQL Server Management Studio

      4:45
    • Create a database

      1:41
    • Creating our first queries

      6:08
    • Creating a table - first pass using GUI

      2:10
    • Creating a table - first pass using T-SQL

      2:58
    • Entering data using the GUI

      2:30
    • Entering data using T-SQL

      4:48
    • Retrieving data

      4:33
    • Deleting the data, then the table

      3:08
    • Creating an Employee table

      4:27
    • Creating temporary variables

      11:45
    • Integer numbers

      7:47
    • Non-integer numbers

      15:09
    • Mathematical functions

      12:38
    • Converting between number types

      8:41
    • Strings

      15:43
    • String Functions - extraction

      7:15
    • NULL - an introduction

      9:17
    • Joining two strings or a string and number together

      11:49
    • Joining a string to a number

      8:46
    • Date data types

      7:45
    • Setting dates and Date extraction

      6:23
    • Today's date, and more date functions

      7:49
    • Date offset

      9:47
    • Converting from dates to strings

      9:53
    • End of Session 1

      1:46

About This Class

This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012/2014".

Rather than present one huge course, this course takes some of the basics and then goes in depth. The basics presented are: how to install SQL Server, and how to create and drop tables.

We then try to create a more advanced table, but find that we need to know more about data types - so we go into some detail about data types and data functions, the foundation of T-SQL.

No prior knowledge is required - I'll even show you how to install SQL Server on your computer for free!

There are regular quizzes to help you remember the information.

Once finished, you will know what how to manipulate numbers, strings and dates, and create database and tables, and have an appreciation of how they can all be used in T-SQL.

9

Students

--

Projects

0

Reviews (0)

Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.

He enjoys investigating data, which allows me to maintain up to date and pro-active systems to help control and monitor day-to-day activities. As part of the above, he also developed and maintained a Correspondence Database in Microsoft Access and SQL Server, for viewing job-related correspondence (110,000 pdfs in one job) by multiple consultants and solicitors.

He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.

He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.

His interests are working with data, including Microsoft Excel, Access and SQL Server.

Business SQL Server Productivity T-SQL 70-461