SQL Server for Developer Certification Training

Live Online & Classroom Certification Training

SQL Server for Developer training teaches participants the skills needed to successfully query and modify data in SQL Server. This course teaches you to Design a database, Maintain databases, tables, and sequences with SQL statements and many more..

(4.7) 121 Learners
Instructed by SPRINGPEOPLE
INDIA

    No Public/Open-house class on the topic scheduled at the moment!

Course Description

Overview

SQL Server for Developer training teaches participants the skills needed to successfully query and modify data in SQL Server.

Objective

At the end of SQL Server for Developer Training course, participants will be able to:

  • 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
  • Retrieve data using cursors
  • Manage binary data using BLOBs

Duration - 5 Days

Prerequisites

No prior experience is presumed.

Course Curriculum

Expand All
  • 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
  • Managing the Database Files
  • Viewing and Modifying The Database
  • Working with Queries
  • Using Books Online
  • The SELECT Statement
  • The SELECT Clause
  • The WHERE Clause
  • The ORDER BY Clause
  • Inner Joins
  • Outer Joins
  • Other Skills for Working with Joins
  • Unions
  • Aggregate Functions
  • Grouping and Summarizing Data
  • Summarizing Data Using SQL Server Extensions
  • Subqueries in Search Conditions
  • Other Ways to Use Subqueries
  • Guidelines for Working With Complex Queries
  • Common Table Expressions
  • Creating Test Tables
  • Inserting New Rows
  • Modifying Existing Rows
  • Deleting Existing Rows
  • Merging Rows
  • SQL Data Types
  • Converting Data
  • String Data
  • Numeric Data
  • Date/Time Data
  • Other Functions
  • 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
  • Creating and Managing Views
  • Using Views
  • Using The View Designer
  • Variables and Temporary Tables
  • Controlling the Execution of a Script
  • Advanced Scripting Techniques
  • Procedural Programming Options in Transact-SQL
  • Coding Stored Procedures
  • User-Defined Functions
  • Triggers
  • Cursors in SQL Server
  • Using Cursors to Retrieve Data
  • Modifying Data Through a Cursor
  • Additional Cursor Processing Techniques
  • Concurrency and Locking
  • How SQL Server Manages Locking
  • Preventing Deadlocks
  • Using SQL to Work with a Varbinary(max) Column
  • A .NET Application That Uses a Varbinary(max) Column
  • Using FILESTREAM Storage

Certification

SpringPeople works with top industry experts to identify the leading certification bodies on different technologies - which are well respected in the industry and globally accepted as clear evidence of a professional’s “proven” expertise in the technology. As such, these certification are a high value-add to the CVs and can give a massive boost to professionals in their career/professional growth.

Our certification courses are fully aligned to these high-profile certification exams; at the end of the course, participants will have detailed knowledge, be eligible and be fully ready take up these certification exams and pass with flying colours.

 

Resources

SpringPeople Corporate Learning Center

Job Trends

About the Instructor

Founded in 2009, SpringPeople is a global premier eLearning marketplace for Online Live, Instructor-led classes in the region. It is a certified training delivery partner of leading technology creators, namely Pivotal, Elastic, Lightbend, EMC, VMware, MuleSoft, RSA, and... Read More


Course Rating and Reviews

4.7

Average Rating
5 Stars
28
4 Stars
12
3 Stars
1
2 Stars
0
1 Star
0

SPRINGPEOPLE SpringPeople Trainer

Tapas Mishra

Intuit
Course:
Instructor:
Course Material:
Class Experience:
Trainer is exceptionally well. Very good teaching style.

SPRINGPEOPLE SpringPeople Trainer

Amit Kumar Das

DBA-2
Intuit
Course:
Instructor:
Course Material:
Class Experience:
NA

SPRINGPEOPLE SpringPeople Trainer

Chaitanya

Sr.systems Engineer
Intuit
Course:
Instructor:
Course Material:
Class Experience:
He is good at the training necessities

This class is intended for participants with some prior exposure to the technology and are now looking to build up their expertise on the topic.

On successful completion of the course, participants will be eligible to sit of the related certification exam (see course overview). All participants receive a course completion certificate, demonstrating their expertise on the subject.

Total duration of the online, live instructor led sessions. Sessions are typically delivered as short lectures (2-hrs weekdays/3-hrs weekends) and detailed hands-on guidance.

Expected offline lab work hours that participants will need to complete and submit to the trainer, during and after the instructor-led online sessions.

  1. We are happy to refund full fee paid - no questions asked - should you feel that the training is not up to your expectations.
  2. Our dedicated team of expert training enablement advisors are available on email, phone and chat to assist you with your queries.
  3. All courseware, including session recordings, will always be available to access to you for future reference and rework.

Contact Us

+91-80-6567-9700 (BLR)

training@springpeople.com

Request Call Back

Related Courses

Recently Viewed