Details

Are you new to the data profession? Are you looking to build your career in the data space but don’t know where to start?

Regardless of the type of job you want to pursue in the data industry, whether you are a DBA, Developer, BI Analyst, Data Engineer or data scientist, you will probably have to work with relational data and databases in some capacity. So you will need to know SQL.

In this session, I will introduce you to the Structured Query Language (SQL) to provide you with a place to start and begin your journey in learning SQL.

The session will use SQL Server and Transact-SQL, and we will get you started writing SQL Queries. You will learn

• Database fundamentals: why it’s essential to understand the database design and schema
• Simple SELECTS –  Writing  a SELECT statement from a single table
• Column Expressions – Column expressions and aliases
• Filter rows  with WHERE
• Using LIKE for Wildcard searches
• Using ORDER BY to sort our results,
• Understanding NULLs and how to handle them
• Inner Joins –  The most common type of join, we  will retrieve data from more than one table in the same Query

If you want to begin writing SQL queries, this session is for you. Sign up here