office (678) 325-7317
fax (678) 325-7317
SQL Server for Developers (2016 or 2012 Version)

Course Length: 5 days or two 3 day classes


Section 1: An introduction to SQL
In this section, you’ll learn the concepts and terms you need for working with any database. You’ll also learn how to use Microsoft SQL Server 2016 and the Management Studio to run SQL statements on your own PC.

Section 2: The essential SQL skills
In this section, you’ll learn all the skills for retrieving data from a database and for adding, updating, and deleting that data. These skills move from the simple to the complex so you won’t have any trouble if you’re a SQL novice. And they present skills like using outer joins, summary queries, and subqueries that will raise your SQL expertise if you already have SQL experience.

Section 3: Database design and implementation
In this section, you’ll learn how to design a database and how to implement that design by using either SQL statements or the Management Studio. When you’re done, you’ll be able to design and implement your own databases. But even if you’re never called upon to do that, this section will give you the perspective that will make you a better SQL programmer.

Section 4: Advanced SQL skills
In this section, you’ll learn the skills for working with database features like views, scripts, stored procedures, functions, triggers, cursors, and transactions. You’ll also learn how to manage database security, and optionally you’ll learn how to use the features for working with XML and BLOB data. These are the features that give a database management system much of its power.

Who Should Attend?

Application developers
I think it’s fair to say that most developers don’t know enough about SQL and the database management system they’re using. As one customer put it, "I know just enough about SQL Server to be a little bit dangerous!" That’s why developers often code SQL statements that don’t perform as efficiently as they ought to. That’s why they aren’t able to code some of the queries that they need for their applications. And that’s why they don’t take advantage of all the features that SQL Server has to offer. That’s also why this course will benefit most application programmers who use SQL Server.

Anyone who wants to become a database administrator
This course is also the right first course for anyone who wants to become a database administrator. Although this course doesn’t present all of the skills that are needed by a DBA, it will get you started. Once you’ve finished it, you’ll be prepared for more advanced courses on the subject.

Anyone who wants to learn standard SQL
SQL is a standard language for accessing database data. So most of the SQL code in this course will work with any database management system. As a result, once you use this course to learn how to use SQL to work with a SQL Server database, you can transfer most of what you have learned to another DBMS such as Oracle, DB2, or MySQL.

What the prerequisites are
Although you will progress through this course more quickly if you have some development experience, everything you need to know about databases and SQL is presented in this course. As a result, you don’t need to have any programming background to use this course to learn SQL.

Course Outline

Section 1 An introduction to SQL

Module 1 An introduction to relational databases and SQL

Module 2 How to use the Management Studio

Section 2 The essential SQL skills

Module 3 How to retrieve data from a single table

Module 4 How to retrieve data from two or more tables

Module 5 How to code summary queries

Module 6 How to code subqueries

Module 7 How to insert, update, and delete data

Module 8 How to work with data types

Module 9 How to work with functions

Section 3 Database design and implementation

Module 10 How to design a database

Module 11 How to create a database and its tables with SQL Statements

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

Section 4 Advanced SQL skills

Module 13 How to work with views

Module 14 How to code scripts

Module 15 How to code stored procedures, functions, and triggers

Module 16 How to manage transactions and locking

Module 17 How to manage database security

Module 18 How to work with XML

Module 19 How to work with BLOBs

Home | AboutUs | Training | Mentoring | Contact Us

© 2008 Dunn Training Inc. All Rights Reserved.