Creating Databases in SQL Server

Learn how to create a database in SQL Server on-premise or Azure SQL Database

Delegates attending this course will cover start to finish creation of SQL Server relational databases.

Develop your SQL Database Creation Skills

This course will introduce you to using the SQL language to create a database, tables and associated database objects such as constraints and indexes.

• SQL Data Definition Language (DDL) statements, and will create database storage, tables, data integrity constraints, and indexes.

The course is aimed at Database Administrators and Database Developers/Database Designers who will need to create a new database from scratch or will be responsible for maintaining database storage, structures, schemas and design for existing databases on a SQL Server platform.

Covers SQL Server 2012, SQL Server 2014, SQL Server 2016 and SQL Server 2017, 2019, Azure SQL Database.

SQL Training Tailored to Your Needs

All of our SQL training courses are offered in a UK based face to face classroom or virtual setting and can be tailored to your needs. Having difficulty with something specific? Let us know and we can focus your training to make sure you learn everything you need to push your SQL solution forwards.

Follow our SQL Learning Path

Once your database is created and data added you will want to learn how to extract and analyse your database data. The next step in your training journey might be as follows:

Introduction to SQL - learn about the SELECT statement

Advanced SQL -learn to write complex data extraction and transformation SQL queries

Transact SQL - learn the powerful TSQL scripting language to assist with automating complex data transformation tasks

Delegates should have knowledge to the level of that provided by the PTR Relational Database Design course.