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.
General Concepts for database and SQL
SQL 2014 Installation
Hello world database example, in this lesson we will create a new database, backup and restore the database.
How to make database script?
Create and designing tables to your database.
Primary Key and Foreign key concept
How to retrieve a data by using select statement query
Use SQL filters to filter your data.
This lesson will learn you how to use Insert and update SQL queries to add or update your data.
This lesson will learn you how to use delete and truncate SQL queries, and difference between delete and truncate quires.
This lesson will learn you what is stored procedure how to use stored procedures.
This lesson will learn you how to use stored procedures with input parameters.
This lesson will learn you what is SQL joins
This lesson will learn you the different types of SQL joins.
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.