CS 150A SQL Server Databases (3)
Credit, Degree Applicable
A course in the use of the Microsoft SQL Server database management system to create, query, and update database tables. The course covers both the syntax and the logic of the major features of the T-SQL query language. The course includes a brief introduction to the programming aspects of T-SQL.
After successful completion of this course, students will be able to:
- Outcome 1: Describe the basic concepts of databases, tables, relationships, and normalization
- Outcome 2: Analyze business requirements, designing and implementing queries that satisfy those requirements and using all of the major components of the SQL language for accessing data, including inner and outer joins, aggregate queries and subqueries, and a variety of the intrinsic functions supplied by SQL Server.
- Outcome 3: Manipulate a SQL Server database using client software to create and modify database objects such as tables, constraints, relationships, and views following a database design and design and implement simple user-defined functions.
- Outcome 4: Create queries that will manipulate data in the database using Data Manipulation Language statements