SQL Server Training Overview
Accelebrate's Introduction to SQL Server course teaches developers the skills they need to successfully automate data in SQL Server 2016.
Location and Pricing
Accelebrate offers instructor-led enterprise training for groups of 3 or more online or at your site. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for private corporate training on-site or online, please contact us.
In addition, we offer some courses as live, instructor-led online classes for individuals.
Objectives
- Use Microsoft SQL Server 2016 and the Management Studio to run SQL statements
- Retrieve data from a database and insert, update, or delete that data
- Use outer joins, summary queries, and subqueries
- Work with data types and functions
- Design a database and implement that design by using either SQL statements or the Management Studio
- Build views, scripts, stored procedures, functions, and triggers
- Use transactions to ensure the atomicity of multistep operations that modify your database data
- Manage database security
- Work with XML and BLOB data
- Incorporate C# and Visual Basic programming logic directly into your database using CLR (Common Language Runtime) integration
Prerequisites
No prior experience is presumed.
Outline
Expand All | Collapse All
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
Using 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
Retrieving 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
Retrieving 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
Coding Summary Queries
- How to work with aggregate functions
- How to group and summarize data
- How to summarize data using SQL Server extensions
Coding 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
Inserting, Updating, and Deleting 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
Working With Data Types
- A review of the SQL data types
- How to convert data
Working 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
Designing a Database
- How to design a data structure
- How to normalize a data structure
Creating 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
Creating a Database And Its Tables With The Management Studio
- The script used to create the AP database
- How to work with tables
- How to generate scripts
Working With Views
- An introduction to views
- How to create and manage views
- How to use views
- How to use the View Designer
Coding Scripts
- An introduction to scripts
- How to work with variables and temporary tables
- How to control the execution of a script
- Advanced scripting techniques
Coding 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
Managing Transactions And Locking
- How to work with transactions
- An introduction to concurrency and locking
- How SQL Server manages locking
- How to prevent deadlocks
Managing 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
Working 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
Working 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
Conclusion
Training Materials
All SQL Server 2016 training students receive a copy of Murach’s SQL Server 2016 for Developers.
Software Requirements
Attendees will not need to install any software on their computer for this class. The class will be conducted in a remote environment that Accelebrate will provide; students will only need a local computer with a web browser and a stable Internet connection. Any recent version of Microsoft Edge, Mozilla Firefox, or Google Chrome will be fine.
