- Course type: Self-paced
- Available Lessons: 82
- Average Lesson Length: 8 min
Eligible for Certificate:
Certificates show that you have completed the course. They do not provide credit.
Watch a preview:chapter 1 / lesson 1Database Terminology
Course SummaryGain 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.
to start this course today
Try it risk-free for 30 days
Course Practice TestCheck your knowledge of this course with a 50-question practice test.
- Comprehensive test covering all topics
- Detailed video explanations for wrong answers
About This Course
This entertaining Introduction to SQL course makes it simple to enhance your comprehension of concepts like joins and subqueries, views, indexes and triggers. Study fun lessons to learn ways to use SQL to remove and modify data. Also use this course to better understand SQL data types and SQL database design. Each lesson in this course is paired with a multiple-choice quiz that can test your knowledge while tracking your progress. We also offer practice exams with each chapter and the entire course to gauge your comprehension. Subject-matter experts can answer any questions you have about topics covered in the lessons. If you have a busy schedule, enjoy 24/7 mobile access that allows you to study any time and in any location you desire.
This course is beneficial for students, professionals and educators who are learning about, work closely with or teach SQL. Students can review the lessons and take the quizzes and practice tests to work on assignments, prepare for tests or enhance their overall grades. Educators can use the resources in this course to supplement existing learning materials used in the classroom. Professionals in the IT field can brush up on their SQL knowledge and enhance their performance in the workplace.
|Intro to Databases & SQL||Discusses the history of SQL, design for databases and differences between SQL and NoSQL databases. Defines T-SQL, PL/SQL, dynamic SQL and Microsoft SQL servers.|
|Overview of SQL Database Design||Teaches about SQL normalization, primary and foreign keys, database queries, first and third normal form in DBMS and schema in SQL.|
|SQL Data Types & Syntax||Provides descriptions of SQL data types like CHAR, VARCHAR, INT, SMALLINT, BOOLEAN and BINARY LARGE OBJECT. Differentiates between basic and advanced SQL query syntax.|
|Retrieving Data with SQL||Explains how to limit the results of a SELECT SQL query, sort the results of an SQL query and group data in databases. Describes the ISNULL and IFNULL functions, CASE statement and GROUP BY clause.|
|Joins & Subqueries in SQL||Defines inner joins, full outer joins, cross joins and self joins. Differentiates between UNION and JOIN, and provides descriptions of SQL subqueries, advanced SQL subqueries and SQL correlated subqueries.|
|Using SQL To Modify Data||Describes data manipulation language (DML), and discusses INSERT, UPDATE and FORMAT statements. Compares and contrasts PIVOT and UNPIVOT in SQL.|
|Views, Indexes & Triggers in SQL||Covers SQL views, database indexes, CREATE indexes, triggers in SQL and the practical application of views.|
|Removing Data Using SQL||Offers an overview of DELETE statements, and differentiates between SQL TRUNCATE strings and tables. Discusses SQL DROP index, database, columns, rows, table, temp table and view.|
Earning College Credit
Did you know… We have over 200 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.
Research Schools, Degrees & Careers
Get the unbiased info you need to find the right school.
Browse Articles By Category
Browse an area of study or degree level.
- Biological and Biomedical Sciences
- Communications and Journalism
- Computer Sciences
- Culinary Arts and Personal Services
- Liberal Arts and Humanities
- Mechanic and Repair Technologies
- Medical and Health Professions
- Physical Sciences
- Transportation and Distribution
- Visual and Performing Arts
- What to Do When Your Study Group Isn't Helping You Succeed on Exams
- The Most Engaging Free Courses: Study.com's People's Choice Award Winner
- Flip Your Classroom with Study.com's Engaging Video Lessons
- Educational Videos Help Teacher to Make Online Courses More Engaging
- How Tech Can Help Teachers Create Engaging Lesson Plans
- Congress Passes Veterans' Act Strengthening Education, Work-Study Benefits
- Online SQL Certification and Certificate Information
- SQL Server Training Programs and Requirements
- Become an SQL Developer: Education and Career Roadmap
- Microsoft SQL Certification and Training Options
- Computer Science Education Top Ranked College for Learning Computer Science - Memphis TN
- Nursing Home Management Degree and Certificate Programs
- Syracuse, New York (NY) Colleges
- Clinical Laboratory Technician Certification and Certificate Programs
- Acupuncture Degree and Education Program Information
- Answers and detailed explanations to each question
- Video lessons to explain complicated concepts
Explore our library of over 79,000 lessons
- College Courses
- High School Courses
- Other Courses