Omaha SSUG – April 2017 Meeting

Synopsis
Pyramid Analytics’ industry-leading Modern BI platform balances IT control and business user success. It offers enterprise capabilities such as advanced data modeling, self-service data discovery, interactive dashboards, and narrative reporting on any device. Here’s what makes Pyramid Analytics unique:

  • A true analytics platform that combines the security and stability of IT governance with the flexibility and utility of user-driven analysis
  • A scalable platform that supports the volume and variety of data, subject areas, and users across the enterprise
  • The BI Office collaboration engine lets users share analysis, comments, and context to bring the power of the collective to every decision
  • Enterprise-grade, role-based security that enables the right access for the appropriate audiences across the platform – even down to the cell level of content
  • Merging advanced visuals and powerful analytics provides real-world utility, and gives users the power to answer challenging organizational questions.

Hear about these unique capabilities as well as Pyramid’s integration with Power BI.

Speaker
Andrew Mauch

Andrew is a results oriented sales and management professional striving to help companies unlock the power of their data.  Andrew has spent several years managing a consulting organization that built custom BI solutions from the Microsoft platform.  Seeing how companies often struggled with BI, Reporting and Analytics, led him to join Pyramid Analytics.  BI Office is where BI is made simple, putting the power of Analytics in the end user’s hands with the governance of IT.

Sponsor
Pyramid Analytics

Food
Food will be served 15-20 minutes prior to the start of the meeting.

SQL Certification Training Opportunity

 

MCSA: SQL Server 2012 Boot Camp 6445N

Lincoln SQL Server User Group is happy to be working with Global Knowledge to bring a SQL Server MCSA Bootcamp to Lincoln Nebraska! We are on a short timeline to get paid attendees so please act quickly. This boot camp is being customized to concentrate each four day training period on one of the three exams. This package is more than just training, but includes the exam fees, study materials, a year of access to training and labs as well as free retake of the course itself. See below for details.

Tailored Schedule: 3 four day training sessions

Hours: 1:00pm to 9:00pm

 

There is a minimum class size of 7 and we must cancel this offering on May 16th if we do not have enough students. So please respond quickly if you wish to attend.

 

Max Class Capacity 16

Dates:

·         Tuesday June 14th through Friday June 17th 2016

·         Tuesday July 19th through Friday July 22nd 2016

·         Tuesday August 16th through Friday August 19th 2016

 

Cost: $6000 all-inclusive for up to 16 attendees.

 

Payment options: Credit Card or PO with Global Knowledge

 

To register and get payment information call

John Danley

President Lincoln SQL Server User Group

402-957-1887

LincolnSSUG@gmail.com

 

Location: Ameritas 5700 O Street, Lincoln, NE

 

Microsoft Exclusives

·         12 months of anytime access to your course labs and lab environment

·         12 months of 24/7 access to mentoring via chat, email and phone

·         12 months of on-demand access to indexed, searchable recordings of your Virtual Classroom or Virtual Classroom Fit class

·         12 months of unlimited retakes of your class

·         30 days of access to the online Microsoft Press E-Reference Library, including all training kits, exam references, and rapid review books

·         30 days of access to a recommended Microsoft reading List designed by our instructors, including topics and chapters within the Microsoft Press E-Reference Library

·         12 months of access to certification practice exams from Transcender that provide realistic Microsoft exam simulations in online and downloadable versions

·         12 months of access to recorded “Power Hours” – an online review session covering key exam objectives conducted by our expert instructors – for each exam

 

Course Overview

 

Gain the database-related skills required for the latest Microsoft certifications through this broad and extensive hands-on training experience. This Boot Camp features an online study program and a choice of delivery methods to suit your learning style preference.

 

In this accelerated learning environment, you will build your skills and prepare for the MCSA: SQL Server 2012 certification exams. This extended-hours boot camp led by senior Global Knowledge instructors includes targeted lectures using Microsoft Learning recommended content as well as twelve months of access to more than 40 hands-on remote labs.

 

This boot camp includes all the exam vouchers required for certification, along with one free retake voucher if needed. It also includes access to our Microsoft Boot Camp Exclusives, providing indispensable certification exam prep.

 

This course incorporates content from Microsoft Official Courses (MOC):

·         Querying Microsoft SQL Server (M20461)

·         Administering Microsoft SQL Server Databases (M20462)

·         Implementing a Data Warehouse with Microsoft SQL Server (M20463)

Note: Microsoft Learning recommends the above courses, which use SQL Server 2014 for preparation for the following MCSA exams that reference SQL Server 2012. Microsoft Learning has no plans to update the MCSA: SQL Server 2012 exams to SQL Server 2014. All the exam skill objectives, however, are covered in the latest courseware as designed. Please see http://www.microsoft.com/learning for certification details.

 

You Will Prepare for These Exams:

·         70-461: Querying Microsoft SQL Server 2012

·         70-462: Administering Microsoft SQL Server 2012 Databases

·         70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

 

Typical Attendees:

·         IT professionals with at least two years of hands-on experience implementing and administering database systems

·         Database administrators, systems engineers, systems analysts, and technical consultants who want to prepare for their MCSA: SQL Server 2012 credential in an accelerated format

 

Labs

Querying Microsoft SQL Server (M20461)

Lab 1: SQL Server 2014 Tools

Lab 2: Transact-SQL Querying

Lab 3: Write Basic SELECT statements

Lab 4: Query Multiple Tables

Lab 5: Sort and Filter Data

Lab 6: Work with SQL Server 2014 Data Types

Lab 7: Modify Data using DML

Lab 8: Built-In Functions

Lab 9: Group and Aggregate Data

Lab 10: Subqueries

Lab 11: Table Expressions

Lab 12: Set Operators

Lab 13: Use Window Ranking, Offset, and Aggregate Functions

Lab 14: Pivot and Group Sets

Lab 15: Execute Stored Procedures

Lab 16: Program with T-SQL

Lab 17: Implement Error Handling

Lab 18: Implement Transactions

Lab 19: Improve Query Performance

Lab 20: Query SQL Server Metadata

 

Administering Microsoft SQL Server Databases (M20462)

Lab 1: Use SQL Server Administrative Tools

Lab 2: Install SQL Server 2014

Lab 3: Manage Database Storage

Lab 4: Back Up SQL Server Databases

Lab 5: Restore SQL Server 2014 Databases

Lab 6: Import and Export Data

Lab 7: Monitor SQL Server 2014

Lab 8: Trace SQL Server Workload Activity

Lab 9: Manage SQL Server Security

Lab 10: Audit Data Access and Encrypting Data

Lab 11: Perform Ongoing Database Maintenance

Lab 12: Automate SQL Server Management

Lab 13: Monitor SQL Agent using Alerts and Notifications

 

Implementing a Data Warehouse with Microsoft SQL Server (M20463)

Lab 1: Exploring a Data Warehousing Solution

Lab 2: Planning Data Warehouse Infrastructure

Lab 3: Implementing a Data Warehouse

Lab 4: Implement Data Flow in as SSIS Package

Lab 5A: Implementing Control Flow in an SSIS Package

Lab 5B: Using Transactions and Checkpoints

Lab 6: Debugging and Troubleshooting an SSIS Package

Lab 7: Extracting Modified Data

Lab 8: Loading a Data Warehouse

Lab 9: Cleansing Data and Deduplicating Data

Lab 10: Implementing Master Data Services

Lab 11: Using Custom Scripts

Lab 12: Deploying and Configuring SSIS Packages

Lab 13: using a Data Warehouse