Implementing a SQL Data Warehouse - Course 20767-C Course in United States
AT7780
This five-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server database. The course covers SQL Server provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.
Training schedule for "Implementing a SQL Data Warehouse - Course 20767-C Course"
Who Should Attend
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of relational databases.
- Some experience with database design.
Course Content
- Module 1: Introduction to Data Warehousing
- Module 2: Planning Data Warehouse Infrastructure
- Module 3: Designing and Implementing a Data Warehouse
- Module 4: Columnstore Indexes
- Module 5: Implementing an Azure SQL Data Warehouse
- Module 6: Creating an ETL Solution
- Module 7: Implementing Control Flow in an SSIS Package
- Module 8: Debugging and Troubleshooting SSIS Packages
- Module 9: Implementing a Data Extraction Solution
- Module 10: Enforcing Data Quality
- Module 11: Using Master Data Services
- Module 12: Extending SQL Server Integration Services (SSIS)
- Module 13: Deploying and Configuring SSIS Packages
- Module 14: Consuming Data in a Data Warehouse
Frequently Asked Questions
"Implementing a SQL Data Warehouse - Course 20767-C Course" trainings are given in ("Group - One to one") two different ways.
The one-to-one tuition fee is 1,480 $.
"Implementing a SQL Data Warehouse - Course 20767-C Course" trainings are given in two different ways.
The tuition fee as a group is 1,490 $. To create a group, you must be at least 3 people.
The one-to-one tuition fee is 1,480 $.
Our "Implementing a SQL Data Warehouse - Course 20767-C Course" trainings are one-to-one 5 days,
Our "Implementing a SQL Data Warehouse - Course 20767-C Course" trainings are group 3 days,
Exam & Certification
Participation Certificate
All trainees who participate in training will have an AcademyTech participation certificate.
AcademyTech Training and Consulting Center
AcademyTech is very affordable and a perfect online training environment. Training Coordicator (Seyma) is always taking care of how the course is going on. A typical day insisted of some prep time in the morning, lots of time for Q and A during the course. Verify flexible schedule and very knowledgeable trainers.
Jason Bradford
Our Company is an Oil & Natural Gas Company in Libya, and our Microsoft Azure Courses given by AcademyTech at Istanbul. We are really glad for the Microsoft Azure Courses which is held at AcademyTech's venue named as Artois Cadde. Moreover the great courses, we have been hosted by the management team in Artois Restaurant at evenings with their tastefull cocktails and Pastas.
Salah Handr
I joined an online 3 days Microsoft course, with great student guides and lab guides, coupled with an instructor (Konstantin Ceran) who made the topics interesting with with knowledge of the subject matter.
Kerri Kincaid
I was in doubt to take this Microsoft course as Online.But I was really impressed with the easy to use online system, Labs and Presentation, as well as the instructor's knowledge, availability, and willingness to help me throughout the course.
Nick Ragan
Just completed the 20703 - Administering SCCM course. Top notch training materials, lab and instruction. Thank you for a great class Mr. Kosta
JOSE GOSENDE
Microsoft Power BI Training by Kosta was actually well tailored to match a novice like me. Online Training Systems and the team (Seyma) behind it also did a good job in following up and arranging everything required for and before the training neatly. Thank you.!
Fabricio Reyes
Took the one day Azure fundamentals. Really enjoyed this course. I have better understanding of Azure. The delivery of this course was great. It was not too technical it was good to have a good picture. Really enjoyed the instructor also showing how things are working in Azure. It's not just a lecture you get to see the components in actions.
Bharat Khare
Very good instructor and very good course (Azure Fundamentals) - I don't like the word "Excellent", I generally use it only for sightseeing :))
Michael Hutchings