O'Reilly logo
live online training icon Live Online training

Getting Started with SQL Server

Managing and querying SQL Server databases

Ami Levin

For more than 20 years, SQL Server has been the platform of choice of numerous organizations, from small shops to the largest enterprises on the planet, for managing their data assets. SQL Server 2019 offers unprecedented features and scalability, both on-prem and in the cloud, using cutting-edge technologies, limitless flexibility, and a unique vision among all database providers.

This online training is intended for anyone who is starting his/her journey with SQL Server and needs to be able to perform basic management tasks and write and execute T-SQL queries.

This practical, hands-on training will arm you with the basic skill set to manage databases and objects; insert, modify, and query data; and establish a solid foundation to continue your journey to SQL and relational database mastery.

What you'll learn-and how you can apply it

By the end of this live, hands-on, online course, you’ll understand:

  • SQL Server basic architecture and tooling
  • What’s new to SQL Server 2019
  • T-SQL query fundamentals

And you’ll be able to:

  • Setup and connect to local and cloud SQL Server environments
  • Create, backup, and restore databases
  • How to create and manage tables, use T-SQL to insert and modify data, and query it efficiently

This training course is for you because...

  • You are a developer, data analyst, or an IT practitioner with little or no experience with SQL Server
  • You need to be able to use and query SQL Server databases

Prerequisites

  • Previous exposure to SQL useful but not required

Recommended preparation:

Recommended follow-up:

About your instructor

  • Ami Levin is a seasoned trainer, data architect, database designer, and SQL wizard with over 25 years of experience.

Schedule

The timeframes are only estimates and may vary according to how the class is progressing

SQL Server Databases, and Objects (1 hour)

  • Lecture: SQL Server Architecture
  • Demonstration: Installation walkthrough; Connecting to local and cloud instances; Using SSMS, Azure Data Studio, and SQLCMD
  • Exercise:Connect to a shared cloud SQL Server and run a query
  • Lecture: Creating and Managing Databases
  • Exercise:Creating and configuring databases
  • Lecture: Accessing SQL Server Objects
  • Exercise: Creating logins and users; Assigning permissions
  • Q&A
  • Break (5 Minutes)

Creating Tables (1 Hour)

  • Lecture: CREATE, ALTER, and DROP TABLE
  • Exercise:Create, modify, and delete tables
  • Lecture: Column and Table Constraints
  • Exercise: Create and modify constraints
  • Lecture: Data Types
  • Demonstration: Data Types
  • Exercise: Create and modify column types
  • Q&A
  • Break (5 Minutes)

Modifying and Retrieving Data (1 Hour)

  • Lecture: Using INSERT, UPDATE, and DELETE
  • Exercise: Using INSERT, UPDATE and DELETE
  • Lecture: Understanding SELECT and Query Processing Order
  • Demonstration: Following query processing order
  • Lecture: T-SQL JOIN fundamentals
  • Demonstration: Basic Join techniques
  • Exercise: Joining 2 tables
  • Lecture: Filtering, Aggregating and Limiting Result Sets
  • Demonstration: Using WHERE, GROUP BY and OFFSET-FETCH
  • Exercise: Using WHERE and GROUP BY
  • Q&A
  • Break (5 Minutes)

Using T-SQL Supporting Objects and Functions (1 Hour)

  • Lecture: SQL Server Indexes
  • Demonstration: Creating and using indexes
  • Exercise: Create an index
  • Lecture: Commonly used Operators and Functions (20 Minutes)
  • Demonstration: Using common operators and functions
  • Exercise: Write a query that use operators and functions
  • Lecture: Views, Stored Procedures, Triggers, and Functions
  • Demonstration: Creating and using programming objects
  • Exercise: Create a trigger
  • Q&A