SQL Server 2016 for Developers

Course duration: 4 days

Dates: 4th to 7th December 2017

Time: 9:30a.m. – 5:00p.m.

Training Company: Professional Training Solutions Limited

Location: Professional Training Solutions, Building 6500, Unit E, Cork Airport Business Park, Kinsale Road, Cork

Member fee: €680

Non-member fee: €1000

 

Book/request a place on this course

To book/request a place on this course please email Annette Coburn on skillnet@itcork.ie or phone on 086 0848704.

Description:

Whether you`re new to SQL or a more experienced developer, this course is a great start and an eye-opener on how much you`re missing out on in SQL. You will cover, how to create complex inner and outer joins, summary queries, and subqueries. What the different data types are and how to handle the common problems you run into with various types of data. How to use built-in functions or write your own to handle everyday challenges. You will also see the basics of database design and implementation using the Management Studio.

Prerequisites:

No particular programming experience is required, the course is taught from a developer`s perspective but it will also suit those new to relational databases and database technology.

An introduction to relational databases and SQL:

An introduction to client/server systems

An introduction to the relational database model

An introduction to SQL and SQL-based systems

The Transact-SQL statements

How to work with other database objects

How to use SQL from an application program

How to use the Management Studio:

An introduction to SQL Server 2016

An introduction to the Management Studio

How to manage the database files

How to view and modify the database

How to work with queries

How to view the documentation for SQL Server

How to retrieve data from a single table:

An introduction to the SELECT statement

How to code the SELECT clause

How to code the WHERE clause

How to code the ORDER BY clause

How to retrieve data from two or more tables:

How to work with inner joins

How to work with outer joins

Other skills for working with joins

How to work with unions

How to code summary queries:

How to work with aggregate functions

How to group and summarize data

How to summarize data using SQL Server extensions

How to code subqueries:

An introduction to subqueries

How to code subqueries in search conditions

Other ways to use subqueries

Guidelines for working with complex queries

How to work with common table expressions

How to insert, update, and delete data:

How to create test tables

How to insert new rows

How to modify existing rows

How to delete existing rows

How to merge rows

How to work with data types:

A review of the SQL data types

How to convert data

How to work with functions:

How to work with string data

How to work with numeric data

How to work with date/time data

Other functions you should know about

How to design a database:

How to design a data structure

How to normalize a data structure

How to create a database and its tables with SQL Statements:

An introduction to DDL

How to create databases, tables, and indexes

How to use constraints

How to change databases and tables

How to work with sequences

The script used to create the AP database

How to create a database and its tables with the Managment Studio:

How to work with a database

How to work with tables

How to generate scripts

How to work with views:

An introduction to views

How to create and manage views

How to use views

How to use the View Designer

How to code scripts:

An introduction to scripts

How to work with variables and temporary tables

How to control the execution of a script

Advanced scripting techniques

How to code stored procedures, functions, and triggers:

Procedural programming options in Transact-SQL

How to code stored procedures

How to code user-defined functions

How to code triggers

How to manage transactions and locking:

How to work with transactions

An introduction to concurrency and locking

How SQL Server manages locking

How to prevent deadlocks

How to manage database security:

How to work with SQL Server login IDs

How to work with permissions

How to work with roles

How to manage security using the Management Studio

How to work with XML:

An introduction to XML

How to work with the xml data type

How to work with XML schemas

Two more skills for working with XML

How to work with BLOBs:

An introduction to BLOBs

How to use SQL to work with a varbinary(max) column

A .NET application that uses a varbinary(max) column

How to use FILESTREAM storage

An introduction to CLR integration:

An introduction to CLR integration

How to use SQL to work with CLR objects

 

 

Book/request a place on this course

To book/request a place on this course please email Annette Coburn on skillnet@itcork.ie or phone on 086 0848704.