SQL NULL Pitfalls: Why NOT IN Returns Zero Results and 3 Points Where MySQL and Oracle Behaviors Diverge

Introduction"I want to list customers who haven't ordered, but I get zero results," or "The count doesn't match when I ...

[Database Series 07] Understand Indexes! Why the Same SQL Can Have Vastly Different Search Speeds

The theme for this session is database "indexes".Indexes are one of the technologies you absolutely must understand when ...
learn

Lesson 1: Create and query database objects

This lesson shows you how to create a database, create a table in the database, and then access and change the data in the table. Because this lesson is an introduction to using Transact-SQL, it doesn ...
learn

Create a database schema

To create a schema, you must have CREATE SCHEMA permission on the database. To specify another user as the owner of the schema being created, the caller must have IMPERSONATE permission on that user.