Code Wala

PHYSICS: Forces and Motion In this video, we are going to learn about and practice applying Newton’s Second Law in calculations, relating force, mass, and acceleration. CREDITS Animation & Design: Bing Rijper Narration: Dale Bennett Script: Bethan Parry and Keith Ross

In this live session on the SQL course, firstly we will introduce you to what is a database, DBMS and later on, we will teach you SQL from scratch to an advanced level along with hands-on demo and interview questions. This video is must watch for everyone who wishes to learn SQL and make a career in it. 00:00 - SQL Full Course 01:07 - Introduction to Database 07:56 - Introduction to DBMS 09:58 - Introduction to SQL 15:37 - Applications of SQL 18:40 - Basics: SQL Tables 20:40 - SQL Tables: Datatypes 23:07 - Installation of SQL Server 27:36 - Create, use and Drop Database in SQL 29:52 - constraints in SQL 31:46 - Creating a table in SQL 35:03 - Insert Query Syntax in SQL 38:41 - Select Statement Syntax in SQL 41:51 - Select Distinct Syntax in SQL 46:06 - Operators in SQL 57:28 - Functions in SQL 01:06:59 - Clauses in SQL 01:17:03 - Statements in SQL 01:23:20 - Joins in SQL 01:43:53 - Union Operator in SQL 01:46:37 - Except Operator in SQL 01:48:20 - Intersect Operator in SQL 01:50:15 - Views in SQL 01:52:56 - How to Alter Table in SQL 01:55:42 - Merge statement in SQL 02:01:22 - Types of user-defined Functions 02:07:50 - Temporary table 02:10:40 - Case Statement in SQL 02:15:45 - IIF() Function in SQL 02:19:26 - Stored Procedure in SQL 02:24:39 - Exception Handling in SQL 02:34:02 - Data Base Administrator 02:35:44 - Types of DBA 02:37:35 - Intro to MS SQL Server 02:38:04 - Evolution of SQL Server 02:41:12 - Editions of SQL Server 02:43:26 - Installing MS SQL Server 02:43:47 - SQL Server System Databases 02:44:14 - Master Database 02:46:08 - Restoring "AdventureWorks" Database through GUI 02:48:14 - Recovery Models 02:51:14 - Planning a Backup Strategy 02:54:52 - Backup models in SSMS 02:55:48 - Point in Time Recovery 02:57:04 - Importing Data 03:02:38 - SQL Server OS Related DMV's 03:05:02 - Activity Monitor 03:05:32 - Starting Activity Monitor 03:07:59 - System Monitor/ Performance Monitor 03:10:56 - Working with SQL Server Profiler 03:12:36 - Ensuring Data Integrity 03:13:44 - Index in SQL 03:17:03 - Fragmentation 03:20:41 - CRUD Operations: SQL Queries 03:32:51 - What is SQL Injection with Hands-on? 03:55:34 - How to become an SQL Developer 04:04:32 - SQL Demo 04:22:14 - SQL vs MySQL 04:26:56 - Skills to become SQL Developer 04:29:22 - Career Path: SQL Developer 04:36:22 - SQL Interview Questions & Answers #Intellipat