Microsoft SQL Crash Course for Absolute Beginners

This Crash course uses Microsoft SQL Server. The SQLs used here can also used in Oracle, MySQL, PostgreSQL, SQLite,etc.
Microsoft SQL Crash Course for Absolute Beginners
File Size :
1.02 GB
Total length :
1h 56m

Category

Instructor

Sandeep Kumar

Language

Last update

Ratings

4.3/5

Microsoft SQL Crash Course for Absolute Beginners

What you’ll learn

Start your career by learning all the basic SQL statements in Microsoft SQL Server
Queries and Files Included
Learn different ways to select Records from Tables
Filter the Records of the Table
How to sort the result
GROUP BY Clause
Learn all aggregate Functions
JOINs in table
UNION and UNION ALL
Create Tables
Insert Records
Update data inside table
Modify the column and constraints
The same set of SQL statements can be used with Oracle, PostgreSQL, MySQL, etc

Microsoft SQL Crash Course for Absolute Beginners

Requirements

No knowledge of SQL required for this course
We will install free version of Microsoft SQL Server 2019 in Windows
A laptop/computer with Windows 8 or Windows 10

Description

‘This Course covers SQL using Microsft SQL Server but you can apply these SQL queries in Oracle, MySql, PostgreSQL, Microsoft Access, SQLite, and DB2’.”Welcome to the most popular Quality crash Course on Microsoft SQL Server(MS SQL Server)”Covers different forms of SELECT StatementsExplains how to filter the RecordsAll the Arithmetic operators are explainedNULL Values are explainedBeautiful examples of all the operatorsORDER BY, GROUP BY, HAVING clauses has examples in detailThe course covers all the Aggregate Functions and other FunctionsUNION and JOINs are explained with real-life examplesI have explained all types of JoinsData types used in Microsoft SQL======================================================================================Join this course which is the best “Microsoft SQL” course. I will share all the syntax of SQL with multiple examples along the way!!!Want to start learning SQL from scratch with no previous coding experience?You have come to the right place. Please have a look at the Course content carefully and ask a few questions yourself?I have shared all the codes which are used in this courseIs the Course taught by a real-time expert? I have more than 15  years of experience as an Instructor and more than 10 years of experience in SQL. I firmly believe that if an Instructor does not have a good experience, he/she will flood the course with poor content.Is the Course content clear and Precise? The content is short, crisp, and clear.The course assumes no prior knowledge of MS SQL(Microsoft SQL Server) and teaches you from scratch to an advanced levelOnce you Enroll in this Course, you get lifetime access to this course and you will get all the future updates.The course does not cover T-SQL directly but it will help you to learn T-SQL also.This will also help you to get Microsoft certification.This Course is not for DBA(Database Administration) but certainly, helps you to become better.If you plan to work with other databases like Oracle, MySQL, SQLite, PostgreSQL, etc, it will be extremely helpful.If you are a data scientist (Data Analysis role) or willing to become a data scientist, then SQL is a must and this course helps in data analytics.Do you want to start on SQL but have no experience with SQL? If you have some prior knowledge of SQL or if you are a complete fresher, you are at the right place. The Course teaches you to SQL right from Scratch. It will be the best course for absolute beginners.There’s no risk involved in taking this Course!I am sure that this is the best crash course on SQL and it is the perfect starting point to learn the basics of SQL.What if you are stuck?I personally answer all the questions which are asked here. If you are stuck anywhere, ask a question or you can message me directly and I will answer all your doubts.Are you getting updated content?Yes, I keep updating the content always to make sure, I provide all the information to my students.Once you enroll for this course-1) Selecting Records from Table – SELECT statement in SQL2) Filtering the Records – Using WHERE clause in SQL3) Sorting Records – Using ORDER BY clause5) Grouping data – using GROUP BY clause6) complete guide with examples of all the Functions – All aggregate functions covered7) Creating simple and advanced Tables – with constraints and without constraints8) Keys, Index – PRIMARY KEY, FOREIGN KEY, UNIQUE INDEX9) Inserting records(loading) – with INSERT Statement10) Updating the records of a Table – Using UPDATE statement11) Combining multiple tables – Using UNIONS12) Joining multiple columns of different tables – Using JOINs13) Modify table properties – ALTER statement14) Deleting records from the table – DELETE statement15) Removing tables from the database permanently – DROP statementNote: This course helps to learn SQL using Microsoft SQL Server but it will also help to master SQL if you want to learn Oracle SQL, MySql, PostgreSQL, SQLite, DB2, etc.

