Conestoga College Logo - Home Page

Development with Microsoft SQL Server (Part-time)

Credential:
Certificate
Program Code:
0018
School:
Engineering & Information Technology

About the Program

The graduate of this program will possess a broad range of skills to develop solutions using the Microsoft SQL Server relational database management system. The program is a practical mixture of database administration and development. Topics covered in this program include database design and Structured Query Language, SQL Server installation and maintenance, native SQL Server programming (Transact SQL) and advanced programming using Analysis Services, Integration Services and Reporting Services.

Program Information

Students must successfully complete all courses as outlined in the Program Outline. All courses must be completed within three (3) years of acceptance into the program.

Admission Requirements

Note re: Admission Requirements

Admission Procedures

Program Requirements

Credit will be given for any qualifying course successfully completed up to two (2) years prior to admission into the program.

How to Apply

Students may obtain a Conestoga College Program Application Form from any Conestoga College campus, OR by writing directly to the Registrar's Office, OR by using the college website at www.conestogac.on.ca/admissions/forms

Send completed applications to:
Conestoga College
Admissions Office
299 Doon Valley Dr
Kitchener, Ontario
Canada N2G 4M4

How to Register for Courses

Go to How to Register for detailed registration information.

Prior Learning Assessment and Recognition (PLAR)

Conestoga recognizes prior learning of skills, knowledge or competencies that have been acquired through employment, formal and informal education, non-formal learning or other life experiences. Prior learning must be measurable at the required academic level and meet Conestoga standards of achievement for current courses. Challenge exams and portfolio development are the primary methods of assessment. Other methods of assessment may be available depending upon the nature of the course objectives. Successful completion of the assessment results in an official course credit that will be recorded on the student's Conestoga transcript. PLAR cannot be used by registered Conestoga students for the clearance of academic deficiencies, to improve grades or to obtain admission into a program.

Learn more about PLAR.

Graduate Opportunities

For more details on related occupations, job market information and career opportunities, see the Government of Canada website: http://www.workingincanada.gc.ca

Program Related Resources

Program Outcomes

Program Courses

Click on the course code or title below for a full description of the course. If available for registration, clicking on "Details" in the status column will open a new browser tab or window in the Student Portal.

Course Information
Course Code Course Title Status
COMP1000 SQL Server Installation and Maintenance
Description: Recommended: Database Concepts PROG1870.
This course provides the student with experience in installing, configuring and maintaining SQL Server. The student will become familiar with the capabilities of the database system, know how to configure the various services available, implement security, perform backup and restore operations and optimize performance.
Hours: 36
Credits: 3
Pre-Requisites:
CoRequisites:
Closed
COMP1105 Business Intelligence Development
Description: Recommended: PROG1430 and PROG1810.
This course introduces the student to Integration Services, Analysis Services and Reporting Services - three Business Intelligence tools that are part of the SQL Server system. Integration Services enable the transfer and transformation of data between SQL Server and other systems; Analysis Services delivers online analytical processing (OLAP) capabilities to support data warehouse and data mining functionality; Reporting Services provides a suite of tools to create, manage and deploy reports that can leverage database information. The student will learn how to install, configure and use these services to build decision support applications.
Hours: 36
Credits: 3
Pre-Requisites:
CoRequisites:
Closed
PROG1300 Visual Basic.NET II
Description: Recommended: PROG1290 or equivalent knowledge. This course builds on programming fundamentals. It exposes the student to Visual Studio.NET environment as it develops the skills in Visual Basic.NET. Upon completion of the course, the student will be able to build complete programs, which conform to Windows standards. Topics include: the Microsoft Windows .NET Framework, object-oriented programming, file IO, arrays, advanced windows controls, multiple-document applications, and structured error handling.
Hours: 36
Credits: 3
Pre-Requisites:
CoRequisites:
Details
PROG1430 ADO.NET
Description: Recommended: PROG1300, PROG1400, PROG1410 or equivalent programming experience. This course builds on the knowledge gained in previous .NET development courses. Upon completion of the course, students will be able to use the System.Data namespace (ADO.NET) in order to interact with online databases using Active Server Pages (ASP.NET). Topics include: relational databases design, database connections, navigating DataSets, modifying records, structured query language (SQL), XML and ASP.NET.
Hours: 36
Credits: 3
Pre-Requisites:
CoRequisites:
Details
PROG1810 Programming SQL Server
Description: Recommended: COMP1000 SQL Server Installation and Maintenance.
This course exposes the student to various concepts in programming the SQL Server database system. Skills developed in this course include the creation and maintenance of various programming objects like stored procedures, user-defined functions, triggers and CLR-based objects. In addition, the course covers the fundamentals of working with XML data.
Hours: 36
Credits: 3
Pre-Requisites:
CoRequisites:
Closed
PROG1870 Database Concepts
Description: This course will introduce students to relational database management systems and database design. Topics will include: table design, table relationships, database normalization, database optimization, query definition, functions, stored procedures, forms and report development. These concepts are reinforced with practical exercises in creating queries, forms and reports to maintain and display the data in a database. The course also introduces students to data validation and security to ensure database integrity.
Hours: 42
Credits: 3
Pre-Requisites:
CoRequisites:
Closed
Annual Delivery Schedule
Course Code Course Title Spring Fall Winter
COMP1000 SQL Server Installation and Maintenance X  
COMP1105 Business Intelligence Development   X
PROG1300 Visual Basic.NET II X X X
PROG1430 ADO.NET X X X
PROG1810 Programming SQL Server   X
PROG1870 Database Concepts X X

Note:
All efforts will be made to adhere to this schedule, however the college reserves the right to make adjustments when necessary.
* To learn more about online course offerings, visit Distance Learning - OntarioLearn.

Disclaimer

The College reserves the right to alter information including requirements and fees and to cancel at any time a program, course, or program major or option; to change the location and/or term in which a program or course is offered; to change the program curriculum as necessary to meet current competencies in the job market or for budgetary reasons; or to withdraw an offer of admission both prior to and after its acceptance by an applicant or student because of insufficient applications or registrations, over-acceptance of offers of admission, budgetary constraints, or for other such reasons. In the event the College exercises such a right, the College’s sole liability will be the return of monies paid by the applicant or student to the College.

Students actively registered in cohort delivered programs who take longer than the designed program length of time to complete their studies are accountable for completing any new or additional courses that may result due to changes in the program of study. Unless otherwise stated, students registered in non-cohort delivered programs must complete the program of study within seven years of being admitted to the program.

SEARCH PART-TIME (PT)

Program Contact

Carol Schlievert, cschlievert@conestogac.on.ca, 519-748-5220 ext. 2390

Videos

Part-time Studies video
More videos

Success Stories

Back To Top