Data Defined
6 training courses found | Help me choose

SQL Server Training

This SETC certified course covers every aspect of the SQL language. Beginning with database basics like creating databases and tables, we proceed to a thorough investigation of the SQL language. We discuss the basic data manipulation statement of SQL together with the data modification statements of the language. With some basics under our belts, we are freed to look at more advanced topics like string and date time manipulation as well as the use of NULL values in tables and scripts. We also take the time to study joins and aggregated data along the way. It makes for a busy and rewarding 2 days. Custom training course titled Introducing SQL: The Basics of Database Querying that will allow you to hone your professional skills.

Jan 29 to Jan 30, 2018$1,150/person Feb 26 to Feb 27, 2018$1,150/person Mar 26 to Mar 27, 2018$1,150/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$1,675/person Feb 14 to Feb 16, 2018$1,675/person Mar 14 to Mar 16, 2018$1,675/person
Custom training course titled Professional MySQL Administration: Mastering Replication, Clustering and High Availability that will allow you to hone your professional skills.

Jan 9 to Jan 12, 2018$3,000/person Feb 6 to Feb 9, 2018$3,000/person Mar 6 to Mar 9, 2018$3,000/person
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.

Jan 23 to Jan 26, 2018$2,500/person Feb 20 to Feb 23, 2018$2,500/person Mar 20 to Mar 23, 2018$2,500/person
Custom training course titled The Complete SQL Server Optimization and Performance Tuning Course that will allow you to hone your professional skills.

Jan 16 to Jan 19, 2018$2,500/person Feb 13 to Feb 16, 2018$2,500/person Mar 13 to Mar 16, 2018$2,500/person
This SETC certified course covers every aspect of the TSQL development language. Beginning with database basics like creating databases and tables, we proceed to a thorough investigation of the TSQL language. We discuss variable declaration, conditional and looping expressions and the use of native functions. With some basics under our belts, we are freed to look at more advanced topics like string and date time manipulation as well as the use of NULL values in tables and scripts. We also take the time to consider the use of stored procedures and BLOB data. It makes for a busy and rewarding week. Custom training course titled The Complete TSQL Programming Course that will allow you to hone your professional skills.

Dec 18 to Dec 21, 2017$2,500/person Jan 16 to Jan 19, 2018$2,500/person Feb 13 to Feb 16, 2018$2,500/person Mar 13 to Mar 16, 2018$2,500/person