<
By:

Become a Premium Member and unlock a free course in leading technologies each month through our Course of the Month program. The Course of the Month is available for 30 days after enrollment.

Course of the Month13 days, 6 hours left to enroll

Microsoft SQL Server and Database Concepts

FREE
Get this free withPremium
or preview the first video
23 Lessons
7:55:20 Total Length
  • About
  • Curriculum

SQL, or Structured Query Language, is used to communicate with a database, and is the standard language for relational database management systems.

SQL is a necessary skill for database analysts, testers, developers, database administrators, and others in the IT field. This course includes a complete step-by-step guide to learn SQL with practical examples. No prior knowledge of SQL/Database is required.

This course covers the following topics:
What is Data and its Types
Database Types  - DBMS & RDBMS
DDL commands: CREATE, ALTER, DROP AND TRUNCATE
DML commands: SELECT, INSERT, UPDATE, DELETE
Creating a Database
Creating Tables: Adding and Deleting Data
Constraints: Primary Key, Foreign Key, Null, etc.
Joins: Inner, Left, Right, Full
Functions: Scalar and Table Valued Functions
Views: Create, Alter, Drop
Indexes
Stored Procedures
Triggers: DDL, DML, and Logon

The course instructor, Kumar, has 9+ years of experience as an SQL DBA Developer and BI Developer. He’s shared all of his experience through this SQL course. This course is suitable for all audiences, even those without database knowledge.

About the Author

Providing Quality based online training's for QA & DBA courses since 2011.
https://www.sqlinstructor.com/course/microsoft-sql-server-database-concepts
Posted: 17 January, 2017
Basics +
Functions
Triggers
Stored Procedures+
This is a certification course.
By completing this course, you are eligible for certification opportunities. This course provides the instruction and educational material needed to prepare for a third-party certification exam.
This is a course package.
Course packages provide a comprehensive learning plan at a discounted price, and may lead to certification opportunities.
INTRO VIDEO