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 

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 4, 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.

Tuesday, April 23, 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 

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.

Wednesday, May 15, 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.

Friday, May 24, 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.

Wednesday, April 17, 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 

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.

Thursday, April 25, 2019 - 6:00am

Pages