LRN0165 - Introduction to SQL
Course Description
Learn how to write SQL code to create and populate database tables and how to write simple SQL queries that are capable of retrieving vast amounts of information from a database. You will discover the power of the relational database, how to create and manage database tables, and how to use SQL Select statements to precisely pinpoint and retrieve data from a database.
Note: This course is part of a Digital Badge for those who wish to earn a credential. You may register for this individual class, but if If you would like to earn the Digital Badge, register for LRN0164- Online Self-Paced SQL Digital Badge.
Course Outline
Unit 1 - The Relational Database and Structured Query Language
- The relational database structure
- Structured Query Language
- Table creation and data insertion
- Defining datatypes and constraints
- Creating Indexes
Unit 2 - Table Management
- Table management
- Adding columns to a table
- Deleting columns from a table
- Deleting a table
Unit 3 - Selecting and Retrieving Data
- Creating a SELECT statement to retrieve data
- Using DISTINCT to display unique values in a column
- Using the AS keyword to create an alternate name for a column
- Merging columns
Unit 4 - Filtering Data
- Creating a WHERE clause
- Using comparison, character, and logical operators to match conditions
- Using the IN operator to match a condition
- Using the BETWEEN operator to match a condition
Cecelia Allison - Instructor
Dr. Cecelia Allison is an experienced software tester and technical specialist with more than 15 years of hands-on experience using and teaching SQL. She is also a technical writer, a published author, and a university professor. She holds a Bachelor of Science in finance, a Master of Science in information systems and a Doctor of Business Administration in management information systems.
Learner Outcomes
Course outcomes
- Understand the structure of a relational database and how SQL is used to query a relational database structure.
- Learn how to use SQL script to create and populate database tables.
- Be able to use SQL script to select, retrieve, and filter data from a database.
Notes
Requirements:
- Windows 8 or later. Macs are not compatible.
- Necessary rights (local administrative rights) to install programs on the computer.