New Pluralsight exam prep course: SQL Server: Understanding Database Fundamentals (98-364)

Tim’s latest Pluralsight course has been published: SQL Server: Understanding Database Fundamentals (98-364). It’s just over 2 hours long, and from the course description:

It is very common for databases to be part of a company’s I.T. infrastructure. In this course, SQL Server: Understanding Database Fundamentals (98-364), you will learn the information and skills necessary to pass the 98-364 exam. First, you will learn core database concepts around database structure and how data is stored, along with statements used to create objects and manipulate data. Next, you will discover database design concepts and relational integrity, plus the impact of primary, foreign, and composite keys. Finally, you will explore how to administer a database, including authentication methods, regular database maintenance, and how to back up and restore databases. When you are finished with this course, you will have the skills and knowledge to start creating and using databases, and to pass the 98-364 Understanding Database Fundamentals exam.

It’s very much a course for absolute beginners in databases, and is geared towards the 98-364 exam.

The modules are:

  • Introduction
  • Understanding Core Database Concepts
  • How to Create Database Objects
  • Manipulating Data
  • Understanding Data Storage
  • How to Administer a Database

Check it out here.

We now have more than 180 hours of SQLskills online training available (see all our courses here), all for as little as $29/month through Pluralsight (including more than 6,000 other developer and IT training courses). That’s unbeatable value that you can’t afford to ignore.



Spring 2020 classes in Chicago, early-bird through end of 2019

I’ve just released our Spring 2020 in-person classes in Chicago for registration!

They will be at our main event hotel as usual in Oakbrook Terrace, and all classes have an early-bird price that expires on 1/1/2020, with an extra $100 discount for past attendees. After 2019 ends, past attendees can register at the early-bird price.

The classes are:

  • IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1
    • April 27-May 1, taught by me and Kimberly
  • IE0: Immersion Event for the Accidental/Junior DBA
    • April 27-29, taught by Erin and Jonathan
  • IECAG: Immersion Event on Clustering and Availability Groups
    • April 30-May 1, taught by Jonathan
  • IEPTO2: Immersion Event on Performance Tuning and Optimization – Part 2
    • May 4-8, taught by me, Kimberly, Erin, and Jonathan
  • IEAzure: Immersion Event on Azure SQL Database, Azure VMs, and Azure Managed Instance
    • May 4-7, taught by Tim

You can get all the logistical, registration, and curriculum details by drilling down from our main schedule page.

We hope to see you there!

A month till our next live, online classes!

We have two live, online classes coming up in October and November that round out our training schedule for 2019. These class will be delivered live via WebEx over three days (roughly 12-13 hours of content including Q&As; about the same as two full workshop days!) and the attendees will have lifetime access to the recordings following the end of the class.

Rather than have people try to watch a full day of training at their computer for one of more days, the class will run from 10am to 3pm PST each day, with two 90-minute teaching sessions, each followed by Q&A, and a lunch break. We chose to do this, and to spread the class over a few days, so the times work pretty well for those in the Americas, Africa, and Europe. We also realize that this is complex content, so want to give attendees time to digest each day’s material, plus extensive Q&A.

The classes we have are:

  • IEVLT: Immersion Event on Very Large Tables: Optimizing Performance and Availability through Partitioning
    • October 29-31, taught by Kimberly
  • IECS: Immersion Event on Columnstore Indexes
    • November 12-14, taught by Jonathan

They’re US$495 each or US$395 for past attendees (email me for how to register).

You can get all the logistical, registration, and curriculum details by drilling down from our main schedule page.

We hope to see you there!