Course Description
SQL Programming - Using MS SQL Server, this course covers ANSI/SQL where students will learn, through hands-on tasks and lectures, the SQL statements to retrieve from and modify data in relational databases, aggregate and group data using summary functions; create stored procedures and triggers; data integrity and database normalization principles; query optimization and use of indexes; transaction management and locking schemes and learn to create a database and tables.

Advanced SQL Programming  - Advanced techniques for transforming an experienced SQL programmer into an expert
What you will learn ...
SQL Programming - The student will learn how to use SQL to work with relational databases.

Advanced SQL Programming - Demonstrate advanced techniques and methods for database design and normalization, SQL data types, querying, grouping, set operations, optimization, data scaling, and encoding.
You may also be interested in ...
search for C.E. courses without log in.
Search for Cont Ed courses without logging into CougarWeb.
Search by Term, then subject(s) and course title (optional).

Log in to online register with CougarWeb
Search and register online for Cont Ed courses by term (semester) using CougarWeb.
Returning student without a login should email cehelp@collin.edu for assistance.


New students who would like to register online need to go through the Continuing Education admissions process to receive a CougarWeb login.


Instructions to search for courses, register online and apply for CE CougarWeb access are found here.


Phone, walk-in and mail-in registration are three additional ways to register for Continuing Education courses.
 

 

Textbook Information
For textbook information and detailed course syllabus - please click here.