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 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.
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?
- Over 33 lectures and 3.5 hours of content!
- 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.
