Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL Server 101 : Microsoft SQL Server for Absolute Beginners
Rating: 3.9 out of 5(149 ratings)
598 students

SQL Server 101 : Microsoft SQL Server for Absolute Beginners

An absolute beginner’s tutorial to quickly learn Microsoft SQL Server from scratch using Management Studio and T SQL.
Created byRashid Khan
Last updated 10/2018
English

What you'll learn

  • At the completion of the course, you will know how to install SQL Server and create a practice environment for yourself.
  • You will be familiarized with some of the core concepts of RDBMS / SQL Server.
  • You will learn the ins and outs of SQL Server Management studio.
  • You will start constructing your SELECT statement to retrieve data from SQL Server.
  • You will know how to filter out unwanted data by using WHERE clause as well as, you would know how to order your result set by using ORDER BY clause.
  • You will also know about some of the string functions, date functions, and system functions.
  • You will see how to get data out of multiple tables using JOIN ( INNER / LEFT OUTER / RIGHT OUTER / FULL OUTER / CROSS JOINS).
  • You will also see how to use UNION / UNION ALL operators and as to how they differ from JOINS.
  • You will see how to group and summarize your data by using , GROUP BY clause, HAVING clause and Aggregate functions.

Course content

10 sections • 45 lectures • 3h 51m total length

  • Course and Instructor Introduction5:03

Requirements

  • NO PRIOR DATABASE OR SQL experience is required.
  • You need High speed Internet connection with a PC.

Description

In this course you will learn:

· Start from scratch by installing Microsoft SQL Server Express edition

· Requirements for installing Microsoft SQL Server

· Core concepts of RDBMS

· Comparison of MS SQL Server with Oracle, IBM etc.

· Getting around SQL Server Management Studio

· Details of System databases

· Constructing SELECT statement starting with literals

· Using FROM clause

· Working with columns specified in the SELECT LIST

· Using WHERE clause

· Using ORDER BY clause

· Using BETWEEN / NOT BETWEEN operator

· Using IN / NOT IN operator

· Pattern matching using LIKE operator and wild card characters

· Working with NULL

· Using string functions including concatenation

· Using Date functions

· SQL Server System functions

· Working with JOINS – INNER / LEFT OUTER / RIGHT OUTER / FULL OUTER / CROSS JOIN

· Working with UNION / UNION ALL

· A look at sub queries

· Duplicate rows – DISTINCT / ALL predicates

· Aggregate functions

· Using GROUP BY clause

· Using HAVING clause


What you'll learn

· At the completion of the course, you will know how to install SQL Server and create a practice environment for yourself.

· You will be familiarized with some of the core concepts of RDBMS / SQL Server.

· You will learn the ins and outs of SQL Server Management studio.

· You will start constructing your SELECT statement to retrieve data from SQL Server.

· You will know how to filter out unwanted data by using WHERE clause as well as, you would know how to order your result set by using ORDER BY clause.

· You will also know about some of the string functions, date functions, and system functions.

· You will see how to get data out of multiple tables using JOIN ( INNER / LEFT OUTER / RIGHT OUTER / FULL OUTER / CROSS JOINS).

· You will also see how to use UNION / UNION ALL operators and as to how they differ from JOINS.

· You will see how to group and summarize your data by using , GROUP BY clause, HAVING clause and Aggregate functions.

Who this course is for:

  • Anyone who is just starting out on their database career.
  • Information workers who work with database.
  • Healthcare professionals who need to understand the working of database in order to make sure that their PHI data remains HIPAA compliant.
  • Finance professionals who need to understand how their data is stored in database and as to how SQL Server provides a better data storing mechanism in strict regulatory environments, such as Sarbanes-Oxley (SOX), Dodd-Frank, Basel II etc.
  • Anyone looking for their first stepping stone to start working on their Microsoft Certification 70-461
  • Quality Analyst people who need to understand the workings of a database while they do their software testing.
  • Managers who need to understand as to how their data is handled by the database while they try to adopt agile development methodology.
  • Business Professional
  • Accountants
  • Software Developers
  • Programming Students
  • Financial Analysts

Report abuse