YoVDO

SQL Tutorials for Beginners - Structured Query Language Tutorials - DBMS

Offered By: Sundeep Saradhi Kanthety via YouTube

Tags

SQL Courses Data Manipulation Courses Database Management Courses Data Retrieval Courses Aggregate Functions Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Learn the fundamentals of Structured Query Language (SQL) in this comprehensive 4.5-hour video tutorial. Master essential SQL concepts including data types, creating and manipulating tables, inserting and modifying data, implementing constraints, and writing complex queries. Explore advanced topics such as aggregate functions, GROUP BY and HAVING clauses, and creating views. Practice your skills with hands-on examples using sailors, reserves, and boats tables. Gain the knowledge needed to effectively manage and query relational databases, preparing you for a career in database management and development.

Syllabus

INTRODUCTION TO SQL
SQL DATATYPES
CREATE COMMAND IN SQL
INSERT COMMAND IN SQL
CONSTRAINTS IN SQL
ALTER COMMAND IN SQL
DROP & TRUNCATE COMMANDS IN SQL
SELECT COMMAND IN SQL
UPDATE & DELETE COMMANDS IN SQL
SQL AGGREGATE FUNCTIONS
GROUP BY & HAVING CLAUSE IN SELECT COMMAND
CREATION & INSERTION OF DATA TO SAILORS , RESERVES & BOATS TABLE
QUERIES ON SAILORS , RESERVES & BOATS TABLE
VIEWS IN SQL


Taught by

Sundeep Saradhi Kanthety

Related Courses

Developing Scalable Apps in Python
Google via Udacity
Capstone: Retrieving, Processing, and Visualizing Data with Python
University of Michigan via Coursera
Teaching Impacts of Technology: Workplace of the Future
University of California, San Diego via Coursera
Build Native Mobile Apps with Flutter
Google via Udacity
Health Informatics and Technology in Decision Making
Doane University via edX