SQL Server DBA Training from Beginner to Advanced

Teacher

COURSE DESCRIPTION

SQL (Structured Query Language) is a computer language for relational database management and data manipulation. Relational databases and SQL are extremely popular in industry and for a good reason. Master the fundamentals of SQL Server, the industry-leading database management platform from Microsoft. In this course, instructor equips beginners with the core skills they need to create and manage SQL Server databases. We begin with the basics, showing what is SQL Server. We then discusses Database In SQL, SQL Data Types, SQL Keywords, Composite Key In SQL, SQL Constraints, Transactions In SQL, First Normal Form, queries, Keys, functions, joints, advanced like aggregate functions in SQL, and then we will show the interview question and answers. IF YOU MASTER THIS TUTORIAL SECTION, YOU WILL DEFINITELY BE READY FOR YOUR FIRST JOB DBA. FIND CERTIFICATION CLASSES HERE

This course is for just about anyone responsible for the performance of the system. Database administrators, certainly, are targeted because they’re responsible for setting up the systems, creating the infrastructure, and monitoring it over time. Developers are too, because who else is going to generate all the well-formed and highly performant T-SQL code Database developers, more than anyone, are the target audience, if only because that’s what we do for work. Anyone who has the capability to write T-SQL, design tables, implement indexes, or manipulate server settings on the SQL Server system is going to need this course/tutorial to one degree or another. Therefore

Who should take up this MS SQL certification training course?

Software Developers and IT Professionals
SQL and Database Administrators
Project Managers
Business Analysts and Managers
Business Intelligence Professionals
Big Data and Hadoop Professionals
Those aspiring for a career in SQL Development

Prerequisites

There are no specific prerequisites for taking up this SQL course. A basic knowledge of relational DBMS can be helpful for knowing all about MS SQL Server.

Topics include:

- What Is SQL Server
- Learn SQL, Structured Query Language
- What is a Database
- Database In SQL
- SQL Data Types
- SQL Keywords
- Composite Key In SQL
- SQL Constraints
- Transactions In SQL
- First Normal Form
- SQL Server Data Types
- SQL Administration
- SQL Variables
- SQL Date Function
- SQL String Functions
- SQL Timestamp
- SQL TO_DATE()
- SQL DATEADD()
- ANY In SQL
- LIKE Query In SQL
- BETWEEN In SQL
- LTRIM() In SQL
- TOP In SQL
- SQL Server Substring
- CUBE In SQL
- SQL RANK()
- SQL CTE
- And Many more…

Course Features

Lectures 107
Quizzes 0
Duration 50 hours
Skill level All levels
Language English
Students 6110157
Assessments Yes

SQL TUTORIAL 28

SQL stands for Structured Query Language. A query language is a kind of programming language that's designed to facilitate retrieving specific information from databases, and that's exactly what SQL does.
- Lecture1.1
  
  What is SQL? 05 min
- Lecture1.2
  
  Careers In SQL 05 min
- Lecture1.3
  
  Careers In SQL Server 05 min
- Lecture1.4
  
  IS SQL Microsoft? 05 min
- Lecture1.5
  
  SQL Management Tools 10 min
- Lecture1.6
  
  What Is SQL Developer 10 min
- Lecture1.7
  
  Uses Of SQL 10 min
- Lecture1.8
  
  How To Install SQL Server 15 min
- Lecture1.9
  
  What Is SQL Server 15 min
- Lecture1.10
  
  Databases in SQL Server 15 min
- Lecture1.11
  
  Distributed Databases in SQL Server 15 min
- Lecture1.12
  
  SQL Server Authentication Modes 10 min
- Lecture1.13
  
  SQL Server Logins 10 min
- Lecture1.14
  
  SQL Server Users 10 min
- Lecture1.15
  
  SQL Server Storage Basics: Database Files 10 min
- Lecture1.16
  
  SQL Server Storage Basics: Database Filegroups 10 min
- Lecture1.17
  
  SQL Data Types 15 min
- Lecture1.18
  
  Create and Schedule a Job in SQL Server 15 min
- Lecture1.19
  
  SQL Keywords 15 min
