Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js Typescript HTML5 PHP
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA CompTIA Security+ Microsoft AZ-900
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Data Analysis Data Warehouse Blockchain Business Intelligence
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Mobile Game Development
Google Flutter iOS Development Android Development Swift React Native Dart (programming language) Kotlin SwiftUI Mobile App Development
Graphic Design Photoshop Adobe Illustrator Drawing Canva Digital Painting InDesign Design Theory Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Sound Therapy Emotional Intelligence Coaching
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Online Business Startup Business Plan Blogging Amazon Kindle Direct Publishing (KDP)
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Copywriting Google Analytics Email Marketing Startup Advertising Strategy

DevelopmentDatabase Design & DevelopmentSQL

SQL Code Challenges: Use SQL to answer Business questions

Build 21 SQL Queries to solve business problems in Real World
Rating: 4.0 out of 54.0 (85 ratings)
16,120 students
Created by Bluelime Learning Solutions
Last updated 6/2021
English
English [Auto]

What you'll learn

  • Build SQL Query to get all records from a database table
  • Build SQL Query to get specific records from a database table
  • Build SQL Query to get data from multiple database tables
  • Build SQL Query to filter and get specific records from a database table
  • Build SQL Queries using various Operators
  • Build SQL Queries that sorts records retrieved from a database table
  • Build SQL Queries that groups data
  • Build SQL Queries that use aggregate functions
  • Build SQL Queries that uses wild characters

Requirements

  • Basic knowledge of SQL is required but not a show stopper
  • Basic knowledge of database concepts
  • Software and database required. The course shows you how to install them

Description

SQL is a standard language for storing, manipulating and retrieving data in databases.SQL is a standard language for storing, manipulating and retrieving data in databases.

The best way to build up your skills in any area is by practice. This course is a hands-on practical learn by doing course.

SQL ( SQL -Structural Query language ) is one of the most popular and sort after skills in the IT industry. SQL Skills is so important especially with big data and data dependent businesses and applications from Facebook to our local banks.

This course was designed with the beginner in mind. The course starts by walking you through how to setup a lab where you will download and install Microsoft SQL Server and the sample Northwind database.

In this course we will solve 21 business related problem questions by building SQL queries to interrogate the database and produce the answers to solving the business problems.

We will use the following while building our queries to solve the business problems :


Retrieve data with SELECT
Use Case Expressions
Eliminate duplicates
Filter data with equality filters
Filter data with basic comparisons
Filter data with string comparisons
Filter data with logical comparisons
Filter data with NULL comparisons
Use order by clause
Sort data by ascending and descending order
Use Table joins to extract data from multiple tables
Use UNION operator to combine results of two or more SELECT Statements
Aggregate functions to compute a single output value
GROUP BY Clause to group related data


By the end of this course you will be would have gained enough skills to interrogate Databases.

Who this course is for:

  • Beginners to SQL
  • Beginner Data Analyst
  • Beginner Data Scientist
  • Beginner Database Administrator
  • Beginners to Data Warehouse

Instructor

Bluelime Learning Solutions
Learning made simple
Bluelime Learning Solutions
  • 4.1 Instructor Rating
  • 34,380 Reviews
  • 734,438 Students
  • 417 Courses

Bluelime is UK based and creates quality easy to understand  eLearning  solutions .All our courses are 100% video based. We teach hands –on- examples  that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Terms
  • Privacy policy
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.