English | MP4 | 1280x720 | 59 kbps | 44 KHz | 4 hours | 597 Mb
Learn about SQL Server tables, SELECT statements (FROM, WHERE, GROUP BY etc), JOIN tables, and INSERT/DELETE/UPDATE data
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.
In session 1 we learnt all about dates, strings and nuMber data types and functions in some detail.
We'll create tables which use these, and then INSERT some data into them. Then we'll write queries which will retrieve and summary this data, using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
We'll then JOIN these tables together to find where we are missing data and where we have inconsistent data. We'll then UPDATE and DELETE data from the tables. This will allow up to fully complete objective nuMber 1 from the 70-461 exam.
If this sounds too basic, then please look at my other sessions.
The only prior knowledge which is required for Session 2 is that which has been taught in Session 1.
There are regular quizzes to help you remeMber the information.
Once finished, you will know what how to 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 all about data types and functions. If you don't, you should take the Session 1 course first.
You should also know how to open SSMS.
There is a 30-day money back guarantee of 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 22 lectures and 3.5 hours of content!
create tables in a database
ALTER columns in the table.
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 objective 1, and work towards other objectives from Microsoft Certification 70-461 "Querying Microsoft SQL Server 2012"
What is the target audience?
This course is for you if want a refresher course in SQL, or are learning SQL for the first time.
If you are starting from the beginning, then you should look at my session 1 course before taking this session 2.
If you want more advanced topics, then please look at my later sessions.
(Buy premium account for maximum speed and resumming ability)