Development Online Course by Udemy, On Sale Here
With real time data base designing techniques, SQL, Joins, SPs, Functions, Views, Transactions, Triggers and lot more.
An excellent training about Database Design & Development
Learn MS SQL Server 2017 With Db Design Techniques
Q:Is it possible for me to learn query writing against MS SQL Server database, even if I don’t have any basics of DBMS?A:Yes! you can learn and this course is perfect for those who are absolute beginners in MS SQL Server technology. In this course we are going to learn every thing from scratch i.e, right from installing MS SQL Server management Studio, creating database, tables, understanding relationships, performing basic insert, update, delete and select operations, using basic builtin functions till all types of joins. We will also understand how to write different kinds ofstored proceduresanduser defined function. Then we will go for writingsub querieswhich includes scalar, multi valued andcorrelated sub queries. Moving ahead we see the programming logic in query writing usingT-SQLand understand how to writeconditional statementsin your large complex stored procedures. And finally we will try to understand the advanced concepts likeviews, scope identity function, transactionsandtriggers. So, I ensure you thatyou will enjoy each and every minute of the videosby learning something newTopics Covered are: Introduction-Database-Table-Keys (36:14)DataTypes-ForeignKey-DBDesign-Techniques (37:26)Insert-Update-Delete-Select Start (37:42)OrderBy-Where-String-Aggrigate (48:11)DateTimeFunctions-GroupBy-IntroToJoins (40:46)Implementing 2 And 3 Tables Joins (24:16)SelfJoin-Union-Simple-Correlates-SubQueries (34:26)Views And Common Table Expression (CTE) (31:25)StoredProcedures-Functions (33:00)Table Variables – Transactions – Slowly Changing Dimensions – ScopeIdentity (36:26)Triggers – Admin Tasks – Assigment (34:00)
Udemy is the leading global marketplace for learning and instruction
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.
Study anytime, anywhere.
Reviews
There are no reviews yet.