SQL Server Database Development

By: Blue Bridge Business & Computer Training  01-07-2013
Keywords: Computer Training, IT training, Computer Courses

  • SQL Server edition overview
  • SQL Server Management Studio
  • Referencing schemas versus using the default schema
  • Hiding schemas with synonyms
  • Selecting appropriate SQL Server data types
  • Constructing tables with CREATE TABLE
  • Enforcing uniqueness using PRIMARY KEY and UNIQUE constraints
  • Validating relationships using FOREIGN KEY
  • Minimizing network traffic using batches and procedures
  • Stored procedure compilation and execution
  • Using scalar functions
  • Developing stored procedures that extract data from multiple servers
  • Executing dynamic queries using OPENROWSET and OPENQUERY
  • Executing remote procedures
  • Capturing RETURN values from stored procedures
  • Creating and utilizing local variables
  • Passing input and output parameters
  • Converting data using CAST and CONVERT
  • Ordering data with ranking functions
  • Ensuring data consistency with transactions and distributed transactions
  • Managing concurrency with isolation levels
  • SQL Server locking fundamentals
  • Avoiding blocking problems with read-committed snapshot isolation
  • Implementing conditions with IF...ELSE
  • Looping with WHILE and GOTO
  • Creating code blocks with BEGIN...END
  • Debugging T-SQL in Management Studio
  • Communicating problems to the client with RAISERROR
  • Intercepting errors with TRY...CATCH
  • Dealing with open transactions
  • Building and using temporary tables
  • Processing rows on the server with a cursor
  • Taking advantage of table variables
  • Concealing complexity with views
  • Solving business problems using multistatement table-valued functions
  • Calculating values with scalar functions
  • Taking advantage of schema binding
  • INSTEAD OF vs. AFTER triggers
  • Detecting row changes using the inserted/deleted tables
  • Tracing metadata changes with DDL triggers
  • Auditing user access using a LOGON trigger
  • Tracking data changes with the OUTPUT clause

Keywords: Computer Courses, Computer Learning, Computer Training, IT training

Contact Blue Bridge Business & Computer Training

Email

Print this page

Share

Other products and services from Blue Bridge Business & Computer Training

08-07-2012

Network + Certification

CompTIA Network+ validates the knowledge and skills of networking professionals. It is an international vendor-neutral certification that recognizes a technicians ability to describe the features and functions of networking components and to install configure and troubleshoot basic networking hardware protocols and services.


08-07-2012

CISCO Certification - CCNA & CCNP

Cisco Certified Network Associate (CCNA) validates the ability to install, configure, operate, and troubleshoot medium-size route and switched networks, including implementation and verification of connections to remote sites in a WAN.


06-20-2012

MS PowerPoint

This course is designed for new users, or users that have been self taught on PowerPoint. The course covers all aspect of creating a presentation from scratch right through to running a presentation with animation


03-28-2012

Microsoft Access 2010 Training

 Access 2010 Introduction Course Objectives:  After the course, you will be able to: Understand Database Concepts and Objects Create, Edit and Maintain Tables Create Queries Create Forms Create Reports Create Relational Tables, Forms, Queries and Reports


03-28-2012

Microsoft Project 2010 Training

 Project 2010 Introduction Course Objectives:  After the course, you will be able to: Understand Project Terms Create and Manage Tasks Apply Resources Apply Project Costing Project Tracking Create Project Reports Requirements:  You do not need any previous Project experience.  You must however have good basic Windows, Mouse and Keyboard skills Project 2010 Intro Course Duration: This is a  day Project 2010 Introduction Course. Course starts at 09:30 and runs until


03-28-2012

Microsoft Excel 2010 Training

Create and maintain spreadsheets Create and edit formulae Format and print worksheets Perform basic list management tasks


08-31-2011

Soft Skills Training

We all want to give interesting, effective and memorable presentations. Your main objective as a presenter is to deliver a message. Your presentation is your pitch. To deliver that pitch perfectly, you need to borrow from a variety of fields; psychology, art & design, IT, politics and of course your own domain which is the subject of the presentation.


Microsoft Office, SQL and Windows skills workshops from Blue Bridge Business & Computer Training thumbnail
01-03-2011

Microsoft Office, SQL and Windows skills workshops

Our workshops range from basic computer skills to advanced  computerskills and empower all attendants to  challenge themselves to become highly skilled  computer professionals.


National Certificate: PC and Network Enginnering from Blue Bridge Business & Computer Training thumbnail
01-03-2011

National Certificate: PC and Network Enginnering

 Learners will gain enough skills and confidence to become junior PC and network professionals.


National Certificate: End User Computing from Blue Bridge Business & Computer Training thumbnail
01-03-2011

National Certificate: End User Computing

This computer course will give learners a solid foundation to  allow them to persue any IT career of their choice by giving them a solid understanding and appreciation of IT and its use in the workplace.Upon completion of this computer course, learners will have a good undestanding of ms office 2007 and its application in the workplace to facilitate communication, team work and collaboration.


PC Support Technician from Blue Bridge Business & Computer Training thumbnail
01-03-2011

PC Support Technician

Upon completion of this short computer course, learners will have a solid understanding of computer hardware,  computer software and computer networks and are able to identify and resolve IT related issues.


Microsoft Office and Windows Skills from Blue Bridge Business & Computer Training thumbnail
01-03-2011

Microsoft Office and Windows Skills

Upon completion of this short computer course, learners will have a solid understanding of computers and use of office 2007 applications to increase productivity and efficiency.Learners will also be able to tackle day to day tasks using office 2007 at work with ease.