Sql Developer Skills For Beginners
Date: 14 August 2022 | Posted by: voska89
Last updated 6/2021
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 267.20 MB | Duration: 5h 23m
Learn SQL Developer Skills
What you'll learn
Create Databases
Create Tables
Write T-SQL Queries
Design Databases
Design Tables
Create Views
Create Constraints
Requirements
How to use a computer and Internet
Determination to Learn
Description
SQL Developers are in demand due to the increasing reliance on data.Becoming a SQL developer can be a very rewarding and fulfilling career.
The path is relatively easy compared to other technical careers.
Microsoft SQL Server is among the top 3 relational database management systems in the worldand getting the skills to becoming an SQL Server developer will serve you well and open many job opportunities .
The advantage of this course is the amazing virtual labs facilities that is available for free from Microsoft. The virtual labs comes with Microsoft Server 2012 and also Microsoft SQL Server 2016 and various instances of SQL Server like SQL Server Analysis Server (SSAS), SQL Server Reporting Service (SSRS),SQL Server Integration serviceВ (SSIS). The virtual labs is ideal because it is free and gives you an environment that mirrors a real world production SQL Server environment. I strongly urge you to take advantage of this opportunity as I do not know how long Microsoft will have these virtual labs available for. All you require to access the virtual labs is a web browser . It does not matter if you are using a mac , Pc or Linux and there is absolutely nothing for you to install. The lab exercise you will perform in this course using the virtual labs are similar to a real world SQL Server production environment.
What you will learn in this course includes
How to create databasesHow to create TablesHow to deseign databasesHow to design TablesHow to create flat file databaseВ How to use SSMS ToolHow to write basic T-SQL Queries
I look forward to seeing on the course.
Thank You
Overview
Section 1: Database Basics
Lecture 1 Introduction
Lecture 2 Database Concepts
Lecture 3 Hierarchical database
Lecture 4 Relational Databases
Lecture 5 RDBMS
Lecture 6 Flat File Databases
Section 2: Setting Up Development Environment
Lecture 7 System Requirements
Lecture 8 Microsoft SQL Server Express 2014 Download
Lecture 9 Microsoft SQL Server Express 2014 Installation
Lecture 10 Download Sample Database
Lecture 11 Install Sample Database
Lecture 12 SSMS Tool
Lecture 13 MSDN Virtual Labs ( No Installation Required )
Section 3: Functions
Lecture 14 AVG
Lecture 15 MAX
Lecture 16 MIN
Lecture 17 COUNT
Lecture 18 SUM
Lecture 19 Grouping Data
Section 4: Developing Databases and Tables with SQL
Lecture 20 Schemas
Lecture 21 Designing and Creating Databases
Lecture 22 Designing and Creating Tables
Lecture 23 Primary Keys
Lecture 24 Foreign Key
Lecture 25 Views
Lecture 26 Creating Stored Procedures
Section 5: Joining Tables
Lecture 27 Intro
Lecture 28 Why are Table Joins Used
Lecture 29 INNER Join
Lecture 30 LEFT OUTER Join
Lecture 31 RIGHT OUTER Join
Lecture 32 Summary
Section 6: T-SQL Refresher
Lecture 33 What is T-SQL
Lecture 34 T-SQL INSERT Query
Lecture 35 T-SQL DELETE Query
Lecture 36 T-SQL UPDATE Query
Lecture 37 T-SQL DISTINCT and TOP Query
Lecture 38 Using Aliases
Lecture 39 T-SQL Comments
Lecture 40 T-SQL SELECT Query
Lecture 41 ORDER BY Clause with T-SQL
Lecture 42 Using Comparison Filters with T-SQL
Lecture 43 Using Equality Filters with T-SQL
Lecture 44 Using String Comparison with T-SQL
Lecture 45 Using Logical Operators with T-SQL
Lecture 46 Null Comparisons
Lecture 47 Thank You
Anyone interested in learning something new
Homepage
https://www.udemy.com/course/sql-developer-skills-for-beginners/DOWNLOAD LINK
Links are Interchangeable - No Password - Single Extraction
See full article