Development with Microsoft SQL Server (Part-time)
- Program Code:
- Engineering & Information Technology
About the ProgramThe 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 InformationStudents 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.
- Ontario Secondary School Diploma (OSSD), or equivalent, OR 19 years of age or older
Note re: Admission Requirements
- Students must be able to receive instruction, respond and research in the English language
- Submit a completed Conestoga College Program Application Form
- Attach proof of admission requirements
Program RequirementsCredit will be given for any qualifying course successfully completed up to two (2) years prior to admission into the program.
How to ApplyStudents 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:
299 Doon Valley Dr
Canada N2G 4M4
How to Register for CoursesGo 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 OpportunitiesFor more details on related occupations, job market information and career opportunities, see the Government of Canada website: https://www.jobbank.gc.ca/home
Program Related Resources
- Create data mining models.
- Create programming objects such as, store procedures and user defined functions.
- Complete a database design process from concept to final implementation.
- Install and configure various editions of SQL Server 2008 and related services.
- Perform backups and restore databases.
- Build web applications to modify and display database records.
- Develop basic reports to display and leverage database information.
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 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.
|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.
|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.
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.
|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.
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.
|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|
|PROG1810||Programming SQL Server||X|
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.
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.