Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Basic information about databases
- Database files, Database Client / Server
- Relational database management systems (RDBMS)
SQL Server versions and the differences between them
- Express, Standard, Enterprise
- Workgroup, Mobile , Developer
SQL Server Tools
- SQL Server Management Studio
- SQL Server Agent
Services in SQL Server
- Database Services
- Analysis Services
- Reporting Services
- Integration Services
Base system
- Master
- Model
- Msdb
- Tempdb
- Distribution
- Resource
Create a database
- The database files and their location
- File size and its growth
- Partitioning tables
Data Modification Language (DML)
- INSERT
- UPDATE
- DELETE
Data Definition Language (DDL)
Designing Tables
- Columns and Attributes
- Determine the type of data
- Indexes and Keys
Indexes
- Clustered Indexes
- Non-Clustered Indexes
- REBUILD vs. REORGANIZE
Creating a database application
Server-side programming
- Procedures
- Views
- Functions
- Triggers
Models play
- Simple
- Full
- Bulk logged
Backup
- Full
- Differential
- Transaction Log
Backup Strategies
- Strategy full copy of the database
- Strategy of full backups and transaction log
- The strategy of incremental database backup
- Strategy copy of the database files
Basic security and administration of SQL Server
Automation
- Maintenance Plan
- Jobs
Basic security and administration of SQL Server
- Server Roles
- Database Roles
- SA Account
- Creating Accounts
- Schemes
High Availability
- Log Shipping
- Database Mirroring
- Server Clustering
Replication
- Snapshot Replication
- Transactional Replication
- Merge Replication
Activity Monitor SQL Server
- SQL Server Profiler
Upgrade
- In-Place vs. Side-By-Side
- Service-Pack
- Cluster
Best Practices
Requirements
Knowledge of computer and Windows operating system
21 Hours
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €6840 online delivery, based on a group of 2 delegates, €2160 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Testimonials (6)
The instructor brought his A game again as he superbly took my staff through the customized training with expert timing, knowledge, support, and rapport with my staff.
James - Shawnee Mission School District
Course - Administering in Microsoft SQL Server
Trainer was knowledgeable and personable
Matthew - Shawnee Mission School District
Course - Administering in Microsoft SQL Server
Shane was very personable and related the information in a way that was easy to understand.
Matthew - Shawnee Mission Schools
Course - Administering in Microsoft SQL Server
Well prepared trainer open for additional questions of any kind at any time
Thomas Griffig - MTU Aero Engines Polska Sp. z o. o.
Course - Administering in Microsoft SQL Server
The exercises and hands-on activity
Raymund Libre - SYKES Asia, Inc.
Course - Administering in Microsoft SQL Server
the in depth knowledge and customize approach
