Creating Databases in SQL Server
Duration: 2 Days
Objectives
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.
Pre-requisites
Delegates should have knowledge to the level of that provided by our Relational Database Design course.
Course includes
A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.
Course outline
Introduction to Business Intelligence
- OLTP databases
- OLAP databases
- Data Warehouses
- SSIS ETL, SSRS and SSAS
Introduction to PowerPivot and Analysis Services Tabular Mode
- What Is PowerPivot?
- PowerPivot Deployment Options
- Self-Service Business Intelligence (SSBI)
- Differences between SSAS Tabular Mode and Multidimensional
- Power Pivot Data Models
- Pivot Tables and Charts
A First Look at Tabular BISM
- Using Visual Studio and working with Projects
- The Tabular Designer
- Importing Data
- Relationships
- Calculations
- Browsing Models
- Modelling and Deploying
- Administering Tabular Models with SSMS
Enhancing Your Tabular BISM
- Refining the Tabular Model
- Hierarchies
- Measures
- KPIs
- Perspectives
- Partitions
- Processing a Tabular Database
- Creating and Applying Security Roles
Introduction To DAX
- DAX Fundamentals
- DAX Operators
- DAX Functions
- DAX as a Query Language
Advanced Topics in DAX
- Parent-Child Hierarchies
- Cross Filtering with Many-to-Many Relationships
- Multiple Relationships Between Tables
- Time Based Analysis
- Non-Aggregatable Columns
Analysing Tabular BISMS in Excel
- Pivot Tables
- Sheet Data Reports
- Pivot Charts
- Local Cubes
- Excel Services
Reporting on Tabular Models with SSRS
- PowerPivot
- PowerPivot Add-In for Excel
- PowerPivot data model
Course Dates
Location: just outside London
| All our courses can be tailored to requirements at your own offices. For alternative dates, please email or call us on 0208 269 4260 |
| All prices are per person and are subject to VAT |
|
15% discount for groups of four delegates.
10% discount for groups of three delegates. (This offer applies for delegates on the same public scheduled course on the same date.) |
"Amazing! Looking forward to the follow-up course!"
MOD
"I thought the course and the location were perfect."
MOD
"I am writing to say thank you for organising my FileMaker training day; I learned so much with my trainer, Nick, and have come away with such a great database. It delighted both the Director and my job share partner. I feel I have left with a great amount of knowledge that can help the business immensely. I learned more than I thought I would and would like to thank Transmedia for being so helpful!"
Lucie Mills
