Intermediate SQL Programming

Intermediate SQL Programming

SQL is a language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). SQL allows you to access many records with one single command and it eliminates the need to specify how to reach a record, e.g. with or without an index. This intermediate course will be focused on using MS SQL Server and T-SQL.

Topics include:

• Data aggregation using aggregate functions
• Writing sub-queries
• Recursive queries
• Common table expressions

You will also gain experience creating views, stored procedures, functions, and triggers using different looping and database locking mechanisms. Specific areas in the SQL Server database using data file structures, database schemas, setting properties, snapshots, data space and type usage and identity columns will be covered. SQL tuning and use of execution plans will also be addressed.

Course typically offered: Quarterly, online (asynchronous).

Prerequisites: CSE-40933 - Introduction to SQL Programming or equivalent knowledge and experience.

Software: This course will use Microsoft SQL Server and Microsoft SQL Server Management Studio (SSMS). SQL Server will run natively on Windows and Linux. You can also run a SQL Server container image with Docker.

Next Steps: Upon completion of this course, consider taking other courses in the Database Management or Business Intelligence Analysis certificate programs to continue learning.

More Information: For more information about this course, please email unex-techdata@ucsd.edu.

Course Number: CSE-40948
Credit: 3.00 unit(s)
Related Certificate Programs: Business Intelligence Analysis, Database Management

+ Expand All

3/26/2024 - 5/31/2024

$725

Online

Closed

• SECTION ID:

  179732

• CLASS TYPE:

  Online Asynchronous.
  
  This course is entirely web-based and to be completed asynchronously between the published course start and end dates. Synchronous attendance is NOT required.
  You will have access to your online course on the published start date OR 1 business day after your enrollment is confirmed if you enroll on or after the published start date.

• INSTRUCTOR:
  

  Williamson, Eric D

  Eric Williamson is a Data Architect at UC San Diego Health. He specializes in Microsoft SQL Server and SharePoint. Williamson has been working with and developing in those technologies for 20+ years. He has been an instructor at Extension since 2013, developing and instructing SQL Server courses. Williamson has also been a Microsoft Certified Professional (MCP) since 2000.

• TEXTBOOKS:

  No textbook required.

• POLICIES:

  No refunds after: 4/1/2024.
  

• NOTE:

• DATE & LOCATION:

  3/26/2024 - 5/31/2024
  extensioncanvas.ucsd.edu
  You will have access to your course materials on the published start date OR 1 business day after your enrollment is confirmed if you enroll on or after the published start date.