Creating Databases in SQL Server

Delegates attending this course will cover start to finish creation of SQL Server relational databases. They will be introduced to all 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. This course, along with the SQL Server Database Querying and Advanced SQL Server Database Querying Courses, helps to prepare delegates for the Microsoft 70-461 exam: Querying Microsoft SQL Server 2012/2014/2016 and exam 70-762: Developing SQL Databases (M20762), which credit towards MCSA and MCSE certifications. It should be noted, however, that all course attendances should be complemented by reference to the skills measured by the exam, a period of self-study and test exams before sitting the actual exam. Covers SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014,and SQL Server 2016.

Introduction to Business Intelligence

Introduction to PowerPivot and Analysis Services Tabular Mode

A First Look at Tabular BISM

Enhancing Your Tabular BISM

Introduction To DAX

Advanced Topics in DAX

Analysing Tabular BISMS in Excel

Reporting on Tabular Models with SSRS


London Greenwich

Thursday 07 to Friday 08 June 2018


Book Now


Programming courses

Sql courses

Database courses