Hands-On Introduction: SQL

Offered By: LinkedIn Learning

Tags

SQL Courses Databases Courses CRUD Operations Courses Data Manipulation Courses Database Management Courses GitHub Codespaces Courses

Course Description

Overview

Get the tools, techniques, and know-how to write SQL queries through hands-on lessons where you’ll code along with the instructor.

Syllabus

Introduction

Introduction to SQL
Using GitHub Codespaces with this course

1. The Select Statement

Fetch data
Filtering data
Types of functions, part 1
Types of functions, part 2
Using multiple tables

2. New Tables and Data

Create new tables
Change table structure
Add new rows to a table
Delete rows in a table
Commit and rollback

3. Modifying Existing Tables

Modify rows and columns in tables
Merge rows in a table
Drop or truncate a table
Rename a table

Conclusion

Next steps

Taught by

Deepa Maddala

Related Courses

Excel 2010
Miríadax Intro to Data Science
Udacity Data Manipulation at Scale: Systems and Algorithms
University of Washington via Coursera Statistical Computing with R - a gentle introduction
University College London via Independent Introducción a Data Science: Programación Estadística con R
Universidad Nacional Autónoma de México via Coursera