Introduction to SQL
Hours: 32 / Access Length: 180 Days / Delivery: Online, Instructor Supported
Online Hours: 32
Retail Price: $394.00
Course Overview:
Structured Query Language (SQL) is the language used to work with databases and the information stored within them. This course will provide a working knowledge of the basic forms of SQL, including how to select and update data from common table formats. Learners will create a database and use SQL to manipulate the data within it.
Students will need a Windows computer in order to use SQL Server Management Studio.
Students will:
- install the SQL Server demo and explore the basics of relational databases.
- write SQL SELECT statements to retrieve data from a single data table.
- write SQL SELECT statements with JOINS to retrieve data from multiple tables.
- write queries to summarize data using aggregate functions.
- write queries that contain sub queries.
- write queries to insert, update and delete data from data tables.
- write queries to convert and edit data in the database.
- design and create a database.
Course Outline:
Lesson 1: Introduction to Relational Databases and SQL
In this lesson you will gain an understanding of what a relational database is, and become familiar with the concepts and terms that apply to the database systems.
Lesson 2: How to Use the Management Studio
In this lesson you will learn how to use the primary tool for working with SQL Server 2016, the SQL Server Management Studio (SSMS).
Lesson 3: Retrieving Data from a Single Table
In this lesson you will learn how to code SELECT statements that retrieve data from a single table. These skills are the essential ones that apply to any SELECT statement, no matter how complex. You'll want to be sure you have a good understanding of the material in this lesson before you go on to the lessons that follow.
Lesson 4: Retrieving Data from Multiple Tables
In this lesson you will learn how to create result sets that contain data from two or more tables.
Lesson 5: Working with Summary Queries
In this lesson you will learn how to code queries that summarize data. For example, you can use summary queries to report sales totals by vendor or state, or to get a count of the number of invoices that were processed each day of the month.
Lesson 6: Working with Sub Queries
A subquery is a SELECT statement that's coded within another SQL statement. You can use subqueries to build queries that would be difficult or impossible to do otherwise. In this lesson you will learn how to use subqueries within SELECT statements.
Lesson 7: Inserting, Updating, and Deleting Data
In this lesson you'll learn how to code the INSERT, UPDATE, and DELETE statements to modify the data in a table. When you're done with this lesson, you'll know how to code the four statements that are used every day by professional SQL programmers.
Lesson 8: Working with Data Types
So far, you have been using SQL statements to work with the three most common types of data: strings, numbers, and dates. Now, this lesson takes a more in-depth look at the data types that are available with SQL Server and shows some basic skills for working with them.
Lesson 9: Working with Functions
This lesson expands on the SELECT concepts from Lesson 3 by presenting many more of the scalar functions. When you complete this lesson, you'll have a thorough understanding of the functions that you can use with SQL Server.
Lesson 10: Designing a Database
In this lesson you'll learn how to design a new database. This is useful information for the SQL programmer whether or not you ever design a database on your own.
Lesson 11: How to Create a Database and Its Tables
Now that you've learned how to design a database, you're ready to learn how to implement your design. To do that, you use the set of SQL statement that are known as the data definition language (DDL). You can use the DDL statements to create and modify the database objects such as tables and sequences that you need for testing. Knowing what these statements do will give you a better appreciation for how a database works.
All necessary course materials are included.
System Requirements:
Internet Connectivity
- Connection Type: Broadband (Cable, Fiber, DSL) or LEO Satellite (e.g., Starlink)
- Minimum Speed: 10 Mbps download / 5 Mbps upload
Note: While cellular hotspots may allow basic access, high latency and fluctuating speeds can cause disconnects during videos, quizzes, or live sessions. Cellular hotspots are not recommended as a primary connection.
Hardware
- Processor: Dual-core 2.0 GHz or higher
- Memory (RAM): 8 GB or higher (4 GB minimum)
- Display Resolution: 1280 x 720 minimum (1920 x 1080 recommended)
- Audio/Video: Speakers or headphones; microphone and webcam (recommended for Live Online sessions)
Operating Systems
- Windows: Windows 10 or Windows 11
- Mac: macOS 13 (Ventura) or newer
- ChromeOS / Linux: Latest supported release
Note: While courses may load on iOS and Android devices, phones and small tablets are not recommended. Their smaller screen sizes and mobile browsers do not provide an optimal environment for coursework or live online sessions.
Web Browsers
- Google Chrome (Latest version — Recommended)
- Mozilla Firefox (Latest version)
- Microsoft Edge (Latest version)
- Apple Safari (Latest version)
Tip: Ensure JavaScript and cookies are enabled, and pop-up blockers are disabled for the learning portal.
Recommended Software
The following software is recommended for viewing and completing general course materials (individual courses may require additional software as noted in the course outline above):
- Productivity Suite: Microsoft 365/Office, Google Workspace, or LibreOffice
- PDF Reader: Adobe Acrobat Reader, Foxit PDF Reader, or a built-in browser PDF viewer
** The course outlines displayed on this website are subject to change at any time without prior notice. **