Overview

Section 1: Installation and select statement

Lecture 1 Install Microsoft SQL Server 2019

Lecture 2 An important announcement

Lecture 3 Import Sample Database

Lecture 4 Different ways to select record from table

Lecture 5 Working Codes – SELECT Statement

Lecture 6 Filter the Records of the Table

Lecture 7 Working Codes – WHERE clause

Section 2: Operators

Lecture 8 Arithmetic operators

Lecture 9 Working Codes – Arithmetic operators

Lecture 10 + Operator and Concatenation

Lecture 11 Working Codes – +Operator and Concatenation

Lecture 12 NULL Value

Lecture 13 Working Codes – NULL Values

Lecture 14 AND & OR Operators

Lecture 15 Working Codes – AND & OR Operators

Lecture 16 Select Records Between 2 Ranges and from a List

Lecture 17 Working Codes – SELECT Records between 2 Ranges and from List

Lecture 18 Match patterns

Lecture 19 Working Codes – Matching patterns

Section 3: Sorting, Grouping and Functions

Lecture 20 Sorting the Result

Lecture 21 Working Codes – Sorting

Lecture 22 Group the Result and Numeric Functions

Lecture 23 Working Codes – GROUP BY and Numeric Functions

Lecture 24 String Functions

Lecture 25 Working Codes – String Functions

Lecture 26 Date Functions

Lecture 27 Working Codes – Date Functions

Lecture 28 HAVING Clause

Lecture 29 Working Codes – HAVING Clause

Section 4: Sub Queries and Joining Rows and Columns from multiple tables

Lecture 30 SubQueries

Lecture 31 Working Codes – SubQueries

Lecture 32 UNION and UNION ALL

Lecture 33 Working Codes – UNION and UNION ALL

Lecture 34 Join multiple tables

Lecture 35 Working Codes – JOINS

Lecture 36 Left Join

Lecture 37 Working Codes -LEFT JOIN

Lecture 38 Right Join

Lecture 39 Working Codes – RIGHT JOIN

Lecture 40 Full join

Lecture 41 Working Codes – FULL JOIN

Section 5: Creating table, inserting records and updating the records

Lecture 42 Data types in Microsoft SQL Server

Lecture 43 Create a table

Lecture 44 Working Codes – CREATE TABLE

Lecture 45 Insert Records into table

Lecture 46 Working Codes – INSERT Records

Lecture 47 Update an existing Record

Lecture 48 Working Codes – UPDATE Statement

Lecture 49 ALTER Statement

Lecture 50 Working Codes – ALTER Statement

Lecture 51 Delete Records from Table

Lecture 52 Working Codes – DELETE Records

Lecture 53 Delete table permanently

Lecture 54 Working Codes – Deleting table permanently

Section 6: Bonus Section

Lecture 55 Let us stay connected

Absolute beginners who have never used SQL on Microsoft SQL,Anyone who wants to refresh the knowledge of SQL,Students who wants to quickly start learning the basic SQL statements without investing too much time at start,This is a crash course and is target for quick basic learning of SQL.,College Students who wants to attend a technical job interview for the first time will also be an ideal choice,This crash course will act as a foundation to master the SQL completely

Course Information:

Udemy | English | 1h 56m | 1.02 GB
Created by: Sandeep Kumar

You Can See More Courses in the Developer >> Greetings from CourseDown.com

New Courses

Scroll to Top