Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Cybrary

Introduction to SQL

via Cybrary

Overview

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.

Syllabus

  • Module 1: Course Introduction
    • 1.1 Course Flyover Part 1
    • 1.2 Course Flyover Part 2
    • 1.3 Database Engines
    • 1.4 MySQL Installation on Windows
    • 1.5 DBeaver Installation Under Windows
    • 1.6 MySQL Installation Under Ubuntu Linux
    • 1.7 DBeaver Installation Under Ubuntu Linux
  • Module 2: Databases
    • 2.1 Database Tables
    • 2.2 One to One Relationships Part 1
    • 2.3 One to One Relationships Part 2
    • 2.4 One to Many Relationships Part 1
    • 2.5 One to Many Relationships Part 2
    • 2.6 Many to Many Relationships
    • 2.7 Ubuntu Linux Installation
    • 2.8 Many to Many Explored
    • 2.9 Windows Installation
    • 2.10 ERD Software
    • 2.11 ERD One to One Relationships
    • 2.12 ERD One to Many Relationships
    • 2.13 ERD Many to Many Relationships
    • 2.14 Polymorphic Models
    • 2.15 Basic Admin
    • 2.16 Join Introduction
    • 2.17 Inner Join
    • 2.18 Left Outer Join
    • 2.19 Right Outer Join
    • 2.20 Using Key Word
    • 2.21 Cross Join
  • Module 3: SQL Programming Part 1
    • 3.1 Database Installation
    • 3.2 Select Statement
    • 3.3 Update Statement
    • 3.4 Insert Statement
    • 3.5 Delete Statement
    • 3.6 Data Types
    • 3.7 Sub Queries
    • 3.8 Complex Update
    • 3.9 Complex Delete
    • 3.10 Purpose and Limitations
    • 3.11 Create View
    • 3.12 Table Expressions
    • 3.13 Advanced CTE
    • 3.14 CTE in Views
    • 3.15 Create Table Statement
    • 3.16 Primary Keys
    • 3.17 Foreign Keys
    • 3.18 Constraints
    • 3.19 Indexes
  • Module 4: SQL Programming Part 2
    • 4.1 Functions Part 1
    • 4.2 Functions Part 2
    • 4.3 String Functions
    • 4.4 User Defined Function Part 1
    • 4.5 User Defined Function Part 2
    • 4.6 Procedures Part 1
    • 4.7 Procedures Part 2
    • 4.8 Transactions and Rollbacks
    • 4.9 Rollback
    • 4.10 Save Points
    • 4.11 Concurrency Problems Part 1
    • 4.12 Concurrency Problems Part 2
    • 4.13 Intro to Events
    • 4.14 Events
  • Module 5: SQL Development
    • 5.1 Design Pattern MVC
    • 5.2 Identify Requirements
    • 5.3 Tags Model
    • 5.4 Categories Model
    • 5.5 Articles Model
    • 5.6 Foreign Keys for Images Table
    • 5.7 Foreign Keys for Comments Table
    • 5.8 Tags Foreign Keys
    • 5.9 Categories Foreign Keys
    • 5.10 Articles Foreign Keys
    • 5.11 Audit Table
    • 5.12 Procedure
    • 5.13 Technical Debt and Good Design
  • Module 6: SQL in Applications
    • 6.1 Power Bi Report Example
    • 6.2 MySQL ODBC Driver
    • 6.3 Excel Report Example
  • Module 7: Course Closing
    • 7.2 Where to Go From Here

Taught by

Kitt Parker

Reviews

Start your review of Introduction to SQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.