Please ensure Javascript is enabled for purposes of website accessibility
Database SQL Course With Queries Hands-On Training Using Microsoft SQL Server
0( 0 REVIEWS )
1 STUDENTS
3h 7m

Learn the basics of Database SQL with Microsoft SQL Server to develop real-world applications.

Read more.
Course Skill Level
Beginner
Time Estimate
3h 7m

Instructor

Mazhar Hussain is teaching Computer Science courses since 2015 at the National University of Computer and Emerging Sciences. He holds a Master's Degree in Computer Science and is passionate to deliver practical knowledge and skills to his students. He has been teaching courses in Artificial Intelligence (AI), Machine Learning (ML), Deep Learning (DL), Computer Vision (CV), Data Science (DS), Programming, and Databases especially SQL SERVER, MYSQL, ORACLE, and MS ACCESS for more than 5 years s


Only want this course? Buy this course for $199 $29 and keep lifetime access. Click here

About This Course

Who this course is for:

  • This course is specifically designed for anyone who is passionate to learn Database SQL Queries using SQL SERVER to develop real-world applications

What you’ll learn: 

  • How to install a free version of SQL SERVER with Management Studio
  • Understand SQL SERVER Structure
  • Create database, drop database and use database
  • Create tables and insert data into tables
  • Use SELECT, WHERE, ORDER BY, TOP, (Logical, Special, and Comparison) Operators, ALIAS, Computed Column and CASE statement
  • Built-in SQL STRING and Numeric Functions, Data Types Conversion Functions, and SQL Date and Time Functions
  • SQL Aggregate Functions, GROUP BY with Aggregate Functions, and HAVING clause to filter out grouped item result
  • Use SQL JOINS to fetch and retrieve data from multiple tables with advanced and complex queries

Requirements: 

  • You are required to install the Free Version of SQL SERVER with Management Studio
  • You do not need prior knowledge of SQL

Welcome to the Database SQL Course With Queries Hands-On Training Using Microsoft SQL Server Course.

We live in a technological era, we know that data is power, as we can extract knowledge and make important decisions. We live in an era where data is the most valuable asset and it’s being put at the heart of every decision-making process and databases are used to store data that can be easily:

  • Accessed
  • Managed
  • Modified
  • Updated
  • Analyzed
  • Controlled
  • Manipulated

SQL QUERIES are used to perform all these operations.

SQL is the top popular language after Python as compared to other languages. SQL skills are required for various jobs. Top 10 high paying jobs that demand SQL are:

  1. Data Analyst
  2. Database Developer
  3. Database Administrator
  4. Data Scientist
  5. SQL Server Developer
  6. Software Developer
  7. Software Consultant
  8. Net Developer
  9. ETL Developer
  10. Big Data engineer

The average salary of a Database Developer is $98,415 per year.

Almost all of the biggest names in tech use SQL. NETFLIX, UBER, AIRBNB, INSTAGRAM, DROPBOX, TWITTER, LINKEDIN, and the list goes on. Even within companies like Facebook, Google, and Amazon, which have built their own high-performance database systems, data teams use SQL to query data and perform analysis.

SQL queries are used with almost every programming language to interact with the database in the backend. Real-world applications like web applications, desktop applications, and mobile applications store data in the database where SQL queries are used for data manipulation.

Our Promise to You

By the end of this course, you will have learned Database SQL.

10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today!

Course Curriculum

