About the course:
Learn to develop commercial SQL Server database applications
Our SQL Server Programming training course gives delegates a solid introduction to developing secure, robust commercial database applications incorporating Transact-SQL, Stored Procedures and XML.
Microsoft SQL Server combines power with scalability, and is at the heart of a huge number of the world's CRM, ERP, CMS and e-commerce systems, and has solid support for deployment in the Cloud through Microsoft's Azure platform.
Please let us know if you require this training on SQL Server 2008, SQL Server 2012, or SQL Server 2014 as we are happy to deliver custom courses on previous versions.
By the end of this course, you will have learnt:
- Create robust and well-optimised databases in SQL Server 2016
- Write SQL queries and Stored Procedures to manipulate data
- Learn SQL Server Management Studio Best Practises
- Creating tables and constraints
- Replicating data between multiple databases
- Disaster Recovery strategies
- Overview of Microsoft Business Intelligence with Reporting Services
Who should attend
This course is aimed at anyone who needs to gain hands-on experience with SQL Server, creating commercial database solutions with T-SQL, XML and Stored Procedures
Prerequisites
Delegates will ideally have some experience of writing basic SQL queries in a Relational Database such as Access or MySQL.
On-site
If you are interested in custom / on-site SQL Server Programming training for any size of team, please get in touch – we would be glad to help build a course that meets your learning requirements.
We can take into account your existing technical skills, project requirements and timeframes, and specific topics of interest to tailor the most relevant and focussed course for you.
This can be particularly useful if you need to learn just the new features and SQL Server Programming Best Practices, or need to include extra topics to help with pre-requisite skills.
We can also base custom courses on SQL Server 2008, SQL Server 2012, or SQL Server 2014 if that is your current production environment.
SQL Server Programming Course Syllabus
Introduction to SQL Server 2016 Architecture
- Client / Server modelSQL Server Management Studio
- Business Intelligence Development Studio
- Database schemas
- Integrating with .NET CLR
- Windows / .NET Authentication
- Creating a database
- Files and Directories
- Parameters and options
- Filegroups
- SQL Server Database Schemas
TSQL Features
- WithResultsSet
- Throw / Catch (Error Handling)
- Offset and Fetch
- Sequence
Tables and Data Types
- Pre-configured Data Types
- Creating custom Data Types
- Handling columns
- Table Partitions
- Indexing tables
Constraints and Triggers
- Primary keys
- Validation
- Foreign keys
- Triggers
Server-Side Programming with Transact-SQL
- SQL statements in Query Designer
- Joining multiple tables
- INSERT, UPDATE, DELETE
Stored Procedures
- Efficiency Benefits of using Stored Procedures
- Creating and deploying new Stored Procedures
- Maintaining existing Stored Procedures
- AFTER Triggers
SQL Server and XML
- Storing and Retrieving XML
- Intro to XQuery
- XML Native Data Types
- XML Schemas and Indexes
Administration Essentials for Developers
- Monitoring SQL Server
- Roles and user memberships
- Security policy
- Maintenance Plan Wizard
- Scheduling backups Checking database integrity
- Defragmenting data
- Notification Services / Management Reports
- Replication - Snapshot / Transactional / Merge