3 training courses found | Help me choose

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 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,775/person Jan 16 to Jan 19, 2018$2,775/person Feb 13 to Feb 16, 2018$2,775/person Mar 13 to Mar 16, 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