Course Outline
Introduction
Setting Up and Configuring Microsoft SQL Server
Key Features of Microsoft SQL Server
Introduction to Transact-SQL Concepts
Retrieving Data using the SELECT Statement
Filtering Records with the WHERE Clause
Arranging Output with ORDER BY
Combining Data from Multiple Tables via Joins
Organizing Data with GROUP BY
Applying Aggregate Functions for Data Calculations
Filtering Aggregated Results with HAVING
Creating a New Database Instance
Exploring the Database Model
Improving Database Structure through Normalization
Advancing Query Capabilities with Procedures
Developing Functions and Sub-routines
Managing Logic Flow with Conditional Statements
Linking Excel to Microsoft SQL Server
Troubleshooting Common Issues
Recap and Final Thoughts
Requirements
- No prior experience with SQL or database systems is necessary.
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 4800 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (4)
data was personalised to our organisations
Vincent Long - ASSMANG PTY LTD
Course - T-SQL Fundamentals with SQL Server Training Course
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
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
The lecture about cte