- Lecture1.20
  
  Composite Key In SQL 15 min
- Lecture1.21
  
  SQL Constraints 10 min
- Lecture1.22
  
  Transactions In SQL 10 min
- Lecture1.23
  
  Understanding Transactions in SQL Server 25 min
- Lecture1.24
  
  First Normal Form 15 min
- Lecture1.25
  
  SQL Server Data Types 10 min
- Lecture1.26
  
  SQL Administration 10 min
- Lecture1.27
  
  SQL Variables 15 min
- Lecture1.28
  
  Cheat Sheet SQL 15 min
OPERATORS 5

An operator is a reserved word or a character used primarily in an SQL statement's WHERE clause to perform operation(s), such as comparisons and arithmetic operations.
- Lecture2.1
  
  SQL Operators 15 min
- Lecture2.2
  
  SQL Arithmetic Operators 15 min
- Lecture2.3
  
  SQL Logical Operators 10 min
- Lecture2.4
  
  SQL String Operators 15 min
- Lecture2.5
  
  Ternary Operator In SQL 15 min
COMMANDS 26

SQL commands are the instructions used to communicate with a database to perform tasks, functions, and queries with data. SQL commands can be used to search the database and to do other functions like creating tables, adding data to tables, modifying data, and dropping tables
- Lecture3.1
  
  SQL Commands 10 min
- Lecture3.2
  
  SQL Alter Command 10 min
- Lecture3.3
  
  SQL Commands Update 10 min
- Lecture3.4
  
  FETCH In SQL 10 min
- Lecture3.5
  
  Enabling SQL Server Optimizer Hotfixes 05 min
- Lecture3.6
  
  Enable/Disable Constraints in SQL Server 05 min
- Lecture3.7
  
  How to Enable Remote Connections in SQL Server 2005 05 min
- Lecture3.8
  
  Views & Stored Procedure in SQL Server 05 min
- Lecture3.9
  
  Grant Execute Or View Permission To Stored Procedures In SQL Server 15 min
- Lecture3.10
  
  Natively Compiled Stored Procedures in SQL Server 2014 15 min
- Lecture3.11
  
  Requirements to Install SQL Server 2014 15 min
- Lecture3.12
  
  Resolving “Cannot Install SQL Server 2014 Service Pack 2” Error 15 min
- Lecture3.13
  
  Daily Shrink Database Log Automatically Using Jobs In SQL Server 20 min
- Lecture3.14
  
  How to Track User That Dropped/Deleted TSQL on SQL Server Objects 15 min
- Lecture3.15
  
  Delete All Table Data Within a Database in SQL Server 10 min
- Lecture3.16
  
  How To Recover Deleted Rows In SQL Server 20 min
- Lecture3.17
  
  Delete Files with a SQL Job in SQL Server 2008 10 min
- Lecture3.18
  
  Most Used SQL Queries 20 min
- Lecture3.19
  
  How to Generate Database Script with Table Data From SQL Server 10 min
- Lecture3.20
  
  Copy Table Schema and Data From One Database to Another Database in SQL Server 15 min
- Lecture3.21
  
  Copy Table With Data From One Database to Another in SQL Server 2012 20 min
- Lecture3.22
  
  Creating Duplicate Table With New Name From Existing Table in SQL Server 2012 10 min
- Lecture3.23
  
  Creating Various Types of Tables in SQL Server 2012 15 min
- Lecture3.24
  
  Passing Table to a Function Parameter in SQL Server 2012 10 min
- Lecture3.25
  
  Taking Script From Database In SQL Server In Different Mode 15 min
- Lecture3.26
  
  Generate Backup And Script File In SQL Server 2014 30 min
CLAUSE 9

MySQL queries are SQL functions that help us to access a particular set of records from a database table. We can request any information or data from the database using the clauses or let’s say SQL statements.
- Lecture4.1
  
  SQL Clauses 10 min
- Lecture4.2
  
  SQL IN Operator 15 min
- Lecture4.3
  
  SQL LIKE Clause 20 min
- Lecture4.4
  
  SQL Minus 15 min
- Lecture4.5
  
  SQL WHERE Clause 15 min
