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
Testimonials (5)
database optimization, dedicated approach, ability to ask questions, insight/assessment of our database
Aleksandra Czyndacka - Mikrobit
Course - Administering in Microsoft SQL Server
Machine Translated
Discussing your own database :D
Przemysław - Mikrobit
Course - Administering in Microsoft SQL Server
Machine Translated
Extensive knowledge and clear way of translating
Kamil Wróblewski - Mikrobit
Course - Administering in Microsoft SQL Server
Machine Translated
Contact from the instructor, explanation of all issues, exercises
Dariusz
Course - Administering in Microsoft SQL Server
Machine Translated
Lots of examples, interesting programming facts, practical approach.
Łukasz - Mitsubishi Electric Europe B.V. (Sp. z o.o.)
Course - Administering in Microsoft SQL Server
Machine Translated