COURSE

Intermediate SQL

Course

Ready to dive into SQL queries, aggregations, events, and database schemas? In our Intermediate SQL course, you’ll learn about these concepts; how they’re used to implement solutions and transactions that preserve data integrity; and how to utilize tools that speed up and protect development.
Full access included with 
Insider Pro
 and 
Teams

9

H

42

M
Time

intermediate

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

10

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
Course Overview
0
H
11
Min
1
Quick Review
0
H
22
Min
1
Environment Setup
1
H
8
Min
1
Intermediate Database Development I
1
H
53
Min
1
Intermediate Database Development II
1
H
29
Min
1
Intermediate SQL Programming I
1
H
48
Min
1
Intermediate SQL Programming II
1
H
25
Min
1
SQL Optimizations
1
H
17
Min
1
Review and Closing
0
H
9
Min

Server Hardware

Free

7m

Functions

Free

8m

Data Types

Free

9m

Indexes

Free

8m

Requirement Overview

Free

7m

Vagrant

Free

4m

Introduction

Free

7m

Database Engines

Free

2m

Development Review

Free

2m

Execution Plans

Free

11m

Procedures

Free

5m

Aggregation Functions

Free

13m

Clustered Indexes

Free

2m

Implement Models Part 1

Free

13m

Install VirtualBox

Free

7m

Course Flyover

Free

5m

Explicit vs. Implicit Joins

Free

6m

Database Structure Review

Free

2m

Indexes Explained

Free

7m

Views

Free

5m

Aggregation Queries

Free

17m

Composite Key

Free

9m

Implement Models Part 2

Free

14m

Install Vagrant

Free

5m

Inner Join

Free

4m

Optimization Review

Free

2m

Full Table and Index Scan

Free

8m

Triggers

Free

6m

Common Table Expressions (CTE)

Free

10m

Database Seeder Update

Free

13m

Implement Constraints

Free

13m

Setup Vagrant

Free

14m

Left Join

Free

3m

Congratulations!

Free

1m

Partitions

Free

8m

Common Table Expressions with Aggregations

Free

10m

Function

Free

11m

Implement Model Relationships Part 1

Free

9m

Laravel Tooling

Free

11m

Right Join

Free

5m

Where to go From Here

Free

2m

Module 8 Challenge Part 1

Free

7m

Module 7 Challenge Part 1

Free

19m

Acumatica Database

Free

4m

Longing Table

Free

5m

Database Migrations

Free

13m

Implement Model Relationships Part 2

Free

7m

Key Types

Free

3m

Module 8 Challenge Part 2

Free

7m

Module 7 Challenge Part 2

Free

23m

Unions

Free

8m

Triggers

Free

8m

Modeling with Laravel

Free

13m

Laravel Tinker for Testing

Free

11m

Module 8 Challenge Part 3

Free

10m

Module 7 Challenge Part 3

Free

4m

Running Totals

Free

6m

Seeding the Database Part 1

Free

16m

Module 8 Challenge Part 4

Free

14m

Module 7 Challenge Part 4

Free

10m

Module 6 Challenge Part 1

Free

14m

Transactional Procedure Part 1

Free

11m

Seeding the Database Part 2

Free

14m

Module 6 Challenge Part 2

Free

18m

Transactional Procedure Part 2

Free

10m

Seeding the Database Part 3

Free

10m

Server Hardware

7m

SQL Optimizations
Functions

8m

Intermediate SQL Programming II
Data Types

9m

Intermediate SQL Programming I
Indexes

8m

Intermediate Database Development II
Requirement Overview

7m

Intermediate Database Development I
Vagrant

4m

Environment Setup
Introduction

7m

Course Overview
Database Engines

2m

Quick Review
Development Review

2m

Review and Closing
Execution Plans

11m

SQL Optimizations
Procedures

5m

Intermediate SQL Programming II
Aggregation Functions

13m

Intermediate SQL Programming I
Clustered Indexes

2m

