70-461 Session 1: Querying Microsoft SQL Server 2012
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.
Take This Course
(That’s $3 per hour!)
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.
Video: 3.5 hours
Skill Level: Beginner Level
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.
|Section 1: Let’s begin, and let’s download SQL Server|
|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 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|
|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|
Do you have a question – why not ask it in the box below?