Microsoft SQL Fundamentals with real world demos

Innocent Musanzikwa, Online Tutor, youtuber and blogger

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
16 Lessons (1h 16m)
    • 1. Course Overview

      1:51
    • 2. Getting Setup

      1:53
    • 3. Introduction to Databases

      2:46
    • 4. SQL Datatypes

      4:00
    • 5. Creating Database Objects 1 : Databases

      4:52
    • 6. Creating Database Objects 2 : Tables

      7:35
    • 7. Creating Database Objects 3 : Temp Tables

      4:51
    • 8. Inserting Data into SQL

      4:30
    • 9. Importing Data from flat files

      8:48
    • 10. Retrieving Data from SQL

      4:32
    • 11. Filtering Output 1 : Where

      4:18
    • 12. Sorting Output

      2:29
    • 13. Filtering Output 2 : Top and Distinct

      3:58
    • 14. Data Manipulation : Delete and Update

      6:09
    • 15. SubQueries

      5:09
    • 16. SQL Joins

      8:13

About This Class

91580799

Hi and welcome to this Microsoft SQL Server Tutorial. I designed this course for students who are new to SQL and Databases or are at a beginner level. I will take you through SQL Fundamentals and you will learn:

  • Getting environment setup

           

4e117fb5

           

         

  • Introduction to databases

               - What is a database and what is it made of ?

  • SQL Datatypes

               - What are some of the familiar datatypes available to SQL Server

  • Creating database Objects

                How to create:

                - Databases

                - Tables

                - Temporary Tables

  • Data inserts

                - Insert statement

  • Importing data into SQL server

                - How to import data from flat file sources into SQL Database

  • Retrieving data

                - Select statement

  • Filtering data retrieval

                -  Restrict output using “where” clause

                - comparison operators with "where" clause

                - Selecting Top n records

                - Selecting Distinct records

  • Data manipulation

                - how to update data in tables

                - How to delete data in tables

                - Truncating data vs deleting

  • Basic Aggregate functions

                - Min and Max

                - Count

                - Sum

                - Avg

  • Sorting output

                - Order by clause

  • Subqueries
  • SQL Joins

               - Left outer join

               - Right outer join

               - Full outer join

I am so excited to teach this class and hopeful you will be able to start working on a SQL production environment when you are done with the class. See you in class !