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 Cont Ed courses without logging into CougarWeb.
Search by Term, then subject(s) and course title (optional).
Search and register online for Cont Ed courses by term (semester) using CougarWeb.
Returning student without a login should email firstname.lastname@example.org
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.
registration are three additional ways to register for Continuing Education courses.