SQL Server

Canadian Business College
Mississauga, Toronto, Scarborough, Ontario, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' * Describe the elements of Microsoft SQL Server and the environments in which it can operate.
* Describe the elements of the Transact-SQL language.
* Describe and configure the data storage architecture of SQL Server.
* Create and manage files, file groups, databases, tables, and transaction logs.
* Enforce data integrity using constraints, defaults, and rules.
* Plan for appropriate use.
* Create and maintain indexes.
* Write queries that retrieve and modify data using joins and subqueries.
* Write queries that summarize data.
* Manage locking options and transactions to ensure data concurrency and recoverability.
* Create views of data.
* Design and create stored procedures.
* Design and create triggers.
* Work with distributed data. ...''

Phone:1-888-925-9929

School Address:

Toronto Campus ¨C Faculty of Business and Technology
2 Bloor Street West, 22nd Floor
Toronto, Ontario, M4W 3E2
Tel: (416) 925-9929
Fax: (416)925-9220

Faculty of Dental Hygiene - Clinical
2 Bloor Street West,
Toronto, Ontario

Mississauga Campus
77 City Centre Dr, Suite # 105
Mississauga, Ontario
Tel:(905) 279-9929

Scarborough Campus
55 Town Centre Court Suite # 600
Scarborough, Ontario
Tel: (416) 290-6565

Branch Campus ¨C Dental Preclinical
80 Bloor Street West, Suite 1000
Toronto, Ontario



Jobs & Resumes: Mississauga, Toronto, Scarborough
Houses & Roommates: Mississauga, Toronto, Scarborough

Oracle Database Analyst
MCPD.NET - Microsoft Certified Professional Developer
MCDBA - Microsoft Certified Database Administrator
MCSA
Comptia A+ Certificate
Analyzing Requirements and Defining Solution Architectures
CISCO CCNA
Applications Development in Microsoft Access 2000
SQL Featuring Oracle
Designing a Microsoft Windows 2003 Directory Services Infrastructure
Visual Basic.NET
MCSA 2003
MCSE 2003
Linux
Unix Administration
C++ Programming
Visual Basic.NET (VB.NET)
Java Script
XML

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.