DeepDive T-SQL Fundamentals: How to Start with Database Querying

DM-SQLDDTT-EN

Introduced in SQL Server 2016

}

Duration: 8 hours

Level: 300

What does this course cover?

You want to start querying database tables? Then you are right here! Learn the basic and fundamentals each higher knowledge about T-SQL and database development is built upon. Basically the basic of the basics of T-SQL.

Pre-requisites: What do you need to know?

None at all

“I started from here and it was a great start!”

Karel Prochazka

Developer, Prague

WHEN and WHERE is this course running?

Course outline

Key Topics:

Background to T-SQL Querying and Programming

  • Theoretical Background
  • SQL Server’s Architecture
  • SQL Server Management Studio
  • Creating Tables
  • Defining Data Integrity
  • Sample Database

Single-Table Queries

  • Elements of SELECT Statement
  • Predicates and Operators
  • CASE Expressions
  • NULLs
  • All-At-Once Operations
  • Working with Character Data
  • Working with Date and Time Data
  • Querying Metadata

All our courses can be offered as a private delivery and tailored for your team's specific needs

Contact us

WHEN and WHERE is this course running next?

Check dates