Intermediate Database Development II
Implement Models Part 1

13m

Intermediate Database Development I
Install VirtualBox

7m

Environment Setup
Course Flyover

5m

Course Overview
Database Structure Review

2m

Review and Closing
Indexes Explained

7m

SQL Optimizations
Views

5m

Intermediate SQL Programming II
Aggregation Queries

17m

Intermediate SQL Programming I
Composite Key

9m

Intermediate Database Development II
Implement Models Part 2

14m

Intermediate Database Development I
Install Vagrant

5m

Environment Setup
Inner Join

4m

Quick Review
Course Description

Upon completion of this course, you will understand moderately complex database structures and concepts such as data queries, aggregation, complex joins, virtual tables, schema design, development techniques, and tooling.

What Are the Goals of This Structured Query Language Training?

This course expects you to already be familiar with development environment setup, basic queries, inner join, left join, right join, cartesian products, basic schema design, views, functions, and table expressions. If you need to learn or brush up on these concepts, we recommend enrolling in the Introduction to SQL course here at Cybrary.

By the end of this intermediate course, you should be able to:

  • Perform intermediate queries using multiple joins, common table expressions, and views
  • Perform complex aggregation queries and subqueries
  • Develop moderately complex database schemas
  • Develop complex triggering for enforcing business rules
  • Develop complex events, procedures, and functions
  • Implement solutions and transactions that preserve data integrity
  • Utilize tools that speed up and protect development
  • In this Intermediate SQL training course, you will expand your SQL knowledge as you learn more about the standard programming language.Become more confident in your ability to understand and write SQL queries.

    What is Considered to be Intermediate SQL Skills?

    SQL skills are often divided into three categories – beginner, intermediate, and advanced SQL. This training course is designed to teach the mid-level skills of SQL. Some of the skills you can expect to learn at this level include:

  • Understanding how indexes work and how to implement them
  • Understanding subqueries
  • Ability to query data across multiple tables
  • Ability to use SQL to access, read, and manipulate data, as well as perform data analysis on the information stored in a database
  • Understanding table relations and how to create and modify complex databases
  • Ability to perform recursive joins and pattern matching
  • Ability to control what the data will look like with CASE statements
  • Understanding the difference between procedural and declarative styles for SQL
  • Ability to design a database in third normal form
  • Understanding of transactions, and how to use them in a single database
  • Knowledge of when and how to analyze an execution plan
  • Understanding a relational database management system (like the Microsoft SQL Server), including relational database concepts like designing and creating a database, normalizing a table, and more.
  • What Does the Intermediate SQL Course Cover?

    In this Intermediate SQL course, students will further their understanding of structured query language and increase their knowledge and skillset of this universal coding language.Maximize your ability to write effective SQL code. You will have the opportunity to master the following:

  • Writing complex SQL queries to execute on a database
  • Designing and writing SQL queries to group, filter, and summarize complex data subsets to retrieve specific information
  • Designing and writing queries and subqueries using functions, unions, and joins
  • Applying key techniques to real-world problems
  • Who Should Take this Intermediate SQL Training?

    SQL is a query language that is widely used, so it’s something that all IT professionals (beginners and experienced) should know. Good candidates for learning SQL include anyone who is looking to build upon basic SQL skills, employees who are looking for continuing education to add value to their organizations, and business managers or owners who want to fully harness business data science.

    Before enrolling, you need to have a basic understanding of SQL and database systems. Although it’s not a prerequisite, you should have completed an introductory SQL course or have an understanding of SQL basics.

    What is the Best Way to Learn Intermediate SQL?

    If you have an understanding of SQL fundamentals and are looking to add to your SQL knowledge, our Intermediate SQL class is a great place to start. Knowing more than the basics of SQL will add valuable skills to your repertoire, making you a more well-rounded IT professional and more appealing to hiring managers and recruiters.

    Cybrary’s Intermediate SQL online training course is a convenient and comprehensive way to continue your SQL learning. Registering for this course is easy. Simply click the Enroll button to get started.

    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.

    Intermediate SQL

    Ready to dive into SQL queries, aggregations, events, and database schemas? In our Intermediate SQL course, you’ll learn about these concepts; how they’re used to implement solutions and transactions that preserve data integrity; and how to utilize tools that speed up and protect development.
    9
    42
    M
    Time
    intermediate
    difficulty
    10
    ceu/cpe

    Course Content

    Course Description

    Upon completion of this course, you will understand moderately complex database structures and concepts such as data queries, aggregation, complex joins, virtual tables, schema design, development techniques, and tooling.

    What Are the Goals of This Structured Query Language Training?

    This course expects you to already be familiar with development environment setup, basic queries, inner join, left join, right join, cartesian products, basic schema design, views, functions, and table expressions. If you need to learn or brush up on these concepts, we recommend enrolling in the Introduction to SQL course here at Cybrary.

    By the end of this intermediate course, you should be able to:

  • Perform intermediate queries using multiple joins, common table expressions, and views
  • Perform complex aggregation queries and subqueries
  • Develop moderately complex database schemas
  • Develop complex triggering for enforcing business rules
  • Develop complex events, procedures, and functions
  • Implement solutions and transactions that preserve data integrity
  • Utilize tools that speed up and protect development
  • In this Intermediate SQL training course, you will expand your SQL knowledge as you learn more about the standard programming language.Become more confident in your ability to understand and write SQL queries.

    What is Considered to be Intermediate SQL Skills?

    SQL skills are often divided into three categories – beginner, intermediate, and advanced SQL. This training course is designed to teach the mid-level skills of SQL. Some of the skills you can expect to learn at this level include:

  • Understanding how indexes work and how to implement them
  • Understanding subqueries
  • Ability to query data across multiple tables
  • Ability to use SQL to access, read, and manipulate data, as well as perform data analysis on the information stored in a database
  • Understanding table relations and how to create and modify complex databases
  • Ability to perform recursive joins and pattern matching
  • Ability to control what the data will look like with CASE statements
  • Understanding the difference between procedural and declarative styles for SQL
  • Ability to design a database in third normal form
  • Understanding of transactions, and how to use them in a single database
  • Knowledge of when and how to analyze an execution plan
  • Understanding a relational database management system (like the Microsoft SQL Server), including relational database concepts like designing and creating a database, normalizing a table, and more.
  • What Does the Intermediate SQL Course Cover?

    In this Intermediate SQL course, students will further their understanding of structured query language and increase their knowledge and skillset of this universal coding language.Maximize your ability to write effective SQL code. You will have the opportunity to master the following:

  • Writing complex SQL queries to execute on a database
  • Designing and writing SQL queries to group, filter, and summarize complex data subsets to retrieve specific information
  • Designing and writing queries and subqueries using functions, unions, and joins
  • Applying key techniques to real-world problems
  • Who Should Take this Intermediate SQL Training?

    SQL is a query language that is widely used, so it’s something that all IT professionals (beginners and experienced) should know. Good candidates for learning SQL include anyone who is looking to build upon basic SQL skills, employees who are looking for continuing education to add value to their organizations, and business managers or owners who want to fully harness business data science.

    Before enrolling, you need to have a basic understanding of SQL and database systems. Although it’s not a prerequisite, you should have completed an introductory SQL course or have an understanding of SQL basics.

    What is the Best Way to Learn Intermediate SQL?

    If you have an understanding of SQL fundamentals and are looking to add to your SQL knowledge, our Intermediate SQL class is a great place to start. Knowing more than the basics of SQL will add valuable skills to your repertoire, making you a more well-rounded IT professional and more appealing to hiring managers and recruiters.

    Cybrary’s Intermediate SQL online training course is a convenient and comprehensive way to continue your SQL learning. Registering for this course is easy. Simply click the Enroll button to get started.

    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 Intermediate SQL Certificate of Completion