Description
In this course, you will :
- Learn SQL concepts and how to use SQL to store and manage data. This course is suitable for both beginners and intermediates.
- This crash course will cover installing MySQL, connecting to AdventureWorks2019, creating users, and writing SQL queries, all with practical demonstrations to ensure that you not only understand but also master the concepts.
- If you want to advance your career and earn a higher salary, this course is for you. This SQL Server crash course will assist you in learning SQL using Microsoft SQL Server, but it will also assist you in mastering SQL if you want to learn Oracle SQL, MySql, PostgreSQL, SQLite, DB2, and other databases.
Syllabus :
- Install MS SQL Server Developer edition 2019
- Install SSMS(SQL Server Management Studio)
- Download and Import AdventureWorks2019 database
- Connect to AdventureWorks2019
- SELECT Statement
- WHERE Clause in SQL Server
- Arithmetic operators in SQL Server
- Combine Strings in SQL Server - Concatenation
- How to find Null values in SQL Server
- Logical operators - AND and OR Operators in SQL Server
- BETWEEN & IN Operators in SQL
- LIKE Operator in SQL
- ORDER BY Clause in SQL
- GROUP BY Clause in SQL
- String Functions in SQL Server
- Date Functions in SQL Server
- HAVING Clause
- SubQuery
- UNION and UNION ALL operators
- INNER Joins
- LEFT Join
- RIGHT Join
- FULL JOIN
- Data Types in SQL Server
- CREATE Table Statement
- CREATE Table with constraints
- INSERT Statement
- UPDATE Statement
- ALTER Statement
- DELETE Statement
- DROP Statement