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.
It then goes into detail about data types and data functions, the foundation of T-SQL, and then the basics of querying - SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
We'll then JOIN two or more tables together, and INSERT, UPDATE and DELETE data.
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, create tables, insert data and create analyses, 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?
What am I going to get from this course?
- Over 48 lectures and 7 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.
- retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
- JOIN two or more tables together, finding missing data.
- INSERT new data, UPDATE and DELETE existing data, and export data INTO a new table.
- complete several objectives 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 of you if you want a refresher on SQL. However, no prior SQL Server knowledge is required.
- If you know all about SELECT queries, data types and data manipulation, and want to learn about views, constraints and merging data sets, then the Day 2 course is for you.
