Database Analysis and Design Using SQL 2014 - for Beginners
3.3 (15 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,084 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Database Analysis and Design Using SQL 2014 - for Beginners to your Wishlist.

Add to Wishlist

Database Analysis and Design Using SQL 2014 - for Beginners

Databases with SQL server 2014 step by step
3.3 (15 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,084 students enrolled
Created by Mohammed Wuhaidi
Last updated 2/2017
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand the basics and concepts of Databases
  • SQL server 2014 Installation
  • Perform backups, restore, script the SQL databases
  • Designing and Implementing Tables
  • Understand relationships and keys
  • Write SQL code based on Queries standards to build and maintain database structures and data
  • Understand SQL Stored Procedures
  • Perform SQL joins
View Curriculum
Requirements
  • This is an introductory course on Databases and SQL Querying.
  • There are no pre-requisities for this course.
  • You will need to have a Windows-based computer to run Microsoft SQL Server.
  • SQL Server 2008 ,2012 or 2014 available on your PC
Description

SQL is the cornerstone of all #relational database operations. The ability to write the SQL language is essential for those who develop database applications and web applications. This course provides a solid foundation of the #SQL programming language that enables students to build, #query and Manipulate #databases. Working will be in SQL 2014 databases throughout this course.

I designed this course to be easily understood by beginners . At the end of this course students will be able to install SQL 2014 environment on their PC's, knowledge of concepts for databases and #relationships, dealing with Microsoft management studio , creating databases,#backup,#scripting the databases. Also the ability to write quires and to manage #tables data in databases.

Who is the target audience?
  • This course is for beginners with absolutely no experience is database. The course will make you proficient with how to use SQL to access and manipulate data. No Prior Programming experience is required.
  • Those who work in organizations where the company typically uses Microsoft databases. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) variant of the SQL language
Students Who Viewed This Course Also Viewed
Curriculum For This Course
16 Lectures
01:17:29
+
Module 1 : Introduction
1 Lecture 02:04

SQL and Database Course Introduction

Preview 02:04
+
Module 2 : Databases Introduction (Theoretical Background)
1 Lecture 02:48

General Concepts for database and SQL

Databases Introduction (Theoretical Background)
02:48
+
Module 3: SQL Server 2014 Installation and Configuration
3 Lectures 12:18

SQL 2014 Installation 

SQL Server 2014 Installation
05:50

Hello world database example, in this lesson we will create a new database, backup and restore the database.

Create, Backup and Restore Databases With SQL Server Management Studio
03:15

How to make database script?

Scripting the Database
03:13
+
Module 4 : Designing and Implementing Tables
2 Lectures 15:52

Create and designing tables to your database.

Creating and Designing Tables
06:36

Primary Key and Foreign key concept

Database table Keys
09:16
+
Module 5: SQL Querying
5 Lectures 26:05

How to retrieve a data by using select statement query

Retrieving Data
04:21

Use SQL filters to filter your data.

Filter records using SQL Query
03:27

This lesson will learn you how to use Insert and update SQL queries to add or update your data.

Preview 09:45

This lesson will learn you how to use delete and truncate SQL queries, and difference between delete and truncate quires.

Delete and Truncate Data
05:12

AND-OR Operators
03:20
+
Module 6 : Stored Procedures
2 Lectures 09:41

This lesson will learn you what is stored procedure how to use stored procedures.

Introduction to Stored Procedures
05:42

This lesson will learn you how to use stored procedures with input parameters.

Implementing Parameterized Stored Procedures
03:59
+
Module 7 : SQL JOIN
2 Lectures 08:41

This lesson will learn you what is SQL joins

What is SQL JOIN
01:27

This lesson will learn you the different types of SQL joins.

JOIN Types
07:14
About the Instructor
Mohammed Wuhaidi
3.7 Average rating
23 Reviews
2,497 Students
2 Courses
Web Developer, Database and System Analyst

My name is Mohammed . I'm 31 years old , I have seven years experience in web , database development  and five years in training and teaching IT courses.

I am a young but experienced and highly passionate in Web and Database ,I also have a Bachelor's degree in IT and a Master's degree in Business Administration.

I am dedicated to Inspiring and Empowering People to Achieve Their Goals through Learning.