Description
MS & Azure SQL for Cloud Computing is a custom-tailored session focused on solving customized training needs with MS & Azure SQL. Throughout the training, students will build custom MS & Azure SQL solutions using custom-built curriculums and methodologies. At the end of training, students will have developed bespoke solutions for work portfolios as well as improved technical skillsets in MS & Azure SQL and enhanced conceptional understandings of cloud computing.
Benefits
• Bespoke solutions for work portfolios
• Technical skillsets in SELECT, ORDER BY, WHERE, Aggregate Functions, GROUP BY, Joins, and Subqueries
• Conceptual understandings of querying data, sorting and filtering queries, aggregating data, combining tables, and nesting queries
• Live private trainings
• Continuous learning resources
Topics
1. Querying data using SELECT, DISTINCT, and CAST
2. Sorting and filtering queries using ORDER BY and WHERE
3. Aggregating data using COUNT, SUM, AVG, MAX/MIN, and GROUP BY
4. Combining tables using INNER JOIN, LEFT/RIGHT JOIN, and FULL JOIN
5. Nesting queries using Subqueries
Deliverables
• 60-min live private training via Google Meet
Requirements
• MS SQL Server & MS SQL Server Management Studio or Azure SQL Database
• MS Excel or Google Sheets (recommended)
• Private information secured during screensharing
Policies
• Scheduling Policy – Scheduling is in 60-min increments. Attendance will be charged in full at start of each 60-min increment.
• Cancellation Policy – Cancelled or Missed attendance without 24-hr notice will be charged in full and ineligible for rescheduling, exchange, or refund. Late arrival over 15-min will be considered Missed.
