YoVDO

SQL Course for Beginners - Programming Database Querying Tutorial

Offered By: Skillademia via YouTube

Tags

SQL Courses Relational Databases Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Dive into a comprehensive 4-hour tutorial on SQL fundamentals for beginners, covering essential concepts of Relational Database Management Systems (RDBMS). Learn to create and manage database objects, including tables and records, apply access restrictions, execute queries, and optimize database memory. Master key SQL concepts such as data types, operators, keys, and constraints. Explore crucial SQL commands and expressions, including CREATE, INSERT, SELECT, and WHERE statements. Advance your skills with more complex querying techniques using LIKE and TOP clauses, and discover how to retrieve unique records. Gain practical knowledge to effectively manage and manipulate data in relational databases through this in-depth, step-by-step programming tutorial.

Syllabus

Welcome
Overview: Introduction
Overview: What is SQL
Overview: What is a RDBMS
Overview: What is a Table
Overview: Common Rules
Overview: List of Databases
SQL Attributes and Concepts: Data Types
SQL Attributes and Concepts: Operators in Detail
SQL Attributes and Concepts: Records vs. Rows
SQL Attributes and Concepts: Fields vs. Columns
SQL Attributes and Concepts: Keys
SQL Attributes and Concepts: Constraints
SQL Attributes and Concepts: SQL Structure Overview
SQL Commands and Expressions: Create New Database
SQL Commands and Expressions: Create Tables
SQL Commands and Expressions: Insert Data
SQL Commands and Expressions: The SELECT Statement
SQL Commands and Expressions: The WHERE Clause
SQL Commands and Expressions: Conjunctive Operators
More with SQL: Updated Queries
More with SQL: The LIKE Clause
More with SQL: The TOP Clause
More with SQL: More Keys
More with SQL: Get Unique Records


Taught by

Skillademia

Related Courses

Introduction to Databases
Meta via Coursera
Intro to Relational Databases
Udacity
Fundamentals of database systems
Indian Institute of Technology Kanpur via Swayam
Capstone: Photo Tourist Web Application
Johns Hopkins University via Coursera
Web Application Development: Basic Concepts
University of New Mexico via Coursera