SQL Essentials An Introduction to Writing SQL Queries
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 important 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 then this session is for you