Introduction to SQL Server 2012 for Query Writers

Introduction to SQL Server 2012 for Query Writers

Bascom Bridge’s  SQL Server 2012 training: Introduction to SQL Server 2012 for Query Writers training course teaches attendees the skills they need to successfully query and modify data in SQL Server 2012.

SQL SERVER 2012 TRAINING OBJECTIVES

• Use the programming environment in SQL Server Management Studio and learn SQL Server’s Transact-SQL language
• Master writing simple and complex queries that retrieve data from the database
• Calculate information across result sets using aggregate queries (sum, min, max, avg, etc.)
• Insert, update, and delete data
• Create and manage views

SQL SERVER 2012 TRAINING PREREQUISITES

No prior experience is presumed.

SQL SERVER 2012 TRAINING MATERIALS

All SQL Server 2012 training students will receive a copy of Murach’s SQL Server 2012 for Developers.

SOFTWARE NEEDED FOR EACH PC:

• 64-bit Windows 7 or later, or Windows Server 2008 R2 or later, with the latest service pack updates and at least 4 GB RAM
• SQL Server 2012 installed
• Related sample databases and lab files that Accelebrate will provide
• If you have purchased this course, please contact us for detailed setup instructions.
• For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.

SQL SERVER 2012 TRAINING OUTLINE

• Introduction
• Relational Databases and SQL
  • The Client/Server System
  • The Relational Database Model
  • SQL and SQL-Based Systems
  • Transact-SQL Statements
  • Working with Other Database Objects
  • Using SQL from an Application Program
• The Management Studio
  • Managing the Database Files
  • Viewing and Modifying The Database
  • Working with Queries
  • Using Books Online
• Retrieving Data From a Single Table
  • The SELECT Statement
  • The SELECT Clause
  • The WHERE Clause
  • The ORDER BY Clause
• Retrieving Data from Two or More Tables
  • Inner Joins
  • Outer Joins
  • Other Skills for Working with Joins
  • Unions
• Summary Queries
  • Aggregate Functions
  • Grouping and Summarizing Data
  • Summarizing Data Using SQL Server Extensions
• Subqueries
  • Subqueries in Search Conditions
  • Other Ways to Use Subqueries
  • Guidelines for Working With Complex Queries
  • Common Table Expressions
• Inserting, Updating, and Deleting Data
  • Creating Test Tables
  • Inserting New Rows
  • Modifying Existing Rows
  • Deleting Existing Rows
  • Merging Rows
• Working With Data Types
  • SQL Data Types
  • Converting Data
• Functions
  • String Data
  • Numeric Data
  • Date/Time Data
  • Other Functions
• Views
  • Creating and Managing Views
  • Using Views
  • Using The View Designer
• Coding Scripts
  • Variables and Temporary Tables
  • Controlling the Execution of a Script
  • Advanced Scripting Techniques
• Conclusion