All The SQL You Will Need Unless You Are A DBA

Learn Relational Database Concepts And How To Manipulate Data With SQL

Created byCraig Kaercher

Last updated 10/2021

English

English [Auto],

What you'll learn

The four actions a user or applications programmer can do to a relational database.
How a relational database works
The major relational databases available to everyone for practicing
Learn how to design a database, tables, and relationships

Course content

10 sections • 21 lectures • 6h 9m total length

Introduction1:13:22
After this lecture you will know the four big SQL statements that are not involved in administrative aspects of a relational database. Additionally, you will see how what we are doing in SQL statements is what we do in Microsoft Access without SQL statements. Additionally, you will be exposed to some free software that will make your first database creation a lot easier.

A Database Has Many Tables, Each Table Has Many Fields8:05
How Tables Relate14:27
Creating A Database And First Table5:51
Here we will show how to use IDEs to create databases and a table both with and without SQL. The CREATE TABLE SQL command is not one of the big four statements because most of the time the database and tables are already set up for you. However it is good to understand CREATE TABLE so when you are in a position where the database does not allow you to create a database and table through the menus, you can do it in SQL.

Basics Of A SELECT Statement10:24
Learn the basics of a SELECT statement, the statement pretty much everybody will have the ability to perform. It reads data from the database but does not change the contents of the database.
Options For The WHERE Clause19:29
Learn how to qualify what data you read so you get exactly the data you want.
Using Between13:42
Use the BETWEEN clause to qualify what data you want.
Using LIKE20:11
Use the LIKE clause to qualify what data you want.
Using Sub SELECTs15:21
Use a sub SELECT to qualify what data you want.
SELECTing Information Using Functions35:54
This lecture shows how to use the functions available to get information from fields on the table.
Aggregate Functions30:58
This shows how to use aggregate functions like SUM and AVERAGE to get information from many rows at the same time from the table.
Other Special Techniques5:24
This shows how to use even more special techniques to get information.

Requirements

None, just an interest in learning to be more knowledgeable and valuable in the job market.
A relatively modern computer or laptop. Anything from Windows 7 on up. Microsoft Access and Excel would be good to have.

Description

In this course we first get to understand how relational databases work. Relational databases are the backbone of how data is stored in the corporate world. Once we understand that, we focus on the four main SQL statements a business user and/or application programmer are likely to use. These four statements are SELECT(read data from the tables), INSERT(add row(s) to a single table), DELETE(delete rows from a single table), and UPDATE(change data in column(s) for selected records of a selected table). To do this we go into a number of related topics such as JOINs, VIEWs, functions, derived fields and more. The goal of the course is not just for you to learn the syntax of SQL statements. The goal of this course is for you to understand how databases are organized, the logic of them, the bigger picture of what 'relational' means, as well as how you can manipulate the data in them. In the course we will primarily use SQL Server, but reference Access and Excel a lot as most people without experience writing SQL will be more familiar with the concepts using these applications. What you know in Excel is relevant to databases. Functions are relevant. Constructing a formula is relevant. By the end of the class you will be very knowledgeable about relational databases and how to manipulate data using SQL.

Who this course is for:

Programmers, students, or business users who want to be able to get information for themselves without having to go to the IT department.
Application programmers or programming students who are interested in integrating a database into a programming language(Python).

All The SQL You Will Need Unless You Are A DBA

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 1hr 13min

The Relational Database Model3 lectures • 28min

First Action: Read Information From A Database Without Changing Anything8 lectures • 2hr 31min

The DELETE Statement - Be Careful!2 lectures • 32min

Using the UPDATE Statement1 lecture • 13min

Using The INSERT Statement2 lectures • 32min

Combining Tables Using JOINs1 lecture • 10min

Combine Tables Using VIEWs1 lecture • 6min

SELECTing From Multiple Tables1 lecture • 19min

Conclusion1 lecture • 4min

Requirements

Description

Who this course is for: