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.
- 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: Online during the Spring and Fall academic quarters.
NOTE - we will be refreshing course content during the SPRING '20 quarter and will be offering the class again during the SUMMER '20 quarter.
Prerequisites: CSE-40933: Introduction to SQL or equivalent knowledge and/or 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 class, consider enrolling in other coursework in the Business Intelligence Analysis Certificate Program.
More Information: For more information about this course, please contact firstname.lastname@example.org.
Course Number: CSE-40948
Credit: 3.00 unit(s)
Related Certificate Programs: Business Intelligence Analysis, Database Management
+ Expand All
6/22/2020 - 8/21/2020
10/5/2020 - 12/5/2020
1/4/2021 - 3/5/2021