COURSE

Introduction to SQL

Course

This introductory SQL training teaches SQL core concepts that can be applied in professional environments. Once students complete this course, they will be able to query and interact with an SQL database, and know how to design database schemas.
Full access included with 
Insider Pro
 and 
Teams

7

H

37

M
Time

beginner

i
Designed for learners who have no prior work experience in IT or Cybersecurity, but are interested in starting a career in this exciting field.
Designed for learners with prior cybersecurity work experience who are interested in advancing their career or expanding their skillset.
Designed for learners with a solid grasp of foundational IT and cybersecurity concepts who are interested in pursuing an entry-level security role.
Experience Level

3

i

Earn qualifying credits for certification renewal with completion certificates provided for submission.
CEU's

Enrollees

Learners at 96% of Fortune 1000 companies trust Cybrary

About this course

Read More

Skills you'll gain

Course Outline

1
Module 1: Course Introduction
0
H
31
Min
1
Module 2: Databases
1
H
59
Min
1
Module 3: SQL Programming Part 1
1
H
57
Min
1
Module 4: SQL Programming Part 2
1
H
55
Min
1
Module 5: SQL Development
0
H
54
Min
1
Module 6: SQL in Applications
0
H
17
Min
1
Module 7: Course Closing
0
H
3
Min

6.1 Power Bi Report Example

Free

6m

5.1 Design Pattern MVC

Free

7m

4.1 Functions Part 1

Free

7m

3.1 Database Installation

Free

3m

2.1 Database Tables

Free

5m

1.1 Course Flyover Part 1

Free

2m

7.2 Where to Go From Here

Free

3m

6.2 MySQL ODBC Driver

Free

4m

5.2 Identify Requirements

Free

4m

4.2 Functions Part 2

Free

8m

3.2 Select Statement

Free

8m

2.2 One to One Relationships Part 1

Free

7m

1.2 Course Flyover Part 2

Free

5m

6.3 Excel Report Example

Free

7m

5.3 Tags Model

Free

4m

4.3 String Functions

Free

14m

3.3 Update Statement

Free

2m

2.3 One to One Relationships Part 2

Free

11m

1.3 Database Engines

Free

6m

5.4 Categories Model

Free

2m

4.4 User Defined Function Part 1

Free

11m

3.4 Insert Statement

Free

7m

2.4 One to Many Relationships Part 1

Free

7m

1.4 MySQL Installation on Windows

Free

4m

5.5 Articles Model

Free

4m

4.5 User Defined Function Part 2

Free

10m

3.5 Delete Statement

Free

5m

2.5 One to Many Relationships Part 2

Free

5m

1.5 DBeaver Installation Under Windows

Free

4m

5.6 Foreign Keys for Images Table

Free

2m

4.6 Procedures Part 1

Free

9m

3.6 Data Types

Free

5m

2.6 Many to Many Relationships

Free

5m

1.6 MySQL Installation Under Ubuntu Linux

Free

6m

5.7 Foreign Keys for Comments Table

Free

5m

4.7 Procedures Part 2

Free

10m

3.7 Sub Queries

Free

8m

2.7 Ubuntu Linux Installation

Free

4m

1.7 DBeaver Installation Under Ubuntu Linux

Free

4m

5.8 Tags Foreign Keys

Free

4m

4.8 Transactions and Rollbacks

Free

7m

3.8 Complex Update

Free

9m

2.8 Many to Many Explored

Free

8m

5.9 Categories Foreign Keys

Free

4m

4.9 Rollback

Free

6m

3.9 Complex Delete

Free

5m

2.9 Windows Installation

Free

6m

5.10 Articles Foreign Keys

Free

4m

4.10 Save Points

Free

6m

3.10 Purpose and Limitations

Free

6m

2.10 ERD Software

Free

5m

5.11 Audit Table

Free

4m

3.11 Create View

Free

9m

2.11 ERD One to One Relationships

Free

10m

5.12 Procedure

Free

7m

4.12 Concurrency Problems Part 2

Free

8m

3.12 Table Expressions

Free

6m

2.12 ERD One to Many Relationships

Free

6m

5.13 Technical Debt and Good Design

Free

5m

4.13 Intro to Events

Free

5m

2.13 ERD Many to Many Relationships

Free

5m

4.14 Events

Free

5m

3.14 CTE in Views

