SQL Quickstart Workshop 1
THE BEST SQL COURSE FOR BEGINNERS IN 2022 - HANDS DOWN!
INCLUDES FREE COPY OF MY #1 BEST SELLING BOOK, ACCESS TO A SAMPLE DATABASE, SQL BROWSER APP AND COMPREHENSION QUIZES!
LIVE Cohort based - Learn as a Group
Walter Teaches Live via Zoom
Group Based Quizzes
Access To Private Group
Data analytics shouldn’t be so complicated. Future-proof your career and learn to analyze data with SQL. Based on my Best-selling SQL book, used in college level courses, "SQL Quickstart Guide". Become one of the most in-demand professionals and analyze big data with ease!
Here's What You'll Learn:
01 UNDERSTANDING DATABASE STRUCTURE
In this module you will be introduced to the concept of a relational database, the SELECT statement and showcase the types of data you will encounter in a database:
Understanding the language databases use
How a relational database functions
Data types
Relational database management systems (RDBMSs)
SQLite
02 SQL TOOLS AND STRATEGIES
In this module you will become familiar with the resources intended to be used in conjunction with this course, as well as the many exercises and self-assessment questions that will help you test your SQL knowledge:
Setting up our SQL environment
The sTunes database
DB Browser for SQLite
Self-assessments
SQL learning strategies
03 EXPLORING A DATABASE IN SQLITE
In this module, we will familiarize ourselves with the interface of our chosen SQL browser for SQLite: DB Browser:
Launching the SQL software
Opening a database file
The Database Structure tab
The Browse Data tab
The Execute SQL tab
04 GETTING STARTED WITH QUERIES
In this module you will cover the basics of writing a good query and formatting the results. By the end of this module you will be able to select individual fields from a specific database and display those fields in alphabetical order:
Query notation techniques
SQL query basics
Using an alias
Sorting results alphabetically
Limiting query results