Sql Bootcamp Hands-On Exercises — Sql Server — Part 1 (2023)

Practice 100 SQL exercises interactively to solidify your SQL and database knowledge.

What you'll learn

Solve 100 exercises using the SQL programming language

Learn SQL with practical hands-on 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

Requirements

No programming experience needed — you will learn everything you need to know.

No set-up required — Everything needed to practice and master SQL is provided.

Write SQL and get immediate response and answers interactively.

Description

Are you ready to take your SQL skills to the next level? Do you want to become proficient in SQL, the industry-standard language for managing and manipulating data? Look no further! Our Udemy course, 'SQL Bootcamp Hands-on Exercises — SQL Server — Part 1 (2023),' is the perfect fit for you.Practice 100 SQL exercises interactively using SQL programming language — interactive SQL exercises with explanations. This course contains 100 SQL exercises to TEST your knowledge of SQL using a fictional Healthcare database. You will practice by writing SQL queries to create a database, create tables and insert data into tables.You will run SQL operations to add, retrieve and analyze data in a database using sorting, filtering and grouping.This complete SQL bootcamp will test and solidify your SQL skills. This course is perfect for anyone — from beginner to master SQL developers.  This course is perfect if you have to prepare for a SQL interview, and you need a one-stop shop for all your exercises. The SQL exercises in this course are interactive. The exercises provide hints when you make an error, so you can correct the mistake and proceed with coding.The solutions to the problems and their explanations are provided after each section. Practice and write SQL right inside the course. Run the SQL code without switching programs or screens. You will solidify your knowledge of : DML - Data Manipulation Language commands to insert or update or delete data in the database.DDL - Data Definition Language commands to modify the data in the database.DQL - Data Query Language commands to access and retrieve data in a database.If you are looking for new and exciting challenges, this is the right course for you. You will go from zero to hero in SQL. This course is fit for those interested in learning and refreshing their SQL knowledge. This course is comprehensive and up to date for students, data engineers, data analysts and other IT professionals.Why should you take this course?SQL is in high demand for data engineering and data analysis.With the growth of cloud computing and generation of petabytes of data, SQL is one of the de-facto programming languages to access and manipulate data stored on the Cloud.Data Engineers and Software engineers are required to know SQL

Overview

Section 1: Relational vs Non-Relational Database

Lecture 1 Relational vs NoSQL Databases

Section 2: SQL Fundamentals

Lecture 2 SQL Query Block

Lecture 3 SQL Command Categories

Section 3: CREATE DATABASE

Lecture 4 What is a database?

Section 4: SQL CREATE TABLE Statement

Lecture 5 SQL Create Table

Lecture 6 Solution - Create Temporary Table

Section 5: Add Data - SQL INSERT INTO Statement

Lecture 7 Add data into a table

Lecture 8 Solution - SQL INSERT INTO

Section 6: Query Data - SQL SELECT Statement

Lecture 9 SQL SELECT

Lecture 10 Solution 3 - SQL TOP and MySQL LIMIT

Section 7: Filter Data - SQL WHERE

Lecture 11 Solution

Lecture 12 Solution

Lecture 13 Solution

Section 8: SQL TRUNCATE

Section 9: SELECT DISTINCT Statement

Lecture 14 Solution - DISTINCT

Section 10: SQL CONCAT () Function

Lecture 15 Solution - SQL CONCAT ()

Section 11: Filter Data - SQL IN Operator

Lecture 16 Solution - SQL IN

Lecture 17 Solution - SQL IN

Section 12: Filter Data - SQL NOT IN Operator

Lecture 18 Solution - SQL NOT IN

Section 13: Filter Data - SQL LIKE Operator

Lecture 19 Solution - SQL LIKE Operator and Solutions

Section 14: Sort Data - ORDER BY Clause

Lecture 20 Order By Solution

Section 15: Group Data - GROUP BY Clause

Lecture 21 Solution - SQL GROUP BY

Section 16: Group Data - SQL GROUP BY + HAVING Clauses

Lecture 22 Solution Having Clause

Section 17: Group Data - Aggregate Functions

Lecture 23 COUNT, AVG, MIN, MAX and SUM

Lecture 24 SQL GROUP Functions and Solutions

Section 18: SQL Logical Operators

Lecture 25 SQL AND, OR, NOT Logical Operators

Section 19: SQL Between Operator

Lecture 26 SQL Between and NOT Between Logical Operator

Section 20: SQL Wildcards

Lecture 27 SQL Wildcards Explained

Section 21: IS NULL and NOT NULL Operators

Lecture 28 SQL IS NULL and IS NOT NULL

Section 22: SQL ALIASES

Lecture 29 SQL ALIAS

Section 23: SQL JOINS

Lecture 30 SQL JOINS

Lecture 31 SQL JOIN, LEFT JOIN, RIGHT JOIN and UNION Solutions

Section 24: SQL VIEWS

Lecture 32 CREATE VIEW, DROP VIEW and RENAME VIEW

Section 25: Stored Procedures

Section 26: Install SQL Server on Docker (Optional)

Lecture 33 Install SQL Server on Docker (Optional)

SQL Developers,Computer Science Students,Data Analysts,Data Engineers,Clinical Informaticists,Data Scientists,Software Engineers,Anyone who wants to learn and test SQL knowledge and proficiency,Anyone studying for a SQL interview,Software Testers