goodrich-topline-image

Courses We Offered

SQL Server Training

    1.DATABASE CONCEPTS.

  • Introduction to SQL server
  • Basic Relational Database Design
  • Database basics
  • System versus User Objects
  • Table basics
  • Relational Database Design Concepts
  • Stored Procedure Basics
  • User-Defined Function Basics
  • Trigger Basics
  • SQL server
  • 2.SQL SERVER BASICS

  • Versions of SQL server Available
  • Installing SQL Server Express
  • Basics of SQL server Management Studio Express
  • 3. SQL SERVER MANAGEMENT STUDIO

  • Features in SQL Server Management Studio
  • Object Explorer
  • Solutions Explorer
  • Template Explorer
  • Creating a SQL server database
  • 4.SQL SERVER TABLES

  • Creating SQL server Tables
  • Working with constraints
  • Identity Columns
  • Working with the computed Columns
  • Working with the user defined data types
  • Adding and modifying indexes
  • 5. TABLE RELATIONSHIPS

  • A introduction to relationships
  • Working with database diagrams
  • Working with the table relationships
  • How to designate table and Column Specifications
  • How to add a relationship name and description
  • How to determine when foreign key relationships constrain the data entered in a column
  • Designating Insert and Update Specifications
  • 6. SELECT STATEMENT

  • Introducing T-SQL
  • Working with the Select Statement
  • Adding on the FROM Clause
  • Including the Where Clause
  • Using the Order by Clause
  • Adding the DISTINCT keyword
  • Working with the FOR XML Clause
  • Creating TOP value queries
  • 7. MULTIPLE SELECT STATEMENTS

  • Working with the Join Types
  • Working with the Group by Clause
  • Including Aggregate functions in your SQL statements
  • Taking advantage of the HAVING clause
  • 8. MODIFYING DATA WITH ACTION QUERIES

  • Modifying data with action queries
  • 9. T-SQL FUNCTIONS

  • Working with the Numeric Functions
  • Taking advantage of String functions
  • Exploring the Date/Time Functions
  • Working with the Nulls
  • 10. SQL SERVER VIEWS

  • Introduction to Views
  • Using T-SQL to create or modify a view
  • 11. COMPLEX VIEWS

  • Creating Views based on data in multiple tables
  • Views and Sub Queries
  • Views and Outer Joins
  • Views and top values
  • Sorting view results
  • Views and Functions
  • Views and Built-in Functions
  • Using Views to secure data
  • Modifying data in a view
  • Modifying Views
  • Renaming views
  • Deleing Views
  • Indexed Views
  • Optimizing the views that you build
  • 12. STORED PROCEDURES

  • Basics of Working with Stored Procedures
  • Declaring and working with variables
  • Controlling the Flow
  • SET NOCOUNT Statement
  • Using the @@Functions
  • Working with Parameters
  • Modifying data with the stored procedures
  • Errors and Error handling
  • Stored Procedures and Transactions
  • 13. STORED PROCEDURES SPECIAL TOPICS

  • Stored Procedures and Temporary tables
  • Stored Procedures and Security
  • Building and Working with User-Defined Functions
  • Creating and working with triggers
  • 14. ADO.NET AND SQL SERVER

  • History of data access
  • Basics of ADO.NET
  • Building queries that modify data
  • 15. USING VB TO DESIGN SQL SERVER STORED PROCEDURES

  • Executing a simple stored procedure
  • Declaring and working with variables
  • Controlling program flow
  • Working with parameters
  • Modifying data with Stored Procedures
  • Working with the Temporary tables
  • Including Error handling in the stored procedures that you build
  • Using Transactions to protect your data
  • 16. USING C# TO DESIGN SQL SERVER STORED PROCEDURES

  • Executing a simple stored procedure
  • Declaring and working with variables
  • Controlling program flow
  • Working with parameters
  • Modifying data with Stored Procedures
  • Working with the Temporary tables
  • Including Error handling in the stored procedures that you build
  • Using Transactions to protect your data
  • 17. DEBUGGING STORED PROCEDURES THAT YOU WRITE

  • Harnessing the power of the Immediate window
  • Invoking the Debugger
  • Using Breakpoints to troubleshoot
  • Stepping through the code
  • Setting the next statement to execute
  • Viewing the call stack
  • Working with the locals window
  • Working with watch expression
  • 18. SECURITY AND ADMINISTRATION

  • SQL server Authentication
  • Basics of Security
  • Types of authentication available
  • How to create logins
  • How to create roles
  • 19. SQL SERVER PERMISSIONS VALIDATION

  • Types of permission available
  • Getting to know table permissions
  • Getting to know View Permissions
  • Getting to know stored procedure permissions
  • Getting to know Function Permissions
  • Implementing Column Level Security
  • 20. CONFIGURING, MAINTAINING AND TUNING SQL SERVER

  • Selecting and Tuning Hardware
  • How to configure and Tune SQL server
  • How to maintain your databases
  • How to main tables and other objects
  • 21. PERFORMANCE MONITORING SQL SERVER

  • Executing Queries in SQL Server management Studio Express
  • Displaying and analyzing the estimated execution plan for a query
  • Adding indexes to enable queries to execute more efficiently
  • Setting query Options
  • Installing the northwind database
  • Attaching the Northwind Sample database file

We Offered

  • Workshops
  • Live Projects
  • Digital Marketing
  • Online Training
  • Application Development
  • Website Development
  • Placement Assistance
  • Off-Campus Seminars

Recent News

  • Demo on every Saturday @ 10am

Get in Touch

Goodrich IT Solutions,
2nd Floor, Maruthi Complex,
Opp. R.S. Brothers, KPHB,
Hyderabad - 500 072

Mobile No. :+91 9885811057
Land Line: +91 4065889933
Email:sathesh@goodrichitsolutions.com

We Offered

  • Workshops
  • Live Projects
  • Digital Marketing
  • Online Training
  • Application Development
  • Website Development
  • Placement Assistance
  • Off-Campus Seminars

Recent News

  • Demo on every Saturday @ 10am

Get in Touch

Goodrich IT Solutions,
2nd Floor, Maruthi Complex,
Opp. R.S. Brothers, KPHB,
Hyderabad - 500 072

Mobile No. :+91 9885811057
Land Line: +91 4065889933
Email:sathesh@goodrichitsolutions.com