Copyright

Introduction to SQL

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

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

  • Watch a preview:

    Database Terminology
    chapter 1 / lesson 1
    Database Terminology

  • Introduction to SQL Practice Test

Course Summary

Gain a quality understanding of SQL concepts by exploring this engaging Introduction to SQL course. Benefit from bite-sized lessons, multiple-choice quizzes, practice exams and other study tools that can strengthen your knowledge and help you succeed on a test, assignment or project.
Create An Account
To Start This Course Today
Try it risk-free for 30 days. Cancel anytime
Create An Account
Try it risk-free for 30 days

8 chapters in Introduction to SQL

Course Practice Test

Check your knowledge of this course with a 50-question practice test.
  • Comprehensive test covering all topics
  • Detailed video explanations for wrong answers
Week {{::cp.getGoalWeekForTopic(0, 8)}}
Ch 1. Intro to Databases & SQL {{cp.topicAssetIdToProgress[602925].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - Database Terminology Score: {{cp.lessonAssetIdToProgress[182655].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182655].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182655].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182655].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - History of SQL Score: {{cp.lessonAssetIdToProgress[355821].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[355821].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[355821].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[355821].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - Design for Databases & SQL Score: {{cp.lessonAssetIdToProgress[182735].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182735].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182735].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182735].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - SQL vs. NoSQL Databases Score: {{cp.lessonAssetIdToProgress[215595].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215595].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215595].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215595].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - What is T-SQL? Score: {{cp.lessonAssetIdToProgress[215571].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215571].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215571].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215571].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - What is PL/SQL? Score: {{cp.lessonAssetIdToProgress[215573].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215573].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215573].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215573].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - What is Dynamic SQL? Score: {{cp.lessonAssetIdToProgress[215575].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215575].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215575].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215575].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - What is Microsoft SQL Server? Score: {{cp.lessonAssetIdToProgress[182669].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182669].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182669].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182669].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - What is SQL Server Management Studio (SSMS)? Score: {{cp.lessonAssetIdToProgress[182671].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182671].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182671].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182671].bestScoreQuestions}}  Take Quiz Optional
Lesson 10 - What is MySQL? - Overview & Usage Score: {{cp.lessonAssetIdToProgress[572997].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[572997].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[572997].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[572997].bestScoreQuestions}}  Take Quiz Optional
Lesson 11 - Installing MySQL for Database Programming
Lesson 12 - Practical Application for Introduction to SQL: Installing Sample Data for MySQL
Lesson 13 - Installing SQL Server Express Edition for Database Programming
Week {{::cp.getGoalWeekForTopic(1, 8)}}
Ch 2. Overview of SQL Database Design {{cp.topicAssetIdToProgress[602929].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - Database Query: Definition & Tools Score: {{cp.lessonAssetIdToProgress[182657].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182657].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182657].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182657].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - Referential Integrity & Constraints in Databases: Definition & Example Score: {{cp.lessonAssetIdToProgress[574367].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574367].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574367].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574367].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - What is a Primary Key in SQL? Score: {{cp.lessonAssetIdToProgress[215599].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215599].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215599].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215599].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - What is a Foreign Key in SQL? Score: {{cp.lessonAssetIdToProgress[215601].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215601].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215601].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215601].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - What is Normal Form in DBMS? - Types & Examples Score: {{cp.lessonAssetIdToProgress[219281].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219281].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[219281].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219281].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - SQL Normalization: Example & Rules Score: {{cp.lessonAssetIdToProgress[215607].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215607].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215607].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215607].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - First Normal Form in DBMS with Examples Score: {{cp.lessonAssetIdToProgress[219283].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219283].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[219283].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219283].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - Third Normal Form in DBMS with Examples Score: {{cp.lessonAssetIdToProgress[219285].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219285].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[219285].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219285].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - What is a Schema in SQL? - Definition & Design Score: {{cp.lessonAssetIdToProgress[215611].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215611].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215611].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215611].bestScoreQuestions}}  Take Quiz Optional
Lesson 10 - Practical Application for Introduction to SQL: Data Normalization
Week {{::cp.getGoalWeekForTopic(2, 8)}}
Ch 3. SQL Data Types & Syntax {{cp.topicAssetIdToProgress[602933].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - SQL Data Types: CHAR & VARCHAR Score: {{cp.lessonAssetIdToProgress[215579].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215579].bestScoreQuestions}}  Take Quiz Optional
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
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
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
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
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
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
Score: {{cp.lessonAssetIdToProgress[215591].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215591].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - Basic SQL Query Syntax Score: {{cp.lessonAssetIdToProgress[215543].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215543].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215543].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215543].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - Advanced SQL Query Syntax Score: {{cp.lessonAssetIdToProgress[574325].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574325].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574325].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574325].bestScoreQuestions}}  Take Quiz Optional
Lesson 10 - Practical Application for Introduction to SQL: Performing a SELECT Statement
Week {{::cp.getGoalWeekForTopic(3, 8)}}
Ch 4. Retrieving Data with SQL {{cp.topicAssetIdToProgress[602937].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - How to Limit the Results of a SELECT SQL Query Score: {{cp.lessonAssetIdToProgress[574327].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574327].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574327].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574327].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - Aliases in SQL: Syntax & Examples Score: {{cp.lessonAssetIdToProgress[574345].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574345].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574345].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574345].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - How to Sort the Results of an SQL Query Score: {{cp.lessonAssetIdToProgress[574329].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574329].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574329].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574329].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - What are SQL Functions? - Use & Examples Score: {{cp.lessonAssetIdToProgress[574331].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574331].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574331].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574331].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - SQL: ISNULL Function Score: {{cp.lessonAssetIdToProgress[215631].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215631].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215631].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215631].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - SQL: IFNULL Function Score: {{cp.lessonAssetIdToProgress[602939].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[602939].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[602939].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[602939].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - SQL: CASE Statement Score: {{cp.lessonAssetIdToProgress[215633].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215633].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215633].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215633].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - SQL: GROUP BY Clause Score: {{cp.lessonAssetIdToProgress[215559].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215559].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215559].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215559].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - Grouping Data in Databases: ROLLUP & CUBE Score: {{cp.lessonAssetIdToProgress[574375].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574375].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574375].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574375].bestScoreQuestions}}  Take Quiz Optional
Lesson 10 - Advanced Use of the GROUP BY Clause in SQL Score: {{cp.lessonAssetIdToProgress[574333].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574333].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574333].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574333].bestScoreQuestions}}  Take Quiz Optional
Lesson 11 - Practical Application for Introduction to SQL: Selection, Grouping & Totals
Week {{::cp.getGoalWeekForTopic(4, 8)}}
Ch 5. Joins & Subqueries in SQL {{cp.topicAssetIdToProgress[602943].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - SQL Complex Queries: Functionality & Examples Score: {{cp.lessonAssetIdToProgress[466729].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[466729].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[466729].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[466729].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - SQL Join: Definition & Examples Score: {{cp.lessonAssetIdToProgress[466733].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[466733].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[466733].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[466733].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - SQL: Inner Joins Score: {{cp.lessonAssetIdToProgress[215547].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215547].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215547].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215547].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - SQL: Full Outer Joins Score: {{cp.lessonAssetIdToProgress[215551].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215551].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215551].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215551].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - SQL: Cross Joins Score: {{cp.lessonAssetIdToProgress[215553].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215553].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215553].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215553].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - SQL: Self-Joins Score: {{cp.lessonAssetIdToProgress[215555].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215555].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215555].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215555].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - SQL: UNION vs. JOIN Score: {{cp.lessonAssetIdToProgress[215557].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215557].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215557].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215557].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - SQL Subqueries: Example & Definition Score: {{cp.lessonAssetIdToProgress[215545].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215545].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215545].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215545].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - Advanced SQL Subqueries: Use & Examples Score: {{cp.lessonAssetIdToProgress[574351].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574351].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574351].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574351].bestScoreQuestions}}  Take Quiz Optional
Lesson 10 - SQL Correlated Subqueries: Use & Examples Score: {{cp.lessonAssetIdToProgress[574353].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574353].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574353].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574353].bestScoreQuestions}}  Take Quiz Optional
Lesson 11 - SQL: EXISTS, NOT EXISTS & WITH Score: {{cp.lessonAssetIdToProgress[574355].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574355].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574355].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574355].bestScoreQuestions}}  Take Quiz Optional
Lesson 12 - Practical Application for Introduction to SQL: Joins & Subqueries
Week {{::cp.getGoalWeekForTopic(5, 8)}}
Ch 6. Using SQL To Modify Data {{cp.topicAssetIdToProgress[602947].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - Data Manipulation Language (DML): Definition & Example Score: {{cp.lessonAssetIdToProgress[182695].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182695].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182695].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182695].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - Data Manipulation Language (DML) Commands Score: {{cp.lessonAssetIdToProgress[182701].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182701].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182701].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182701].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - Data Definition Language (DDL) Commands Score: {{cp.lessonAssetIdToProgress[182699].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182699].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182699].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182699].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - SQL: INSERT Statement Score: {{cp.lessonAssetIdToProgress[215623].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215623].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215623].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215623].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - Multi-Table Inserts in Databases: Example & Use Score: {{cp.lessonAssetIdToProgress[574379].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574379].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574379].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574379].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - SQL: UPDATE Statement Score: {{cp.lessonAssetIdToProgress[215625].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215625].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215625].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215625].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - SQL: FORMAT Statement Score: {{cp.lessonAssetIdToProgress[215627].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215627].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215627].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215627].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - SET Operators in Database Management: Definition & Use Score: {{cp.lessonAssetIdToProgress[574373].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574373].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574373].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574373].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - SQL: PIVOT & UNPIVOT Score: {{cp.lessonAssetIdToProgress[215561].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215561].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215561].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215561].bestScoreQuestions}}  Take Quiz Optional
Lesson 10 - Practical Application for Introduction to SQL: INSERT, UPDATE & SET
Week {{::cp.getGoalWeekForTopic(6, 8)}}
Ch 7. Views, Indexes & Triggers in SQL {{cp.topicAssetIdToProgress[602951].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - SQL Views: Definition & Example Score: {{cp.lessonAssetIdToProgress[466731].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[466731].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[466731].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[466731].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - What is a Database Index? - Definition & Tutorial Score: {{cp.lessonAssetIdToProgress[182739].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182739].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182739].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182739].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - SQL: CREATE Index Score: {{cp.lessonAssetIdToProgress[215621].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215621].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215621].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215621].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - Indexes in SQL Score: {{cp.lessonAssetIdToProgress[215597].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215597].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215597].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215597].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - Triggers in SQL: Example & Syntax Score: {{cp.lessonAssetIdToProgress[215613].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215613].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215613].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215613].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - Practical Application for Introduction to SQL: Views
Week {{::cp.getGoalWeekForTopic(7, 8)}}
Ch 8. Removing Data Using SQL {{cp.topicAssetIdToProgress[602955].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - SQL: DELETE Statement Score: {{cp.lessonAssetIdToProgress[215637].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215637].bestScoreQuestions}}  Take Quiz Optional
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
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
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
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
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
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
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
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
Score: {{cp.lessonAssetIdToProgress[182717].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182717].bestScoreQuestions}}  Take Quiz Optional
Lesson 10 - Practical Application for Introduction to SQL: DROP Statements

Earning College Credit

Did you know… We have over 160 college courses that prepare you to earn credit by exam that is accepted by over 1,500 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.

Practice Tests in this course
Check your knowledge of this course with a 50-question practice test. Once you take the test, you will receive a detailed exam report complete with your personal statistics and even specific lessons to focus on! Take the practice test now
Your detailed study guide will include:
  • Answers and detailed explanations to each question
  • Video lessons to explain complicated concepts
Course Practice Test
More practice by chapter
See practice tests for:
Support