SQL for Beginners - Learn SQL In A Practical Manner

In this SQL course, you will learn the SQL programming language, the SQL basics and SQL fundamentals in a practical manner. We will start with a brief introduction of the SQL programming language, followed by an Overview of Databases and the Relational Database Management System (RDBMS). We will install Microsoft SQL Server in a Docker Container in order to learn SQL in a practical manner. This will provide you with a brief introduction to Docker - open platform for developing, shipping, and running applications. Alternatively, Microsoft SQL Server on a standalone Windows Operating System will also be used. Using a Healthcare System use case, we will create a database, create tables, insert some data into those tables. We will cover SQL syntax, and SQL DML operations to access, modify or retrieve the data from the database.

At the end of this course, students will be able to perform SQL operations to insert, retrieve, and update data in a database and perform data analysis.

This course will provide first hand knowledge for new data engineers, data analysts and software developers. We will learn first hand using examples in a real-world database.

---------

What You Will Learn

Databases and the Relational Database Management System (RDBMS)
SQL programming language, SQL basics, fundamentals and SQL syntax
Docker
Azure Data Studio
Create tables in a database
Add data into a database
SQL to query a database
SQL Data Definition Language (DDL) operations - create and alter table
SQL Data Manipulation Language (DML) operations to access, modify or retrieve data
SQL JOIN commands - INNER and OUTER JOINS to combine two or more tables together
SQL logical operators to filter and group data
SQL group functions such as min, max etc.
SQL Wildcards
SQL Aliases
SQL Between and Not Between

---------

Why You Should Take This Class

Understand Databases and the Relational Database Management System (RDBMS)
Be proficient in SQL programming language, SQL basics, fundamentals and SQL syntax
Ace your next SQL interview

---------

Who This Class Is For

Beginner or new data engineers and software developers
College students interested in data engineering
Healthcare IT professionals interesting in data engineering and data analysis
People interested in learning about databases and how to access, modify or retrieve data in a database

---------

Materials/Resources

SQL Server installation on Docker documentation
SQL Server on Windows installation documentation

----------

Who am I?

My name is Benjamin - I'm a Master Data Management Engineer and Healthcare IT Subject Matter Expert (SME) and have worked for fortune 500 companies such as GE and Caradigm for the last 10 years to design and build data products. I've worked with terabytes of healthcare data running in clustered environments in Amazon Web Services (AWS) and Microsoft Azure to enable secure, reliable and connected healthcare. I've decided to put together this SQL series of Skillshare classes to share my own knowledge of working with data and how to analyze data. If you are new to SQL and data engineering, don't worry - you got this. I will teach you the basics of databases and SQL along with techniques to analyze data in a practical manner.

---------

Other Useful Links:

My website ► https://data-engineer-365.teachable.com/

My Equipment ► https://bit.ly/32iCNj3

Anastasiia Sirotkina

1

1