This course provides comprehensive training in SQL Server, with the aim of helping students achieve their certification in the language upon completing the course. This course covers basic, intermediate, and advanced SQL techniques, meaning students will start by learning core database concepts and the differences between major types of SQL (as well as their ideal use cases).
Intermediate and advanced training will cover advanced analysis techniques, including how to work with joins, data types, aggregate functions, and date/time operations to uncover deeper insights and organize complex datasets. Students will learn to write sophisticated queries and utilize techniques like subqueries, CASE expressions, views, functions, and stored procedures. Taken together, these are all key skills for roles in data analysis, data science, and database management.
This course aims to ensure that students, regardless of their skill level, are prepared to work with SQL Server in a professional capacity upon completing the course. Each student will receive a certificate of completion upon graduation and will be able to work alongside certified trainers and experts as part of the live course structure.
What You Will Learn
- Understand core database concepts, including tables, rows, columns, and different types of SQL.
- Explore data types, comparison operators, and case sensitivity to refine queries with greater control.
- Perform calculations with aggregate functions like SUM, COUNT, AVG, MAX, and MIN to summarize data.
- Apply date functions to extract, format, and compare dates for time-based analysis.
- Implement conditional logic with CASE and IIF statements to dynamically transform query results.
- Manipulate text data using string functions like SUBSTRING, CHARINDEX, UPPER, and others.
- Build and query views, user-defined functions, and stored procedures to modularize your SQL code.
Program Courses
SQL Level 1
Learn the fundamentals of SQL and relational databases, including SQL syntax, database tables, and writing SQL queries. This course will also cover topics such as filtering results, using joins to combine data from multiple tables, and exploring databases with the SQL Server Management Studio app.
SQL Level 2
Enhance your SQL skills by learning how to join, filter, group, and analyze data in this intermediate course. Discover techniques for outer joins, manipulating data types, working with dates and times, grouping data, and filtering grouped data. Gain the ability to extract and analyze specific data for actionable insights.
SQL Level 3
This advanced course will take your SQL skills to the next level, where you will learn about subqueries, views, variables, functions, stored procedures, and more. Gain a deeper understanding of SQL techniques that will better prepare you for roles in data analysis, data science, and working with data in databases.
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.