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
Module 1: Core Database Concepts
•Introduction to core database principles
•Defining databases
•Examples of relational database tables
•Overview of common database terminology
•Relational concepts
•Normalization
•Referential integrity
•Constraints
Module 2: Creating Database Objects
•Data types
•Data objects
•DML (Data Definition Language) Statements
•Script creation
Module 3: Manipulating Data
•Utilizing DML (Data Manipulation Language) Statements
•Implementing the SELECT statement
•Employing INSERT, UPDATE, and DELETE for data management
•Indexes
•Triggers
Module 4: Understanding Data Storage
•Table design
•Creating and modifying tables
•Viewing tables
•Deleting tables
Module 5: Database Administration
•SQL Server security
•Securing databases and objects
•Executing database backups
•Executing database restores
Requirements
Foundational knowledge of database concepts
35 Hours
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 6500 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (1)
Being human and talking to us as understandable possible
