Scribd
Upload
2 views5 pages

Data Analytics - SQL Course Contents

This document outlines a comprehensive SQL course divided into seven lessons. Topics covered include SQL syntax, functions, joins, advanced functions, database management, references, and practical examples. Each lesson provides detailed insights into various SQL operations and concepts essential for database management.

Uploaded by

zqkxe96517
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views5 pages

Data Analytics - SQL Course Contents

This document outlines a comprehensive SQL course divided into seven lessons. Topics covered include SQL syntax, functions, joins, advanced functions, database management, references, and practical examples. Each lesson provides detailed insights into various SQL operations and concepts essential for database management.

Uploaded by

zqkxe96517
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Lesson 1 - Introduction Class For SQL

SQL Intro
SQL Syntax

Lesson 2 – SQL Functions – Part I

SQL Select
SQL Select Distinct
SQL Where
SQL And, Or, Not
SQL Order By
SQL Insert Into
SQL Null Values
SQL Update
SQL Delete
SQL Select Top
SQL Min and Max
SQL Count, Avg, Sum
SQL Like
SQL Wildcards
SQL In
SQL Between
SQL Aliases

Lesson 3 – SQL Functions – Part II - Joins

SQL Joins
SQL Inner Join
SQL Left Join
SQL Right Join
SQL Full Join
SQL Self Join
SQL Union

Lesson 4 – SQL Functions – Part III - Advanced

SQL Group By
SQL Having
SQL Exists
SQL Any, All
SQL Select Into
SQL Insert Into Select
SQL Case
SQL Null Functions
SQL Stored Procedures
SQL Comments

Lesson 5 - SQL Database

SQL Create DB
SQL Drop DB
SQL Backup DB
SQL Create Table
SQL Drop Table
SQL Alter Table
SQL Constraints
SQL Not Null
SQL Unique
SQL Primary Key
SQL Foreign Key
SQL Check
SQL Default
SQL Index
SQL Auto Increment
SQL Dates
SQL Views
SQL Injection
SQL Hosting

Lesson 6 - SQL References

SQL Keywords
MySQL Functions
SQL Server Functions
MS Access Functions
SQL Operators
SQL Data Types
SQL Quick Ref

Lesson 7 - SQL Examples

SQL Examples
SQL Quiz – Quiz 1
SQL Quiz – Quiz 2
SQL Exercise – Exercise 1
SQL Exercise – Exercise 2
SQL Exercise – Exercise 3

You might also like