Free

2m

2.14 Polymorphic Models

Free

2m

3.15 Create Table Statement

Free

6m

2.15 Basic Admin

Free

5m

3.16 Primary Keys

Free

6m

2.16 Join Introduction

Free

4m

3.17 Foreign Keys

Free

5m

2.17 Inner Join

Free

5m

3.18 Constraints

Free

7m

2.18 Left Outer Join

Free

5m

3.19 Indexes

Free

6m

2.19 Right Outer Join

Free

4m

2.20 Using Key Word

Free

4m

2.21 Cross Join

Free

6m

6.1 Power Bi Report Example

6m

Module 6: SQL in Applications
5.1 Design Pattern MVC

7m

Module 5: SQL Development
4.1 Functions Part 1

7m

Module 4: SQL Programming Part 2
3.1 Database Installation

3m

Module 3: SQL Programming Part 1
2.1 Database Tables

5m

Module 2: Databases
1.1 Course Flyover Part 1

2m

Module 1: Course Introduction
7.2 Where to Go From Here

3m

Module 7: Course Closing
6.2 MySQL ODBC Driver

4m

Module 6: SQL in Applications
5.2 Identify Requirements

4m

Module 5: SQL Development
4.2 Functions Part 2

8m

Module 4: SQL Programming Part 2
3.2 Select Statement

8m

Module 3: SQL Programming Part 1
1.2 Course Flyover Part 2

5m

Module 1: Course Introduction
6.3 Excel Report Example

7m

Module 6: SQL in Applications
5.3 Tags Model

4m

Module 5: SQL Development
4.3 String Functions

14m

Module 4: SQL Programming Part 2
3.3 Update Statement

2m

Module 3: SQL Programming Part 1
1.3 Database Engines

6m

Module 1: Course Introduction
5.4 Categories Model

2m

Module 5: SQL Development
4.4 User Defined Function Part 1

11m

Module 4: SQL Programming Part 2
3.4 Insert Statement

7m

Module 3: SQL Programming Part 1
1.4 MySQL Installation on Windows

4m

Module 1: Course Introduction
5.5 Articles Model

4m

Module 5: SQL Development
Course Description

The Introduction to SQL course introduces a student to common concepts from the application of SQL in professional environments that permits the accurate and effective use of SQL language constructs. Upon completion you will understand how to query and interact with a SQL database, how to write effective queries for use in reporting applications, and how to design simple database schemas for light applications.

What is SQL?

Structured Query Language (SQL) is a domain-specific programming language used to manage data that stored in relational database management systems (RDBMS), or to perform stream processing in relational data stream management systems (RDSMS). In other words, SQL is a programming language that is used to interact with a database.

SQL has a long history as a universal coding language and has been used since 1974. It helps programmers transition into learning other computing programming languages such as JavaScript and Python.

What is this SQL Training Online Like?

Cybrary’s SQL training online is designed to teach students the basics of the SQL language. Students will learn about databases, SQL programming, SQL development, SQL in applications, and how to proceed further in their career paths. The course is online and self-paced. Upon completion, students will understand core concepts related to the application of SQL and will be able to write queries to use in reporting applications and create straightforward database schemas for applications.

How Hard is it to Learn SQL?

SQL is not difficult to learn. It doesn’t require any prior programming experience, which makes it a good place to start. Because SQL is an English-like language, anyone who uses English, even at a basic level, can write SQL queries with ease. In addition, once someone knows SQL, they should be simple to work with any relational databases, as most are compatible with SQL.

Who Should Take SQL Training Online?

SQL is a universal database query language that is widely used. Both novice and experienced IT professionals should become well-versed in SQL. Additionally, this SQL training online is ideal for individuals who are in the following job positions, or who are targeting these positions in the future: * Project managers – It’s important that project managers know all the inputss and outputss of their projects, and it’s the data which tells them their project's status. * Database developers – Both frontend and backend developers need to know SQL, though frontend developers may not use it as much. * Data scientists – These professionals are the ones who understand data better than any others. It’s essential, therefore, that they have a thorough understanding of SQL. * Data Analysts – Data analysts need to understand relational databases so knowing SQL is a must. * Data Engineers – Data engineers are the individuals who design and manage databases, so it’s vital that they know SQL.

Why Learn SQL?

