SQL: ۲ کتاب در ۱ - راهنمای جامع مبتدی و متوسط برای یادگیری برنامه‌نویسی SQL به صورت گام به گام

★★Buy the Paperback Version of this Book and get the Kindle Book version for FREE ★★Are you looking for a dynamic and workable programming language ? Have you tried a few but none seem to work to your liking? Have you considered SQL? There are literally thousands of programming languages available in today's market, ranging from the simple to the infinitely complex. As a beginner you probably want something that is easy to use and to get your head around and SQL, or Structured Query Language, could be the answer.Inside the pages of SQL: The Ultimate Beginner's & Intermediate Guide to Learn SQL Programming Step by Step , you'll find a comprehensive guide to get you started & is ideal for helping you with a range of intermediate skills including chapters on: Book 1- Data definition language- SQL joins and union- Ensuring data integrity- Database creation- Database administration- Modifying and controlling tables- And much more... Book 2- A recap on the basics of SQL- An easy guide to installing and configuring SQL- Data types and their functions- Encrypting, creating and indexing views- Getting the most out of stored routines and functions- The benefits of normalizing your data- And lots more... When searching for a programming language that is the right one for you, SQL is one of the best around for ease of use and flexibility for the beginner. And as this book has been written with the novice in mind, it means that you could soon be writing your own programs quickly and efficiently , building on your new skills with each passing chapter.Don't wait any longer and get your copy today .There really is no better way to get started with a programming language and you'll be amazed how fast you will learn with SQL! SQL: THE ULTIMATE BEGINNER'S GUIDE 11 Introduction 14 1.Advantages Of Databases 15 2.Types Of Sql Queries 16 Chapter 1: The Data Definition Language 18 3.Ddl For Database And Table Creation 18 4.Alter Ddl For Foreign Key Addition 20 5.Foreign Key Ddl In Tables 20 6.Unique Constraint Ddl In Tables 21 7.Delete And Drop Ddl In Tables 21 8.Ddl To Create Views 21 Chapter 2: Sql Joins And Union 25 1.Sql Inner Join 25 2.Sql Right Join 26 3.Sql Left Join 27 4.Sql Union Command 28 5.Sql Union All Command 30 Chapter 3: How To Ensure Data Integrity 34 Integrity Constraints – The Basics 35 The Not Null Constraint 36 The Unique Constraint 37 The Primary Key Constraint 40 The Foreign Key Constraints 43 The Check Constraint 50 Chapter 4: How To Create An Sql View 56 How To Add A View To A Database 57 How To Create An Updateable View 62 How To Drop A View 63 Database Security 64 The Security Model Of Sql 65 Creating And Deleting A Role 66 Granting And Revoking A Privilege 67 Chapter 5: Database Creation 69 Creating A Database 70 Removing A Database 71 Schema Creation 72 Creating Tables And Inserting Data Into Tables 75 How To Create A Table 76 Creating A New Table Based On Existing Tables 78 Inserting Data Into Table 79 Populating A Table With New Data 80 Inserting Data Into Specific Columns 84 Inserting Null Values 85 Data Definition Language 90 Running The Ddl Script 93 Data Manipulation Language 94 Running The Dml Script 97 Chapter 6: Database Administration 99 Chapter 7: Sql Transaction 115 Chapter 8: Logins, Users And Roles 130 Like Clause 137 Sql Functions 140 Sql Avg Function 145 Sql Round Function 148 Sql Sum Function 150 Sql Max 153 Chapter 9: Modifying And Controlling Tables 159 Modifying Column Attributes 160 Renaming Columns 161 Deleting A Column 162 Adding A New Column 163 Modifying An Existing Column Without Changing Its Name 164 Rules To Remember When Using Alter Table 165 Deleting Tables 166 Combining And Joining Tables 167 Sql Character Functions 183 Note: 183 Sql Constraints 186 Not Null Constraint 187 Default Constraint 188 Unique Constraint 189 Primary Key 191 Foreign Key 193 Check Constraint 195 Index Constraint 197 Conclusion And Next Steps 202 References 205 SQL: THE ULTIMATE INTERMEDIATE GUIDE 208 Introduction 210 Chapter 1: The Simple Basics Of Sql 213 What Is Sql? 214 Working On The Databases 215 Relational Database 215 Client And Server Technology 215 Internet-Based Database Systems 216 Chapter 2: Installing And Configuring Mysql 219 What Is Mysql? 220 How To Install Mysql On Microsoft Windows On Your Computer 220 Chapter 3: The Sql Server 227 Installing Oracle Database 11g Express Edition 228 Installing Sql Developer 232 Creating A System Connection 234 Creating A Database Account 236 Creating Your Account Connection 239 Showing Line Numbers 240 Deleting The System Connection 242 Using Sql Developer 244 Running An Sql Statement 245 Inserting Rows 246 Running A Pl/Sql Program 247 Multiple Worksheets For A Connection 248 Storing The Source Code 250 How To Open A Source Code 251 Storing The Listings In Appendix A In Files 252 Running Sql Or Pl/Sql From A File 252 Clearing A Worksheet 253 Displaying Output 253 Clearing Dbms_Output 258 Chapter 4: Data Types 261 Categories Of Data Types 263 Character 263 Number 263 Date And Time 264 Arithmetic 265 Chapter 5: Sql Script Boundaries 268 Dropping Restricts 269 Integrity Restricts 270 Delegating Responsibility 272 Chapter 6: Filters 274 Where Clause 275 Having Clause 277 Evaluating A Condition 282 And Operator 283 Or Operator 284 Usage Of Parentheses 284 The Not Operator 287 Sequences 290 Renumbering A Sequence 293 Chapter 7: Views 299 Encrypting A View 300 Creating A View 301 Indexing A View 302 Chapter 8: Triggers 304 Trigger Syntax 305 After Trigger 306 Instead Of Trigger 309 Chapter 9: Stored Routines And Functions In Sql 312 Stored Procedures 312 Benefits Offered By Stored Procedures In Sql 312 Creating A Stored Procedure 313 Executing A Stored Procedure 314 Inserting Records 315 Updating Records 316 Deleting Records 317 Modifying A Stored Procedure 318 Deleting A Stored Procedure 319 Functions 320 Scalar Functions 320 Table-Valued Functions 320 Notes On Functions 321 Cursors 322 Chapter 10: How To Pivot Data 327 How Can You Compose Your Pivot Query? 328 Chapter 11: Clone Tables 332 How To Create A Clone Table 333 Purposes Of Clone Tables 334 Chapter 12: Normalization Of Your Data 336 How To Normalize The Database 337 Raw Databases 337 Logical Design 338 The Needs Of The End User 338 Data Repetition 339 Normal Forms 339 Naming Conventions 340 Benefits Of Normalizing Your Database 340 Denormalization 341 Database Normal Forms 343 First Normal Form 343 Second Normal Form 344 Third Normal Form 346 Boyce-Codd Normal Form 348 Fourth Normal Form 348 Fifth Normal Form 348 Chapter 13: Security 350 Components Of Database Security 351 Authentication 351 Encryption 351 Authorization 351 Access Control 351 Three-Class Security Model 353 Schemas 353 Server Roles 353 Logins 355 Mixed Mode Authentication 356 Database Roles 356 Encryption 358 Master Keys 358 Transparent Data Encryption 359 Chapter 14: Sql Injections 362 How Do They Work? 363 Preventing An Sql Injection 364 Like Quandary 364 Hacking Scenario 364 Chapter 15: Fine-Tune Your Indexes 366 Sql Tuning Tools 368 Chapter 16: Deadlocks 370 Deadlock Analysis And Prevention 372 Reading Deadlock Info Via Sql Server Error Log 372 Some Tips For Avoiding Deadlock 376 Chapter 17: Database Administration 378 Setting Up A Maintenance Plan In Sql Server 380 Define Backup Database 381 Define Database Check Integrity Task 381 Define Shrink Database Task 381 Define Reorganize Index Task 381 Define Rebuild Index Task 382 Define Update Statistics Task 382 Define History Cleanup Task 382 Define Backup Database 382 Define Backup Database 382 Define Execute Sql Server Agent Job Task 382 Define Maintenance Cleanup Task 383 Report Options 383 Complete The Wizard 383 Running The Maintenance Plan 384 Emailing The Reports 384 Configuring The Database Mail 384 Sql Server Agent 385 Backup And Recovery 386 The Transaction Log 386 Recovery 386 Changing The Recovery Model 387 Backups 387 Performing A Backup 389 Restoring A Database 389 Attaching And Detaching Databases 389 Chapter 18: Working With Ssms 394 Downloading Sql Server Management Studio 394 Starting The Database Engine Services 394 Connect To Sql Server With Ssms 397 The Basics And Features Of Ssms 399 Managing Connections 399 Choosing Your Database 399 New Query Window 399 Executing Statements 400 Intellisense 401 Results Presentation 402 Object Explorer 403 Databases 403 Chapter 19: Real-World Uses 406 Sql In An Application 407 Conclusion 412 References 414 **★★Buy the Paperback Version of this Book and get the Kindle Book version for FREE ★★Are you looking for a __dynamic and workable programming language__? Have you tried a few but none seem to work to your liking? Have you considered SQL?**__easy to use__ **SQL: The Ultimate Beginner's & Intermediate Guide to Learn SQL Programming Step by Step****Book 1- Data definition language- SQL joins and union- Ensuring data integrity- Database creation- Database administration- Modifying and controlling tables- And much more...****When searching for a programming language that is the right one for you, SQL is one of the best around for ease of use and flexibility for the beginner. And as this book has been written with the novice in mind, it means that you could soon be writing your own programs __quickly and efficiently__, building on your new skills with each passing chapter.Don't wait any longer and **get your copy today**.There really is no better way to get started with a programming language and you'll be amazed how fast you will learn with SQL!**