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.
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.
