SQL Bootcamp Hands-On Exercises — Learn SQL by Coding 2024
Learn SQL by Coding. Learn SQL with Quizzes, Exercises and Real-World Examples on SQL Server and MySQL.
4.00 (2 reviews)
6
students
1 hour
content
Jun 2024
last update
$39.99
regular price
What you will learn
Use the SQL language to solve SQL problems
Build your SQL skills through interactive SQL exercises on SQL Server and MySQL
Create database objects — tables, views and stored procedures using DML commands
Add data to a database using DML – Data Manipulation Language commands — SQL INSERT INTO
Retrieve data using DQL – Data Query Language commands
INNER, OUTER and UNION joins to combine table(s) and find patterns in data
Create complex SQL queries to filter and aggregate data
Aggregate functions COUNT(), MAX(), MIN(), SUM(), AVG() to analyze and group data
SQL Aliases to enhance SQL code readability and functionality
Delete data using TRUNCATE
Data analysis using SQL Wildcards and SQL logical operators
Analyze data using IS NULL, IS NOT NULL, BETWEEN and NOT BETWEEN etc.
Create and execute Stored Procedures
Practice for your SQL interview
Related Topics
4543350
udemy ID
2/10/2022
course created date
10/25/2022
course indexed date
Bot
course submited by