Course Overview

This DataShed SQL Server Administration course provides an introduction to performing various administrative tasks with Microsoft SQL Server 2016, along with practical examples. The course covers most aspects of SQL Server administration, including backup and recovery, the security model, and database maintenance. The course also covers several methods of accessing and manipulating data in the database using Integration Services, plus a rundown of the capabilities of the SQL Server Management Studio tool.

Course Itinerary

At completion of this course, participants should be able to:

  • Customise and use the Management Studio administration tool
  • Understand database components and SQL Server operation
  • Back up and restore databases
  • Choose an appropriate database recovery model and backup methodology
  • Automate administrative, maintenance and other tasks
  • Create and manipulate SQL objects including tables and views
  • Create and modify constraints, triggers, and indexes
  • Understand the SQL security model and the relationships between logins, users, roles and permissions
  • Create and automate custom data import / export processes.

Day 1

  • SQL Server Management Tools
  • Management SQL Instance and Database
  • Backup and recovery
  • SQL Server Agent.

Day 2

  • Creating / Modifying tables, views and constratints
  • Indexes, Query Optimiser and Execution Plans
  • Stored Procedures, User-defined functions, Triggers
  • The Query Window and the Query Designer
  • Security/Permissions – Logins, Users, Roles, Privileges.

Course Dates

Fremantle
Date TBA
Johannesburg
Date TBA
Vancouver
Date TBA

Course Overview

This DataShed Introductory SQL Queries course provides participants with the skills to create and execute various query tasks with Microsoft SQL Server 2016, along with practical examples. It is suitable for people who have no prior experience in using SQL. The course covers many aspects of writing practical SQL queries to enhance your data management system. It includes instruction on how to apply several expressions to make data interrogation more efficient.

Course Itinerary

At completion of this course, participants should be able to:

  • Customise and use the Management Studio administration tool
  • Understand database components and SQL Server operation
  • Understand the use of Expressions including;
    • Select
    • Join
    • Insert
    • Update
    • Delete
    • Output / Top.

Day 1

SQL Management Studio:

  • Features of the query window
  • Editing and executing queries
  • Browsing and saving results
  • Using the query designer.
Basic Expressions:

  • Expression Components
  • SELECT Queries.

Day 2

Expressions and Practical Application:

  • JOIN Queries
    • INNER / OUTER / CROSS Queries
  • More SELECTING
  • DISTINCT Queries
  • INSERT Queries
  • UPDATE Queries
  • DELETE Queries
  • OUTPUT & TOP Queries.

Course Dates

Fremantle
Date TBA
Johannesburg
Date TBA
Vancouver
Date TBA

Course Overview

This DataShed Advanced SQL Queries course provides participants with the skills to create and execute high level query tasks with Microsoft SQL Server 2016, along with practical examples. It is expected participants will have a good working knowledge and understanding of SQL Management Studio and basic SQL query writing. The course covers many aspects of writing practical high level SQL queries to even further enhance your data management system. It includes instruction on how to apply several expressions to make data interrogation more efficient.

Course Itinerary

At completion of this course, participants should be able to:

  • Understand and Implement the use of Expressions including
    • TOP
    • Advanced Joins
    • Sub-Queries
    • Dynamic SQL
  • Execute Plans
  • Transactions.

Day 1

  • TOP, Aggregate and Ranking Functions
  • Joins – Revision
  • Advanced Joins
  • Sub-Queries.

Day 2

  • Dynamic SQL
  • Execute Plans
  • Transactions
  • Review and Questions.

Course Dates

Fremantle
Date TBA
Johannesburg
Date TBA
Vancouver
Date TBA