MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQL Database for Beginners

Course Summary

Learn Microsoft SQL - An Easy and Simple Way


  • +

    Course Syllabus

    • Course Introduction
      • Introduction to SQL
    • SQL Overview
      • Installation of MS SQL Server 2012
      • How to connect to MS SQL Server Management Studio
      • Sample SQL Database - Adventureworks
    • Database Creation in SQL
      • Create Database using MS SQL Server Management Studio
      • Create Database using Command Tool
      • Create Table using Template GUI
    • Database Design and RDBMS Concepts in Microsoft SQL
      • Normalization in Database
      • 1NF - First Normal Form
      • 2NF - Second Normal Form
      • 3NF - Third Normal Form
    • Primary and Foreign Key - Referential Data Integrity in SQL
      • Adding a Primary key in an existing column
    • Create, Delete, Insert and Update
      • Create Table
      • Alter Tables IDENTITY
      • Aliasing Column
      • Delete Statements
      • Update Statements in MS SQL
    • Transactions in MS SQL
      • Transactions
      • Transactions ACID test
    • Function and Operators in SQL
      • String Functions in MS SQL
      • Aggregate Functions
      • Date Functions in MS SQL
    • Basic Select Statements in SQL
      • Using Select statements - examples
      • Using Select Statement Right from the Database to Schema
    • Complex Select Statements in SQL
      • Select statement and where clause use
      • Select statement for String Concatenation
      • Automatically generate a Select and other statements in Studio
      • Where Clause in MS SQL
      • SQL Select Calculated Columns
      • Create a Table Alias
      • Transfering the table from one schema to another
    • Insert and Deletes in MS SQL
      • INSERT INTO TABLES
      • Insert into new SQL table with Select INTO
      • Insert data using Server Mgmt Studio
      • QUERY EDITOR AND GUI FOR ADDING DATA
      • Insert into using Variables
    • Joins, Unions and Subqueries in SQL
      • Joins in MS SQL
      • Unions in MS SQL
      • SubQuery in MS SQL
    • Having, Order By, Distinct in SQL
      • Order By Clause
      • Select with Order by and Where Clause
    • Schema, Views and Indexes in SQL
      • Creating and Assigning permissions in a Schema in MS SQL
      • Create Views in MS SQL
      • Drop Views
      • Create Index in MS SQL
      • Drop an Index in MS SQL
      • Clustered Index in MS SQL
    • Stored Procedures in MS SQL
      • Create Procedure -Basic
      • Comment in Stored Procedure in MS SQL
      • Stored Procdure - with in parameters
      • Stored Procedure with OUTPUT Paramter
      • Insert into using Stored Procedure
      • Drop Stored Procedures in MS SQL
    • Functions and Triggers in SQL
      • Triggers in MSSQL
      • After Trigger
      • Create Functions in MS SQL
    • Backup and Recovery
      • Backup and Restore in SQL
    • Conclusion
      • Conclusion
      • Data Types in MS SQL


Course Fee:
USD 99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top