Microsoft SQL Server and Database Concepts
Browse All Courses > Databases
Have a question while you're learning?
Get in-depth explanations, tips, further insights, and more from Certified Experts. Our experts are vetted industry professionals eager to help you learn from their experiences.
Course Syllabus(23 Lessons)
Course Description
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.
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.
Course Details
- Level:
- Beginner
- Duration:
- 7h 55m 20s
- Students:
- 634
Instructor
Kumar D
I have over 10+ years in IT industry as DBA developer, SSRS reporting, Business Intelligence, and others. I am very passionate about teaching & blogging on SQL concepts. I have obtained 3 certifications from Microsoft including Microsoft Certified Professional and Microsoft Certified Solutions Associate. My top skills are in Microsoft SQL Server, SSIS, SSRS, and SSAS.
