Login
Copyright

SQL Tutorial & Training

  • Course type: Self-paced
  • Available Lessons: 54
  • Average Lesson Length: 8 min
  • Eligible for Certificate: Yes

    Certificates show that you have completed the course. They do not provide credit.

  • Watch a preview:

    Basic SQL Query Syntax
    chapter 1 / lesson 1
    Basic SQL Query Syntax

Course Summary

Make use of this collection of lessons to expand your knowledge about the advantages and database applications of SQL. Created by field experts, these lessons expand your skill set by teaching you SQL syntax, data types, variations, and more.
Create An Account
To Start This Course Today
Used by over 30 million students worldwide
Create An Account
Try it free for 5 days

6 chapters in SQL Tutorial & Training

Week {{::cp.getGoalWeekForTopic(0, 6)}}
Ch 1. SQL Basics & Syntax {{cp.topicAssetIdToProgress[215541].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - Basic SQL Query Syntax Score: {{cp.lessonAssetIdToProgress[215543].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215543].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - SQL Subqueries: Example & Definition Score: {{cp.lessonAssetIdToProgress[215545].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215545].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - SQL: Inner Joins Score: {{cp.lessonAssetIdToProgress[215547].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215547].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - SQL: Left & Right Joins Score: {{cp.lessonAssetIdToProgress[215549].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215549].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - SQL: Full Outer Joins Score: {{cp.lessonAssetIdToProgress[215551].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215551].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - SQL: Cross Joins Score: {{cp.lessonAssetIdToProgress[215553].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215553].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - SQL: Self-Joins Score: {{cp.lessonAssetIdToProgress[215555].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215555].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - SQL: UNION vs. JOIN Score: {{cp.lessonAssetIdToProgress[215557].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215557].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - SQL: GROUP BY Clause Score: {{cp.lessonAssetIdToProgress[215559].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215559].bestScoreQuestions}}  Take Quiz Optional
Lesson 10 - SQL: PIVOT & UNPIVOT Score: {{cp.lessonAssetIdToProgress[215561].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215561].bestScoreQuestions}}  Take Quiz Optional
Lesson 11 - What is a Cursor in SQL? - Example & Syntax Score: {{cp.lessonAssetIdToProgress[215563].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215563].bestScoreQuestions}}  Take Quiz Optional
Lesson 12 - What is SQL Injection? - Example & Prevention Score: {{cp.lessonAssetIdToProgress[215565].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215565].bestScoreQuestions}}  Take Quiz Optional
Lesson 13 - SQL: Parameterized Queries Score: {{cp.lessonAssetIdToProgress[215567].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215567].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(2, 6)}}
Course Progress Best Score
Lesson 1 - SQL Data Types: CHAR & VARCHAR Score: {{cp.lessonAssetIdToProgress[215579].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215579].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - SQL Data Types: INT & SMALLINT Score: {{cp.lessonAssetIdToProgress[215581].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215581].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - SQL Data Types: DECIMAL & NUMERIC Score: {{cp.lessonAssetIdToProgress[215583].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215583].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - SQL Data Types: REAL, FLOAT & DOUBLE Score: {{cp.lessonAssetIdToProgress[215585].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215585].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - SQL Data Types: BOOLEAN Score: {{cp.lessonAssetIdToProgress[215587].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215587].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - SQL Data Types: DATE, TIME & TIMESTAMP Score: {{cp.lessonAssetIdToProgress[215589].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215589].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - SQL Data Types: BINARY LARGE OBJECT Score: {{cp.lessonAssetIdToProgress[215591].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215591].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(3, 6)}}
Course Progress Best Score
Lesson 1 - Database Terminology Score: {{cp.lessonAssetIdToProgress[182655].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182655].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - What is an SQL Database? - Definition & Sample Score: {{cp.lessonAssetIdToProgress[182735].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182735].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - SQL vs. NoSQL Databases Score: {{cp.lessonAssetIdToProgress[215595].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215595].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - What is Microsoft SQL Server? Score: {{cp.lessonAssetIdToProgress[182669].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182669].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - Indexes in SQL Score: {{cp.lessonAssetIdToProgress[215597].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215597].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - What is a Primary Key in SQL? Score: {{cp.lessonAssetIdToProgress[215599].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215599].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - What is a Foreign Key in SQL? Score: {{cp.lessonAssetIdToProgress[215601].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215601].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - SQL Index Types: Clustered & Nonclustered Score: {{cp.lessonAssetIdToProgress[215603].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215603].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - Index Fragmentation in SQL Score: {{cp.lessonAssetIdToProgress[215605].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215605].bestScoreQuestions}}  Take Quiz Optional
Lesson 10 - SQL Normalization: Example & Rules Score: {{cp.lessonAssetIdToProgress[215607].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215607].bestScoreQuestions}}  Take Quiz Optional
Lesson 11 - SQL Collation: SQL Server & MySQL Score: {{cp.lessonAssetIdToProgress[215609].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215609].bestScoreQuestions}}  Take Quiz Optional
Lesson 12 - What is a Schema in SQL? - Definition & Design Score: {{cp.lessonAssetIdToProgress[215611].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215611].bestScoreQuestions}}  Take Quiz Optional
Lesson 13 - Triggers in SQL: Example & Syntax Score: {{cp.lessonAssetIdToProgress[215613].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215613].bestScoreQuestions}}  Take Quiz Optional
Lesson 14 - SQL: Constraints Score: {{cp.lessonAssetIdToProgress[215615].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215615].bestScoreQuestions}}  Take Quiz Optional
Lesson 15 - SQL: Stored Procedures Score: {{cp.lessonAssetIdToProgress[215617].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215617].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(4, 6)}}
Week {{::cp.getGoalWeekForTopic(5, 6)}}
Course Progress Best Score
Lesson 1 - SQL: DELETE Statement Score: {{cp.lessonAssetIdToProgress[215637].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215637].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - SQL DROP Index & DROP Database: Tutorial Score: {{cp.lessonAssetIdToProgress[182711].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182711].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - SQL DROP Columns & Rows: Tutorial Score: {{cp.lessonAssetIdToProgress[182703].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182703].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - SQL DROP Constraint: Tutorial & Overview Score: {{cp.lessonAssetIdToProgress[182705].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182705].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - SQL DROP Table: Tutorial & Explanation Score: {{cp.lessonAssetIdToProgress[182707].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182707].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - SQL DROP Temp Table: Tutorial & Explanation Score: {{cp.lessonAssetIdToProgress[182709].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182709].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - SQL DROP View: Tutorial & Overview Score: {{cp.lessonAssetIdToProgress[182713].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182713].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - SQL TRUNCATE String: Tutorial & Overview Score: {{cp.lessonAssetIdToProgress[182715].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182715].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - SQL TRUNCATE Table: Tutorial & Explanation Score: {{cp.lessonAssetIdToProgress[182717].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182717].bestScoreQuestions}}  Take Quiz Optional

Earning College Credit

Did you know… We have over 95 college courses that prepare you to earn credit by exam that is accepted by over 2,000 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Support