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.
Overview
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
