When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Development
SkillShare logo

SQL for Beginners 2024  —  Learn SQL Step by Step

Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.

     
  • 3
    •  |
  • Reviews ( 63 )
Free
SQL for Beginners 2024  —  Learn SQL Step by Step

Related Courses

This Course Includes

  • iconskillshare
  • icon3 (63 reviews )
  • icon1 hours 32 minutes
  • iconenglish
  • iconOnline - Self Paced
  • iconcourse
  • iconSkillShare

About SQL for Beginners 2024  —  Learn SQL Step by Step

Course Overview

Why Should I learn SQL

Why Should You Listen To Me

Database Overview

Healthcare System Database Use Case

RDBMS Overview

Relational vs NoSQL Databases

What is SQL?

SQL Fundamentals

DCL Commands

DDL Commands

DML Commands

DQL Commands

Install SQL Server on Docker

SQL Create Database

SQL Create Table

Add data into Patients Table Using SQL INSERT INTO

SQL Create Medication Table

SQL SELECT Statement

SQL Select TOP

SQL WHERE clause

SQL distinct keyword

SQL Order By

Sql Order By Position

SQL Group By

SQL Having Clause

SQL AND OR Operators

SQL AND OR NOT Operators

SQL LIKE Operator

SQL Wild Characters

SQL NOT Operator

SQL Count, Avg, Min, Max and Sum

SQL JOIN and INNER JOIN

SQL LEFT JOIN and SQL RIGHT JOIN

SQL UNION

SQL SORTING ASC or DESC

SQL UPDATE

SQL DELETE

What You Will Learn?

  • 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.
  • ---------.
  • Why You Should Take This Class.
  • ---------.
  • Who This Class Is For.
  • ---------.
  • Materials/Resources.
  • ----------.
  • 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 .