Create Database and its objects,Tables,Views,Procedures,Built in functions
Normalization of Data,DML,DDL and DCL Statements
Relational Mapping of Data,Cardinalities between tables,Clauses, Predicates and Date Functions
14 sections • 20 lectures • 3h 43m total length
SQL Server Start Ups
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Control Language (DCL)
DDL Statements Assignment
How to add relationship in SQL
How to work with views
How to work with SQL Stores Procedures
Be able to write SQL queries efficiently and become a query master
Should have basic knowledge of database.
Be able to create RDBMS and get knowledge of how to store data into parts
Learning SQL from scratch, is a key source to develop skills in database programming, the course will cover from installation of SQL Server till advance query writing and relationship management between data.
below are the topics covered in this course:
1. Microsoft SQL Server Installation and Introduction
2. What is data and information?
3. Create very first database and table
4. Introduction to T-SQL Statements
6. What is primary key and foreign key? (Relationships)
7. What are SQL Constraints?
8. What are SQL Joins?
9. What are SQL Views?
10. What are SQL Stored procedures?
Who this course is for:
Students who are new to database and programming
Students who face difficulties in writing SQL queries
Students who wants to revise and polish their MS-SQL skills
I am an experienced .NET professional having 7 years of experience as an instructor in Karachi, Pakistan. I have worked on .NET technologies like C#, ASP.NET, MS SQL as well as other open source tools like PHP, ANDROID, J QUERY, CRYSTAL REPORTS, MySQL , WORD PRESS, ANGULAR JS,HTML 5 CSS3, JAVA SCRIPT & JAVA