Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

SQL course for Beginner:For Data Analytics & Business Intelligence

person icon Sachin Jivanlal Agrawal

4.2

SQL course for Beginner:For Data Analytics & Business Intelligence

SQL for Beginner-For Data Analytics & Business Intelligence

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Sachin Jivanlal Agrawal

English [CC]

category icon SQL,SQL Server,Development,Database Management

Lectures -28

Resources -1

Duration -1 hours

4.2

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Have a detailed knowledge and understanding of using Microsoft SQL, one of the most widely used databases in the world.

Obtained a knowledge of SQL, allows students to apply for jobs in the IT sector.

In-depth knowledge of database design will give students an edge over other applicants.

Key concepts you will learn and work with in this course.

  • SQL (Structured Query Language - very much an in-demand technology).
  • Database Design
  • Data Analysis
  • Through out the course you will go through creating an example database for Movie.
  • Creating, Modifying and Deleting Tables in a Database (DDL)
  • Inserting, Updating and Deleting Data from Tables (DML)
  • Select Queries
  • Joins
  • Aggregate Functions
  • Sub queries
  • Database Design
  • Creating Databases.
  • Constraints,
  • Case when,
  • Clauses,
  • Operators

Not only does the course teach you SQL, but there are multiple exercises for you to try with video solutions to further help you understand the material. Become skilled as a database developer generally needs you to learn SQL, a database, and then database design.  Often this will require multiple courses.  However you learn all those topics, and data analysis in this one course.

Essentially, you are learning from someone who has all the professional training, skills, and experience needed to teach you how to become proficient with SQL and Database design as quickly as possible.

After completing this course, you will have the necessary skills to be able to use SQL confidently, have a solid understanding of SQL and be skilled in database design.

Goals

What will you learn in this course:

  • Key concepts you will learn and work with in this course. SQL (Structured Query Language - very much an in-demand technology). Database Design Data Analysis

  • Creating, Modifying and Deleting Tables in a Database (DDL), Inserting, Updating and Deleting Data from Tables (DML)

  • Select Queries, Joins Aggregate Functions Subqueries Database Design Creating Databases. Constraints, Case when, Clauses, Operators

  • Not only does the course teach you SQL, but there are multiple exercises for you to try with video solutions to further help you understand the material.

Prerequisites

What are the prerequisites for this course?

  • Microsoft SQL Server Management Studio.

SQL course for Beginner:For Data Analytics & Business Intelligence

Curriculum

Check out the detailed breakdown of what’s inside the course

SQL-Structured Query Language
28 Lectures
  • play icon SQL-Create Database,table,Insert,Select 09:21 09:21
  • play icon SQL-Delete,Truncate,Drop,Alter 03:35 03:35
  • play icon SQL-Delete,Truncate,Drop,Alter 1 05:37 05:37
  • play icon SQL-Update,Delete,Backup 05:53 05:53
  • play icon SQL Operators_1 01:00 01:00
  • play icon SQL Operators_2 01:58 01:58
  • play icon SQL Operators_3 00:51 00:51
  • play icon SQL Operators_4 02:13 02:13
  • play icon SQL Like Operators_1 02:59 02:59
  • play icon SQL Like Operators_2 00:54 00:54
  • play icon SQL Like Operators_3 00:32 00:32
  • play icon SQL Like Operators_4 00:34 00:34
  • play icon Aggregate_Date Functions_1 02:15 02:15
  • play icon Aggregate_Date Functions_2 00:48 00:48
  • play icon Aggregate_Date Functions_3 01:54 01:54
  • play icon Aggregate_Date Functions_4 03:13 03:13
  • play icon Text Functions_0 02:02 02:02
  • play icon Text Functions_1 01:27 01:27
  • play icon Text Functions_2 01:07 01:07
  • play icon Text Functions_3 01:01 01:01
  • play icon Text Functions_4 00:34 00:34
  • play icon Text Functions_5 01:04 01:04
  • play icon SQL Clauses 06:54 06:54
  • play icon SQL Clauses_1 03:42 03:42
  • play icon Sub Query 01:59 01:59
  • play icon Case When 01:12 01:12
  • play icon Joins 01:56 01:56
  • play icon Constraints 09:34 09:34

Instructor Details

Sachin Jivanlal Agrawal

Sachin Jivanlal Agrawal

e


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515