70-461 Session 1: Querying Microsoft SQL Server ’12-16 T-SQL. With the help of this course you can T-SQL (Transact SQL Server) beginners: Create tables, data types + functions. Work to certification, inc. 70-761 (2016).
This course was created by Phillip Burton. It was rated 4.1 out of 5 by approx 1173 ratings. There are approx 80749 users enrolled with this course, so don’t wait to download yours now. This course also includes 4.5 hours on-demand video, 7 Articles, 3 Supplemental Resources, Full lifetime access, Access on mobile and TV & Certificate of Completion.
What Will You Learn?
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”
“Best I’ve seen. Instead of just throwing information at me, I’m able to work along with the instructor. Thanks!!!” — Charles Schweiger
“Lots of material covered in an easy-to-follow way. Not too slow, and not too face. Great job!” — Anita Parks
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.