- Lecture4.6
  
  SQL With Clause 15 min
- Lecture4.7
  
  SQL HAVING Clause 15 min
- Lecture4.8
  
  GROUP BY Clause In SQL 15 min
- Lecture4.9
  
  ORDER BY Clause In SQL 15 min
QUERIES 4

A query is a question or inquiry to a set of data. We use SQL, or Structured Query Language, to retrieve data from databases. When we build the structure we are pulling data from tables and fields. The fields are columns in the database table while the actual data makes up the rows.
- Lecture5.1
  
  SQL Insert Query 10 min
- Lecture5.2
  
  SQL SELECT Query 15 min
- Lecture5.3
  
  SQL SELECT RANDOM 20 min
- Lecture5.4
  
  SQL Subquery 15 min
KEYS 5

An SQL key is either a single column (or attribute) or a group of columns that can uniquely identify rows (or tuples) in a table. SQL keys ensure that there are no rows with duplicate information.
- Lecture6.1
  
  SQL Keys 20 min
- Lecture6.2
  
  Primary Key In SQL 20 min
- Lecture6.3
  
  Foreign Key In SQL 15 min
- Lecture6.4
  
  Unique Key In SQL 15 min
- Lecture6.5
  
  Alternate Key In SQL 20 min
FUNCTIONS 14

SQL functions are simply sub-programs, which are commonly used and re-used throughout SQL database applications for processing or manipulating data.
- Lecture7.1
  
  SQL Date Function 15 min
- Lecture7.2
  
  SQL String Functions 15 min
- Lecture7.3
  
  SQL Timestamp 15 min
- Lecture7.4
  
  SQL TO_DATE() 15 min
- Lecture7.5
  
  SQL DATEADD()
- Lecture7.6
  
  ANY In SQL 15 min
- Lecture7.7
  
  LIKE Query In SQL 15 min
- Lecture7.8
  
  BETWEEN In SQL 15 min
- Lecture7.9
  
  LTRIM() In SQL 20 min
- Lecture7.10
  
  TOP In SQL 15 min
- Lecture7.11
  
  SQL Server Substring 20 min
- Lecture7.12
  
  CUBE In SQL 20 min
- Lecture7.13
  
  SQL RANK() 20 min
- Lecture7.14
  
  SQL CTE 15 min
JOINTS 12

Joins in SQL can be of four different types, subjected to the outcome expected by combining records from two or more tables by making use of the common columns from tables involved in the Join function. Inner Join is used to get records with same values In both tables, Left Join is used to get all records from Left side table and only matching values from right table and Right Join is used to get all records from Right table and only matching records in left table. finally Full Join to get all the records from both tables irrespective of matching records.
- Lecture8.1
  
  Types Of Joins In SQL 25 min
- Lecture8.2
  
  Types Of Joins In SQL Server 20 min
- Lecture8.3
  
  SQL Inner Join 20 min
- Lecture8.4
  
  SQL Join Two Tables 20 min
- Lecture8.5
  
  SQL Delete Join 20 min
- Lecture8.6
  
  SQL Left Join 20 min
- Lecture8.7
  
  SQL Right Join 20 min
- Lecture8.8
  
  SQL Cross Join 15 min
- Lecture8.9
  
  SQL Outer Join 15 min
- Lecture8.10
  
  SQL Full Join 15 min
- Lecture8.11
  
  SQL Self Join 20 min
- Lecture8.12
  
  Natural Join SQL 15 min
INTERVIEW QUESTIONS 4

These SQL Interview questions will help you with different expertise levels to reap the maximum benefit
- Lecture9.1
  
  SQL Interview Questions 10 min
- Lecture9.2
  
  Advance SQL Interview Questions 10 min
- Lecture9.3
  
  SQL Joins Interview Questions 10 min
- Lecture9.4
  
  SQL Server Interview Questions 10 min
CONGRATULATION YOU HAVE COMPLETED THIS COURSES IF YOU STUDY AT THIS POINT. CHECK OUT OUR INDUSTRY RECOGNIZED CERTIFICATION COURSES 0

No items in this section