Free

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

Development Review

2m

Review and Closing
Introduction

7m

Course Overview
Database Engines

2m

Quick Review
Vagrant

4m

Environment Setup
Requirement Overview

7m

Intermediate Database Development I
Indexes

8m

Intermediate Database Development II
Data Types

9m

Intermediate SQL Programming I
Functions

8m

Intermediate SQL Programming II
Server Hardware

7m

SQL Optimizations
Database Structure Review

2m

Review and Closing
Course Flyover

5m

Course Overview
Install VirtualBox

7m

Environment Setup
Implement Models Part 1

13m

Intermediate Database Development I
Clustered Indexes

2m

Intermediate Database Development II
Aggregation Functions

13m

Intermediate SQL Programming I
Procedures

5m

Intermediate SQL Programming II
Execution Plans

11m

SQL Optimizations
Optimization Review

2m

Review and Closing
Inner Join

4m

Quick Review
Install Vagrant

5m

Environment Setup
Implement Models Part 2

14m

Intermediate Database Development I
Composite Key

9m

Intermediate Database Development II
Aggregation Queries

17m

Intermediate SQL Programming I
Views

5m

Intermediate SQL Programming II
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

    Instructor
    Kitt Parker

    I am a technology enthusiast who loves to learn about new and evolving tech. At a young age, I began building my own personal computers and also started exploring various programming languages while in high school. As soon as high school ended, I joined the Air Force for 8 years. During my time in the military I earned a Bachelor of Science in Information Technology. After a great experience in the US Air Force, I exited the military with an honorable discharge, activated my GI Bill and earned a Bachelor of Science in Computer Science at a local university while working full time. The second degree allowed me to further envelop myself in the topic I loved while being able to skip the normally associated costs, a fantastic advantage provided through military service. I currently work as a Business Intelligence Developer that provides me with a wide range of professional experience that varies from complex server management techniques to developing applications via full stack programming. I have varied experience across multiple computer programming languages that include Python, PHP, C#, Visual Basic, C++, SQL.

    Provider
    Cybrary Logo
    Certification Body
    Certificate of Completion

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