SQL Essential Training
4.8 /5- Offered byLinkedin Learning
SQL Essential Training at Linkedin Learning Overview
Duration | 4 hours |
Total fee | ₹1,150 |
Mode of learning | Online |
Difficulty level | Beginner |
Credential | Certificate |
SQL Essential Training at Linkedin Learning Highlights
- Earn a sharable certificate
- 1 exercise file for practice
- 9 quizzes to test knowledge
SQL Essential Training at Linkedin Learning Course details
- In this course, Walter Shields teaches learner: the basic structure of databases—what they are, how they work, and how to successfully navigate them; how to use SQL to retrieve and understand data no matter the scale of a database; and how to master the most important SQL query syntax, along with how and when to use it best
SQL Essential Training at Linkedin Learning Curriculum
Introduction
The data-driven world
42s
What you should know
The Basics of Database Structures
Relational database theory
The SQLite database engine
The SQL Stack
WSDA Music (sample database)
The DB Browser software
How to install DB Browser
Learning tips
The SQLite Database Environment
How to access the DB Browser for SQLite software
Load the sample database file
Getting familiar with a database
The browse data area
The query writing area
Composing Queries
Queries
Query commenting
Query composition
Query composition best practices
Column custom names
Sorting query results
Limiting query results
Discovering Insights in Data
Types of SQL operators
Filter and analyze numeric data
BETWEEN and IN operators
Filter and analyze text data
Search records without an exact match
Filter and analyze using dates
Filter records based on more than one condition
Logical operator OR
Brackets and order
IF THEN logic with CASE
Accessing Data from Multiple Tables
Joins explained
How tables share a relationship, part 1
How tables share a relationship, part 2
Simplifying JOINs
Types of JOINs
The INNER JOIN
The LEFT JOIN
The RIGHT JOIN
Tables and Entity Relationship diagrams
Joining many tables
SQL Functions
Calculating with functions
String, date, and aggregate function types
Connecting strings
Separating text
UPPER and LOWER string functions
Date functions
Aggregate functions
Nesting functions
Grouping
Grouping your query results
Filtering with a grouped condition
Grouping with the WHERE clause
Grouping with the HAVING clause
Grouping with the WHERE and HAVING clause
Grouping by many fields
Nesting Queries
Subqueries and aggregate functions
SELECT clause subquery
Aggregated subqueries
Non-aggregate subqueries
IN clause subquery
DISTINCT clause subquery
Stored Queries
View introduction
Creating a view
Editing a view
Joining views
Deleting views
Adding, Modifying, and Deleting Data
Analysis and administration
Inserting data
Updating data
Deleting data
Project Missing Money Matters
Project challenges
Project solution, part 1
Project solution, part 2
Project solution, part 3
Conclusion
Next steps and tips
SQL Essential Training at Linkedin Learning Faculty details
Other courses offered by Linkedin Learning
Student Forum
Anything you would want to ask experts?