Learn the basics of Database SQL with Microsoft SQL Server to develop real-world applications.
Read more.Instructor
Mazhar Hussain is currently in the role of Deep Learning and Computer Vision Engineer. He has extensive teaching experience at University Higher Education level and Online over a decade. He has published several research papers on Deep Learning in well-reputed Journals and Conferences. He believes on comprehensive practical trainings with stunning support for his students where all his courses are 100% hands-on with step-by-step problem-based learning, demos and examples. Mazhar Hussain is te
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout 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:
- Data Analyst
- Database Developer
- Database Administrator
- Data Scientist
- SQL Server Developer
- Software Developer
- Software Consultant
- Net Developer
- ETL Developer
- 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 | ||
Related Courses
Are you interested in higher education?