There are numerous reasons to learn SQL, even though there are more modern database languages out there. Here are just a few:

* SQL is the most commonly used database language. These days, data is a valuable asset and it’s at the center of most business-related decisions. SQL has been, and continues to be, the most universal interface for data analysis. It empowers the most frequently used database engines such as SQL Server, SQLite, MySQL, and PostgreSQL. * SQL is easy to learn. The major objective when SQL was created was to allow common people to get data of interest from databases. * SQL is a skill that is sought-after by employers. Many hiring managers look to hire IT team members who have SQL as a skill. This doesn’t only apply specifically to SQL developers, but also to other roles like web developers, data scientists, desktop developers, SysAdmins, etc. * SQL knowledge can garner higher salaries. The national average annual salary for SQL Developers is over $70,000, with the top end of the pay scale hitting nearly $110,000 per year. As with other IT job openings, there are currently more SQL Developer (and related roles) openings that there are professionals to fill them. Learning SQL can put you in a small group of highly sought-after professionals.

What is the Best Way to Learn SQL?

SQL has been around for a long time, and it isn’t going anywhere soon. It’s an essential query language for IT professionals to know, as a starting point to learn other languages like Python and JavaScript.

Cybrary’s Introduction to SQL course is a great way to learn SQL. The online course is convenient, self-paced, and thorough. To register for this course, click the Register button at the top right of this screen.

Train Your Team

Cybrary’s expert-led cybersecurity courses help your team remediate skill gaps and get up-to-date on certifications. Utilize Cybrary to stay ahead of emerging threats and provide team members with clarity on how to learn, grow, and advance their careers within your organization.

Included in a Path

Instructors

Kitt Parker
Read Full Bio
Learn

Learn core concepts and get hands-on with key skills.

Practice

Exercise your problem-solving and creative thinking skills with security-centric puzzles

Prove

Assess your knowledge and skills to identify areas for improvement and measure your growth

Get Hands-on Learning

Put your skills to the test in virtual labs, challenges, and simulated environments.

Measure Your Progress

Track your skills development from lesson to lesson using the Cybrary Skills Tracker.

Connect with the Community

Connect with peers and mentors through our supportive community of cybersecurity professionals.

Success from Our Learners

"Cybrary really helped me get up to speed and acquire a baseline level of technical knowledge. It offers a far more comprehensive approach than just learning from a book. It actually shows you how to apply cybersecurity processes in a hands-on way"

Don Gates

Principal Systems Engineer/SAIC

"Cybrary’s SOC Analyst career path was the difference maker, and was instrumental in me landing my new job. I was able to show the employer that I had the right knowledge and the hands-on skills to execute the role."

Cory

Cybersecurity analyst/

"I was able to earn my CISSP certification within 60 days of signing up for Cybrary Insider Pro and got hired as a Security Analyst conducting security assessments and penetration testing within 120 days. This certainly wouldn’t have been possible without the support of the Cybrary mentor community."

Mike

Security Engineer and Pentester/

"Cybrary really helped me get up to speed and acquire a baseline level of technical knowledge. It offers a far more comprehensive approach than just learning from a book. It actually shows you how to apply cybersecurity processes in a hands-on way"

Don Gates

Principal Systems Engineer/SAIC

"Cybrary’s SOC Analyst career path was the difference maker, and was instrumental in me landing my new job. I was able to show the employer that I had the right knowledge and the hands-on skills to execute the role."

Cory

Cybersecurity analyst/

"I was able to earn my CISSP certification within 60 days of signing up for Cybrary Insider Pro and got hired as a Security Analyst conducting security assessments and penetration testing within 120 days. This certainly wouldn’t have been possible without the support of the Cybrary mentor community."

Mike

Security Engineer and Pentester/

"Becoming a Cybrary Insider Pro was a total game changer. Cybrary was instrumental in helping me break into cybersecurity, despite having no prior IT experience or security-related degree. Their career paths gave me clear direction, the instructors had real-world experience, and the virtual labs let me gain hands-on skills I could confidently put on my resume and speak to in interviews."

Cassandra

Information Security Analyst/Cisco Systems

"I was able to earn both my Security+ and CySA+ in two months. I give all the credit to Cybrary. I’m also proud to announce I recently accepted a job as a Cyber Systems Engineer at BDO... I always try to debunk the idea that you can't get a job without experience or a degree."

