|
Database & Reporting Training
/
IBM Training
Netezza SQL50%Lecture/Demo 50%Lab IBM® Netezza® appliances are now part of IBM PureSystems, a quick, efficient integrated data analytics system that optimizes performance and runs complex algorithms. Accelebrate's Netezza SQL training class teaches students how to write efficient big data queries using Netezza SQL. Course Number:IBM-110Duration:3Location and PricingMost Accelebrate courses are delivered as private, customized, on-site training at our clients' locations worldwide for groups of 3 or more attendees and are custom tailored to their specific needs. Please visit our client list to see organizations for whom we have delivered private in-house training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote for private training at your site or online, please contact us. Netezza SQL Training ObjectivesAll students will learn:
Netezza SQL Training OutlineIntroduction Basic SQL Functions The WHERE Clause Distinct Vs Group By Review Aggregation Function Join Functions Date Functions OLAP Functions Temporary Tables Sub-query Functions Substrings and Positioning Functions Interrogating the Data View Functions Set Operators Functions Data Manipulations Tables, DDL, and Data Types Statistical Aggregate Functions Stored Procedure Functions Nexus Query Chameleon Conclusion Prerequisites:No prior experience is required. Training Materials:All Netezza training students receive comprehensive courseware, available electronically. Software needed for each student PC:We have multiple options for setting up this course using a mix of local and/or cloud resources that we provide. Please ask us for details. For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor's screen simultaneously with working on their own. Related Courses: |