Programming Microsoft SQL Server

COM SCI X 418.694A
Intended for anyone working with Microsoft SQL server, this course covers basic syntax and statements used to create functioning Transact-SQL modules with an emphasis on reporting techniques and performance tuning.
Starting at $1,125.00
As few as 11 weeks
4.0 Credits
3.6 CEUs

What you can learn.

  • Be able to describe the elements of SQL server and design a SQLserver enterprise application architecture
  • Describe the conceptual basis of programming in Transact-SQL and create and manage databases and their related components
  • Implement data integrity by using the IDENTITY column property, constraints, defaults, rules, and unique identifiers
  • Plan for the use of indexes; create and maintain indexes; create, use, and maintain data views
  • Implement user-defined functions; design, create, and use stored procedures; create and implement triggers
  • Program across multiple servers by using distributed queries, distributed transactions, and partitioned views

About this course:

Transact-SQL extends SQL by adding the constructs found in other procedural languages, such as variables and control structures, thus allowing for a flexible procedural extension to SQL. Intended for anyone working with or evaluating Microsoft SQL Server, this course covers the basic syntax and statements used to create functioning Transact-SQL modules with an emphasis on reporting techniques and performance tuning. Students write different types of Transact-SQL modules, including batches, transactions, stored procedures, user-defined functions, and triggers.
Suggested Prerequisites

It is advisable that you complete the following (or equivalent) since they are prerequisites for Programming Microsoft SQL Server.

Working knowledge of basic SQL and knowledge of database concepts. Some experience with any programming language such as Visual Basic, Java, C or C++ is highly recommended.

Summer 2019 Schedule

These courses are fully online, and there are no in-person classroom meetings.

Future Offering (Opens 29 Apr 2019 12:00:00 AM)
Instructor: Virginia Mushkatblat
See Details

Enrollment limited. Enrollment deadline: July 2, 2019. Internet access required. Materials required.

Refund Deadline
No refunds after July 9, 2019
Course Requirements
Internet access required to retrieve course materials.

Contact Us

Our team members are here to help. Hours: Mon-Fri, 8am-5pm.

This course applies towards the following certificates & specializations…

Keep up to date on the latest news and offerings in Network & Infrastructure

vector icon of building

Corporate Education

Learn how we can help your organization meet its professional development goals and corporate training needs.

Learn More

vector icon of building

Donate to UCLA Extension

Support our many efforts to reach communities in need.

Innovation Programs

Student Scholarships

Coding Boot Camp

Lifelong Learning