SQL Server video course – Session 1

70-461 Session 1: Querying Microsoft SQL Server 2012

Install SQL Server, learn how to create and drop tables, and data types and functions in detail. Quizzes included.
Use the coupon code SQLINTRO to save 50%

About This Course

This course is the foundation for the Microsoft Certificate 70-461: “Querying Microsoft SQL Server 2012”.

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

$20  $10
Take This Course

(That’s $3 per hour!)

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.

Lectures: 33
Video: 3.5 hours
Skill Level: Beginner Level
Languages: English
Includes: Lifetime access
30 day money back guarantee!
Available on iOS and Android
Certificate of Completion

Preview video 13

(Why not view the below video full screen? Click the YouTube logo in the bottom-right hand corner.)

Want to see more preview videos?

What are the requirements?

You need to know how to use a computer, and hopefully know how to use a spreadsheet.

No prior knowledge of SQL Server required.

You don’t even need SQL Server installed – I’ll show you have to install it on your computer for free!

There’s a 30-day money back guarantee on this Udemy course.

Why not have a look at the curriculum below and see what you can learn? If you already know them, please see my later sessions.

What am I going to get from this course?

  • create, alter and drop tables in a database.
  • know what data type to use in various situations.
  • use functions to manipulate date, number and string data values.
  • work towards objectives 1 and 8 from Microsoft Certification 70-461 “Querying Microsoft SQL Server 2012”

What is the target audience?

  • This SQL course is meant for you, if you have not used SQL Server much (or at all), and want to start to learn T-SQL.
  • This course is also for you if you want a refresher on SQL. However, no prior SQL Server knowledge is required.
  • If you already know all this, and want to learn about more advanced topics, please see my later sessions.

Curriculum

Section 1: Let’s begin, and let’s download SQL Server
Lecture 1 Introduction 02:23
Lecture 2 Curriculum 08:54
Lecture 3 Downloading SQL Server 07:22
Lecture 4 Installing SQL Server 07:07
Section 2: Starting SQL Server
Lecture 5 Opening SQL Server 03:01
Lecture 6 Looking at SQL Server Management Studio 04:45
Lecture 7 Create a database 01:41
Lecture 8 Creating our first queries 06:08
Quiz 1 Databases and Queries 2 questions
Section 3: Creating tables – First pass
Lecture 9 Creating a table – first pass using GUI 02:10
Lecture 10 Creating a table – first pass using T-SQL 02:58
Quiz 2 New Tables 2 questions
Lecture 11 Entering data using the GUI 02:30
Lecture 12 Entering data using T-SQL 04:48
Quiz 3 Entering data using T-SQL 1 question
Lecture 13 Retrieving data 04:33
Quiz 4 Retrieving data 1 question
Lecture 14 Deleting the data, then the table 03:08
Quiz 5 Deleting data using T-SQL 2 questions
Section 4: Number types and functions
Lecture 15 Creating an Employee table 04:27
Lecture 16 Resources Article
Lecture 17 Creating temporary variables 11:45
Lecture 18 Integer numbers 07:47
Quiz 6 Integer numbers 5 questions
Lecture 19 Non-integer numbers 15:09
Quiz 7 Non-integer numbers 3 questions
Lecture 20 Mathematical functions 12:38
Quiz 8 Mathematical functions 2 questions
Lecture 21 Converting between number types 08:41
Quiz 9 Converting between number types 1 question
Section 5: String data types and functions
Lecture 22 Strings 15:43
Quiz 10 Strings 2 questions
Lecture 23 String Functions – extraction 07:15
Quiz 11 String Functions – extraction 2 questions
Lecture 24 NULL – an introduction 09:17
Lecture 25 Joining two strings or a string and number together 11:49
Quiz 12 NULL 2 questions
Lecture 26 Joining a string to a number 08:46
Quiz 13 Joining numbers to strings 2 questions
Section 6: Date data types and functions
Lecture 27 Date data types 07:45
Lecture 28 Setting dates and Date extraction 06:23
Quiz 14 Date data types 3 questions
Lecture 29 Today’s date, and more date functions 07:49
Quiz 15 Today’s date and more date functions 2 questions
Lecture 30 Date offset 09:47
Lecture 31 Converting from dates to strings 09:53
Quiz 16 Converting from date to strings 1 question
Section 7: End of session 1
Lecture 32 BONUS – Recap, Look ahead and Voucher Code 03:38
Lecture 33 Well done! 01:46

Take This Course

Do you have a question – why not ask it in the box below?


Comments are closed.