设计星素材分享平台 Udemy – 70-461 Session 2: Querying Microsoft SQL Server 2012

收藏
50积分下载

素材介绍

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.

wolves

166
12788401

77组电影外观Log/Rec709视频还原色彩分级调色Lut预设包Pixflow – Colorify Cinematic LUTs
- 275
- 0
- 0
- 0
复古怀旧电影风格温暖色调索尼Sony S-Log3视频调色LUT预设ROMAN HENSE – LUTs 24 for Sony S-Log3
- 290
- 0
- 0
- 0
JUAN MELARA – P6K2Alexa PowerGrade AND LUTs V2 GEN 5
- 238
- 0
- 0
- 0