Course Outline
Introduction
Installing and Configuring Microsoft SQL Server
Overview of Microsoft SQL Server Features
Transact-SQL Concepts Overview
Database Querying with SELECT
Data Filtering Using WHERE
Data Sorting with ORDER BY
Multi-Table Queries via Joins
Data Grouping with GROUP BY
Applying Aggregate Functions for Data Calculations
Group Filtering with HAVING
Database Creation
Understanding the Database Model
Database Optimization through Normalization
Query Enhancement with Procedures
Developing Functions and Sub-routines
Controlling Flow with Conditions
Excel Connectivity to Microsoft SQL Server
Troubleshooting
Summary and Conclusion
Requirements
- No prior experience with SQL or databases 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
