catraining

 

Microsoft Partner

Developing SQL Queries with SQL Server Management Studio (SSMS)

Audience: This course is designed for those who are new to SQL (Structured Query Language) Server and want to understand the basics for extracting data from SQL Server Databases. This includes an overview of the capabilities of SQL Server Management Studio (SSMS), creating single table and multiple table queries, and discussing the different join types and how those joins will affect the data that is being extracted. You will also learn insert, update and deleting data, and how to aggregate data.

Duration: 1 day Course Types: Group bookings, public courses; 1-2-1 sessions, bespoke tailored courses.

 

Course Location: This training course can be delivered at our training centre or at your offices. Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

reaining course

 

After completing this course, students
will be able to:
    • • Understand database fundamentals
      • • Build and examine a database diagram/schema
      • • Differentiate between Primary and Foreign keys
      • • Create databases using SSMS and SQL
      • • Extract Data using the SSMS graphical tools and SQL
      • • Fully understand the SELECT statement syntax
      • • Use all constituent parts of the SELECT statement
      • • Join to other tables to extract normalised data
      • • Implement INNER and OUTER joins
      • • Understand the Self Join and Cross Join
      • • Add new records with the INSERT statement
      • • Alter existing data with the UPDATE statement
      • • Remove existing records with the DELETE statement

  • Course Outline
    print this page
    Module 1: Getting Started with SSMS

    • The role of SQL

    • Database fundamentals

    • The example database

    • Becoming familiar with SSMS

     
    Module 2: Single Table Select Statements

    • Understand the SELECT statement

    • Sorting the results with ORDER BY

    • Filtering the results with WHERE

    • Using SSMS to extract data

     
    Module 3: Multi-Table Queries

    • Selecting data with the INNER JOIN

    • Extracting data with OUTER JOIN

    • Understand how NULL affects your data

    • Visualise a SELF JOIN

    • Discuss the CROSS JOIN

     
     

     

     
     
     
    Module 4: Implement Action Queries

    • Create new records with the INSERT statement

    • Modify existing data with the UPDATE clause

    • Remove existing rows with DELETE

     
    Module 5: Aggregating Data

    • Utilising aggregates

    • SUM

    • AVG

    • MIN and MAX

    COUNT

    • Removing duplicates with DISTINCT

    • How NULL affects your results

    • GROUP BY

    • HAVING

     
    Module 6: Nested Queries

    • Correlated vs Non-correlated subqueries

    • Subqueries in the FROM clause Subqueries in the column list

     
      Microsoft

Call us now for further information Tel:08001601666