Course details

Module One: SQL SERVER OVERVIEW

  • Understanding Client Server Architecture
  • Creating Sample Databases

Module Two: USING MANAGEMENT STUDIO

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

Module Three: DESIGNING RELATIONAL DATABASES

  • Understanding Normalization
  • Avoiding Over Complexity
  • Creating Physical Keys
  • Using the Database Diagram Tool

Module Four: WORKING WITH SINGLE TABLE QUERIES 

  • Understanding Query Flow
  • Filtering Data with the Where Clause
  • Columns, Expressions & Scalar Functions
  • Using Case Expressions
  • Working with Nulls

Module Five: Selecting Environment Functions

  • Working with Dates & Times
  • Parsing Strings
  • Converting Data
  • Sorting Data

Module Six: 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

Module Seven: WORKING WITH SUBQUERIES

  • Using Subqueries as Expressions
  • Including Subqueries as Lists
  • Adding Subqueries as Derived Tables

Module Eight: AGGREGATING DATA

  • Using Aggregate Functions
  • Grouping a Data Set
  • Nesting Aggregations
  • Filtering Groups & Adding Grand Totals
  • Calculating Cumulative Sums

Module Nine: SELECTING DATA THROUGH VIEWS

  • Creating Views
  • Nesting Views

Module Ten: MODIFYING DATA

  • Inserting Data
  • Updating Data
  • Deleting Data

Module Eleven: T-SQL & STORED PROCEDURES

  • Introducing T-SQL
  • Working with Variables
  • Introducing Stored Procedures
  • Passing Parameters
  • Returning Parameters
  • Handling Errors

Module Twelve: USER-DEFINED FUNCTIONS

  • Creating Scalar Functions
  • Working with Functions

Module Thirteen: INDEXING FOR PERFORMANCE (2 hours)

  • Introducing Indexes
  • Creating Indexes
Updated on 08 November, 2015

About CTC Academy

We_They Academy | Authorized Training Center: We_They Academy is an Egyptian company established in 1999 in Cairo-Egypt.

We_They Academy Training centers are private independent training centers.

Our office is located in Cairo. We_They Academy Training centers programs are offered by highly professional training methods. We_They Academy is one of the leading private educational centers which offers International Universities and Training Colleges programs.

Employers in the international employment market are confident that holders of our certificates and diplomas have been well trained and have acquired good skills and knowledge. Certificates and diplomas awarded by We_They Academy Training Centers are stamped by highly professional international training colleges and universities. The demand on We_They Academy Training Centers courses, programs, certificates and diplomas are on the increase nationally in the Arab Republic of Egypt.

See all CTC Academy courses
Are you from CTC Academy ? Claim your course!
Courses you can instantly connect with... Do an online course on SQL Server starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or