SQL for Beginners

Learning SQL through Microsoft SQL Server.

Beginner 5(10 Ratings) 2012 Students enrolled English
Created by Techitaka .
Last updated Sat, 10-Sep-2022
+ View more
Course overview

You'll learn how to read and write complex queries to a database using one of the most in demand skills. These skills are also applicable to any other major SQL database, such as MySQL, PostgreSQL, Amazon Redshift, Oracle, and much more.

Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in demand tech skills! In this course you'll learn quickly and receive challenges and tests along the way to improve your understanding!

This is course that put's you in control, having you set up and restore databases right at the start of the course, instead of watching someone else code. SQL is one of the most in demand skills for business analysts, data scientists, and anyone who finds themselves working with data! Upgrade your skill set quickly and add SQL to your resume by learning today!


SOFTWARE DOWNLOAD LINKS:

SQL Server Management Studio:
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

SQL Server:
https://www.microsoft.com/en-us/sql-server/sql-server-downloads



TOPICS COVERED:


[SECTION 1] SQL Basics For Beginners

A. Installing SQL Server Management Studio and Create Tables
B. Select From Statements
C. Where Statement
D. Group By and Order By Statements


[SECTION 2] Intermediate SQL

A. Inner & Outer Joins - Use Cases
B. Unions - Union Operator
C. Case Statement - Use Cases
D. Having Clause
E. Updating Deleting Data
F. Aliasing
G. Partition By


[SECTION 3] Advanced SQL

A. CTE - Common Table Expression
B. Temp Tables
C. String Functions - Use Cases
D. Stored Procedures - Use Cases
E. Sub-Queries

Course Author: Alexander F
Distributed under Creative Commons Attribution license CC-BY


What will i learn?

  • SQL Fundamentals
  • Select Statements
  • Where Statement
  • Group By Statements
  • Order By Statements
  • Inner & Outer Joins
  • Unions
  • Case Statement
  • Having Clause
  • Updating & Deleting Data
  • Aliasing
  • Partition By
  • CTE - Common Table Expression
  • Temp Tables
  • String Functions
  • Stored Procedures
  • Subqueries
Requirements
  • Computer Basics
Curriculum for this course
17 Lessons 01:51:44 Hours
SQL Basics For Beginners
5 Lessons 00:31:54 Hours
  • SQL Downloadable material -ZIP file
    .
  • Installing SQL Server Management Studio and Create Tables
    00:09:36
  • Select Statements
    00:06:13
  • Where Statement
    00:07:57
  • Group By & Order By Statements
    00:08:08
Intermediate SQL
7 Lessons 00:37:11 Hours
  • Inner and Outer Joins - Use Cases
    00:05:52
  • Unions - Union Operator
    00:05:24
  • Case Statement - Use Cases
    00:07:25
  • Having Clause
    00:03:30
  • Updating & Deleting Data
    00:04:36
  • Aliasing
    00:06:11
  • Partition By
    00:04:13
Advanced SQL
5 Lessons 00:42:39 Hours
  • CTE - Common Table Expression
    00:03:43
  • Temp Tables
    00:10:18
  • String Functions - Use Cases
    00:13:48
  • Stored Procedures - Use Cases
    00:06:14
  • Subqueries
    00:08:36
+ View more
Other related courses
About instructor

Techitaka .

Don't Just Change. Grow.

58 Reviews | 2291 Students | 8 Courses
Technology Data Science Software Tools Full Stack Developement Mobile Apps Blockchain AI-ML Web 3.0
Technology skills are always evolving. Every Techie strives to be upto date. Techitaka helps get Access To Thousands of Inspiring courses and the support of a learning community. D...
Student feedback
5
10 Reviews
  • (0)
  • (0)
  • (0)
  • (0)
  • (10)

Reviews

  • Imran Fazal
    I will never forget how I ended up here and finally secured a job for myself and this course has had immeasurable contribution towards my success. It helped me get started with SOMETHING when my brain was cluttered, and I was living in despair with all the wrong decisions in life. I'm very thankful to Mike and whoever put this course in this format.
  • Vikash Agarwal
    This course is good and timeless! You literally discussed a information worth of Gold. I learned a lot here more than in my class. I'm taking this to refresh my knowledge on SQL for a job interview, hope I'll do well.
  • Asad Ahmad
  • Gurpreet Singh
    Thank you for this content. Also many thanks to the instructor, who makes it almost seamless to go from zero to a level that you are comfortable to work with SQL. Now it’s practice time!
  • Pooja Gupta
    The best course for the SQL! You made it so easy to understand! Thanks!
  • Gaurav Kishore
    I really enjoyed this course...Thank you for the opportunity you gave me to have a better understanding of Databases.
  • Prashanth Reddy
    Thanks for efforts man, you describe so well for beginners. If you are beginners then watch full video without skipping anything and you will find that this is one of the best way to explain for beginners, so guys don't waste your time and study and I am sure you are to learn many things and thank you man for your efforts.
  • Md Nomani
    Such an easy-to-understand SQL course.
  • Divya Jasti
  • Rizwan Ansari
    A way easy and comprehensive way to learn SQL. Thanks!
Skillup
Get enrolled
Includes:
WhatsApp Icon

Call Us

+91-8050080399

Email Us

apply@skillzam.com