You are here

SQL

Featured in 

SQL is a powerful language, and tool, for data analysis and data handling. In this bootcamp, youll dive deep into SQL syntax and database structures, while applying your new SQL skills to address business problems. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence. Takeaways Understand SQL vocabulary such as tables, schema, functions and JOINS. Understand the differences between different data management systems for SQL databases. Create basic SQL queries by applying Boolean logic, sorting functions, and commenting.

Tuesday, June 25, 2019 - 6:00am
Featured in 

SQL is a powerful language, and tool, for data analysis and data handling. In this bootcamp, youll dive deep into SQL syntax and database structures, while applying your new SQL skills to address business problems. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence. Takeaways Understand SQL vocabulary such as tables, schema, functions and JOINS. Understand the differences between different data management systems for SQL databases. Create basic SQL queries by applying Boolean logic, sorting functions, and commenting.

Sunday, June 30, 2019 - 6:00am
Featured in 

Enabling analysts to broaden their SQL skills to retrieve and manipulate data from multiple sources into timely, cohesive, informative analysis. Takeaways We will be going over the following: JOIN and UNION with Aliasing Primary and Foreign Keys Aggregation and Functions Complex JOINs with multiple tables NULL values and related SQL functions GROUP BY combined with HAVING CASE and SUBSELECT Preparation Understanding of SQL fundamentals including the use of the following command line functions: SELECT queries that include FROM, WHERE, ORDER BY, LIMIT.

Friday, June 14, 2019 - 6:00am
Featured in 

In this course you will compose Advanced SQL queries to retrieve desired information from a database. You will build on derived tables and common expressions, group and summarize data, explore advanced where clauses and finally write advanced queries.

Wednesday, June 26, 2019 - 6: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, June 24, 2019 - 5: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, June 17, 2019 - 5: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, June 10, 2019 - 5:00am
Featured in 

This course introduces Microsoft's SQL Server Reporting Services 2014 (SSRS) utility. It begins with a discussion of the Reporting Services architecture and how to set up Reporting Services servers. Students will install and configure Reporting Services, and perform hands-on exercises where they create various types of reports, including basic table-based reports, parameterized reports, drilldown reports, linked reports, sub-reports, matrix reports (pivot tables), free-form reports and reports with charts and gauges.

Monday, June 10, 2019 - 5:00am