You are here

SQL

Featured in 

Designing and Implementing Cloud Data Platform Solutions The focus of this three-day instructor-led Microsoft Training course is on designing and implementing cloud data platform solutions with the Microsoft Data Platform by using SQL Server on-premises, hybrid and cloud data platform solutions. It describes how to design and implement and optimize workloads in hybrid scenarios with both on-premises and Microsoft Azure cloud-based solutions, and how to implement high availability and disaster recovery solutions.

Monday, November 19, 2018 - 9: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, July 19, 2018 - 6:00pm
Featured in 

SQL & Excel Database Fundamentals Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. In this course, you will examine the basic database concepts and learn the differences in how data is stored and manipulated in common tools such as MS Excel versus true relational database tools such as MS SQL Server or MS Access.

Friday, October 26, 2018 - 9:00am
Featured in 

SQL & Excel Database Fundamentals Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. In this course, you will examine the basic database concepts and learn the differences in how data is stored and manipulated in common tools such as MS Excel versus true relational database tools such as MS SQL Server or MS Access.

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

SQL & Excel Database Fundamentals Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. In this course, you will examine the basic database concepts and learn the differences in how data is stored and manipulated in common tools such as MS Excel versus true relational database tools such as MS SQL Server or MS Access.

Tuesday, August 28, 2018 - 9:00am
Featured in 

In this course, you'll walk through installation steps for installing a text editor, installing MAMP or XAMPP (or equivalent) and creating a MySql Database. You'll learn about single table queries and the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys, and the JOIN operation. Lastly, you'll learn to model many-to-many relationships like those needed to represent users, roles, and courses.

Monday, June 18, 2018 - 12:00pm
Featured in 

Over the next 10 years the Department of Labor has projected a job increase for individuals who possess the right skills to store and query large data sets. This course is will leverage best practices to understand Data, create robust spreadsheet models using excel, a general survey of SQL to input, extract and manipulate data stored in a database, and enhance data models and insights with Tableau visualizations. Excel is a standard across many industries and often time used to access, manipulate, evaluate, and visualize data.

Saturday, September 29, 2018 - 9:30am
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.

Saturday, September 1, 2018 - 10: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.

Saturday, September 29, 2018 - 10: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.

Saturday, July 7, 2018 - 10:00am

Pages