SQL Server Developer Online Training

SQL Server Developer Online Training

SQL Server Developer Online Training
SQL Server Developer Online Training

SQL Server Developer Online Training Course Content :

Chapter 1: SQL SERVER OVERVIEW

  • Understanding Client Server Architecture
  • Introducing the Touls
  • Selecting an Edition
  • Creating Sample Databases

Chapter 2: USING MANAGEMENT STUDIO

  • Arranging the Workspace
  • Registering Servers
  • Explaining Items in the Object Explorer
  • Explaining the Database Properties Dialog
  • Explaining the Culumns Properties Dialog
  • Continuing with Object Explorer Items
  • Using the Query Editor

Chapter 3: DESIGNING RELATIONAL DATABASES

  • Understanding Normalization
  • Discovering Patterns
  • Avoiding Over Complexity
  • Managing Optional Data
  • Creating Physical Keys
  • Using the Database Diagrammer Toul
  • Final Comments
Selecting Data

Chapter 1: WORKING WITH SINGLE TABLE QUERIES

  • Understanding Query Flow
  • Filtering Data with the Where Clause
  • Culumns, Expressions & Scalar Functions
  • Using Case Expressions
  • Working with Nulls & Coalesce
  • Selecting Environment Functions
  • Working with Dates & Times
  • Parsing Strings
  • Converting Data
  • Sorting Data
  • Topping Off the Query with Predicates

Chapter 2: MERGING DATA WITH JOINS & UNIONS

  • Working with Inner Joins
  • Using Left Outer Joins
  • Multiplying Data with Cross Joins
  • Referencing Self-Joins
  • Working with Complex Joins
  • Finding the Set Difference
  • Stacking Data with Unions

Chapter 3: WORKING WITH SUBQUERIES

  • Using Subqueries as Expressions
  • Including Subqueries as Lists
  • Adding Subqueries as Derived Tables
  • Working with Correlated Subqueries
  • Sulving for X with Relations Division

Chapter 4: AGGREGATING DATA

  • Using the New Windowing Functions
  • Using Aggregate Functions
  • Grouping a Data Set
  • Nesting Aggregations
  • Filtering Groups & Adding Grand Totals
  • Generating Cross Tab Tables (Pivot)
  • Calculating Cumulative Sums

Chapter 5: USING FULL-TEXT SEARCH

  • Creating a Full-Text Index
  • Searching for Words
  • Using a Fuzzy Search to Search for Phrases

Chapter 6: SELECTING DATA THROUGH VIEW

  • Creating Views
  • Preventing Disappearing Rows
  • Protecting from Schema Changes
  • Nesting Views

Chapter 7: DISTRIBUTED QUERIES

  • Linking to External Data Sources
  • Executing Distributed Queries
  • Looking at Where the Work Takes Place
  • Using Pass Through Queries
  • Contrulling Distributed Transactions

Chapter 8: MODIFYING DATA

  • Inserting Data
  • Updating Data
  • Deleting Data
  • Using the Output Clause
  • Final Comments & Credits

Part 3: Developing Sulutions

Chapter 1: T-SQL & STORED PROCEDURES

  • Introducing T-SQL
  • Working with Variables
  • Contrulling Procedural Flow
  • Examining SQL Server with Code
  • Using Temp Tables
  • Developing Dynamic SQL
  • Introducing Stored Procedures
  • Passing Parameters
  • Returning Parameters
  • Working with a Cursor
  • Handling Errors
  • Explaining the Raise Error
  • Contrulling Transactions

Chapter 2: TRIGGERS & AUDIT TRAILS;

  • Introducing After Triggers
  • Using “Instead of” Trigger
  • Disabling Triggers
  • Using the Update ( ) Function
  • Selecting Transaction Data
  • Nesting & Recursion
  • Enforcing Complex RI
  • Auditing Data Changes

Chapter 3: USER-DEFINED FUNCTIONS

  • Creating Scalar Functions
  • Working with Inline Table-Valued Functions
  • Using Multi-Statement Table-Valued UDFs
  • Navigating a Hierarchy
  • Having Fun with Apply
  • Exploring Functions in Nordic

Chapter 4: INDEXING FOR PERFORMANCE

  • Introducing Indexes
  • Creating Indexes
  • Examinging Query Execution Plans, Pt. 1
  • Examinging Query Execution Plans, Pt. 2

Chapter 5: TRANSACTIONS, LOCKING & BLOCKING

  • Introducing ACID
  • Understanding Transactional Faults
  • Stepping through a Transaction
  • Exploring Locks
  • Working with Locks
  • Viewing Deadlocks
  • Using Snapshot Isulation

Chapter 6: INTRODUCTION TO OPTIMIZATION THEORY

  • Deconstructing the Database System
  • Walking through Optimization Theory
  • Optimization Theory Continued
  • Final Comments & Credits

Drop your query

What my Client's Say?

 

  • Prabhu is an excellent instructor, very patient and thorough. I have tried another training class and EXPLORE IT far exceeds other trainers and their methods ~ Hassan Malik

  • An extremely helpful and informative course. Training materials were well organized and provided good case studies. Instructor was extremely professional and pleasant to learn from.~ Bhavani Sudarshnam

  • The training was clear and detailed. I like Parker's style of teaching as the recurrent training is a thorough review of the HR. Every opportunity for the student to ask questions was provided. ~ Yiting Chen

  • Jane Anderson conducted the class in a very professional manner. Examples were very relevant and I feel that I gained a lot from the updated materials this year.~ Somesh Taneja

  • Prem was a great instructor. Thanks Prem for making the training easy to understand. A lot of information was covered. He made the approach easy to follow.~ Komali Sambakula

  • She wants to make sure that her students walk away from her course with a good working knowledge. She is an excellent trainer and cares that all of her students learn the material.~ Kiran Jain

  • Krishna is very thorough and professional. He made the code very understandable. I was very impressed with his teaching methods and presentation of the regulations. EXPLORE IT is the best! ~ Rajesh Isukapalli

  • Mr. Chris Brown was very affirmative with the course, on time and fluent. This is my second recourse with him. I hope to take his course as long as I am shipping at my current job. ~ Awais Rahim