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

Omaha SSUG – May 2016 Meeting

Our next SQL user group meeting with be on Tuesday, May 10th.

We will have an open topic night. Since we haven’t met in quite a while, it will be a good time to just socialize and catch up with what’s going on in the community as well as the database world.

We will be meeting at Blue Cross and Blue Shield of Nebraska, 1919 Aksarben Drive.

Food will be served around 5:45 PM and we will start at 6 PM.

RSVP Today!

Omaha SSUG – January 2016

Our next Omaha SQL/BI User Group meeting will be Wednesday, January 20th, 2016 at 6PM. We will be sponsored by Blue Cross and Blue Shield of Nebraska and we will be located at BCBSNE, 1919 Aksarben DR, Omaha NE 68180.

Our January 2016 speaker will be you, the members of the Omaha SSUG!

The Topic:

BYOSP! (Bring Your Own SQL Problem!)

Synopsis:

Having problems with SQL Server? Bring the issue to the meeting! Can get that report just right? Bring the issue to the meeting! Your cube not slicing & dicing the way that you want? Bring the issue to the meeting! Need clarification on a SQL Server feature? Bring it to the meeting! Don’t have anything but want to help out your fellow IT person? Bring yourself to the meeting!

Nothing is out of bounds for this meeting. We’ll take a list of topics from the members and we’ll use the collective brain power of those present to try to get you pointed in the right direction and/or even present a solution to you!

We’ll have a facilitator and access to a test SQL Server so that we can test some of the questions out on.

So bring your laptops, your questions, and your willingness to speak up and help another!

Food will be provided about 15-20 minutes prior to the start of the meeting. Register today to let us know you’re coming and to be eligible for a chance to win some great SWAG!

Registration Link: http://omahamtg.com/Event/Details/225

SQL Saturday Pre-Cons – Registration now open!

Registration is now open for the three pre-con sessions we are holding on Friday, August 14th at UNO’s Mammel Hall – 6708 Pine ST, Omaha, NE 68106.

We have three great sessions:

  • Ed Leighton-Dick: SQL Server Security Master Class
  • Mike Fal: Introduction to Powershell
  • Dandy Weyn: Power BI

The cost to attend a session is $129 and it will be from 8 AM to 5 PM.

Register today! http://www.eventbrite.com/e/sql-saturday-omaha-pre-cons-tickets-17823195658?aff=omahasql

Or register directly below:

[xyz-ihs snippet=”SQL-Saturday-Omaha-397-Pre-Con-Registration”]

 

 

Omaha SSUG – July 2015 – SQL Server Databaseology

UPDATE – John has provided his slide and scripts here: http://www.omahasql.com/sql-user-group/omaha-sql-user-group-july-8th-2015/

Our next meeting is Wednesday, July 8th, 2015 at 6PM. We will be meeting at Farm Credit Services of America. (Food will be served 20-30 minutes ahead of time.) We are looking forward to seeing you there!

Speaker – John Morehouse (@SqlrUs)
John Morehouse is currently a Database Architect with Farm Credit Mid-America out of Louisville, KY. He is a blogger, avid tweeter, and a frequent speaker at SQL Saturday’s as well as other conferences. He is also heavily involved with the Professional Association of SQL Server (PASS) . In his spare time, you can usually find John reading up on SQL Server topics as well as chasing his two young sons around the house.

Abstract
Have you ever taken apart a toaster or an alarm clock just to see how it worked? Ever wondered how that database actually functions at the record level, behind the scenes? SQL Server Databaseology is the study of SQL Server databases and their structures down to the very core of the records themselves. In this session, we will explore some of the deep inner workings of a SQL Server database at the record and page level. You will walk away with a better understanding of how SQL Server stores data and that knowledge that will allow you to build better and faster databases.

RSVP Today: http://www.omahamtg.com/Event/Details/214

Omaha SSUG – June 2015 – Migrating to the Cloud

Our next meeting is Wednesday, June 3rd, 2015 at 6PM. We will be meeting at Blue Cross and Blue Shield of Nebraska (1919 Aksarben DR, Omaha, NE 68106). (Food will be served 20-30 minutes ahead of time.) We are looking forward to seeing you there!

