Course Outline
Introduction <\/p>
Installing and Configuring Microsoft SQL Server <\/p>
Overview of Microsoft SQL Server Features <\/p>
Key Concepts of Transact-SQL <\/p>
Database Querying with SELECT <\/p>
Data Filtering using WHERE <\/p>
Sorting Data with ORDER BY <\/p>
Querying Multiple Tables via Joins <\/p>
Organizing Data with GROUP BY <\/p>
Performing Calculations on Results Using Aggregate Functions <\/p>
Filtering Groups with HAVING <\/p>
Creating a New Database <\/p>
Understanding the Database Model <\/p>
Database Optimization through Normalization <\/p>
Enhancing Queries with Procedures <\/p>
Writing Functions and Sub-routines <\/p>
Controlling Flow with Conditional Statements <\/p>
Connecting to Microsoft SQL Server through Excel <\/p>
Troubleshooting Common Issues <\/p>
Summary and Conclusion <\/p>
Requirements
- No prior experience with SQL or databases is necessary. <\/li> <\/ul>
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
