Course Outline
Introduction
Installing and Configuring Microsoft SQL Server
Overview of Microsoft SQL Server Features
Overview of Transact-SQL Concepts
Querying a Database using SELECT
Filtering the Data with WHERE
Sorting the Data with ORDER BY
Querying Multiple Tables with Joins
Grouping Data with GROUP BY
Using Aggregate Functions to Perform Calculations on Resulting Data
Filtering Groups with HAVING
Creating a New Database
Understanding the Database Model
Optimizing the Database through Normalization
Enhancing your Queries with Procedures
Writing Functions and Sub-routines
Using Conditions to Control the Flow
Connecting to Microsoft SQL Server through Excel
Troubleshooting
Summary and Conclusion
Requirements
- NO previous SQL or database experience is required.
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 (5)
The curriculum was complete both theoretically and practically
Marlene Rodriguez - NAZAN COMERCIALIZADORA DE CALZADO
Course - SQL Server Management Studio (SSMS) Administration
Machine Translated
The practical examples, which already had more realistic information prepared in the database.
Enrique Pruneda Sandoval - GEODIS
Course - SQL language in MSSQL
Machine Translated
Being human and talking to us as understandable possible
Sorin
Course - Database Administration Fundamentals for MS SQL Server
All the various ways Darius explained concepts and then put them into our database tables.
James Rodi - Medtech Limited
Course - T-SQL Fundamentals with SQL Server Training Course
It allowed us to have an applied hands on sproc to our company database.
