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

Bharath Vivekanandan

Course:
Instructor:
Course Material:
Class Experience:
Adding one more day to the course duration might help

SPRINGPEOPLE SpringPeople Trainer

Ravi Ranjan Kumar

Engineer
Mindtree Ltd.
Course:
Instructor:
Course Material:
Class Experience:
not required

SPRINGPEOPLE SpringPeople Trainer

Archana M

Team Lead
Mindtree
Course:
Instructor:
Course Material:
Class Experience:
Overall Good Training experience, interactive sessions, got to know many insights of Powershell, Trainer knowledge and explanation was excellent.

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