This video course is appropriate for those beginners who want to learn SQL and work with it. It is designed to equip you with the following skills: implementing data warehouse solutions, troubleshooting and debugging SSIS packages, creating an ETL process and a SSIS package with the usage of SQL Server Integration Services. In addition, you will learn the ways to install and download SQL Server Data Tools, create reports with the help of SQL Server reporting Services.
138 lectures are included in the course. They are divided into 5 sections. You will start with setting up the text environment. Then, you will go to T-SQL, and this topic involves 43 lectures. Among them, there are lectures about primary and foreign keys; the SELECT statement; case expressions; filtering with logical, basic, string, and NULL comparisons; COUNT(), AVG(), MIN(), MAX(), SUM() functions; grouping data; new records addition. The separate block of 23 lectures cover SQL Server Integration Services. You will learn how to install visual studio; configure and add flat file source, lookup transformation, OLE DB destination, etc.; write data to cache; make new SSIS package, and so on. The topics of Data Warehouse and SSAS, as well as SSRS, are also a part of the curriculum.At the end of the training, you will be capable of:
Thus, this course is a good start to become a SQL Server developer, which opens many career opportunities as these skills are in high demand today.
Get 100% Real Exam Questions, Accurate & Verified Answers As Seen in the Real Exam!
30 Days Free Updates, Instant Download!