Introduction to SQL Server 2012 for Developers

Introduction to SQL Server 2012 for Developers

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

 

SQL SERVER 2012 TRAINING OBJECTIVES

  • 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
  • Understand the differences among views, stored procedures, triggers, and user-defined functions, and know the advantages and drawbacks of each
  • Build stored procedures, functions, and triggers
  • Design a database
  • Maintain databases, tables, and sequences with SQL statements
  • Create and manage views
  • Ensure the integrity of multiple, related database updates by using transactions
  • Manage binary data using BLOBs

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
  • Creating and maintaining databases, tables, and sequences with SQL statements
    • An introduction to DDL
    • Creating Databases, Tables, and Indexes
    • Using Constraints
    • Changing Databases and Tables
    • Working with Sequences
    • The Script Used to Create the AP Database
  • 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
  • Stored Procedures, Functions, and Triggers
    • Procedural Programming Options in Transact-SQL
    • Coding Stored Procedures
    • User-Defined Functions
    • Triggers
  • Managing Transactions and Locking
    • Concurrency and Locking
    • How SQL Server Manages Locking
    • Preventing Deadlocks
  • Working with BLOBs
    • Using SQL to Work with a Varbinary(max) Column
    • A .NET Application That Uses a Varbinary(max) Column
    • Using FILESTREAM Storage
  • Conclusion

Send a Comment

Your email address will not be published.

CONTACT US

+91 9376007676  

INQUIRY NOW


,

Introduction to SQL Server 2012 for Developers

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
  • Course No : SQL-301
  •  Theory : 40%
  •  Lab : 60%
  • Duration : 30 hours
Scroll Up
Skip to toolbar