Basic SQL SELECT

Focused View

Eric Manske

2:01:38

70 View

1. Introduction to Databases and Structured Query Language (SQL)

1. Welcome!.mp4

02:43

2. What is a database.mp4

01:50

3. What tools do I use with databases.mp4

02:56

4. Where do I find data for databases.mp4

02:42

5. How do I get help with databases.mp4

03:13

6. What is SQL (Structured Query Language).mp4

05:35

2. Managing One Data Set

1. Gather Data with SELECT and FROM.mp4

18:38

2. Filter and Sort with WHERE and ORDER BY.mp4

07:56

3. Aggregations with GROUP BY and HAVING.mp4

08:05

4. Standard SELECT Clauses.html

5.1 metadata queries.zip

5.2 oltp vs olap schematic.zip

5.3 oltp vs olap table.zip

5. Interlude Database Environments.mp4

06:55

6. Conjunctions (AND, OR, NOT).mp4

07:40

7. Conditions (CASE Statement).mp4

12:20

8. Section 2 Quiz.html

3. Managing Multiple Data Sets

1. JOINs.mp4

09:08

2. Interlude Considerations for Good Coding Style.mp4

13:57

3. Set Operators.mp4

03:03

4. Section 3 Quiz.html

5. Subqueries.mp4

11:45

4. Conclusion

1. Quick Summary.mp4

02:51

2. Thank you and come again!.mp4

00:21

Description

Using SQL (Structured Query Language) to select data from a database

What You'll Learn?

Understand the logic of databases and succeed at pulling data from them
Be able to answer the question, "What is SQL?" with a few different answers
Know the basics of the six standard SQL SELECT statement clauses
Understand a couple different ways to pull together data from more than one data set
Construct well-formed SQL SELECT statements that allow others (and you in the future) to understand, at a glance, the business request
Know how to pursue further SQL instruction and how to research your SQL questions

Who is this for?

Anyone who has heard of SQL and wants to know a bit about what it is

Businesspeople who have been given SQL statements and want to know more about what they have been given

Beginners with SQL (all platforms)

More details

Description
The tools of business continue to change and grow. Long ago, paper and pencil replaced rote memory and more recently were themselves replaced by computers. Analysts used to work out calculations on calculators, then switched to spreadsheet applications, like Excel. Understanding SQL used to be a skill reserved for IT personnel; now, SQL is becoming an indispensable analytical tool in the modern workplace. Just like spreadsheets were once a tool known only to specialists but are now ubiquitous in the workplace, likewise SQL is beginning to become more accessible throughout organizations.
This course focuses on the SELECT statement in SQL so stays squarely in the realm of Data Query Language (DQL) commands. Although this focus may sound limiting, understanding the SELECT statement is essential for many of the other commands, since typically the data will need to be selected first before doing something else with it. As well, many of the standard and exotic commands and functions can be easily presented with a SELECT statement, and mastery of this beginning set will prepare people for further explorations into SQL.
I learned everything IÂ know about SQLÂ on the job, and so can you. After teaching for 10 years, IÂ was pulled into IT at my first corporate position and have used SQLÂ in every role since then. I know what it is like to learn a keyword for the first time, to start exploring its uses, to be shown tricks and techniques using it by others, and to eventually gain a deeper understanding of why it works the way it does. I have trained many others in SQL in companies large and small, including some Fortune 50 companies. I have compiled my experiences and curated from those lessons what I believe to be the important initial steps to share with you. (Those of you from my past training sessions will likely recognize parts of these lessons!) I trust you will take this knowledge, and Spirit willing, share it with others.
So, without further ado, let's begin. Please click on the first lecture in section 1, the starting point to work your way through this course.
Who this course is for:
Anyone who has heard of SQL and wants to know a bit about what it is
Businesspeople who have been given SQL statements and want to know more about what they have been given
Beginners with SQL (all platforms)

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Eric Manske

Instructor's Courses

I taught high school and college math for 10 years before leaping in to the corporate world. God continues to allow me to use my gifts and background in education to train colleagues and others around me. I enjoy sharing knowledge and helping others learn, and am grateful for the opportunities to be a part of others pursuing their goals well and watching them succeed.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.