Description
In this course, you will learn :
- Start your career by mastering complete SQL statements in Microsoft SQL Server
- Queries and Files Included
- Learn different ways to select Records from Tables
- Filter the Records of the Table
- How to sort the result
- GROUP BY Clause
- Learn all aggregate Functions
- JOINs in table
- UNION and UNION ALL
- Create Tables
- Insert Records
- Update data inside table
- Modify the column and constraints
- The same set of SQL statements can be used with Oracle, PostgreSQL, MySQL, etc
- All the Keys and Constraints are explained in detail
Syllabus :
- Installation and select statement
- Filter the Records
- Matching a pattern
- Sorting and Grouping
- Functions
- SubQueries
- Union and Intersections
- Joins
- Creating Tables, keys and Constraints
- Insert records and update records
- Views
- Copy Records from other table
- Alter the properties