Section 1 - Database SQL Introduction And Motivation
Database SQL Introduction And Motivation 00:00:00
Section 2 - Installing SQL SERVER And Its Structure Understanding
Installing SQL SERVER With Management Studio (Free Version) 00:00:00
Understanding SQL SERVER Structure 00:00:00
Section 3 - Creating Database And Tables In SQL
Creating Database In SQL SERVER 00:00:00
CREATE, USE And DROP DATABASE (SQL CODE) 00:00:00
Creating Tables In SQL SERVER 00:00:00
EMPLOYEES TABLE (SQL CODE) 00:00:00
Section 4 - Select Statement In SQL
SELECT Statement To Retrieve Data From Database Tables 00:00:00
SELECT DISTINCT Statement To Return Only Unique ROWS In A Result-Set 00:00:00
Section 5 - Practice Session 1 (SELECT, DISTINCT)
Coding Exercise 1: Practice Query (SELECT Statement) 00:00:00
Solution Coding Exercise 1: Practice Query (SELECT Statement) 00:00:00
Coding Exercise 1: Practice Query (SELECT DISTINCT) 00:00:00
Solution Coding Exercise 1: Practice Query (SELECT DISTINCT) 00:00:00
Section 6 - WHERE Clause In SQL
WHERE Clause To Filter Out ROWS Of A Table 00:00:00
Section 7 - ORDER BY Keyword In SQL
ORDER BY Keyword To Sort The Result In Ascending Or Descending Order 00:00:00
Section 8 - Practice Session 2 (WHERE, ORDER BY)
Practice Query (WHERE, ORDER BY) 00:00:00
Solution – Practice Query (WHERE, ORDER BY) 00:00:00
Section 9 - TOP Clause In SQL
TOP Clause To Select Number Or Percentage Of ROWS That Are In The Top Of Result 00:00:00
Section 10 - Logical Operators (OR, And, NOT) In SQL
Logical Operators (OR, And, NOT) To Filter ROWS Based On More Than One Condition 00:00:00
Section 11 - Practice Session 3 (TOP, OR, AND, NOT)
Practice Query (Top, NOT) 00:00:00
Solution – Practice Query (Top, NOT) 00:00:00
Practice Query (OR, AND) 00:00:00
Solution – Practice Query (OR, AND) 00:00:00
Section 12 - Special Operators In SQL
BETWEEN Special Operators To Check Whether An Attribute Value Is Within A Range 00:00:00
In Special Operators Used For Matching Any Value Within A Value List 00:00:00
IS NULL Special Operators To Check Whether An Attribute Value Is Null Or Not 00:00:00
LIKE Special Operators Used For Matches A Given String Pattern 00:00:00
Section 13 - Practice Session 4 (BETWEEN, IS NULL, IN, LIKE)
Practice Query (BETWEEN) 00:00:00
Solution – Practice Query (BETWEEN) 00:00:00
Practice Query (IN) 00:00:00
Solution – Practice Query (IN) 00:00:00
Practice Query (IS NOT NULL) 00:00:00
Solution – Practice Query (IS NOT NULL) 00:00:00
Practice Query (LIKE, %) 00:00:00
Solution – Practice Query (LIKE, %) 00:00:00
Practice Query (LIKE, _) 00:00:00
Solution – Practice Query (LIKE, _) 00:00:00
Section 14 - Comparison Operators In SQL
Comparison Operators To Compare A Given Value 00:00:00
Section 15 - ALIAS And Computed Column In SQL
ALIAS To Give A Table Or A Column In A Table A Temporary Name 00:00:00
Computed Column To Perform Arithmetic’s Operations On Columns 00:00:00
Section 16 - Practice Session 5 (Comparison Operators, ALIAS, Computed Column)
Practice Query (Comparison Operators) 00:00:00
Solution – Practice Query (Comparison Operators) 00:00:00
Practice Query (ALIAS And Computed Column) 00:00:00
Solution – Practice Query (ALIAS And Computed Column) 00:00:00
Section 17 - CASE Statement In SQL
CASE Returns A Value On A Specified Condition Just Like If And Else 00:00:00
Section 18 - SQL STRING Built-In Functions
Concatenate Two Different String Columns And Returns A Single Column 00:00:00
Convert Strings To UPPER And LOWER CASE 00:00:00
Get A Substring Or Part Of A String 00:00:00
Retrieve The Length Of Strings 00:00:00
Replace A NULL With A Value 00:00:00
Replace, Replicate, And Reverse Strings Built-In Functions 00:00:00
Section 19 - Practice Session 6 (STRING Functions)
Practice Query (STRING Functions) 00:00:00
Solution – Practice Query (STRING Functions) 00:00:00
Section 20 - SQL Datatypes Conversion Built-In Functions
Convert A Value Of Any Type Into A Specified Datatype 00:00:00
Section 21 - SQL Date And Time Built-In Functions
Manipulate Year Part Of The Date 00:00:00
Manipulate Month Part Of The Date 00:00:00
Manipulate Day Part Of The Date 00:00:00
Calculate Difference Between Two Dates 00:00:00
Adds A Time Or Date Interval To A Date 00:00:00
Section 22 - Practice Session 7 (DATA And TIME Functions)
Practice Query (DAY, MONTH, YEAR) 00:00:00
Solution – Practice Query (DAY, MONTH, YEAR) 00:00:00
Section 23 - SQL Math Or Numeric Built-In Functions
Perform Numeric Operation Using SQL Built-In Functions 00:00:00
Section 24 - Aggregate Functions In SQL
Count Function Used To Tally Number Of Non-Null Values Of A Column 00:00:00
Calculate Minimum And Maximum Values Of A Column 00:00:00
Calculate Sum, Average And Standard Deviation Of A Column 00:00:00
Section 25 - Practice Session 8 (COUNT, MAX, MIN, SUM, AVG, STEDEV)
Practice Query (COUNT, MAX, MIN) 00:00:00
Solution – Practice Query (COUNT, MAX, MIN) 00:00:00
Practice Query (SUM, AVG, STDEV) 00:00:00
Solution – Practice Query (SUM, AVG, STDEV) 00:00:00
Section 26 - GROUP BY And HAVING CLAUSE
GROUP BY To Summarize Result Across Small Grouped Items In The Database Table 00:00:00
HAVING To Filters Result Based On The Output Of The Grouped Items 00:00:00
Section 27 - Practice Session 9 (GROUP BY, HAVING)
Practice Query (GROUP BY) 00:00:00
Solution – Practice Query (GROUP BY) 00:00:00
Practice Query (HAVING) 00:00:00
Solution – Practice Query (HAVING) 00:00:00
Section 28 - JOINS In SQL - Write Advance And Complex Queries
Introduction To JOINS And Their Types 00:00:00
Concept Of Relationships Using Foreign Key 00:00:00
Tables For JOINS 00:00:00
TABLES SQL CODE: EMPLOYEES MANAGEMENT SYSTEM 00:00:00
INNER JOIN 00:00:00
OUTER JOINS 00:00:00
CROSS JOIN 00:00:00
SELF JOIN 00:00:00
Section 29 - Practice Session 10 (JOINS)
Tables SQL Code For Joins Practice Queries 00:00:00
Practice Query (INNER JOIN) 00:00:00
Solution – Practice Query (INNER JOIN) 00:00:00
Practice Query (SELF JOIN) 00:00:00
Solution – Practice Query (SELF JOIN) 00:00:00
3954196

Get LIFETIME ACCESS to ALL courses 

Enter your Name and Email for a chance to win Lifetime Access to all courses!
Promotion ends today.

3954197

Get LIFETIME ACCESS to ALL courses 

Enter your Name and Email for a chance to win Lifetime Access to all courses!
Promotion ends today.

Success! You are now entered to win lifetime access to all courses. Winners are selected at the beginning of each month. 

P.S. Look out for our exclusive sales only shown to students on our email list!