Speaker – Sudhir Gajre
Sudhir has over 20 years of experience in the Data Management and the Analytics field. He spent the last 14 years at Microsoft where he was a Data Architect and later a Principal Technologist. He has authored SQL Server performance tuning whitepapers, designed VLDB and Highly Scalable SQL Server Architectures, and led technical teams. He is a frequent speaker at conferences and SQL Saturdays and is a recognized expert in the Data Management field. He currently works for DB Best Technologies, a Gold Partner of Microsoft in the Data Platform where he is a Director of Data Services and Cloud and is responsible for managing and running the Central US business for the company.

Abstract
IaaS, PaaS, SaaS, Storage, Hybrid etc. etc. are you confused? If you are, that’s ok. In this session I explore the different capabilities that are available to migrate on-prem workloads to the cloud. I discuss what workloads are more conducive to a cloud migration and how you can determine the ‘low hanging fruit’. I will walk you through a framework I developed to examine all the dependencies that you need to understand and evaluate before migrating to the cloud. I will also lead you through various migration options and architectures that are being commonly deployed in the cloud.

RSVP Today: http://omahamtg.com/Event/Details/211

Omaha SSUG – April 2015 – BYOSP! (Bring Your Own SQL Problem!)

Our next Omaha SQL/BI User Group meeting will be Wednesday, April 1st, 2015 at 6PM. We will be sponsored by TEKSystems and hosted by Blue Cross and Blue Shield of Nebraska, 1919 Aksarben DR, Omaha NE 68180.

Our April 2015 speaker will be you, the members of the Omaha SSUG!  After last year’s highly successful event, we’re bringing it back!

The Topic:

BYOSP! (Bring Your Own SQL Problem!)

Synopsis:

Having problems with SQL Server? Bring the issue to the meeting!
Can get that report just right? Bring the issue to the meeting!
Your cube not slicing & dicing the way that you want? Bring the issue to the meeting!
Need clarification on a SQL Server feature? Bring it to the meeting!
Don’t have anything but want to help out your fellow IT person? Bring yourself to the meeting!

Nothing is out of bounds for this meeting. We’ll take a list of topics from the members and we’ll use the collective brain power of those present to try to get you pointed in the right direction and/or even present a solution to you!

We’ll have a facilitator and access to a test SQL Server so that we can test some of the questions out on.

So bring your laptops, your questions, and your willingness to speak up and help another!

Food will be provided about 15-20 minutes prior to the start of the meeting. Register today to let us know you’re coming and to be eligible for a chance to win some great SWAG!

Registration Link: http://omahamtg.com/Events.aspx?ID=273

PASS – Business and Data Analytics Training Webinars

Do you want some expert-led webinar training content to keep you busy this weekend?

This month PASS held a Business Analytics Webinar Marathon as a sneak preview to the April Conference and the sessions are available right now on the website for free:

There’s new content added weekly so check back for more free learning!

Interested in accelerating your career with more BA training? Use our Chapter’s Unique Discount Code LABA18 for $150 off the registration rate for the PASS Business Analytics Conference taking place April 20-22, 2015 in Santa Clara, CA – you can share this code with your friends and colleagues too!

Omaha SSUG – March 2015 – Building and Managing SQL Server Availability Groups

Our next meeting is Wednesday, March 4th, 2015 at 6PM. We will be meeting at Blue Cross and Blue Shield of Nebraska. (Food will be served 20-30 minutes ahead of time.) We are looking forward to seeing you there!

Speaker – David Klee
David Klee, Microsoft MVP and VMware vExpert, is a SQL Server performance and virtualization expert. David spends his days handling performance and HA/DR architecture of physical and virtualized critical SQL Servers as the Founder of Heraflux Technologies. His areas of expertise are virtualization and performance, datacenter architecture, and risk mitigation through high availability and disaster recovery. You can read his blog at davidklee.net, and reach him on Twitter at @kleegeek.

Abstract
Have you heard and read everything around SQL Server AlwaysOn Availability Groups but never seen or used it in action? This interactive session from David Klee is going to show you how to build and manage Availability Groups from start to finish – live! Bring your questions and scenarios and let’s build some Availability Groups.

RSVP Today: http://omahamtg.com/Events.aspx?ID=267