You are here

SQL

Featured in 

In this course you will compose SQL queries to retrieve desired information from a database. You will explore database concepts, write simple select queries, use built-in functions and expressions, join tables, build subqueries and unions, and finally perform some advanced where clauses.

Tuesday, September 18, 2018 - 10:00am
Featured in 

This workshop will teach you the core concepts of databases as well as how to write effective SQL queries you can use in your everyday work. We will spend a quarter of the workshop reviewing database theory and the majority of the time going through examples. The session will be highly interactive and engaging - questions are encouraged! This single-session workshop will run for 3 hours. Who this program is for: This workshop is for beginners. We will start with basic examples and gradually move toward more complex SQL queries.

Thursday, September 6, 2018 - 6:00pm
Featured in 

This workshop will teach you the core concepts of databases as well as how to write effective SQL queries you can use in your everyday work. We will spend a quarter of the workshop reviewing database theory and the majority of the time going through examples. The session will be highly interactive and engaging - questions are encouraged! This single-session workshop will run for 3 hours. Who this program is for: This workshop is for beginners. We will start with basic examples and gradually move toward more complex SQL queries.

Thursday, September 20, 2018 - 6:00pm
Featured in 

This workshop will teach you the core concepts of databases as well as how to write effective SQL queries you can use in your everyday work. We will spend a quarter of the workshop reviewing database theory and the majority of the time going through examples. The session will be highly interactive and engaging - questions are encouraged! This single-session workshop will run for 3 hours. Who this program is for: This workshop is for beginners. We will start with basic examples and gradually move toward more complex SQL queries.

Thursday, August 23, 2018 - 6:00pm
Featured in 

This Transact-SQL programming course teaches students relational database fundamentals and SQL programming skills in the Microsoft SQL Server environment. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. The course also covers Microsoft-specific T-SQL programming constructs, creation and use of stored procedures and user-defined functions, use of cursors and updateable views. This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language.

Monday, December 17, 2018 - 9:00am
Featured in 

This SQL programming course teaches students relational database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, participants will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful SELECT, INSERT, UPDATE and DELETE statements.

Monday, December 17, 2018 - 9:00am
Featured in 

This hands-on course provides students with the knowledge and skills to administer a SQL Server 2017 database infrastructure. You will learn how to install, configure, manage, secure, automate, monitor, and optimize SQL Server 2017. You will also learn how to create, manage, back up, and restore individual databases, transfer and replicate data, configure for high availability, and plan disaster recovery. Course PrerequisiteFamiliarity with database concepts, Windows desktop navigation and Transact-SQL.

Monday, December 17, 2018 - 9:00am
Featured in 

This hands-on course provides students with the knowledge and skills to administer a SQL Server 2017 database infrastructure. You will learn how to install, configure, manage, secure, automate, monitor, and optimize SQL Server 2017. You will also learn how to create, manage, back up, and restore individual databases, transfer and replicate data, configure for high availability, and plan disaster recovery. Course PrerequisiteFamiliarity with database concepts, Windows desktop navigation and Transact-SQL.

Monday, October 15, 2018 - 9:00am
Featured in 

SQL Server 2017 Business Intelligence: Integration Services and Analysis Services provides a rich environment for business intelligence development. The focus of this course is to familiarize developers with the use of SQL Server Engine, SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) to create and populate data warehouses through ETL processing and build Multidimensional and Tabular models to use and reporting data sources. Students will learn how to design and build data warehouses and marts using SQL Server Management Studio.

Monday, December 10, 2018 - 9:00am
Featured in 

This course introduces Microsoft's SQL Server Reporting Services 2017 (SSRS) utility. All reports are developed utilizing SQL Server Data Tools (SSDT), however Report Designer is also introduced. Students will complete hands-on exercises creating a number of reports including table-based, cross tabular and forms based designs. Reports utilizing charts, gauges, KPIs, spark lines, data bars and tree maps will be built. Exercises will incorporate the use of report parameters and features such as drill down, interactive sorting, hyperlinks, book marks and report maps.

Monday, October 1, 2018 - 9:00am

Pages