Casey

Cyber Systems Engineer/BDO

"Cybrary has helped me improve my hands-on skills and pass my toughest certification exams, enabling me to achieve 13 advanced certifications and successfully launch my own business. I love the practice tests for certification exams, especially, and appreciate the wide-ranging training options that let me find the best fit for my goals"

Angel

Founder,/ IntellChromatics.

Introduction to SQL

This introductory SQL training teaches SQL core concepts that can be applied in professional environments. Once students complete this course, they will be able to query and interact with an SQL database, and know how to design database schemas.
7
37
M
Time
beginner
difficulty
3
ceu/cpe

Course Content

Course Description

The Introduction to SQL course introduces a student to common concepts from the application of SQL in professional environments that permits the accurate and effective use of SQL language constructs. Upon completion you will understand how to query and interact with a SQL database, how to write effective queries for use in reporting applications, and how to design simple database schemas for light applications.

What is SQL?

Structured Query Language (SQL) is a domain-specific programming language used to manage data that stored in relational database management systems (RDBMS), or to perform stream processing in relational data stream management systems (RDSMS). In other words, SQL is a programming language that is used to interact with a database.

SQL has a long history as a universal coding language and has been used since 1974. It helps programmers transition into learning other computing programming languages such as JavaScript and Python.

What is this SQL Training Online Like?

Cybrary’s SQL training online is designed to teach students the basics of the SQL language. Students will learn about databases, SQL programming, SQL development, SQL in applications, and how to proceed further in their career paths. The course is online and self-paced. Upon completion, students will understand core concepts related to the application of SQL and will be able to write queries to use in reporting applications and create straightforward database schemas for applications.

How Hard is it to Learn SQL?

SQL is not difficult to learn. It doesn’t require any prior programming experience, which makes it a good place to start. Because SQL is an English-like language, anyone who uses English, even at a basic level, can write SQL queries with ease. In addition, once someone knows SQL, they should be simple to work with any relational databases, as most are compatible with SQL.

Who Should Take SQL Training Online?

SQL is a universal database query language that is widely used. Both novice and experienced IT professionals should become well-versed in SQL. Additionally, this SQL training online is ideal for individuals who are in the following job positions, or who are targeting these positions in the future: * Project managers – It’s important that project managers know all the inputss and outputss of their projects, and it’s the data which tells them their project's status. * Database developers – Both frontend and backend developers need to know SQL, though frontend developers may not use it as much. * Data scientists – These professionals are the ones who understand data better than any others. It’s essential, therefore, that they have a thorough understanding of SQL. * Data Analysts – Data analysts need to understand relational databases so knowing SQL is a must. * Data Engineers – Data engineers are the individuals who design and manage databases, so it’s vital that they know SQL.

Why Learn SQL?

There are numerous reasons to learn SQL, even though there are more modern database languages out there. Here are just a few:

* SQL is the most commonly used database language. These days, data is a valuable asset and it’s at the center of most business-related decisions. SQL has been, and continues to be, the most universal interface for data analysis. It empowers the most frequently used database engines such as SQL Server, SQLite, MySQL, and PostgreSQL. * SQL is easy to learn. The major objective when SQL was created was to allow common people to get data of interest from databases. * SQL is a skill that is sought-after by employers. Many hiring managers look to hire IT team members who have SQL as a skill. This doesn’t only apply specifically to SQL developers, but also to other roles like web developers, data scientists, desktop developers, SysAdmins, etc. * SQL knowledge can garner higher salaries. The national average annual salary for SQL Developers is over $70,000, with the top end of the pay scale hitting nearly $110,000 per year. As with other IT job openings, there are currently more SQL Developer (and related roles) openings that there are professionals to fill them. Learning SQL can put you in a small group of highly sought-after professionals.

What is the Best Way to Learn SQL?

SQL has been around for a long time, and it isn’t going anywhere soon. It’s an essential query language for IT professionals to know, as a starting point to learn other languages like Python and JavaScript.

Cybrary’s Introduction to SQL course is a great way to learn SQL. The online course is convenient, self-paced, and thorough. To register for this course, click the Register button at the top right of this screen.

This course is part of a Career Path:
No items found.

Instructed by

Provider
Cybrary Logo
Certification Body
Certificate of Completion

Complete this entire course to earn a Introduction to SQL Certificate of Completion