2 training courses found | Help me choose

This SETC certified course covers every aspect of database administration in a production SQL Server environment. Beginning with the configuration of the underlying operating system, the course explores every aspect of the installation and configuration process in both a dedicated and virtual topology. We then tackle the creation of databases, files and filegroups in complex multi-server environments. This is followed by detailed discussions of data import and export, backup and recovery, SQL Server security, SQL Server monitoring and performance tuning. This course also includes a full discussion of indexes, index types and performance tuning. The course concludes with an extensive hands-on lab that allows participants to practice the skills that they have learned in the course. Custom training course titled SQL Server Administration: The Complete Course that will allow you to hone your professional skills.

Nov 6 to Nov 9, 2017$2,775/person Jan 23 to Jan 26, 2018$2,775/person Feb 20 to Feb 23, 2018$2,775/person Mar 20 to Mar 23, 2018$2,775/person
This SETC certified course covers the full range of SSIS concepts from the basics of data sources to advanced data flows and control flows. The course begins with a tour of the BIDS (Business Intelligence Development Studio) environment and its many windows, dialog boxes and features, From there, the student is taken through a comprehensive investigation of basic tasks such as importing data from delimited and positional files, exporting data to external data sources and implementing simple error conditions. Having mastered the basics, the course proceeds to study the intricacies of complex data transformation tasks which require transformations, NULL value handling and encoding changes. This comprehensive learning event concludes with a case study which shows participants how to load a data warehouse using SSIS packages. If you want to use SSIS to manipulate your data, this SETC certified course is the course for you. Custom training course titled Maintaining and Transforming Data with SSIS that will allow you to hone your professional skills.

Jan 17 to Jan 19, 2018$2,250/person Feb 14 to Feb 16, 2018$2,250/person Mar 14 to Mar 16, 2018$2,250/person