SQL

Beginner 0(0 Ratings) 1 Students enrolled
Created by Devi Cobra Last updated Tue, 30-Jun-2020 English
What will i learn?

Curriculum for this course
35 Lessons 00:00:00 Hours
SQL Intro
2 Lessons 00:00:00 Hours
  • Introduction to SQL
  • RDBMS
  • Database Tables
  • SQL Statements
  • Semicolon after SQL Statements?
  • SQL Comments
  • SQL CASE Statement
  • SQL UPDATE Statement
  • UPDATE Table
  • UPDATE Multiple Records
  • SQL IFNULL(), ISNULL(), COALESCE(), and NVL() Functions
  • SQL SELECT Statement
  • SELECT Column Example
  • SQL DELETE Statement
  • SQL DELETE Example
  • SQL UNIQUE Constraint
  • SQL FOREIGN KEY Constraint
  • SQL FOREIGN KEY on CREATE TABLE
  • SQL PRIMARY KEY Constraint
  • SQL BACKUP DATABASE for SQL Server
  • SQL DROP DATABASE Statement
  • SQL CREATE DATABASE Statement
  • SQL CREATE TABLE Statement
  • SQL AND, OR and NOT Operators
  • Demo Database
  • The SQL AND, OR and NOT Operators Example
  • Combining AND, OR and NOT
  • SQL UNION Operator
  • SQL UNION Example
  • INSERT INTO Example
  • The SQL MIN() and MAX() Functions
  • MIN() Syntax,MAX() Syntax
  • What is a NULL Value?
  • Demo Database
  • The IS NOT NULL Operator
Requirements
+ View more
Description
+ View more
Other related courses
00:00:00 Hours
Updated Mon, 29-Jun-2020
0 1 Free
00:00:00 Hours
Updated Tue, 30-Jun-2020
0 1 Free
00:00:00 Hours
Updated Tue, 30-Jun-2020
0 1 Free
00:00:00 Hours
Updated Tue, 30-Jun-2020
0 1 Free
00:00:00 Hours
Updated Wed, 01-Jul-2020
0 1 Free
00:00:00 Hours
Updated Wed, 01-Jul-2020
0 1 Free
00:00:00 Hours
Updated Thu, 02-Jul-2020
0 0 Free
00:00:00 Hours
Updated Thu, 02-Jul-2020
0 0 Free
00:00:00 Hours
Updated Thu, 09-Jul-2020
0 1 Free
About the instructor
  • 0 Reviews
  • 1 Students
  • 9 Courses
+ View more
Student feedback
0
Average rating
  • 0%
  • 0%
  • 0%
  • 0%
  • 0%
Reviews
Free
Includes:
  • 00:00:00 Hours On demand videos
  • 35 Lessons
  • Full lifetime access
  • Access on mobile and tv