filmov
tv
SQL Course | SQL Tutorial For Beginners | Learn SQL | Intellipaat
Показать описание
👉This SQL course video is an SQL tutorial for beginners where you will learn SQL end to end. This SQL tutorial is all you need to get started with this technology.
#SQLCourse #SQLTutorialforBeginners #LearnSQL #SQL #StructuredQueryLanguage
📝Following topics are covered in this SQL Tutorial video:
00:00 - SQL full course
01:13 - What is Data?
02:22 - What is Database?
04:15 - Why need a Database?
08:20 - Database Management System(DBMS)
10:19 - Introduction to SQL
11:40 - Relational Databases
14:17 - Sample SQL Query
16:20 - SQL vs NoSQL
18:00 - Applications of SQL
21:00 - Basics of SQL
21:28 - SQL Tables: Fields
21:58 - SQL Tables: Records
23:18 - SQL Tables: Datatypes
25:50 - CRUD Operations
26:42 - What can SQL do?
28:10 - CRUD Operation Demo
38:00 - Installation of SQL Server
45:32 - Data Types in SQL
46:10 - Different Data Types in SQL
51:30 - Create Table Syntax
54:16 - Insert Query Syntax
57:55 - Select Statement Syntax
01:00:53 - Select Distinct Syntax
01:02:20 - Where Clause in SQL
01:05:10 - Operators in SQL
01:17:37 - Functions in SQL
01:26:00 - Order By and Top Clause in SQL
01:29:40 - Group By Clause in SQL
01:33:13 - Having Clause in SQL
01:36:04 - Update Statement in SQL
01:39:24 - Delete Statement in SQL
01:41:18 - Truncate Statement in SQL
01:42:22 - Joins in SQL
02:02:43 - Union Operator in SQL
02:05:27 - Except Operator in SQL
02:07:10 - Intersect Operator
02:09:05 - Views in SQL
02:11:45 - Alter Table in SQL
02:14:32 - Merge Statement in SQL
02:20:10 - User Defined Functions in SQL
02:26:40 - Temporary Table in SQL
02:29:30 - Case Statement in SQL
02:34:23 - IIF Function in SQL
02:38:04 - Stored Procedure in SQL
02:43:16 - Exceptional Handling
02:43:25 - Try/Catch Blocks in SQL
02:47:45 - Transactions in SQL
02:52:38 - Database Administrator
02:52:50 - Roles of Database Administrator
02:54:22 - Types of DBA
02:56:12 - Intro to MS SQL Servers
03:02:24 - SQL Server Sysytem Databases
03:04:08 - Quiz
03:04:40 - Backup & Restore of Database
03:05:18 - Restoring "AdventureWoks" Database through GUI
03:07:25 - Recovery Models
03:18:54 - Quiz
03:19:17 - Dynamic Management Views
03:20:04 - Catagories of DMV's
03:24:30 - Activity Monitor
03:25:00 - Starting Activity Monitor
03:27:25 - System Monitor/Performance Monitor
03:30:20 - Working with SQL Server Profiler
03:32:02 - Quiz
03:32:36 - Data Integrity
03:32:52 - Categories of Data Integrity in SQL
03:33:45 - Index in SQL
03:34:15 - Types of Indexes in SQL
03:37:07 - Fragmentation in SQL
03:39:15 - Rebuilding in SSMS
03:40:43 - Quiz
03:40:56 - SQL Job Trend
03:41:20 - SQL Interview Questions
If you’ve enjoyed this SQL full course, Like us and Subscribe to our channel for more similar informative SQL course tutorials.
Got any questions about SQL training? Ask us in the comment section below.
----------------------------
Intellipaat Edge
1. 24*7 Life time Access & Support
2. Flexible Class Schedule
3. Job Assistance
4. Mentors with +14 yrs
5. Industry Oriented Course ware
6. Life time free Course Upgrade
------------------------------
Why should you opt for a SQL career?
SQL optimization has always been a popular topic in database management. SQL Database optimization can be an extremely difficult task, in particular for large-scale data wherever a minute variation can result or impact drastically on the performance. So learning this skill will definitely help you grab the best jobs in top MNCs after finishing Intellipaat SQL online training. The entire Intellipaat SQL course is in line with the industry needs.There is a huge demand for SQL certified professional. The salaries for SQL professional are very good. Hence this Intellipaat SQL database tutorial for beginners is your stepping stone to a successful career!
------------------------------
For more Information:
#SQLCourse #SQLTutorialforBeginners #LearnSQL #SQL #StructuredQueryLanguage
📝Following topics are covered in this SQL Tutorial video:
00:00 - SQL full course
01:13 - What is Data?
02:22 - What is Database?
04:15 - Why need a Database?
08:20 - Database Management System(DBMS)
10:19 - Introduction to SQL
11:40 - Relational Databases
14:17 - Sample SQL Query
16:20 - SQL vs NoSQL
18:00 - Applications of SQL
21:00 - Basics of SQL
21:28 - SQL Tables: Fields
21:58 - SQL Tables: Records
23:18 - SQL Tables: Datatypes
25:50 - CRUD Operations
26:42 - What can SQL do?
28:10 - CRUD Operation Demo
38:00 - Installation of SQL Server
45:32 - Data Types in SQL
46:10 - Different Data Types in SQL
51:30 - Create Table Syntax
54:16 - Insert Query Syntax
57:55 - Select Statement Syntax
01:00:53 - Select Distinct Syntax
01:02:20 - Where Clause in SQL
01:05:10 - Operators in SQL
01:17:37 - Functions in SQL
01:26:00 - Order By and Top Clause in SQL
01:29:40 - Group By Clause in SQL
01:33:13 - Having Clause in SQL
01:36:04 - Update Statement in SQL
01:39:24 - Delete Statement in SQL
01:41:18 - Truncate Statement in SQL
01:42:22 - Joins in SQL
02:02:43 - Union Operator in SQL
02:05:27 - Except Operator in SQL
02:07:10 - Intersect Operator
02:09:05 - Views in SQL
02:11:45 - Alter Table in SQL
02:14:32 - Merge Statement in SQL
02:20:10 - User Defined Functions in SQL
02:26:40 - Temporary Table in SQL
02:29:30 - Case Statement in SQL
02:34:23 - IIF Function in SQL
02:38:04 - Stored Procedure in SQL
02:43:16 - Exceptional Handling
02:43:25 - Try/Catch Blocks in SQL
02:47:45 - Transactions in SQL
02:52:38 - Database Administrator
02:52:50 - Roles of Database Administrator
02:54:22 - Types of DBA
02:56:12 - Intro to MS SQL Servers
03:02:24 - SQL Server Sysytem Databases
03:04:08 - Quiz
03:04:40 - Backup & Restore of Database
03:05:18 - Restoring "AdventureWoks" Database through GUI
03:07:25 - Recovery Models
03:18:54 - Quiz
03:19:17 - Dynamic Management Views
03:20:04 - Catagories of DMV's
03:24:30 - Activity Monitor
03:25:00 - Starting Activity Monitor
03:27:25 - System Monitor/Performance Monitor
03:30:20 - Working with SQL Server Profiler
03:32:02 - Quiz
03:32:36 - Data Integrity
03:32:52 - Categories of Data Integrity in SQL
03:33:45 - Index in SQL
03:34:15 - Types of Indexes in SQL
03:37:07 - Fragmentation in SQL
03:39:15 - Rebuilding in SSMS
03:40:43 - Quiz
03:40:56 - SQL Job Trend
03:41:20 - SQL Interview Questions
If you’ve enjoyed this SQL full course, Like us and Subscribe to our channel for more similar informative SQL course tutorials.
Got any questions about SQL training? Ask us in the comment section below.
----------------------------
Intellipaat Edge
1. 24*7 Life time Access & Support
2. Flexible Class Schedule
3. Job Assistance
4. Mentors with +14 yrs
5. Industry Oriented Course ware
6. Life time free Course Upgrade
------------------------------
Why should you opt for a SQL career?
SQL optimization has always been a popular topic in database management. SQL Database optimization can be an extremely difficult task, in particular for large-scale data wherever a minute variation can result or impact drastically on the performance. So learning this skill will definitely help you grab the best jobs in top MNCs after finishing Intellipaat SQL online training. The entire Intellipaat SQL course is in line with the industry needs.There is a huge demand for SQL certified professional. The salaries for SQL professional are very good. Hence this Intellipaat SQL database tutorial for beginners is your stepping stone to a successful career!
------------------------------
For more Information:
Комментарии