Getting Started with SQL Bootcamp

  • Duration – 25 hour

 

Are you a student or professional in the field of data science, business or systems analysis, product or maybe even contemplating an educational or career move to the SQL development world? Have you been looking for a quick and easy way to get up and running with SQL Server 2017, SQL Querying & Reporting, and don’t want to go through an overwhelming amount of material just to get your environment setup and ready for building your SQL queries that interact with data? Don’t worry as THIS IS THE COURSE FOR YOU! 

ALL SQL/MYSQL COURSES BUNDLE

$40

Getting Started with SQL Bootcamp

Section : Introduction

 

. Introduction

 

 

. Installation of SQL Server  & SSMS

 

 

. Connect To Sql Server

 

 

. Create Sample Database (MediaStoreDb)

 

 

. Generate a Database Relationship Diagram

 

Section : SELECT

 

. Get all Customer Details

 

 

. Get all Album Details

 

 

. Get Customer Fields

 

 

. Get Track Fields

 

 

. Get Employee Fields

 

Section : Column Alias

 

. Display Customer Phone Number using Custom Field Name

 

 

. Display Track Unit Price using Custom Field Alias

 

Section : DISTINCT

 

. Get Customers Unique Countries

 

 

. Get Employee Titles

 

Section : WHERE(=,<>,>,<,>=,LIKE,BETWEEN,IN

 

. Get Tracks having Track Length

Condition

 

 

. Customers having Last Name Condition

 

 

. Tracks Starting With The Letters A – F

 

 

. Tracks Not Starting With The Letters A- F

 

 

. Get Invoices Between Two Dates

 

 

. Get Customers from California and Florida

 

 

. Get Management Level Employees

 

 

. Get IT Staff Level Employees

 

 

. Customers in USA, Canada with Custom Last Name

 

 

. Customers not from USA with Custom Last Name

 

 

. Customers Missing a State Code

 

Section : ORDER BY (ASC/DESC)

 

. Customers Living in Berlin Sorted

 

 

. Most Recent Orders between Two Dates

 

 

. Employees Sorted by Title and Last Name

 

 

. Tracks Having a Composer Sorted by Name

 

Section : TOP

 

. Last Five Invoices Created

 

 

. Top % of Tracks by Length

 

 

. First Ever Invoice Created

 

Section : Aggregates/GROUP BY (SUM,AVG,COUNT,MAX,)

 

. Total Price of Each Invoice

 

 

. Total Price of Each Invoice with Condition

 

 

. Average Track Length

 

 

. Customer Count by Country

 

 

. Countries Having Less than Customers

 

 

. Invoice Count per Customer

 

 

. Longest Running Track and Total Tracks

 

 

. Average Runtime, Total Price, Highest Bytes,Total Tracks (All Albums)

 

 

. Average Runtime, Total Price, Highest Bytes,Total Tracks (Per Album)

 

Section : Concatenation

 

. Customer Display Name (Last, First)

 

 

. Apply % Discount of Track’s Unit Price

 

Section : Inner Queries/SubQueries

 

. Tracks Having Runtime Smaller than Average

 

 

. Customers with Invoices More Than Some Amount

 

 

. Tracks Having No Sales

 

 

. Genres Having No Sales

 

Section : Joins (INNER, LEFT,RIGHT)

 

. Customer, Invoice Info for Orders Placed Before March

 

 

. Invoice Details for a Specific Customer

 

 

. Total Daily Sales by Sales Agent

 

 

. Customers Having Zero Orders Placed

 

 

. Albums that Generated Zero Sales

 

Section : Stored Procedures

 

. Overview

 

 

. Create and Alter Your First Stored

Procedure

 

 

. Excel GetCustomers Report

 

Complete End to End Job Oriented Courses.

Best self paced courses created by industry experts & 24/7 support.

Knowasap Features 

300+ Courses

After your course completion, we provide course completion certificate as well.

Lifetime Access

All courses are for lifetime access.

l

Priority Support

All queries are answered 24/7.

What People Are Saying

Abhilash -

A very good match. i am enjoying every bit.

Sonal-

Experience was quite good and it was very useful and well elaborated course.

Karan-

I FEEL AS IF I AM ATTENDING A WORLD CLASS TRAINING AND THE LECTURER HAS BEEN AWESOME!

Gilbert-

I find that the explanation is good and also understandable.

Seyed-

Really helpful, recommended to everyone to grow up your future skills for next level especially in this competitive market.

Mayur-

I really like this course, it was a good match for me :))

Mahesh-

Standard process and hands on covered nicely.

 

Emily-

Perfect, with complete hands on. Well structured and nicely covered.

Kevin-

Great Content, nice and up to the mark course.

Mayuresh-

 

Great courses. Beginner friendly and the explanations are clear and very easy to understand.

Saket-

Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Tushar-

A very detailed explanation and quite handy tips and tricks! loved it

Sourabh-

 

Excellent lecture, pace of the instructor is very good, easy to understand

Rishi-

Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Mahima-

This Courses is really useful for my career and surely i will recommend other to fulfill their career goals.

 Mauricio Roldan -

A pesar de no dominar perfectamente el idioma, se entiende bien.

Emile-

Yes lessons are very good. Not so fast, well explained

Kishore-

Worth course for the beginner to invest their time to learn this demanding skills.

Learn at your pace

Courses Made By Industry Experts

Enhance your career

Enroll NowContact us